Search found 42 matches
- Mon Jun 22, 2009 4:17 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Partion Table option in DB2 Enterprise Stage
- Replies: 2
- Views: 1712
Partion Table option in DB2 Enterprise Stage
Hi, I have a query with join 3 Tables(eg : A,B,C).I defied it as User Defined Qyery in the Db2 Enterprise Stage.The job run slow as the default method of "User Defied Query" is sequential.I am trying to use the PARTION Table option to make this qury work in parallel mode.I provided value P...
- Mon Nov 13, 2006 2:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job Sequencing
- Replies: 4
- Views: 2940
- Mon Nov 13, 2006 2:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job Sequencing
- Replies: 4
- Views: 2940
Job Sequencing
Hi,
I have to design 2 jobs in such a way that on the 45th successful completion on first job I have to kick start the second job. This job will run one time and will again wait for 45 completions of Job one.
How can I implement this.
Thanks
I have to design 2 jobs in such a way that on the 45th successful completion on first job I have to kick start the second job. This job will run one time and will again wait for 45 completions of Job one.
How can I implement this.
Thanks
- Fri Sep 08, 2006 4:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: conerting a decimal(12,3) to decimal (9,2)
- Replies: 4
- Views: 2820
- Fri Sep 08, 2006 4:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: string to decimal
- Replies: 5
- Views: 2909
- Fri Sep 08, 2006 4:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Compiling job
- Replies: 3
- Views: 1661
- Thu Sep 07, 2006 5:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel Routine
- Replies: 4
- Views: 2418
Parallel Routine
Hii,
Can anyone tell me where to write the Code for a Parallel Routine.I want to wite a routine for caracter to Integer Decoder.
I can create the routine through the manger but I am not able to figure out where to write the code.(In server there is a tab as CODE).
Is it somewhere in Parallel Also.
Can anyone tell me where to write the Code for a Parallel Routine.I want to wite a routine for caracter to Integer Decoder.
I can create the routine through the manger but I am not able to figure out where to write the code.(In server there is a tab as CODE).
Is it somewhere in Parallel Also.
- Tue Sep 05, 2006 1:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: UserDefined Transforms
- Replies: 3
- Views: 3117
- Mon Sep 04, 2006 11:44 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: UserDefined Transforms
- Replies: 3
- Views: 3117
UserDefined Transforms
I have written a Built In Transforms to convert Null to Zero in the designer.
But i am not able to see it in the transformer Stage Functions.
Do we have to compile it Somewhere in Director or Manager ??
But i am not able to see it in the transformer Stage Functions.
Do we have to compile it Somewhere in Director or Manager ??
- Thu Aug 31, 2006 11:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fetch job Stats
- Replies: 8
- Views: 3370
- Thu Aug 31, 2006 8:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fetch job Stats
- Replies: 8
- Views: 3370
Fetch job Stats
Hii,
I need to fetch the job Start time,Job Termination Time and Number of times job ran into a db2 Table.
Can anyone tell me how to do that ??
Thanks
I need to fetch the job Start time,Job Termination Time and Number of times job ran into a db2 Table.
Can anyone tell me how to do that ??
Thanks
- Fri Jun 02, 2006 6:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Schema File Structure
- Replies: 16
- Views: 8941
Schema File Structure
Hi,
Can anyone give me a Schema File Templete which is used in the Sequential file Stage .Please give a exaple of what type of file is there.
Is it a csv file or what & where to store that file.
cheers,
Jayant
Can anyone give me a Schema File Templete which is used in the Sequential file Stage .Please give a exaple of what type of file is there.
Is it a csv file or what & where to store that file.
cheers,
Jayant
- Thu Jun 01, 2006 5:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: To find out duplicate records
- Replies: 9
- Views: 6528
Re: To find out duplicate records
Hi Amarpreet, In the final Transformer Stage you can concate all key columns to a long String and Store it into a Stage Variable named STG1. Now another variable STG2 = STG1. Compare the two.by this you will capture the rows in the two variables.Check them and put the constaint accordingly on the li...
- Thu Jun 01, 2006 4:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Run Time Propagation
- Replies: 6
- Views: 4597
- Tue Feb 07, 2006 4:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Db2 Stage error
- Replies: 2
- Views: 2162
Db2 Stage error
I am gettin this fatal error in my Job when i m tring to load in Db2 Enterprise Stage. DB2 Driver Embedded SQL message: SQL0311N The length of string host variable number "3" is negative or greater than the maximum. SQLSTATE=22501 ; sqlcode = -311; sqlstate = 22501 Execute failed. just a i...