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

having problem in writing the query


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
gireesh.c

New User


Joined: 11 Jul 2005
Posts: 1

PostPosted: Fri Apr 21, 2006 10:43 am
Reply with quote

i have a screen which is done by front end people. in that there are some 8 options and each option contains 2 to 3 suboptions. if the user selects these options the result should be displayed on the next screen.
this is an online application.
please anyone tell me how to retrieve the records from the table for this problem.
thanks and regards,
gireesh.
Back to top
View user's profile Send private message
DavidatK

Active Member


Joined: 22 Nov 2005
Posts: 700
Location: Troy, Michigan USA

PostPosted: Tue Apr 25, 2006 6:01 am
Reply with quote

gireesh,

Sound like your going to need some dynamic SQL in your COBOL program

Read all about it at this link for Coding dynamic SQL in application programs

Dave
Back to top
View user's profile Send private message
Hanfur

Active User


Joined: 21 Jun 2006
Posts: 104

PostPosted: Mon Jul 03, 2006 12:48 pm
Reply with quote

As Dave said its a good option to for dynamic SQL

But if are not good in that u could code separate cursor for each conditions and open the cursor only when based on the combination in which user selects..

-Han
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 Map Vols and Problem Dataset All Other Mainframe Topics 2
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 Two input files & writing counter... DFSORT/ICETOOL 12
No new posts Query on edit primary command CLIST & REXX 5
Search our Forums:

Back to Top