DSXchange

I didn't realize that this was a new function at V8; but if it is any consolation I have a PMR open with IBM regarding problems with this function. Could you try to use a timestamp output datatype to a peek stage with the extended attributes set to see if that works?

The DSJobController macro that Craig mentioned will give you the runtiem information for a job - meaning that it will return the job or sequence name that called it for a given run. I've been using V8, which has extended metadata reporting capabilities, so cannot give you the exact method to use a V...

dodda wrote:...Missing record delimiter "\n", saw EOF instead...

is the important part. You haven't defined line terminators identical to your file contents.

Do you have a constraint in your transform stage - either an explicit clause using @INROWNUM or perhaps a row limiter? When you job stops, is it with a status of aborted?

@DATE and @TIME will return the internal format for the date/time when the process was started, DATE() and TIME() will return the date/time of when the function was called.

To convert to "?" in a transform stage, use "CONVERT(CHAR(000),'?',In.StringColumn)"

Mandyli - that is the DataStage equivalent of the "Warning" light in your car lighting up. It means something has gone wrong but doesn't really narrow down the cause. Has your job ever run without the error? Have you tried resetting the job to see if the log shows more information? Are there other m...

shobhitj - please get Premium membership.

PICS S9(5) COMP-3 is a standardized COBOL format, it can contains values from -99999 through 99999 and always uses 3 Bytes (6 nibbles or 24 bits) to store this information. Each digit is stored in 4 bits (1 nibble) and the sign occupies another 4 bits. 7 numeric digits will fit into a PIC S9(7) COMP...

What about

No need to code anything external. The high-level logic to do this is to take the date, add 2 months, then subtract one day. The DateFromDaysSince() function performs addition/subtraction from a date.

Often this happens when your column does not have the "extended" attribute enabled. right-mouse-click on the column, then "edit row" and see what your settings are.

When I do "orchadmin describe -c {dataset name}", i am getting the following error: ##E TFPA 000021 $APT_CONFIG_FILE was not set... As mentioned earlier, you will need to set the UNIX env variables and also run the ". $DSHOME/dsenv" file. I am not at a datastage site right now, but I think that the...

How long does Job 1 take? Combining these two jobs and removing the DataSet will certainly speed up processing.

use "orchadmin describe -c {dataset}" to get the APT_CONFIGuration from the dataset, then compare that with your dataset as used in the job.