DSXchange

After executing dssh in an apporpriate directory (one the is the DS engine directory or a project directory, containing a VOC file in either case) the prompt changes to ">". This prompt signifies that you are working in the TCL (terminal command language) environment. You return to the UNIX shell by...

Upsert mode, update first.

Wouldn't it be easier just to set the Null Field Value property in the Sequential File stage, for example to "<NULL>", so that spaces continue to be treated as spaces?

This site uses the "premium poster" concept as a means for funding the site. The revenue comes nowhere near paying for the site, but it helps. The added value provided by these few posters ought to make it worth your while to invest the less than $1 per week required for a premium membership. It is ...

Given that it's a function of your data, it's impossible to say. Essentially it's a measure of how much information (what rarity value) is contributed by that value compared to all the values in that field (the field's "domain").

Hashed files do not support the TimeStamp data type. Prefer VarChar with a precision at least as large as you need (19, 23, 26 or more). You will need to enclose the value in single quotes.

However you like. They can be passed (as command line arguments) from DataStage to the shell script, for one example. They could be environment variables (perhaps encrypted) for another example.

Then you need to think long and hard about how to solve your requirement in a generic fashion. How DO you define "Input rows"? How do you define "Output rows"? And so on. Perhaps you could create an after job subroutine and pass it a list of the link names in the job for which you want row counts. T...

Packager Wizard as a mechanism for deployment was last used when the Great Pyramid of Cheops was built. You can't create a job deployment package until you have released one or more jobs.

It is much easier to use Version Control to get read-only DataStage objects promoted.

Does not "same" mean "not different"? What exactly are you asking here?

Dates aren't "in" any particular kind of format. It's only when they are converted to string that format becomes important. Having created a date, as in this thread, you can then apply a DateToString() function and specify an explicit date picture such as "%dd-%mm-%yyyy".

Welcome aboard. :D

You must construct a job sequence that reads the file in question and uses the data contained therein to provide values to job parameters of the job that contains an Oracle stage.

Welcome aboard. :D Provided that the worksheets have a tabular form only, and with column headings, you can use the ODBC Enterprise stage via the Microsoft ODBC driver for Excel. Otherwise you can pre-process the worksheet(s) to get them dumped into a file format, for example CSV. This limits you to...

Re-read your post! I will concede, however, that the OP did not mention 7.5x2.