Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Can Inspect verb be used in a where statement.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> HomeWorks & Requests
View previous topic :: :: View next topic  
Author Message
babruvahana

New User


Joined: 30 Mar 2008
Posts: 10
Location: hyderabad

PostPosted: Sat Dec 13, 2008 2:53 pm    Post subject: Can Inspect verb be used in a where statement.
Reply with quote

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?
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Dec 13, 2008 10:26 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
babruvahana

New User


Joined: 30 Mar 2008
Posts: 10
Location: hyderabad

PostPosted: Mon Dec 15, 2008 1:59 pm    Post subject: Reply to: Can Inspect verb be used in a where statement.
Reply with quote

2nd screen sorrry 1st screen is printed twice

Screen shots removed per babruvahana's request
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2237
Location: @my desk

PostPosted: Tue Dec 16, 2008 8:36 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
babruvahana

New User


Joined: 30 Mar 2008
Posts: 10
Location: hyderabad

PostPosted: Tue Dec 16, 2008 11:28 am    Post subject:
Reply with quote

Thank you dick and arcvns for your replies i will check out in the db2 forum
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue Dec 16, 2008 3:04 pm    Post subject:
Reply with quote

anil.k

maybe LOCATE or POSSTR is what you are looking for.
Back to top
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Wed Dec 17, 2008 1:04 am    Post subject:
Reply with quote

Screen shots, in addition to being discouraged here, are not a good idea when they display valid IP addresses.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> HomeWorks & Requests All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts ROUNDED Problem with COMPUTE statement shalem COBOL Programming 11 Thu Feb 09, 2017 8:16 pm
No new posts VALIDATE NULL VALUE IN DB2 CASE STATE... useit DB2 5 Thu Feb 09, 2017 4:34 pm
No new posts -913/-911 Deadlock during UPDATE stat... NoSleep319 DB2 5 Fri Nov 18, 2016 12:37 am
No new posts COBOL DB2 - CALL statement - high CPU... TS70363 DB2 15 Sun Sep 11, 2016 6:07 am
No new posts Converting NULL column into NOT NULL ... Raghu navaikulam DB2 5 Sat Aug 06, 2016 3:45 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us