double quotes for the numbers

kirankota79 · Post by **kirankota79** » Wed Dec 20, 2006 3:35 pm

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!

ray.wurlod · Post by **ray.wurlod** » Wed Dec 20, 2006 3:52 pm

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.

kirankota79 · Post by **kirankota79** » Wed Dec 20, 2006 7:15 pm

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

I_Server_Whale · Post by **I_Server_Whale** » Wed Dec 20, 2006 7:54 pm

No quotes for Numeric values.

chulett · Post by **chulett** » Wed Dec 20, 2006 7:54 pm

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

kirankota79 · Post by **kirankota79** » Wed Dec 20, 2006 8:16 pm

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

ray.wurlod · Post by **ray.wurlod** » Wed Dec 20, 2006 10:15 pm

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.