DSXchange

Hi, I have a requierment like i am extarcting the data from a query using teradata stage and in that for automation i need to pass year and month to the query. The year and month should be pass from the sequencer becuase it will take the values when ever we run the seq and pass it to the job inside....

Actaully it will come either way like if we see it from unix box it will showing " (123,45)" and if we open directly from windows with XL it is showing -123,25. so finally i should move this record to target like decimal value(00000.00). Please note the there is a space between quote("...

Hi thanks for u r reply..

But need to put this in if condition .......?

Rd,
pr.

Hi, The requirement is we have a .csv file which comes from external server with having the data like 123,10,10,20," 465,45 " 123,10,10,10," (456,45)" (amount field) and if i open the same .csv file with XL sheet it will show the amount field data for this " (456,45)" a...

Hi Craig,

I am using DemailToString(Colname,"suppress_zero")...


Rd,
pradeep.

Hi, I have a scenario like from source i am getting amount value as -450000.00,it is a varchar and i am converting it to decimal for one mutiplication activity .Finally i am trying to load it into a sequential file by converting it to a varchar as customer needs.But in the sequential file i am getti...

Hi, Please find the below info : -The requirement is i have one sequntial file which will give two output files one is actual file will have amount data and its corresponding columns and one will have amount as zero and its corresponding columns. -After this i need to load the actual file(amount) in...