I am using a CICS-COBOL-DB2 program which has a field for an ID, if the user wishes to enter a partial ID then the pgm xctl's to another screen which displays the list of ID's which begin with the ID entered in the previous screen and user can select against the record to view the details.
In coding the second screen can i use inspect verb while retreiving data from the tables in the sql query?
You need not post the screenshots unless it's really required to express your problem. As suggested above you can't have an INSPECT in an SQL. If I understood that correctly, I believe you'll be able to do that using the 'LIKE' parameter in SQL and a host variable having '%' wildcards. Search the DB2 forum. A similar topic was in discussion sometime back.