Search found 4 matches

by guilherme007
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...
by guilherme007
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 ...
by guilherme007
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...
by guilherme007
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: ======================================...