DSXchange

dsjob can dump the entire contents of the job log. Therefore, for example, if you had APT_DUMP_SCORE set to True, there will be a score event (or two - one for licensing) in the job log. Other environment variables (in the Reporting section) control what other information is logged.

Well done! Search is your friend.

And, continuing on that theme, what else is happening on (is loading) the machine when this problem occurs?

In that case you will need to incorporate adding tags into your own derivation logic.

Probably the easiest way to do this is to write a routine to generate a long string which produces all the output rows with LF between. Write this to a sequential file (as a single VarChar column) with 000 as the delimiter and quote character and then read from the same sequential file using whateve...

Please expand on "its not working out". As I read your code, the Input Values field should provide a string of the form directorypath~filename~datetime and issues an ERASE command for the file directorypath\filename.datetime.war.csv if the link row count is zero. Add some diagnostic capability. For ...

When you import from a COBOL FD you can specify the column in which the level 01 item begins. The import wizard expects the A margin and B margin to be properly configured (two+ levels of indenting, usually four spaces each, though the importer can be flexible about that).

kduke wrote:Hashed files should not be considered persistent meaning these values should be recreated every job run.

...except, of course, for the Repository tables and SDKSequences.

As far as I am aware, DataStage does not use HTTP so adding secure HTTP (HTTPS) ought not to affect DataStage.

As Craig says (says), the Wait For File activity does not support wildcards. However, such a routine would be easy to write, and could be invoked from a Routine activity. In a loop, execute an operating system command to list whatever the wildcard refers to, and to return if the number of items list...

Of course you can copy - there's nothing outside the file system. However, how did you go about updating system tables such as UV.ACCOUNT, UV_SCHEMA and so on? Or did you copy the Engine directory as well? With identical configuration a "copy everything" approach would work, because the pathnames an...

Your visa problems all sorted, then?

Just to be clear for everyone else who might look for it, Batch::UTILSetDefaultParams comes from Ken Bland & Associates - it's not "built-in" to DataStage as jdmicelli suggests.

Nice one. :D

The histograms are at the bottom of the report file. They're printed sideways - ideally you need continuous stationery but you can glue regular pages together.