zOs/SQL/GUBLER
SELECT CHAR(P.NAME,22), CHAR(P.CREATOR, 8), 00010010
CHAR(P.TSNAME, 8), CHAR(A.TSNAME,8), 00020010
CHAR(P.DBNAME, 8), CHAR(A.DBNAME, 8) 00030010
FROM SYSIBM.SYSTABLES P 00040010
LEFT JOIN SYSIBM.SYSTABLES A 00050010
ON P.NAME = A.NAME AND A.CREATOR = 'VDPS2' 00060010
WHERE P.CREATOR LIKE 'GDB04%' 00070010
AND P.NAME IN ('VTRESTRICTIONSUSP ', 00080012
'VTCSMFSMANDDETAIL ', 00090005
'VTCONDITIONTRACK ', 00100005
'VTCONDCOMPONENTPRO ', 00110005
'VTCFCONDITION ', 00120006
'VTTRUST ', 00130014
'VTTRUSTDETAIL ', 00140014
'CTINSTRSP42DETAILS ', 00170006
'VTUNDERFIXREFCOMP ', 00180006
'VTTRADINGPLACE ', 00190006
'VTTIMEZONEINFO ', 00200006
'VTSPECTRADINGDAY ', 00210006
'VTUNDERFIXINGREF ', 00220006
'VTMANDATORYEXDATE ', 00230006
'VTOFFERCONDEXDATE ', 00240006
'VTCFEVENTEXDATE ', 00250006
'VTCASHFLOWREINLIST ', 00260006
'VTTRDPHYSSECCHANGE ', 00270006
'VTTRDPHYSSECOFUNC ', 00280006
'VTTRDPHYSSECTRANS ', 00290006
'VTTRDPHYSSECVALID ', 00300006
'VTCONTRACTSPECIFIC ', 00310006
'VTTRDSTATISTICS ', 00320006
'VTEOMLISTGROUPKEY ', 00330006
'VTEXDATE ', 00340006
'VTUNDERFXCOMPONENT ', 00350006
'VTFUTUNDERFXSTRUCT ', 00360006
'VTOPTUNDERFXSTRUCT ', 00370006
'VTLINUNDERFXSTRUCT ', 00380006
'DTUNDERFIXCOMP ', 00390006
'VTCFREINVESTLIST ', 00400006
'VTLISTING ', 00410006
'VTLISTGROUPSCHEME ', 00420006
'VTLISTINGGROUP ', 00430006
'VTLISTINGIDENT ', 00440015
'VTLISTINGIDENT_OLD ', 00440115
'VTINSTRRESTRICTION ', 00442015
'VTINSTRRESTRICTION_OLD') 00450008
ORDER BY P.CREATOR, P.NAME 00460013
00470000
; 00480000
X 00490000
CREATE TABLE GDB0414.VTRESTRICTIONSUSP 00500000
CREATE TABLE GDB0414.VTCSMFSMANDDETAIL 00510000
CREATE TABLE GDB0414.VTCONDITIONTRACK 00520000
CREATE TABLE GDB0413.VTCONDCOMPONENTPRO 00530000
CREATE TABLE GDB0408.VTCFCONDITION 00540000
ALTER TABLE GDB0413.VTTRUST ADD 00550000
ALTER TABLE GDB0413.VTTRUSTDETAIL ADD 00560000
ALTER TABLE GDB0414.CTINSTRSP42DETAILS 00570000
ALTER TABLE GDB0414.CTINSTRSP42DETAILS 00580000
ALTER TABLE GDB0414.CTINSTRSP42DETAILS 00590000
ALTER TABLE GDB0415.VTUNDERFIXREFCOMP 00600000
ALTERFORGETDATA TABLE GDB0413.VTTRADINGPLACE 00610000
ALTERFORGETDATA TABLE GDB0413.VTTIMEZONEINFO 00620000
ALTERFORGETDATA TABLE GDB0413.VTSPECTRADINGDAY 00630000
ALTERNODATA TABLE GDB0415.VTUNDERFIXINGREF 00640000
ALTERNODATA TABLE GDB0411.VTMANDATORYEXDATE 00650000
ALTERNODATA TABLE GDB0412.VTOFFERCONDEXDATE 00660000
ALTERNODATA TABLE GDB0415.VTCFEVENTEXDATE 00670000
ALTERNODATA TABLE GDB0414.VTCASHFLOWREINLIST 00680000
ALTERNODATA TABLE GDB0413.VTTRDPHYSSECCHANGE 00690000
ALTERNODATA TABLE GDB0413.VTTRDPHYSSECOFUNC 00700000
ALTERNODATA TABLE GDB0413.VTTRDPHYSSECTRANS 00710000
ALTERNODATA TABLE GDB0413.VTTRDPHYSSECVALID 00720000
ALTERNODATA TABLE GDB0409.VTCONTRACTSPECIFIC 00730000
ALTERNODATA TABLE GDB0413.VTTRDSTATISTICS 00740000
ALTERNODATA TABLE GDB0409.VTEOMLISTGROUPKEY 00750000
ALTERDATARENAMECOL TABLE GDB0409.VTEXDATE 00760000
ALTERDATARENAMECOL TABLE GDB0415.VTUNDERFXCOMPONENT 00770000
ALTERDATARENAMECOL TABLE GDB0409.VTFUTUNDERFXSTRUCT 00780000
ALTERDATARENAMECOL TABLE GDB0412.VTOPTUNDERFXSTRUCT 00790000
ALTERDATARENAMECOL TABLE GDB0411.VTLINUNDERFXSTRUCT 00800000
ALTERDATARENAMECOL TABLE GDB0414.DTUNDERFIXCOMP 00810000
ALTERDATARENAMECOL TABLE GDB0408.VTCFREINVESTLIST 00820000
ALTERDATARENAMECOL TABLE GDB0411.VTLISTING 00830000
ALTERDATARENAMECOL TABLE GDB0411.VTLISTGROUPSCHEME 00840000
ALTERDATARENAMECOL TABLE GDB0411.VTLISTINGGROUP 00850000
ALTERDATAMANUAL TABLE GDB0411.VTINSTRRESTRICTION 00860000