Search found 73 matches
- Tue Jan 11, 2005 8:10 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Line Terminators
- Replies: 2
- Views: 1061
Line Terminators
I have created a file where one of the fields is a CDU Number which we have formatted to a PIC COMP field. Within some of these values will be the EBCDIC value of 10 (<LF>). I have handled this within DS by changing the "Contains terminators" value within the file to YES for the relevant f...
- Tue Jan 11, 2005 4:12 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataTypePicComp
- Replies: 35
- Views: 10149
- Tue Jan 11, 2005 3:53 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataTypePicComp
- Replies: 35
- Views: 10149
- Tue Jan 11, 2005 1:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataTypePicComp
- Replies: 35
- Views: 10149
- Tue Jan 11, 2005 1:43 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataTypePicComp
- Replies: 35
- Views: 10149
Arnd Another issue that has come to light is that when we run the job and the output file of the converted Customer Numbers is created, one of the lines has the following error: UKWHCustSegtIntCDUXtct3Job..CDURefreshFile.DSLink335:read_fixedwidth() - row 55, column CDU_CIN, column unexpectedly ended...
- Mon Jan 10, 2005 9:05 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataTypePicComp
- Replies: 35
- Views: 10149
Found the problem but on't have the answer. Your routine works perfectly.. the problem we have is: List of Numbers: 40 44 74 When your routine converts them we get: ( , J Which have the following hex values: 28 2C 4A When we transfer this to mainfrme via NDM (either bin or text) we get the following...
- Mon Jan 10, 2005 3:08 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataTypePicComp
- Replies: 35
- Views: 10149
- Mon Jan 10, 2005 2:56 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataTypePicComp
- Replies: 35
- Views: 10149
Arnd
Should this be sufficent then within the routine ?
With Arg1 being the Customer Number
Or should I also trim ANS ?
Cheers
Jez
Should this be sufficent then within the routine ?
Code: Select all
WorkString = OCONV(trim(Arg1),"MX")
Or should I also trim ANS ?
Cheers
Jez
- Mon Jan 10, 2005 2:29 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataTypePicComp
- Replies: 35
- Views: 10149
- Fri Jan 07, 2005 9:16 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataTypePicComp
- Replies: 35
- Views: 10149
Arnd We have a Customer Number: 0123456789 0122222222 0999999999 We need to convert these within DS to be in the format: PIC S9(9) COMP. (I understand these will be gibberish, but want to then re-run this file through the inbuilt conversion to check before we send the file off). Any ideas Welcome, l...
- Fri Jan 07, 2005 9:15 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataTypePicComp
- Replies: 35
- Views: 10149
Arnd We have a Customer Number: 0123456789 0122222222 0999999999 We need to convert these within DS to be in the format: PIC S9(9) COMP. (I understand these will be gibberish, but want to then re-run this file through the inbuilt conversion to check before we send the file off). Any ideas Welcome, l...
- Fri Jan 07, 2005 8:36 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataTypePicComp
- Replies: 35
- Views: 10149
- Fri Jan 07, 2005 5:22 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Phantom Errors
- Replies: 3
- Views: 1877
Phantom Errors
I have been getting the following warnings when running a DS Job. It involves the conversion of CHAR vakues to a COMP PIC value.
Any ideas what this warning may mean ?
Any ideas what this warning may mean ?
Code: Select all
DataStage Job 1941 Phantom 24759
28
2C
4A
66
68
DataStage Phantom Finished
- Wed Jan 05, 2005 2:58 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataTypePicComp
- Replies: 35
- Views: 10149
- Tue Jan 04, 2005 9:57 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataTypePicComp
- Replies: 35
- Views: 10149