DSXchange

neena wrote:When you bring the field try to change into "yyyy-mm-dd hh:nn:ss" format and use the function. I did a test job and it seems like the function is working only with the above format.

Neena,
Will you please share your derivation.
And how about if date time stamp is 'pm' ?

Could you provide the exact derivation that you used? With the exact input and output datatype. ... Hi Kumar, Please find the exact derivation and datatype of input and output respectively StringToTimestamp(DSLink4.time,"%yyyy-%mm-%dd %hh:%nn:%ss") Input: 19 bytes Char Output: 26 Bytes, s...

Hi Friends, Need a help on date time stamp conversion. I recieve a timestamp of format which will be read in a CFF stage using cobol definition : 2009091909.25.03 am (yyyymmddhh.mm.ss am) - 12 hours format. Bytes:19 Data type: Character Now I want to convert it in to standard date time stamp 2009-09...

Sreenivasulu wrote:Simple soluton - may not fit
Do a count(*) with an alias and get the number of records loaded

Regards
Sreeni

No Sreeni as mentioned , we want to avoid scan of entire table , as its a daily job and loads the table with millions of records and may degrade the system performance.

Not being able to test it with reject links makes it tough; can you duplicate the production data on another DataStage machine in order to test it? What about duplicate primary keys? ... No Not really !! But yes reject link test will solve it.But want a logic or code written, which will be used as ...

Not really. If there are errors in the load then the job will show those errors, if they don't show up there, then I would look at duplicate keys overwriting existing records as a possible reason. You could use a reject link and insert/update method to check. Thanks for your quick reply, As far as ...

Hi Friends, can some one help me out to write a routine or any other method to know whether all the records in the load dataset are properly loaded into DB2 table or not? For eg: Suppose there are around 100 records in the load dataset and only 95 got loaded and job is successfully completed. Is the...