Hi ,
That is correct qt_ky .
I convinced my business that Decimal(2,5) do not fit in ETL world :D :D .
and defined as decimal (7,5)
closing the thread !!
Search found 10 matches
- Thu Aug 30, 2018 5:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Define decimal(2,5) in datastage ?
- Replies: 6
- Views: 3978
- Thu Aug 30, 2018 2:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Define decimal(2,5) in datastage ?
- Replies: 6
- Views: 3978
- Wed Aug 29, 2018 7:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Define decimal(2,5) in datastage ?
- Replies: 6
- Views: 3978
Define decimal(2,5) in datastage ?
Hi Gurus,
I have an attribute which talks about INTEREST_PERCENTAGE(15.12345) , is there a way to define a column as decimal(2,5) in datastage,
as a basic standard that precision can be equal are greater than scale.
Please provide your valuable inputs.
Thanks
Kishore
I have an attribute which talks about INTEREST_PERCENTAGE(15.12345) , is there a way to define a column as decimal(2,5) in datastage,
as a basic standard that precision can be equal are greater than scale.
Please provide your valuable inputs.
Thanks
Kishore
- Wed Aug 08, 2018 7:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Create HIGH HEX value
- Replies: 7
- Views: 4487
- Mon Aug 06, 2018 6:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Create HIGH HEX value
- Replies: 7
- Views: 4487
- Mon Aug 06, 2018 5:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Create HIGH HEX value
- Replies: 7
- Views: 4487
- Fri Aug 03, 2018 3:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Create HIGH HEX value
- Replies: 7
- Views: 4487
Create HIGH HEX value
Dear Gurus, I have a requirement to create a trailer record of length 30 with HIGH hex value (FF) in ebcidic format,fixed width so that mainframes can invoke it ,able to create one "FF" using Conversion("255","MX","O") in transformer and write to CFF stage / p...
- Fri Apr 01, 2016 8:25 pm
- Forum: General
- Topic: Way to generate automated Excel templates?
- Replies: 8
- Views: 7936
Thanks craig / qt_ky , I am not familiar with HTML language and in this HTML approach can we merge 5 different layouts ?.. I am exploring this , once my data is ready in a tab , need to move another csv(xls/xlsx doesnt work) which has that macro but again when we move the to windows does this reflec...
- Thu Mar 31, 2016 11:22 pm
- Forum: General
- Topic: Way to generate automated Excel templates?
- Replies: 8
- Views: 7936
- Thu Mar 31, 2016 3:07 am
- Forum: General
- Topic: Way to generate automated Excel templates?
- Replies: 8
- Views: 7936
Way to generate automated Excel templates?
Champs , Team is generating an excel report with the batch cycle run details manually which takes 30-45 mins every day and I am in a process to automate that report. Except cosmetic changes ( headings / font size / Textcolour /background colour) . I am able to generate the report with a simple paral...