I FOUND the solution :D .... I'm a stupid guy .
In the format folder, I have forgot to add Final delimiter = end.
I'm very sorry for your time and Thank you
Pey
Search found 144 matches
- Thu Sep 16, 2004 11:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Format for Opening file with Decimal in PX
- Replies: 5
- Views: 3321
- Thu Sep 16, 2004 11:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Format for Opening file with Decimal in PX
- Replies: 5
- Views: 3321
- Thu Sep 16, 2004 9:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Format for Opening file with Decimal in PX
- Replies: 5
- Views: 3321
- Thu Sep 16, 2004 8:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: warning in the sequential file
- Replies: 2
- Views: 2536
- Thu Sep 16, 2004 8:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Format for Opening file with Decimal in PX
- Replies: 5
- Views: 3321
Format for Opening file with Decimal in PX
I have a little problem: I try to open a sequential file (fixed length). For the character, that's Ok, I put blanck for the default but I cannot found the format for the decimal (length 12; scale 2) with sign (-). I have already try 000000000.00 or 0000000000.00 but It gives me an error: "##E T...
- Thu Sep 16, 2004 8:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Transformer and job parameters type
- Replies: 5
- Views: 2817
- Fri May 21, 2004 8:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Result of a division
- Replies: 4
- Views: 2365
- Thu May 20, 2004 6:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Result of a division
- Replies: 4
- Views: 2365
Result of a division
Hi everybody, In my transform, I try to divise 2 fields : A Number 9 B Number 9 My targer is C Decimal 5 scale 2 When I check the result, I never have the number after the comma. It always truncate the value. For exemple: A = 27 B = 5 C= 5.00 but the right value is 5.40 How can I revolve that? If yo...
- Mon Apr 05, 2004 9:23 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Key function
- Replies: 2
- Views: 1016
Key function
Hi, I need to do a lookup between a file and a Hash File on more fileds (6). If I use the standard technique, It's very long. I know (but I don't remember) that DataStage have a function where I can concatenate all these fields in a new field (for my two files) and after in the transform, The lookup...
- Thu Apr 01, 2004 12:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Warning :Input buffer overrun
- Replies: 1
- Views: 2997
Warning :Input buffer overrun
Sorry but Is someone have an explanation about this warning :
BusEntHeadTrail,0: Input buffer overrun at field "RECORD_ID", at offset: 0?
How can I suppress it?
Thank you,
Pey
BusEntHeadTrail,0: Input buffer overrun at field "RECORD_ID", at offset: 0?
How can I suppress it?
Thank you,
Pey
- Thu Apr 01, 2004 12:36 pm
- Forum:
- Topic: Importing Transformer Model into MetaStage error
- Replies: 4
- Views: 2720
- Fri Mar 19, 2004 1:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: File with variable length
- Replies: 1
- Views: 2326
- Fri Mar 19, 2004 11:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: File with variable length
- Replies: 1
- Views: 2326
File with variable length
Easy question for you:
I have a file with only one row but the length is variable.
How can I parameter that with the PX Sequential File Stage? At this moment I cannot open it when I try to view it under DataStage.
Thanks
Pey
I have a file with only one row but the length is variable.
How can I parameter that with the PX Sequential File Stage? At this moment I cannot open it when I try to view it under DataStage.
Thanks
Pey
- Mon Mar 15, 2004 9:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Write Load Method with Oracle Stage
- Replies: 2
- Views: 3507
Thank you for your time and your Answers, Ascential gives me the same answers than you: 1- Please connect to unix with dsadm, source the dsenv and then execute the sqlldr with the control file. to source the dsenv: cat /.dshome ( to find your $dshome directory) cd to $dshome above type: . ./dsenv ( ...
- Mon Mar 15, 2004 9:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Write Load Method with Oracle Stage
- Replies: 2
- Views: 3507
Thank you for your time and your Answers, Ascential gives me the same answers than you: 1- Please connect to unix with dsadm, source the dsenv and then execute the sqlldr with the control file. to source the dsenv: cat /.dshome ( to find your $dshome directory) cd to $dshome above type: . ./dsenv ( ...