DSXchange

JezT,

either your data is wrong or your PICture clauses are. The PIC 9 datatype is not packed, it is essentially a CHAR field that contains only digits. Are you doing the EBCDIC to ASCII conversion?

JezT, that is not exactly what you need to know --> from what language is this field being written and what is the definition of that field in that language. This is kind of like a Rosetta Stone for data... Once the data type is known you can either use a built-in DS function to decode it or use tho...

If you are sure that you are only outputing the one string from your shell script, then EREPLACE(@FM,'',TRIM(Output)) should do it; this replaces all occurrences of the @FM (field mark) with empty -> any cr/lf in the returned string are representing as a field mark; and this also messes up the DataS...

JezT,

what is the exact datatype you are getting? It would seem that it is not a PIC S9 COMP-3 cobol type.

Oli, what data type did you declare this parameter to be? And the output of the execute command will have more than just the one value, it will have a number of field-marks (which are the carriage returns and line feeds in the output) that you need to strip out in order to get a single string; did y...

Could you check your readme file for the DataStage installation and make sure that it is supported for the 64 bit version; I seem to recall that it is not.

When you Execute a shell you actually have 2 return values, one is the return code (0 if successful) and the other is the contents of the standard output. Because ExecSh is a before/after subroutine it only returns the contents of the system return code. You should use the Call DSExecute("UNIX", {Yo...

jasper, in my current project we have done something quite similar. Essentially we have a table (in Oracle, copied to a Hash file) which contains the Sequence and Job structure (unique primary key is Name & Parent) and so we can compute which jobs are called by which sequences - this is necessar...

JezT,

since these are binary fields DataStage cannot display them without knowing which conversion to apply. If you look into the routines/functions in the SDK you will find "DataTypePicComp3" which should solve your problem.

Good morning Jasper, most of what you would like to do is available in different places within DataStage. Since yo mention "script" I will assume you want to get all of this from somewhere outside of DataStage, so your main source will be variations on the unix "dsjob" command to get the log entries...

Pain in the Appendage

See FAQ post about ENVironment variables for information about environment variables - including encrypted ones at 7.5

The trigger of "OK - Conditional" will continue on an exit status of OK or OK with warnings; so that is not the cause of the problem. Do you have your sequence set to "Automatically handle activities that fail" (if so, unset it)?

No problem at all - I meant to scare you away. I think I once spent a week on a linux implementation to get an external call working. The UCI (going from a library to a UniVerse program) is much simpler!

Craig, there is a whole GCI guide available on IBM's pages (see Universe GCI Guide PDF ). You can define C (or any other language that uses the appropriate pointer to string datatype) library routines to be callable as if they were UniVerse functions; it takes a bit of work to get set up correctly b...