Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
db2-embeded sql

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
karthikuma

New User


Joined: 29 Mar 2005
Posts: 62

PostPosted: Wed Jul 20, 2005 12:21 pm    Post subject: db2-embeded sql
Reply with quote

Hi,

In embeded sql how to select all the data,(without using cursor and single-select statement).plz give me an gusestion this is an interview question.select * is not allowed in embeded sql.
Back to top
View user's profile Send private message

gangas

New User


Joined: 20 Jul 2005
Posts: 15

PostPosted: Wed Jul 20, 2005 2:24 pm    Post subject:
Reply with quote

we need to all the columns in select query
Back to top
View user's profile Send private message
gangas

New User


Joined: 20 Jul 2005
Posts: 15

PostPosted: Wed Jul 20, 2005 2:24 pm    Post subject:
Reply with quote

we need give all the column names in select query
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Diff between select in QMF/SPUFI and ... bnveena Mainframe Interview Questions 7 Tue Apr 06, 2010 10:41 am
No new posts Can we use select * in the embeded sql manjunathkv DB2 3 Thu Sep 11, 2008 1:15 pm
No new posts DATE SELECT: embeded sql in cobol pro... dick scherrer DB2 4 Tue Aug 07, 2007 2:20 pm
No new posts Pass value to embeded DB2 prgm using ... ajishvijay COBOL Programming 3 Wed Dec 20, 2006 4:29 pm
No new posts Embeded sql statements in Cobol-db2 p... Gops DB2 2 Mon Aug 01, 2005 12:18 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us