Re: Table of dynamic SQL queries

From: Paul Vernon <paul.vernon_at_ukk.ibmm.comm>
Date: Thu, 13 Feb 2003 11:53:30 -0000
Message-ID: <b2g12u$sbm$1@sp15at20.hursley.ibm.com>

"stu" <smcgouga_at_nospam.co.uk> wrote in message news:b2fubq$99r$1$8300dec7_at_news.demon.co.uk...
> Has anybody ever used/thought about a table of sql statements?
> create table SQL(Title varchar * 20, SQLText Memo)
>
> Where you can store dynamic sql to be executed at runtime. This structure
> could prove very flexible. You could also implement custom searches/reports
> for users in jig time!

Er isn't that what VIEWs are?

db2 select substr(TEXT,1,60) from syscat.views fetch first 5 rows only

CREATE VIEW SYSIBM.CHECK_CONSTRAINTS (CONSTRAINT_CATALOG, CO
CREATE VIEW SYSIBM.COLUMNS  (      TABLE_CATALOG, TABLE_SCHE
CREATE VIEW SYSIBM.COLUMNS_S   (  TABLE_CATALOG     , TABLE_
CREATE VIEW SYSIBM.REFERENTIAL_CONSTRAINTS (     CONSTRAINT_
CREATE VIEW SYSIBM.REF_CONSTRAINTS  (     CONSTRAINT_CATALOG

5 record(s) selected.

Regards
Paul Vernon
Business Intelligence, IBM Global Services Received on Thu Feb 13 2003 - 05:53:30 CST