Search found 91 matches

by pmadhavi
Mon Aug 07, 2006 3:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSD.SEQOpen Unable to create file
Replies: 9
Views: 5579

DSD.SEQOpen Unable to create file

Hi I have to generate a flat with with the timestamp in the name of the file. I gave Test_#DSJobStartTimestamp#.txt; it throws an error DSD.SEQOpen Unable to create file I gave Test_#DSJobStartTime#.txt; it throws an error. DSD.SEQOpen Unable to create file D:\TestFolder\Test16:38:43.csv. If I give ...
by pmadhavi
Tue Jul 25, 2006 10:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Difference between DS7.1 and DS7.5
Replies: 4
Views: 1272

Difference between DS7.1 and DS7.5

Hi We have DS 7.1r1 right now. We are planning to propose the client to upgrade it to DS 7.5. We need to document the differences between the 2 versions. Pls find the differences which I could Identify 1. RowSplitter and Row Merger(not in DS7.1present in DS7.5) 2. Start Loop and End loop activity(ab...
by pmadhavi
Tue Jul 11, 2006 10:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Start Loop in DS7.1
Replies: 38
Views: 10169

ray.wurlod wrote::idea: It's not a bad idea to check that DSSetParam() has worked correctly.
Thanks a lot to all of u guys.
I just added the wait command and it worked fine.
by pmadhavi
Mon Jul 10, 2006 1:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Start Loop in DS7.1
Replies: 38
Views: 10169

Show me the syntax of your UtilityRunJob(). Just copy paste the derivation for me. Also, i just tested your scenario out, it works perfectly fine for me. Also go into the job log of your Sequence job and check out its status in the last run. After the first run, somehow its not in a runnable state....
by pmadhavi
Mon Jul 10, 2006 1:03 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Start Loop in DS7.1
Replies: 38
Views: 10169

I diasabled the mutli instance option long back. Only for the first value of the csv file, the job is running successfully. But for 2nd onwards, it is showing the following warning in the main job <jobname>..Transformer_0 (DSRunJob): Job control error (-2) (DSRunJob) Job <sequencejob> is not in a ru...
by pmadhavi
Mon Jul 10, 2006 1:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Start Loop in DS7.1
Replies: 38
Views: 10169

I diasabled the mutli instance option long back. Only for the first value of the csv file, the job is running successfully. But for 2nd onwards, it is showing the following warning in the main job <jobname>..Transformer_0 (DSRunJob): Job control error (-2) (DSRunJob) Job <sequencejob> is not in a ru...
by pmadhavi
Mon Jul 10, 2006 12:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Start Loop in DS7.1
Replies: 38
Views: 10169

Hi Guru, I hope u remeber my job. I need to run a set of jobs for each input coming out of the csv file. I gave 2 values in the file. The job ran successfully for the first value but for the second value, it did not run and the status is showing @false(ie=0) and the warning that I am getting in the ...
by pmadhavi
Mon Jul 10, 2006 11:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Start Loop in DS7.1
Replies: 38
Views: 10169

I have a sequence job which consists of 3 jobs As Guru suggested I created a job in which source is the csv file and in the transformer I called a routine which in turn runs the sequence job. But before runnign the main job, if i try to compile the other jobs in the sequence I am gettign that error....
by pmadhavi
Mon Jul 10, 2006 10:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Start Loop in DS7.1
Replies: 38
Views: 10169

Its due to the constraints of the OP with respect to DS version, OS that a work arounds are provided. Atleast if the OP was on unix, life would have become so much easier :lol: I would say Craig has a very valid point. Just upgrade. Hi, Whenever I am compiling a job, I am getting the following erro...
by pmadhavi
Fri Jul 07, 2006 1:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Start Loop in DS7.1
Replies: 38
Views: 10169

Hi, I dont understand why there are so many features missing in DS7.1 I can not select a routine from sdk and assign it to the parameter in 7.1 in the job activity stage I dont have anything coming on the right side which I can browse through. If I manually enter the lookup routine, its throwing an ...
by pmadhavi
Thu Jul 06, 2006 4:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Start Loop in DS7.1
Replies: 38
Views: 10169

My friend has posted the query for me. It's the same requirement. I am still working on it. I need to take input from an excel and run a set of jobs in sequnce.All the jobs need the same input to be passed. For which u suggested me to load the input to a hashed file first and then Use UtilityHashLoo...
by pmadhavi
Thu Jul 06, 2006 1:41 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Start Loop in DS7.1
Replies: 38
Views: 10169

DSguru2B wrote:That link is not working. Its taking me to a login page and once i login, it dosnt show the topic.
The The heading of the post is:
Passing values from excel to two jobs sequentially


and it got posted on June 28 Wednesday
by pmadhavi
Thu Jul 06, 2006 1:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Start Loop in DS7.1
Replies: 38
Views: 10169

DSguru2B wrote:That link is not working. Its taking me to a login page and once i login, it dosnt show the topic.
The The heading of the post is:
Passing values from excel to two jobs sequentially


and it got posted on June 28 Wednesday
by pmadhavi
Thu Jul 06, 2006 12:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Start Loop in DS7.1
Replies: 38
Views: 10169

DSguru2B wrote:I vaguely remember the post you are mentioning. Can you kindly provide me the link to that post so that i can refresh my memory and help you.
pls check the below given link
http://dsxchange.com/viewtopic.php?t=10 ... 0e48a6d878
by pmadhavi
Thu Jul 06, 2006 12:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Start Loop in DS7.1
Replies: 38
Views: 10169

Maybe write your own job control :? I already posted a query sometime back on taking the inputs from an excel. U suggested me to load the data into hash file. I loaded the data into the hashed file and I wrote a routine to call the UtilityHashLookup which in turn fetches the required value from the...