DSXchange

(Iconv(date1,"D/DMY[2,2,4]")

Along with the mathematical type conversion functions, you may want to use the mathematical functions Floor, Ceil and Mod to get the level of precision you want by rounding or truncating.

Did you try using JobHandle instead of DSJ.ME as jobname in the DSAttachJob function?

That error indicates it's likely the compiler options.

I'm on -> on AIX 5.2 DS 7.5.2

try this ->

/usr/vacpp/bin/xlc_r -c -O -qsourcetype=c++ greatest.c -o greatest.o


Or rename your .c file .cpp

My in file:
Filed1,Field2

SELECT 1301128551.1,1324414646 FROM DUAL

My out file
"23286094.9"

all fields dec(30,8)

deriv: DSLink77.Two- DSLink77.One

Can't recreate error - mine works fine

or create shell looping for each $PROJNAME found using dsjob -lprojects, #### $JOBNAME is your job #### define a $LOGFILE cd ${DSHOME} bin/uvsh >${LOGFILE} 2>&1 << EOF LOGTO ${PROJNAME} LIST DS_JOBS WITH NAME=${JOBNAME} QUIT EOF cd echo " " ${PROJNAME} " ${JOBNAME} " `cat ${L...

Write a unix script:

loop through output of dsjob -dsprojects to get $PROJNAME or similar

then dsjob -jobinfo $PROJNAME yourjobname | grep -i category | wc -l > ctr

if ctr >0 then echo $PROJNAME

Just confirming, I should have said "Is this what you have set up"

Anyway, try

SUM_CASH_VAL :decimal[11,2] = handle_null(SUM_CASH_VAL,0)

Note the brackets [] after the word "decimal". Not parens (). That could be your problem.

CV Totals In (SUM_CASH_VAL nullable is "Y") ->

Modify (handle nulls here) -> (SUM_CASH_VAL nullable is "N") ->

out rec

My guess is management decree. They paid for it, ergo you must use it. I've actually worked in a situation where the push was to convert EVERY server job to EE even though we were chugging through a whopping 20,000 rows max per job. Feeling nauseous yet?

Maveric wrote:Sort data on profit field in descending order and take only the first row from the output.

Try maximum function in aggregator stage

Could be a DB2 communication/connection glitch . Did you try rerunning? Can you view table data by opening the DB2 stage with the desired job params?

Can you just direct me how to do it? I would really appreciate the help. Cheers! I created a doc just last week which explains how to create a simple C++ function, compile it in AIX 5.2, and create a PX routine that references it. Let me know if you're interested. To avoid having my work email addr...