Search found 118 matches
- Wed Jun 16, 2004 9:04 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Suggestion Needed
- Replies: 2
- Views: 1068
Suggestion Needed
I have to run a unix script to load the data into warehouse. Is it better to use after job subroutine or a sequencer that will call the script if the job ran successfully ?
- Tue Jun 15, 2004 10:33 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: EndTime
- Replies: 2
- Views: 1050
EndTime
Is there anyway we can get the End Time of the Job. We can get startDate and Start Time, but not End Date and End Time using DS Constants..? Any Ideas?
- Tue Jun 15, 2004 9:32 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Empty Source File
- Replies: 9
- Views: 3500
Empty Source File
Thanks Guys..This Helps
- Tue Jun 15, 2004 9:06 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Empty Source File
- Replies: 9
- Views: 3500
ROW COUNT
Thanks Craig,
But when I am trying to run after job routine for row count, its giving compilation errors. Says DSAttachJob needs to be dimensioned. What I am trying to do is first Attach the job, then get job info, stagelist and then row count. But its not working...
But when I am trying to run after job routine for row count, its giving compilation errors. Says DSAttachJob needs to be dimensioned. What I am trying to do is first Attach the job, then get job info, stagelist and then row count. But its not working...
- Tue Jun 15, 2004 5:03 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Empty Source File
- Replies: 9
- Views: 3500
Empty Source File
I want to give a warning when the source file is empty but the job should not abort. Right now if I have an empty source file, the the job aborts as the source spage cannot read the file. Can anyone tell me how to handle this situation? My requirement is that the job should not abort but should give...
- Sun Jun 13, 2004 6:31 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job Info
- Replies: 6
- Views: 3941
- Sun Jun 13, 2004 9:36 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job Info
- Replies: 6
- Views: 3941
Job Info
I have a situation where I need to log Job information in the file. There are DS routines that I can use ? And is it anyways I can run them afterstage or afterjob ? I want the timestamp, row count, job name..all these write into flat file in same job. And if someone can tell me in steps as to how to...
- Sun May 23, 2004 6:38 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sequencer Design
- Replies: 4
- Views: 1752
Sequencer Design
How to insert parameters automatically for the jobs, in sequncer. Here I dont want to enter parameters manually, it should happen automatically.
So do i have to design a job with that stores parameters in file ?
So do i have to design a job with that stores parameters in file ?
- Sun May 23, 2004 4:44 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Design Question
- Replies: 4
- Views: 1512
Thanks Craig, But my problem is the tables on which i m doing join, are different from the tables that I will use to find Sum. So how can i use all these tables in the Driving stage. I need to have some design where I have to use two different DB stages. Suppose I have 4 tables, where i need records...
- Sat May 22, 2004 10:31 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Design Question
- Replies: 4
- Views: 1512
Design Question
Can anyone Tell me how to Design a job, where few coluns in the target files need Joins beweent table, few need Sum result and few need the record count for particular where condition in join. can you desin this within one job ?
- Thu May 20, 2004 10:24 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Can any one tell me how to view Datastage Generated Code ?
- Replies: 1
- Views: 853
- Thu May 20, 2004 10:23 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Can any one tell me how to view Datastage Generated Code ?
- Replies: 1
- Views: 763
- Wed Mar 10, 2004 11:07 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Creating Hierarchical Flat Files using DS6.0 ?
- Replies: 3
- Views: 977
Creating Hierarchical Flat Files using DS6.0 ?
Hello Everyone,
Can anyone tell me What is Hirerarchical Flat file ? and How to create a hirarchical flat file in DS 6?
Thanks
Can anyone tell me What is Hirerarchical Flat file ? and How to create a hirarchical flat file in DS 6?
Thanks