how to dynamically create query

Sikkandhar · New User Joined: 03 Dec 2007 Posts: 61 Location: Bangalore

I have a query which can have a variable number of variables in the select condition ranging from 5-55. the exact number will be known only after executing the rexx whereby i can get the variables by reading a file.

im stuck now at writing the query. I tried reading up on stored procedures also but they seem to be a little confusing.

any help in this regard is appreciated.

thanks

Srihari Gonugunta · Posted: Thu Dec 27, 2007 6:41 pm

You can use DSNREXX interface to prepare the SELECT query dynamically.

Please see the following topic for further information
ibmmainframes.com/post-59232.html

Sikkandhar · New User Joined: 03 Dec 2007 Posts: 61 Location: Bangalore

i have used cobol not rexx