DSXchange

From the command line... the utility is named "orchdbutil" from what I recall. Pretty sure that's a practical approach, I'm sure someone else will come along and comment on it for us.

That API allows integration of Java into a DataStage job. What you are looking to do doesn't require any sort of "job" to accomplish so while the API may not be relevant that doesn't mean you couldn't do this in Java itself. As noted, you just need something to retrieve a list of tables an...

Do you have any Documentum people you work with who could answer those questions for you?

We would routinely steal an export from the nightly backups and use a modified version of one of Chuck Smith's utilities to parse and then load it up into database tables. This allowed the searching to be done by SQL and let us know the source right away without any of that pesky back-tracking for t...

You could always all Old School on it - export the project as a dsx and then search the exported project for your text. Once found you can work backwards from there to the beginning of the job definition to find the name / category.

Similar != same. Off you go to your own post.

Are you sure you need to escape it at all? Are you getting a syntax or runtime error that you can share? If for some reason that approach isn't manageable, you could use the function in a lookup / select before the insert so that you just have a 'normal' value to insert in the target. Or perhaps eve...

OK, fine... "default" was a poor choice of word on my part as I wasn't referring to an ANSI standard timestamp. If you've actually specified that formatting for the field in the Sequential File stage and it's not respecting it then perhaps it is a bug. Unless someone has some advice on a d...

Yup, the linked post mentions both the Looper and the Cutter.

You need to use a hex dump (od -h) on that file or open it in a hex editor and let us know where / what those two extra characters are.

Then you should be fine... just make sure your input column name is correctly specified. The example you posted has too many "dots" in it:

Which is why you are getting the default formatting in the file. If you really want control over it, declare the output field as a string and then use TimestampToString() to get the specific external format you are looking for. That or don't worry about it.

Not sure what you mean by it is "asking for" anything, there's nothing more to the syntax than what Arnd posted. Can you be more specific? Examples from the documentation are here. Is your "Column1" a string?

How are they declared in the output Sequential File stage - as a string or as a timestamp?