DSXchange

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 !!

Hi Craig,

I will have to define this attribute manually in datastage and in netteza and yes my parallel job do not compile when I defined like decimal(2,5).

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

Hi ,

we agreed on populating default values
Thanks for your time .
Iwill close this marking as workaround.

Hi Franklin,
Thanks for your reply.
You are correct as we do this transformation in ASCII set up and write to EBCIDIC file using CFF stage and not sure how datastage would understand our generated values (xFF ) and writes to EBCIDIC file.

Hi Franklin, Thanks for your inputs . I tried as you suggested but its not working as expected. 1)stagevariable:- Space(30) or ' ' -(tried with both) 2) Convert(' ','xFF',StageVar_1). And HEX value i see in the ebcidic file is "A7" not "FF" . Hi Ray , Thanks for your input. I tri...

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...

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...

Thanks craig & mamu kim . @ Mamu Kim , Could you please explain this in little more details ?.. build table tag. Then row tag. Field tag. Field value. Close field tag. Close row tag. what I doing is pulling our needed data from oracle (5 sqls ) and creating 5 csv files and finally appending in o...

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...