DSXchange

Hmmm, now this is starting to look like interview questions. If not, show us what you've tried so far.

The INT() function truncates a number, so for positive numbers the function would be

Asking the same question in two threads won't get you better answers.

BASIC has not ROUND() function.

The @DATE and DATE() functions will do that for you.

This might be the AS/400 conversion from EBCDIC. Have you tried setting $APT_EBCDIC_VERSION to IBM01141?

Craig - we had to put in a BASIC transform stage in order to figure out byte lengths, basically we had to parse a very long string into multiple Oracle strings and they could contain multibyte data and the BASIC ByteLen() was our first choice. I think we've now replaced that with a BuildOp because t...

Set the $APT_CONFIG_FILE in your user's .profile, e.g.:

If you manually enter your compile from the command line does it compile without an error? /usr/vacpp/bin/xlC_r -O -I/dms/Ascential/projects/DMSProjects/buildop -I/landing01/dataint/Ascential/DataStage/PXEngine/include -D_LARGE_FILES -qlonglong /dms/Ascential/projects/DMSProjects/buildop/bosource307...

Isn't the "Looking for Talent" forum more appropriate for this?

Server job output stage rejects come off the transform stage before the actual output stage, unlike PX jobs where they come directly off the actual output stage.

If the intermediate file is to be read sequentially, then using a hashed file instead of a sequential file would be adding unnecessary overhead.

Change your timestamp to a char(19) and see if the error goes away. I would think it is the nonstandard "MMM" portion that you haven't catered for.

If you want the parent process of the job that is running, then simple use "DSGetJobInfo(DSJ.ME,DSJ.JOBCONTROLLER)"

I know that you can do a "OCONV(YourString,NLSMapName)" and check the return code using STATUS() but there might be a single command to check - you could try searching the BASIC handbook (which I don't have available to me now).