DSXchange

Hi Ifong, thanks for reading. At the end of the day I still should have a file with detial records and a trailer record containing counts. The record formats for the two will never be the same. I'm not sure how the funnel stage will work in your example? Could you please elaborate. Thank you!!!!

:? Hi, I have a transformer stage that has 2 output links. Each link has different metadata because one link is a trailer record containing various counts derived in the transformer during processing. I only right the trailer record once at the end of processing. How can I bring the 2 links together...

Thanks to everyone for you help.

Hi DSguru2B, it looks like the sequential file stage gives me the option to override the timestamp default. It's on the format tab in the sequntial file stage. Is this what you were thinking too? Thanks!!

Actually I'm going to try this instead


StringToTimestamp(DateToString(CurrentDate(),"%mm-%dd-%yyyy"),"%mm-%dd-%yyyy-%hh.%nn.%ss")


Is there a better way? Thanks!!!

I going to try this, but there may be a better way. Can anyone think of a better approach?


DateToString(CurrentDate(),"%mm-%dd-%yyyy") : CurrentTime()

For a timestamp the format is %yyyy-%mm-%dd %hh:%nn:%ss, but I need to convert to %mm-%dd-%yyyy %hh:%nn:%ss

Thanks

Thanks for reading.

I'm trying to take the date suplpied by the DataStage CurrentTimestamp() function within a transformer derivation and convert it to MMDDCCYYHHMMSS.

I read the PX PDF, but still trying to find a specific example. I trying to simply take CurrentTimestamp and convert it to MMDDCCYYHHMMSS.

Hi, how do you do this on in a DataStage PX 7.5 job? Thanks!!

Hi, thanks for reading. How can I convert a timestamp to MMDDCCYYHHMMSS? Thanks!!

I should have asked; What did you do in the seperate job to obtain the count?


Thanks!!

Hello ABC123, how did you end up obtaining the final count in a seperate job? Thanks!!!

Thanks for both responses. If it were a termination character in a varchar or char field would the job run okay with the same data if you simply resubmit the job? The job design is DB2 ------> funnel ---> lookup ----> transformer ....etc DB2 The funnel stage is what spits out the fatal error.

Greetings...we have a job that has been running in our production environment for several years now with no issues. Our last run produced the following fatal errors: Funnel_23,0: Failure during execution of operator logic. Funnel_23,0: Fatal Error: APT_SYSselect returned error status -1 and no input...

The date is defined as a 'date' field.