DSXchange

gssr wrote:As you read the column as Varchar, you can convert it using the Type conversion technique. Do you get the whole value as Varchar(Including the decimal value)?

yes got whole value as varchar including decimal, but dont want that. want to read as decimal

Can you able to see the records in the sequential file ?. If not then check with the metadata you have mentioned and then we can go for the type conversion!! Yes I can able to see records in veiwdata, with final column as varchar. But want to read as decimal. I have another file, with two decimals ...

As you read the column as Varchar, you can convert it using the Type conversion technique. Do you get the whole value as Varchar(Including the decimal value)? I can use the type coversion but its not working. all 0's are being loaded into table in last column Just let me know the format of stringto...

Hi, I have a csv file reading using SeqFile stage. I have about 10 columns in csv file(eg. below) but the last two columns are decimals. Here is Eg. my csv file 641,ABC,2009,10,ABCDEF,GHIJKLM,111,200,485262.93,336360.00 first 8 files are varchar files and last two are decimal fields i would like to ...

How can I replicate a project in Information Analyzer. I have completed one project and want to make a copy of it with different project name.