IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Unload a table and converting fileds


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
danylele74

New User


Joined: 03 Jul 2014
Posts: 27
Location: Italy

PostPosted: Thu Nov 26, 2015 9:00 pm
Reply with quote

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
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2568
Location: NYC,USA

PostPosted: Thu Nov 26, 2015 9:12 pm
Reply with quote

Use DB2 functions or there are lots of sort examples here.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2448
Location: Hampshire, UK

PostPosted: Fri Nov 27, 2015 4:51 pm
Reply with quote

Assuming you mean from DB2 using SQL then this post should be in the DB2 section. Moving.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Converting a file from PD to display ... SYNCSORT 4
No new posts Converting Hex to PD Special Condition SYNCSORT 3
No new posts Need to read duplicate rows from tabl... DB2 3
No new posts Unload Report in ARCHIVE from CA-Disp... CA Products 0
No new posts Hex Table COBOL Programming 2
Search our Forums:

Back to Top