Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

PL/I small integer?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> PL/I & Assembler
View previous topic :: :: View next topic  
Author Message
John Poulakos

New User


Joined: 13 Jun 2012
Posts: 49
Location: United States

PostPosted: Wed Dec 24, 2014 2:22 am    Post subject: PL/I small integer?
Reply with quote

I need to declare a DB2 null indicator in a PL/I program, for an SQL. DB2 says it must be a "SMALLINT". I have never heard of that in PL/I. What should it be? I'm pretty sure it's one byte.
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Wed Dec 24, 2014 2:29 am    Post subject:
Reply with quote

a simple google search with db2 pl/i data types equivalence

would have taken You to

http://www-01.ibm.com/support/knowledgecenter/#!/SSEPEK_10.0.0/com.ibm.db2z10.doc.apsg/src/tpc/db2z_equivalentplidatatypes.dita
Back to top
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1238
Location: Richfield, MN, USA

PostPosted: Wed Dec 24, 2014 2:31 am    Post subject:
Reply with quote

SMALLINT is a halfword (2 Bytes). It's COBOL equivalent is PICTURE S9(4) COMP (or BINARY).
Back to top
View user's profile Send private message
John Poulakos

New User


Joined: 13 Jun 2012
Posts: 49
Location: United States

PostPosted: Wed Dec 24, 2014 10:28 pm    Post subject:
Reply with quote

Thanks a lot. I don't have internet access from work. I only had a minute to post the question from a computer with access.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> PL/I & Assembler All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Syncsort - NULL in Integer field chec... nartcr SYNCSORT 4 Thu Oct 06, 2016 6:47 am
No new posts 64bit integer in PLI sabav42 PL/I & Assembler 1 Thu Jun 26, 2014 8:07 pm
No new posts Converting Sign leading separate to n... jaidev85 DFSORT/ICETOOL 3 Thu Mar 27, 2014 9:45 am
No new posts DB2:: Division of an Integer Column b... GaganGarg DB2 15 Thu Jan 16, 2014 11:35 am
No new posts Create a small subset of MAN dataset vasanthz All Other Mainframe Topics 5 Fri Nov 15, 2013 2:16 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us