Search found 26 matches
- Thu Jan 24, 2013 2:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Complex Flat File with Occurs in the table
- Replies: 6
- Views: 2073
Complex Flat File with Occurs in the table
Hi Guys, I unable to find a way to derive this in the complex flat file . Below is the copy book 01 C-MSG-DTA-PORT-MRK. 10 C-MSG-DTA-PORT-MRK-TBL OCCURS 10 TIMES INDEXED BY PORT-SUB. 15 C-SHP-ORD-CTL-NO PIC X(9). 15 C-PORT-MRK-LN-NO PIC 9(3). 15 C-PORT-MRK-TXT PIC X(40). 05 FILLER PIC X(274). How ca...
- Fri Mar 13, 2009 2:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading multiple files
- Replies: 4
- Views: 2985
- Wed Jul 16, 2008 3:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Bad dboption error
- Replies: 1
- Views: 1562
Bad dboption error
Hi All,
I am getting the following error Bad dboption list. Failed on Expected "," or "}", got: "@", line 1 when I am running the job from the sequencer.
But same error is not coming when I am running the job.
Thanks in Advance
I am getting the following error Bad dboption list. Failed on Expected "," or "}", got: "@", line 1 when I am running the job from the sequencer.
But same error is not coming when I am running the job.
Thanks in Advance
- Tue Mar 11, 2008 11:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Pivoting
- Replies: 2
- Views: 1900
Pivoting
Hi, I have need clarification to do this scenario, My input is this....... Col1 Col2 Col3 1 A RT 1 A PT I need to have output as this.... Col1 Col2 Col3 Col4 1 A RT PT Can anyone help on this.. Thanks in Advance.......
- Mon Oct 08, 2007 1:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: If count exceeds Job should Abort
- Replies: 3
- Views: 1744
If count exceeds Job should Abort
Hi,
I have scenario in that a lookup stage is used for that I need to use two links one reject and other is stream link.
If the count in the reject link exceeds 100 records the Job should abort
Can anyone help me to do this
Thanks in Advance
I have scenario in that a lookup stage is used for that I need to use two links one reject and other is stream link.
If the count in the reject link exceeds 100 records the Job should abort
Can anyone help me to do this
Thanks in Advance
- Fri Sep 07, 2007 5:47 am
- Forum: General
- Topic: Problem with Bigint when getting Nulls
- Replies: 3
- Views: 2108
- Fri Sep 07, 2007 5:26 am
- Forum: General
- Topic: Problem with Bigint when getting Nulls
- Replies: 3
- Views: 2108
Problem with Bigint when getting Nulls
Hi, I have a problem when Importing the metadata for Datatype BigInt from the table. when importing the key column from the table it writes as BigInt and NotNull. I am using Join stage inorder to get this key When Join fails it should write Nulls.But instead of writing Nulls its writing "0"...
- Wed Jul 18, 2007 6:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Accomadating Shared container in Parallel job
- Replies: 2
- Views: 1342
Accomadating Shared container in Parallel job
Hi,
I need a clarification that can we use "Shared container in Parallel job" , the shared containers which are built with server jobs.
Do we get any performance related issues?
Thanks in Advance,
I need a clarification that can we use "Shared container in Parallel job" , the shared containers which are built with server jobs.
Do we get any performance related issues?
Thanks in Advance,
- Tue Jun 26, 2007 4:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Trim in Modify stage
- Replies: 20
- Views: 25231
- Mon Jun 25, 2007 5:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Trim in Modify stage
- Replies: 20
- Views: 25231
- Mon Jun 25, 2007 4:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Trim in Modify stage
- Replies: 20
- Views: 25231
Trim in Modify stage
HI ,
Can any one tell me abt the syntax to use in Modify stage for Trim function.
Thanks in Advance
Can any one tell me abt the syntax to use in Modify stage for Trim function.
Thanks in Advance
- Wed May 16, 2007 5:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Removing Duplicates using stage variables in parallel job
- Replies: 5
- Views: 3278
- Wed May 16, 2007 2:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Removing Duplicates using stage variables in parallel job
- Replies: 5
- Views: 3278
Removing Duplicates using stage variables in parallel job
Hi, I have a source file which contains duplicates in the data. I used this Derivation If Curr <> Prev Then 'Y' Else 'N' in the Stage variable and rejected the duplicate records to the sequential file which i want do it. I tried the same logic in Parallel job but it's not working. Why does this does...
- Fri May 04, 2007 2:38 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage Tx
- Replies: 1
- Views: 1236
Datastage Tx
Hi,
What for we use Datstage Tx. Can anyone tell me the exact usage of that.
If any one have material abt that please send it to me.
Thanks in Advance
What for we use Datstage Tx. Can anyone tell me the exact usage of that.
If any one have material abt that please send it to me.
Thanks in Advance
- Mon Apr 30, 2007 3:46 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Use of @FM,@IM,@TM
- Replies: 1
- Views: 1081
Use of @FM,@IM,@TM
Hi,
Can anyone help me out in the usage of @FM,@IM,@TM system variables where we exactly use this.
Thanks
Can anyone help me out in the usage of @FM,@IM,@TM system variables where we exactly use this.
Thanks