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

small int to zoned decimal conversion


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
kanitha

New User


Joined: 23 Nov 2022
Posts: 3
Location: india

PostPosted: Tue Jul 23, 2024 10:45 pm
Reply with quote

Hi I have a requirement to convert SMALLINT (data in DB2 table) to displayable data using SORT. What is the datatype to be coded in OUTREC for SMALL INT.Please help.[/Search]
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 2127
Location: USA

PostPosted: Wed Jul 24, 2024 1:37 am
Reply with quote

Code:
//SYMNAMES DD  *
Small_Int_Field,x,2,BI
. . . . .
//SYSIN    DD  *
. . . . . . . .
. . . . BUILD=(...,Small_Int_Field,EDIT=(III,IIT),...),
. . . .
//*
Back to top
View user's profile Send private message
kanitha

New User


Joined: 23 Nov 2022
Posts: 3
Location: india

PostPosted: Wed Jul 24, 2024 10:40 am
Reply with quote

It worked, thanks
[/img]
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 2127
Location: USA

PostPosted: Wed Jul 24, 2024 8:26 pm
Reply with quote

kanitha wrote:
It worked, thanks

This is described in details on several first pages of any SORT manual.
Did you ever try reading one?
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 -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts GDG generation name to GDG Base name ... DFSORT/ICETOOL 3
No new posts FB to .CSV conversion using sort DFSORT/ICETOOL 7
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts 10 byte RBA conversion DB2 2
No new posts 10 byte RBA conversion -non applicati... JCL & VSAM 1
Search our Forums:

Back to Top