Search found 4 matches
- Wed Mar 25, 2009 7:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Schema file doubt in Datastage
- Replies: 3
- Views: 5371
Yes Chulett, I mean sign, thanks for the correction. I was very tired when I wrote the first post! I have just written the solution in the other post asorrell. Now the only problem I am having is that I need to format a 'llu' integer with sign, but I wondering if this is possible because I did not f...
- Tue Mar 24, 2009 4:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Not Null Columns of Dataset showing as Nullable
- Replies: 4
- Views: 3405
Solved
Hi Girija, I Just solved the problem, and I opened a question in another related subject: http://www.dsxchange.com/viewtopic.php?p=321253#321253 The c_format was causing the problem as datastage was expecting an int64 instead of int32 in the schema file. The error showed in this case is "FIELD ...
- Tue Mar 24, 2009 4:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Schema file doubt in Datastage
- Replies: 3
- Views: 5371
Schema file doubt in Datastage
Using the RCP to create a datafile from an oracle table I faced a problem with the format of an integer field. As I described in another the topic http://www.dsxchange.com/viewtopic.php?t=125153&highlight=null+oraclestage I was not being able to load the data in the file. I solved the problem by...
- Tue Mar 24, 2009 12:18 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Not Null Columns of Dataset showing as Nullable
- Replies: 4
- Views: 3405
Similar Problem...
I am having a simlar problem, using Datastage 7.5.2, in a parallel job. In this job I am using RCP, and I only have the fields defined in the SQL Query and in the SCHEMA File which I use to define the columns of the output sequential file. The job is only this: ======================================...