Search found 2 matches

by Sridhar G
Wed Dec 29, 2004 5:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Capturing Job log
Replies: 12
Views: 5518

Capturing Job log

Hi all, We have a requirement in our project to capture job log for each job in a sequential file. The following routine returns the log for a particular job for the last ran day. DSGetLogSummary(JobHandle,DSJ.LOGANY,DSGetJobInfo(JobHandle,DSJ.JOBSTARTTIMESTAMP),DSGetJobInfo(JobHandle,DSJ.JOBLASTTIM...
by Sridhar G
Wed Dec 22, 2004 2:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Difference between Insert else Update and Update else insert
Replies: 4
Views: 5700

Hi Anand,
From the experience that we have had, i feel it is better to use Update else Insert b'coz, if you update first, whenever a matching record is found, it immediately updates and goes to the next record. Else, it waits till all the insert is completed and then only updates.