Search found 233 matches
- Wed May 07, 2008 1:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DSExecute return code
- Replies: 2
- Views: 2564
- Wed May 07, 2008 10:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DSExecute return code
- Replies: 2
- Views: 2564
DSExecute return code
Hi Gurus, I'm trying to create a server routine in 8.0 with below code. cmd = "cd /opt/isproj/ctl/ ./ctlAccess 2" Call DSExecute("UNIX",cmd,Output,SystemReturnCode) Ans = Output But I get no output , but return code is 0 which is sure that its getting executing ctlAccess is a pro...
- Mon May 05, 2008 11:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date Conversion
- Replies: 5
- Views: 1844
Date Conversion
Hi Gurus,
We have date from source in packed format the data type is
S(9) 7 COMP-3 and it will always be 7 chr long. Below is the few conversion
1060101 2006-01-01
0060101 1906-01-01
-1060101 1806-01-01
I tried every sort of onversion but somehow not able to get results.
Regards,
We have date from source in packed format the data type is
S(9) 7 COMP-3 and it will always be 7 chr long. Below is the few conversion
1060101 2006-01-01
0060101 1906-01-01
-1060101 1806-01-01
I tried every sort of onversion but somehow not able to get results.
Regards,
- Mon Apr 28, 2008 10:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Universe Stage
- Replies: 3
- Views: 996
We have switched from 7.5.1a server edition to 8.0 and 7.5.1a has universe stage...but I'm not able to find it in 8.0. If its not there then is there is alternative way to store data in DS repository and run queries on it like select, insert, delete. Client is lil rigid and not allowing us to create...
- Mon Apr 28, 2008 10:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Universe Stage
- Replies: 3
- Views: 996
Universe Stage
Hi, Do we have universe stage in 8.0 or they have removed the concept of universe stage. If yes then is there is alternative stage for it. which can have select insert commands i.e. user defined query. We are using 8.0 and not able to see the universe stage , wondering whether installation team has ...
- Thu Apr 24, 2008 3:18 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Version conflict
- Replies: 5
- Views: 2953
- Thu Apr 24, 2008 2:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Version conflict
- Replies: 5
- Views: 2953
- Thu Apr 24, 2008 2:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Version conflict
- Replies: 5
- Views: 2953
Version conflict
Hi Gurus, I've 7.1, 7.5, 7.5.1a, 8.0 client installed on my machine. I'm succesfully able to switch b/w all the clients and open up jobs in all the env i.e. 7.1, 7.5,7.5.1a,8.0 but in 8.0 env I'm not able to iopen any stages when I double click on it below is the error I get. The incorrect version o...
- Thu Dec 20, 2007 11:11 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Send email for 0 rows in link
- Replies: 4
- Views: 2292
Send email for 0 rows in link
Hi, Our requirement is to send the email to users if the file is empty i.e. there are no rows processed, we want to implement the logic in ETL only. I used the below logic in stage variable, constraint and even column transformation but it only runs if if there are actually rows processed i.e. @INRO...
- Thu Oct 04, 2007 12:08 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Scheduling batch jobs
- Replies: 6
- Views: 2599
Re: Scheduling batch jobs
I got it working seems like the status UV is not getting updated as soon as first job finishes , i ut a sleep 10 in b/w two batch jobs and its working. Thanks again. [quote="shrey3a"]I've a test enviorment in which there are 2 jobs in category ....one is designed to fail always. Batch 1 - ...
- Thu Oct 04, 2007 10:47 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Scheduling batch jobs
- Replies: 6
- Views: 2599
Re: Scheduling batch jobs
I've a test enviorment in which there are 2 jobs in category ....one is designed to fail always. Batch 1 - Runs these 2 jobs in Category Batch 2- Check the status and emails and reset the jobs which is failed in category. Both Batch jobs work fine when run individually but when caled in another batc...
- Thu Oct 04, 2007 10:43 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Scheduling batch jobs
- Replies: 6
- Views: 2599
Re: Scheduling batch jobs
No warnings
Finished Job Batch::Test.
But no output when i execute it individually it runs fine......the only problem is second job do not run both the jobs are Batch jobs.
Finished Job Batch::Test.
But no output when i execute it individually it runs fine......the only problem is second job do not run both the jobs are Batch jobs.
DeepakCorning wrote:Wht does the log file of the second one say? Go to log message where it is suppose to send the mail and check.
- Thu Oct 04, 2007 10:21 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Scheduling batch jobs
- Replies: 6
- Views: 2599
Scheduling batch jobs
Hi, I'm trying to run 2 batch jobs thru sequencer job or calling them in another batch job to run them -- trigger in sequential jobs is unconditional Batch1-- Run all the jobs in a category Batch 2 - Checks the status of jobs in category emails and reset the failed and aborted ones. But first one ex...
- Wed Oct 03, 2007 1:51 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Dynamic Job name as Email subject
- Replies: 2
- Views: 912
- Wed Oct 03, 2007 11:34 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Dynamic Job name as Email subject
- Replies: 2
- Views: 912
Dynamic Job name as Email subject
Hi, I'm trying to create batch job which will go and check the status of jobs in particular categoty and email seperately or a common mail for all the jobs failed in category , The below code works and send seperate email if any job is aborted or finished with warnings ******************************...