Hi ArndW,
Thanks for your suggesion. I have tried like if I am using numeric datatype, I got exact output but after the value dot(.) was present.
Ex. 0000012345. like this....
I'll try ur idea too....
Thankyou very much
Regards,
Gopal
Search found 18 matches
- Wed Jun 18, 2008 5:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Column Length - Scale
- Replies: 3
- Views: 1511
- Wed Jun 18, 2008 4:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Column Length - Scale
- Replies: 3
- Views: 1511
Column Length - Scale
Hi,
If I am defining the legth of column is 10(Integer Type) but my real data length is only 5. I need to use all length which is specified in the column metadata.
My real data is : 12345 but I need a format like this. i.e 0000012345
Could u pls help me out how can I achieve this...
If I am defining the legth of column is 10(Integer Type) but my real data length is only 5. I need to use all length which is specified in the column metadata.
My real data is : 12345 but I need a format like this. i.e 0000012345
Could u pls help me out how can I achieve this...
- Wed Jun 18, 2008 4:02 am
- Forum: General
- Topic: Information Server
- Replies: 2
- Views: 1133
Information Server
Hi,
I would like to know about complete outline of DataStage Information Server and difference between PX and this.
May I know the difference between PX and TX
I would like to know about complete outline of DataStage Information Server and difference between PX and this.
May I know the difference between PX and TX