Thanks for the response.
how do I exit from the loop? using terminator activity? but this would abort the sequence. Can I exit grace fully without aborting the sequence.
Search found 115 matches
- Thu May 08, 2008 1:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Run set of jobs based on input file using loop
- Replies: 7
- Views: 3773
- Thu May 08, 2008 12:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Run set of jobs based on input file using loop
- Replies: 7
- Views: 3773
- Wed May 07, 2008 11:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Run set of jobs based on input file using loop
- Replies: 7
- Views: 3773
Run set of jobs based on input file using loop
Hi, I have a scenario where Job1, Job2 and Job3 run in a sequence one after another. Input for Job 1 is a sequential file and output for job3 is the same sequential file. I want to put these 3 jobs in a sequence and run in a loop untill the input sequential file is "empty". Can this be ach...
- Tue Apr 15, 2008 12:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error reading nullable date from sequential file
- Replies: 4
- Views: 2190
- Mon Apr 14, 2008 11:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error reading nullable date from sequential file
- Replies: 4
- Views: 2190
- Mon Apr 14, 2008 11:42 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error reading nullable date from sequential file
- Replies: 4
- Views: 2190
Error reading nullable date from sequential file
Hi, We have problem in reading CSV sequential file. The date column is nullable and is a empty string when null. The null field value is set to "", the SQL Type set for the column is Date with length 10. The date format is %yyyy-%mm-%dd. At field "dt": A fixed length field cannot...
- Wed Aug 15, 2007 6:39 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Parameterize path of command for in execute command activity
- Replies: 3
- Views: 2132
- Wed Aug 15, 2007 5:38 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Parameterize path of command for in execute command activity
- Replies: 3
- Views: 2132
Parameterize path of command for in execute command activity
Hi We have a shell script which is executed after a job successfully completed. The script is executed through "Execute Command Activity". But the problem is we have to pass the full path of the script in the "Command:". We want to parameterize the path of the script which would ...
- Sun Jul 08, 2007 12:23 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Oracle OCI Stage
- Replies: 5
- Views: 2903
Craig, Thanks for your response. I'm certainly not an angry man and dont have high BP, I control my diet and exercise daily for this. :D Allow me to explain my problem: We are facing problem whenwe use the Date datatype in my source-target columns. If we simply allow the stage to generate the SQL in...
- Tue Jul 03, 2007 4:41 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Oracle OCI Stage
- Replies: 5
- Views: 2903
- Tue Jul 03, 2007 3:01 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Oracle OCI Stage
- Replies: 5
- Views: 2903
Oracle OCI Stage
Hi, We are using the 8.0.1 version. We are facing problem while reading and writting from and to Oracle OCI stage. Though we can view (view button) the data from the stage but when the job runs we get the following error:ORA-01036: illegal variable name/number. But the same query runs fine from SQL ...
- Wed Jun 20, 2007 6:43 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problem when importing column defination
- Replies: 3
- Views: 2021
- Wed Jun 20, 2007 5:26 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problem when importing column defination
- Replies: 3
- Views: 2021
Problem when importing column defination
Hi Guys,
I have problem when I try import table defination through Plug-in metadata table defination.
The length for varchar2 and char are not imported.
While there is no problem when we import through ODBC.
I have problem when I try import table defination through Plug-in metadata table defination.
The length for varchar2 and char are not imported.
While there is no problem when we import through ODBC.
- Sat May 19, 2007 5:02 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Difference Between Domain and Server
- Replies: 3
- Views: 2810
Difference Between Domain and Server
Hi
In the 8.0.1 version when we login it asks for a Domain and Server.
What is the difference between the two.
In the 8.0.1 version when we login it asks for a Domain and Server.
What is the difference between the two.
- Tue May 08, 2007 12:26 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Difference between version 7.5 & 8.0
- Replies: 3
- Views: 1841