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!
double quotes for the numbers
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 315
- Joined: Tue Oct 31, 2006 3:38 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 315
- Joined: Tue Oct 31, 2006 3:38 pm
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
-
- Premium Member
- Posts: 315
- Joined: Tue Oct 31, 2006 3:38 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: