DSXchange

I am taking a table from db2 database into a sequential file. In the db2 table there are two double (data type) columns. The data looks like follow:

3.87675610000000006E+01 for both the columns.

When i set the format as double quote (") for sequential file, iam getting the doublequotes for all the columns except these two. and i cannot see the rows containing this type of data from datastage view. can anybody please tell me how i will get the doublequotes for these columns!

If you must, select them as VarChar, possibly using a CAST function in the column derivation in the DB2 stage. But why do you think you need double quotes? It's a numeric value - the "rules" for CSV files specify quotes for character string data.

can u tell me the rules for CSV for numeric values?

No quotes for Numeric values.

Seeing as how quotes are only for character strings, numeric values would fall into the "no quotes" camp.

I have a mix of columns with character and numeric. How can i proceed then?

With impunity.

Set the format for Quote character to match the quotes on your character strings. Numeric files will be expected not to be quoted.