Search found 233 matches

by shrey3a
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

Thanks a lot it worked. Regards, [quote="chulett"]You need a command delimiter between the two, otherwise all that happens in the 'cd' I'd wager. While you could use ";" I'd suggest the much nicer "&&" which tells the second command to execute only if the first ...
by shrey3a
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...
by shrey3a
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,
by shrey3a
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...
by shrey3a
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 ...
by shrey3a
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

[quote="lstsaur"]Did you use the Multi-client Manger (8.0.1) on the machine? If you have earlier version of Multi-client Manger on the machine, you must uninstall it first.[/quote] We have submitted the request to uninstall previous version of multiclient manger now do we need to uninstall...
by shrey3a
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

gpatton wrote:I believe that you must install the multi-client manager that comew with version 8
yes we have installed the multiclient manager which has come with 8.0 but then also its a problem.

Thanks,
Munish
by shrey3a
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...
by shrey3a
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...
by shrey3a
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 - ...
by shrey3a
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...
by shrey3a
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.

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.
by shrey3a
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...
by shrey3a
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

Thanks great help its working now. Thanks again! [quote="chulett"]Isn't this the same issue as your [url=http://www.dsxchange.com/viewtopic.php?t=113507]other post?[/url] :? Your other post at least showed you attempting to use the JobName, here you would send the [b]job handle[/b] if it w...
by shrey3a
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 ******************************...