DSXchange

Alternitavely if the jobs for each table are in seperate jobs then you can always store the MAX value in the Global Variable ( Read this post: viewtopic.php?t=86986&highlight=user+global ).

I would just use a simple SQL statement like the following: select ID, MAX(Fld1) "Fld1", MAX(Fld2) "Fld2" from (select ID, case when Colname = 'Fld1' then New_Value else NULL end "Fld1", case when Colname = 'Fld2' then New_Value else NULL end "Fld2" from your_...

GIGO = "Garbage In, Garbage Out" The best option is of course to change the source data. But it looks like you won't be getting a fix in the soruce system anytime soon. It really depends on how often you will be getting data with the double quotes character inside the actual field. A nice ...

Thanks Ray.

Thought so. I have been importing some jobs of mine from 7.1 into 7.0 and it kept complaining about "Unknown property name: 'Checkpoint'". That sort of gave it away to me. But it's good to be sure.

Does anyone know if Sequence jobs in Datastage 7.0 support check points for restarts? Or is this only available in versions 7.1+ ?

Perhaps try using the DB2 native format: YYYY-MM-DD-HH.MI.SS.FFFFFF

Would look something like:
OCONV(ICONV(linkname.DATE1,"DMDY"),"D-YMD[4,4,2]") : "-00.00.00.000000"