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

Select COMP-3 field in SQL
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
harshadeshpande

New User


Joined: 23 Mar 2007
Posts: 5
Location: United States
PostPosted: Mon Oct 06, 2008 11:02 pm
 Reply with quote
There is a numeric field 9(16) in the table...How can I select this field as COMP-3 variable in my SQL?

Any function that you are aware of?
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA
PostPosted: Mon Oct 06, 2008 11:33 pm
 Reply with quote
Just use a numeric literal or a comp-3 host variable!
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
PostPosted: Mon Oct 06, 2008 11:44 pm
 Reply with quote
Quote:

numeric field 9(16)


no such thing in db2. what is the declared datatype?
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 Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts Dynamically pass table name to a sele... DB2 2
No new posts COBOL - Move S9(11)v9(7) COMP-3 to -(... COBOL Programming 5
No new posts Join 2 files according to one key field. JCL & VSAM 3
No new posts SELECT from data change table DB2 5
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us