Can Inspect verb be used in a where statement.

babruvahana · New User Joined: 30 Mar 2008 Posts: 10 Location: hyderabad

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?

dick scherrer · Posted: Sat Dec 13, 2008 10:26 pm

Hello,

You need to post some examples of what you want to do. Post what might be entered on the screen and some example table data that is to be "selected".

The cobol INSPECT is not valid in an sql statement, but there may be a way to get what you want.

babruvahana · New User Joined: 30 Mar 2008 Posts: 10 Location: hyderabad

2nd screen sorrry 1st screen is printed twice

Screen shots removed per babruvahana's request

Arun Raj · Posted: Tue Dec 16, 2008 8:36 am

babruvahana,

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.

babruvahana · New User Joined: 30 Mar 2008 Posts: 10 Location: hyderabad

Thank you dick and arcvns for your replies i will check out in the db2 forum

dbzTHEdinosauer · Posted: Tue Dec 16, 2008 3:04 pm

anil.k

maybe LOCATE or POSSTR is what you are looking for.

Terry Heinze · Posted: Wed Dec 17, 2008 1:04 am

Screen shots, in addition to being discouraged here, are not a good idea when they display valid IP addresses.