Midrange News for the IBM i Community


Posted by: Bob Cozzi
Rogue Programmer
Cozzi Productions, Inc.
Chicagoland
QADBXFIL vs SYSTABLES
has no ratings.
Published: 29 Jun 2015
Revised: 09 Jul 2015 - 714 days ago
Last viewed on: 22 Jun 2017 (1646 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

QADBXFIL vs SYSTABLES Published by: Bob Cozzi on 29 Jun 2015 view comments(1)

Return to midrangenews.com home page.
Sort Ascend | Descend

COMMENTS

(Sign in to Post a Comment)
Posted by: avrSteve
Premium member *
Comment on: QADBXFIL vs SYSTABLES
Posted: 1 years 11 months 14 days 18 hours 27 minutes ago

The view defitiniton column is helpful if you have UDF's embedded in views & you need to change parameters to the UDF. Doing a sql LIKE against the column you describe saves a lot of pain. I needed to change a UDf & had trouble finding the views that use the UDF and after snooping around came up woth the stmnt below.

 

SELECT * FROM QSYS2.Views
  WHERE TABLE_SCHEMA = yourLibrary AND
        VIEW_DEFINITION LIKE '%yourUDF%';