View previous topic :: View next topic
|
Author |
Message |
danylele74
New User
Joined: 03 Jul 2014 Posts: 28 Location: Italy
|
|
|
|
Hi,
i must to unload a table and in the Meanwhile converting the fileds comp / comp-3 in a numeric field (format 9999 or 9999,99 NOT 9.999,99) and the DATE fields in the format YYYYMMDD.
How can i do? Is it possible?
Thanks |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3053 Location: NYC,USA
|
|
|
|
Use DB2 functions or there are lots of sort examples here. |
|
Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
|
|
|
|
Assuming you mean from DB2 using SQL then this post should be in the DB2 section. Moving. |
|
Back to top |
|
|
|