Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Verify WITH UR present inside program in each select query
Goto page Previous  1, 2
 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CLIST & REXX
View previous topic :: :: View next topic  
Author Message
prino

Senior Member


Joined: 07 Feb 2009
Posts: 1161
Location: Vilnius, Lithuania

PostPosted: Sat Jun 15, 2019 7:06 pm    Post subject:
Reply with quote

I'm sure the DB2 precompiler generates different parameters for a call to the DB2 interface, for those cases where "WITH UR" is or isn't present. Scan the listing, and not a free-format source file!

And maybe use that obscure IBM utility, SRCHFOR...

Sheesh, another thread going nowhere.

AND REXX DOES NOT THROW ANYTHING!
Back to top
View user's profile Send private message

don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 684
Location: Whitby, ON, Canada

PostPosted: Sun Jun 16, 2019 4:21 am    Post subject:
Reply with quote

I may be late to this thread, but is there any reason why the TS cannot look at the ISOLATION column in SYSIBM.SYSSTMT? Easier than parsing source code, IMHO.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2235
Location: Hampshire, UK

PostPosted: Sun Jun 16, 2019 2:14 pm    Post subject: Reply to: Verify WITH UR present inside program in each select query
Reply with quote

Yes, well. I do not see in the SRCHFOR documentation how it can: find a keyword on one line, then find another keyword on a different line, ensure that the second keyword comes before a third keyword and, finally, then write to 2 different report data sets.

As to using the SYSSTMT table, I do not know. Maybe need another hour of research.
Back to top
View user's profile Send private message
prino

Senior Member


Joined: 07 Feb 2009
Posts: 1161
Location: Vilnius, Lithuania

PostPosted: Sun Jun 16, 2019 5:37 pm    Post subject:
Reply with quote

ISRSUPC has an option to find lines and context, but just doing a search for EXEC, END-EXEC and "WITH UR" should already greatly reduce the amount of data to be processed.

Anyway, the Db2 catalog tables should have all the info in a much easier way!
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 -> CLIST & REXX All times are GMT + 6 Hours
Goto page Previous  1, 2
Page 2 of 2

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Query on JCL abdulrafi DFSORT/ICETOOL 5 Wed Oct 16, 2019 7:02 pm
No new posts Running a REXX exec program using ZOSMF Sakthi344 CLIST & REXX 1 Tue Oct 15, 2019 3:13 pm
No new posts How to handle NULL in COBOL program bhaskar_kanteti COBOL Programming 8 Mon Oct 07, 2019 3:54 pm
No new posts REXX - CLIST program to be invoked af... pkmurali CLIST & REXX 5 Wed Sep 04, 2019 4:31 pm
No new posts Search the strings present in ps file... Bhuvana Narasimhan All Other Mainframe Topics 8 Thu Aug 22, 2019 8:20 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us