DSXchange

"dsjob -log" inserts a record into the log, you are looking for "dsjob -logsum"

The "dsjob" command is the same on Windows and UNIX. It can be called from either the server or the client.

'' is not a valid date, try

dodda wrote:if Trim(Out_MAI21.Suppdate)='' then StringToDate('19000101',"%yyyy%mm%dd") else StringToDate(Out_MAI21.Suppdate,"%yyyy%mm%dd")

Craig - good point, I must have been in "consultant" mode (the mantra is "Billable Hours....Billable Hours...")

It doesn't allow you to create these two file types in the hashed file stage. The forum contains numerous descriptions of how you can create your own files, i.e. "CREATE.FILE MYFILE 10" from the TCL command line.

In this example the key would be COUNTRY.

c++ compiler is missing or not installed correctly.

Common methods that I use are vertical and horizontal alignment methods in the designer.

hint - if you specify your question more precisely, you will probably get an answer you can use

I am not sure where you are looking, but type 1 and 19 files exist; both are directory types but type 1 has a limited filename/key length and shouldn't be used.

cetzhbo - this is a volunteer site and not affiliated with IBM. You can search the IBM site for 7.5, 7.5.1, 7.5.2, 7.5.3, 7.5x2, 8.0, 8.0.1 and get the details of what differences there are. In addition, the readme files on your media document all the patches and fixes and changes from previous vers...

You need to execute the "dsenv" file in $DSHOME in order to completely set up your paths and libararies

No, the "&" should have no effect on this. How are you doing the join - do you have any custom SQL involved?

Why not use the sequence invocation id value as part of the job invocation id, that way it would generate unique values. You can get the invocation id of the sequence inside the sequence using the DSJobInvocationId macro.

Export all your projects to .dsx files, then write a DataStage program to search these files for the tags found only in the Oracle Bulk Loader.

The problem is that the DS shell isn't getting it's input from the script. The easiest solution would be for you to skip the LOGTO by doing a CD to the project directory in the shell script, then use
to issue single commands that exit back out of the shell

DataStage Server has no builtin compression functionality, but you can always shell out and execute UNIX or Windows commands such as gzip, compress or the command-line version of WinZip or WinRar or pkzip to mention just a few