|
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: 3109
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: 2454
Location: Hampshire, UK
|
|
|
|
| Assuming you mean from DB2 using SQL then this post should be in the DB2 section. Moving. |
|
| Back to top |
|
|
|
|
