Search found 55 matches

by hi_manoj
Fri Mar 15, 2013 1:16 am
Forum: General
Topic: Automate to run 3 jobs as and when available.
Replies: 6
Views: 2439

Hi All, Prasson, Thanks a lot for you effort, can this be done in one sequence if not I will convince them to have 3 seq one for each job startloop----> waitforfile------>JobA ---->ExecCommand---->EndLoop I want to run the job between 6 am to 8 pm. As per your approach the job will start and it will...
by hi_manoj
Fri Feb 22, 2013 6:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue with constraint in Transformer
Replies: 5
Views: 2375

Any help Guy's. I have reverse the condition (x>y change to y<x) but no luck.

One more thing I like to share regarding this issue, If i change the order of A,B,C then no data is going to any of the link.

Please help.

Regards
Manoj
by hi_manoj
Fri Feb 22, 2013 4:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue with constraint in Transformer
Replies: 5
Views: 2375

No I have not check the Otherwise check box, I have rechecked it and not of the check box is checked for any of the 5 links.

I mean Othewise/Logs is unchecked for all the link
by hi_manoj
Fri Feb 22, 2013 4:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue with constraint in Transformer
Replies: 5
Views: 2375

Issue with constraint in Transformer

Hi, My Target are sequential file. Before target i have a transformer and from Transformer I have 5 out put links (my target files) Suppose My transformer is T and out put link are A,B,C,D,E. There is a constraint for each out put link. Out of the 5 constraint 3 are same (say constraint for link A,B...
by hi_manoj
Wed Jan 09, 2013 3:26 am
Forum: General
Topic: Routine Statement not understood
Replies: 4
Views: 1731

Ray, I have understood this only part from the book (that you have mention) , but when I look at the code how it is being used was my question. If anyone has any handy document to understand routine please share.

Regards
Manoj
by hi_manoj
Wed Jan 09, 2013 2:15 am
Forum: General
Topic: Routine Statement not understood
Replies: 4
Views: 1731

Routine Statement not understood

Hi All, I have started working on routine , I was trying to debug few that are already available in my project. I understand what it is doing, but there were few statements that I have not understood and they are 1) Common /SDKStringDecode/ Initialized, ValueArray, LookupArray 2) Difference between ...
by hi_manoj
Sat Mar 10, 2012 2:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can it be possible to calculate sum of salary and number of
Replies: 3
Views: 1643

Can it be possible to calculate sum of salary and number of

Hi I was trying to implement a senario where i have in comming data from a dataset. I am trying to do this with one aggregator stage Empno Deptno Salary 1111 10 200 2222 20 300 3333 10 400 4444 30 400 5555 20 400 6666 10 400 oupt put Deptno Sum_Salary Mem_count 10 1000 3 20 700 2 30 400 1 Regards Ma...
by hi_manoj
Thu Aug 18, 2011 7:14 am
Forum: General
Topic: Retrive a vlaue from one job and use that in a different job
Replies: 2
Views: 1665

Retrive a vlaue from one job and use that in a different job

Retrive a vlaue from one job and use that in a different job while reading from source, In detail I am reading from a table (oracle) and writing to a dataset (or if suggested can be a seqential file). From table i am select just one column for a max(vlaue) in the where condition and it is retrieving...
by hi_manoj
Wed Aug 17, 2011 11:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: execution mode for Oracle Enterprise stage
Replies: 3
Views: 2246

Thanks a lot Ray.. So you are saying if source table is partition then only the source stage execution mode will be parallel. else it will run in sequential mode. Is there any way to read the table (not partition) in parallel execution mode, This task i am doing for performance improvement. Table pa...
by hi_manoj
Wed Aug 17, 2011 4:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: execution mode for Oracle Enterprise stage
Replies: 3
Views: 2246

execution mode for Oracle Enterprise stage

Hi All, I am reading from Oracle Enterprise stage and writing to dataset stage. My question is related to execution mode of the stage. Here i am trying to explain my job design. I have 2 different flows in the same pallet reading from 2 different table Oracle --> Transformer stage --> Dataset satge ...