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

What will be the result of below query
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
sivatechdrive

Active User


Joined: 17 Oct 2004
Posts: 191
Location: hyderabad
PostPosted: Wed Nov 10, 2004 5:28 pm
 Reply with quote
what will be the result of below query


select '1' ,empno from emptable
where ssn= 000010


the table has empid,empno,ssn fields
what does is mean giving literals in a query ( '1')

Thanks
Siva
Back to top
View user's profile Send private message
anuradha

Active User


Joined: 06 Jan 2004
Posts: 247
Location: Hyderabad
PostPosted: Wed Nov 10, 2004 8:00 pm
 Reply with quote
Hi Siva,

Suppose the emptable has rows like:

10 200 000010
20 400 000020

then the result of the query is:

1 200 000010
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 RC query -Time column CA Products 3
No new posts Dynamically pass table name to a sele... DB2 2
No new posts Query on edit primary command CLIST & REXX 5
No new posts Query on edit primary command CLIST & REXX 1
No new posts first column truncated in search result IBM Tools 13
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