Re: SQL Option for DSPFFD

I use ACS-RSS and saved this in the SQL Examples.
I change the library name (MyDataLibrary) and table name (MyTable) in the
two Create Variable commands then run them and run the next Select. Gives
me more information than I need most of the time.
If I need to know the dependencies I run the next Select.
If I need a list of columns comma separated to paste into another SQL I run
the last Select.

-- category: .SYS
-- description: sys_Table_Information
-- =========+=========+=========+=========+=========+
-- Create a work variable with search value Change the default and run
both
CREATE OR REPLACE VARIABLE MyLibrary.@vtmpsql01 CHAR(10) DEFAULT
'MyDataLibrary' -- Library
;
CREATE OR REPLACE VARIABLE MyLibrary.@vtmpsql02 CHAR(10) DEFAULT 'MyTable'
-- Table
;