Search found 6 matches

by akhila.chitti
Wed Jan 02, 2008 4:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Decimal Range
Replies: 4
Views: 1920

Hello,

I understand that the change in the metadata range from 15,7 to 15,3 would work but then if I still need to get the output using some transformation logic or some function, then how would I be able to obtain the same?

Thanks in advance,
Akhila.
by akhila.chitti
Thu Dec 06, 2007 1:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage Warning.....
Replies: 3
Views: 1422

DataStage Warning.....

Hello, I am trying to run a load job, writing the data from a fixed-width seq file to the table. In my job, 2 of my columns in the file are Char by nature and when getting loded into the table, they become Numeric by nature. The job runs fine but tends to generate a warning: Program "JOB.208035...
by akhila.chitti
Thu Dec 06, 2007 12:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage Warning......
Replies: 1
Views: 1058

DataStage Warning......

Hello, I am trying to run a load job, writing the data from a fixed-width seq file to the table. In my job, 2 of my columns in the file are Char by nature and when getting loded into the table, they become Numeric by nature. The job runs fine but tends to generate a warning: Program "JOB.208035...
by akhila.chitti
Wed Dec 05, 2007 10:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage Warning....
Replies: 3
Views: 3048

DataStage Warning....

Hello, I have tried running a load job, wherein I am trying to load data into a table from a fixed-width seq file. The warning I get is: fsqRecType1Customer.lnkCustRead: read_fixedwidth() - row 1, too many columns in record Later on when I have used another transformer in the job wherein I have trie...
by akhila.chitti
Wed Dec 05, 2007 9:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Warning....
Replies: 2
Views: 1467

Datastage Warning....

Hello, I am trying to run a load job and the following is the Phantom error that I get: DataStage Job 920 Phantom 24848 Program "JOB.208035487.DT.1458444514.TRANS1": Line 122, Nonnumeric data when numeric required. Zero used. Could you please let me know what this means and help me to proc...
by akhila.chitti
Tue Dec 04, 2007 8:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Decimal Range
Replies: 4
Views: 1920

Decimal Range

Hello, I am trying to implement a logic within the transformer for an output column in a parallel job. This output column is producing the result like 3.24681234. I would like to see my result as 3.247. Do I use the DecimaltoDecimal function? If so, how would I write it? Is there any other way to ac...