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.
Search found 6 matches
- 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
- 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...
- 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...
- 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...
- 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...
- 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...