Search found 39 matches

by kausmone
Fri Nov 02, 2007 7:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: server routine for eliminating headers
Replies: 7
Views: 2209

Unfortunately, the project has some auditing set-up which forces me to update the file before it gets read by the jobs. Else, I would be 'silently' dropping a record in an audited job
by kausmone
Fri Nov 02, 2007 6:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: server routine for eliminating headers
Replies: 7
Views: 2209

server routine for eliminating headers

Hello everyone, I am writing an application that should read data from csv files for further processing. The problem is that these csv files may or may not contain a header record, depending on the source. I know how to eliminate the header (if present) using UNIX (sed, for example does it quite ele...
by kausmone
Tue Oct 02, 2007 7:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Load Balancing using job Control
Replies: 15
Views: 5345

It was observed that the calling routine was Finishing even though the jobs that it had called hadn't completed execution. Added the following code at the end to avoid this, and including it here for the sake of completeness of the solution: For k=1 To MAX_SIM_RUNS Step 1 JobCurrStatus=DSGetJobInfo(...
by kausmone
Mon Oct 01, 2007 4:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unhandled failure encountered calling routine
Replies: 2
Views: 1200

You're right Ray. I hardcoded zero as the return and it worked :)

Thanks so much!

ciao,
kaus
by kausmone
Mon Oct 01, 2007 4:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Load Balancing using job Control
Replies: 15
Views: 5345

You are right, just that in this case, i know the total number of jobs. We can pass this as a parameter otherwise, just as the MAX_SIM_RUNS is. MAX_SIM_RUNS is passed to the routine from the calling sequencer. Similarly, the value for number of jobs can be passed as a parameter. Thanks for the input...
by kausmone
Mon Oct 01, 2007 3:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Load Balancing using job Control
Replies: 15
Views: 5345

solution...

Hi Everyone, Thanks for responding to the topic (I am the developer mentioned above :) ). We have an existing multiple-instance job-control that is calling the actual job, based on a parameter "SUBFILE_RUN_LIST". In the previous environment, this job-control was called multiple times in th...
by kausmone
Mon Oct 01, 2007 3:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unhandled failure encountered calling routine
Replies: 2
Views: 1200

Unhandled failure encountered calling routine

Hi, I am calling a server routine using a sequencer. The routine (named GNSJobRunOpt) executes a set of jobs by reading the list of jobs to run from a sequential file. When I executed the sequencer, it aborted giving the following error in the Director log as "Unhandled failure (21) encountered...
by kausmone
Thu Sep 27, 2007 7:39 am
Forum: General
Topic: Value of Job-Handle
Replies: 2
Views: 1521

Thanks for the welcome, Craig... and for the confirmation :)

I am storing job-handles in an array, wherever an empty array-element exists, so wanted to confirm if I can use 0 to identify an empty slot

kaus
by kausmone
Thu Sep 27, 2007 3:41 am
Forum: General
Topic: Value of Job-Handle
Replies: 2
Views: 1521

Value of Job-Handle

Hello,

Is 0 (zero) ever returned as a valid job-handle by the DSAttachJob function? I have always seen a non-zero integer so far, but just wanted to confirm...

Thanks,
Kaustubh