DSXchange

Knowledge, don't know if this will help you. Can you convert your Access Database into a .csv file and then read it in Datastage as a sequential file? Once you are able to read it you should be able to do what ever you need to do with it. Once the .csv is created FTP it from windows to your UNIX sou...

Me too. Don't know if worked out for Sagar.

Me too. Don't know if worked out for Sagar.

Hi, sorry to post in an open post but I have the exact same issue and the Hex character is '0D'. Job design.. Database----------->Xfm----------------->seqfile The database gets populated with mainframe file and the hex character is coming from that mainframe file. I do not have control over how the ...

Hi, sorry to post in an open post but I have the exact same issue and the Hex character is '0D'. Job design.. Database----------->Xfm----------------->seqfile The database gets populated with mainframe file and the hex character is coming from that mainframe file. I do not have control over how the ...

Hi, don't know how your variables are set up but try separating the domain and user in 2 variable instead of 1. For example ftp -i -n -d ${HOST} << EOF user ${DOMAIN}"\"${USER} ${PWD} cd FOLDER_NAME put ${SRCFILE} ${TGTFILE} quit EOF Also, I am assuming you tried this multiple times and ba...

Hi all,

Found a solution for this.

"=":DQuote(FieldName)

This will import the Text field as is into the .csv file thus eliminating how letter 'E' is changed into exponent.
I will mark this as resolved.

I don't know about directly writing to a windows share. What you can do is write it in UNIX box and FTP it to the windows share.

I did the following..and no the extra character is fine as long as the data comes without exponent.

Fieldname : CHAR(9).

Did I miss something?

Appending the ASCII 9 doesnot work. Has anyone implemented this before? I mean not the appending part but the converting data as is part.

As per your above post how can we append ACSII 9 at the end of the column?

Hi,
Everything is consistent. Names, value.Still cannot figure out.

Hi, I have jobs that get their parameter from a UNIX file at runtime. These files are designed to accomodate the changing values of different environments. The values of these files should override whatever the value is defined at job level. But lately this is not happening. Somehow the values are n...

Hi Craig,
I donot want the exponent format data. I want the data as is..1234E567. The data is displayed correctly in datastage and I realize this is an excel problem. But if there is any solution please share.
Thanks.

Hi, I have a file which has some data as 1234E567. When I output it as a .csv file it is displayed as 1234E+112. Somehow the character "E" is read as a formula in excel. What I need is 1234E567. I tried putting the string in double quotes but again the data is displayed as 1234E567". ...