Page 1 of 1

dynamic query

PostPosted: Tue Feb 17, 2009 10:33 pm
by kristene
Hi

Is it posibble to write dynamic queries in a COBOL-DB2-CICS program?
I have written a COBOL program which creates a databse tablespace,table and index. But I want to take the table name from the user through a CICS (BMS) map and create the table with that user-defined name.

Re: dynamic query

PostPosted: Wed Feb 18, 2009 1:55 am
by dick scherrer
Hello,

Could you make this a "logical" table rather than a "real" table? I suspect that if 5 users create "the table" all of the tables would have the same definition, just a different "table name" (under the current scheme). You might add a new column to be the high-order part of the primary key that would be the "logical table name" and when the user enters this, use it to differentiate between user's tables.

Whether a real table is created or a logical table is identified, how will this be used by the system? What would be the purge criteria or would these just accumulate forever?

What business requirement is this meant to provide?