DSXchange

I believe the following will work if you don't need a full timestamp (based on using an ODBC stage). In the transfom stage that loads the database use the following expression ... Oconv(DateGenericToInternal(InputLink.DateField), "D-YMD[4,2,2]") : " 00:00" ... and change the Data...

I would like to see DataStage enforce data type constraints when writing to a text file, something similar as currently occurs when writing to a database table. While I'm aware that in this case it's the database engine enforcing the constraint, it would prove useful in some cases if there was a swi...

Thanks for the response ... you're right I didn't expect the behaviour I got either. I did initially replace 'CRLF' with a 'pipe', but it affected the column width. I've now found a solution ... it seems so simple I must admit to being a little embarrassed. Solution? Define 2 columns in the initial ...

I'm working with fixed width files containing call centre data, where the source app permits the use of the <enter> key to start a new line, within a single field. The fixed width text file consequently, contains extraneous CRLF (DOS files) within the definition of a single field width. I can read t...