Search found 2 matches

by gsb198926
Thu Jul 27, 2017 7:38 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: How to check constraints for DB2 table in mainframe
Replies: 0
Views: 3716

How to check constraints for DB2 table in mainframe

Hello everyone,
Need help regarding constraints and checks for a DB2 table
How can we find out what constraints are defined on a Table ?
we can see index and column information in SYSIBM.SYSCOLUMNS and SYSIBM.SYSINDEXES but is there any way we can get the constraints for the table


Thanks
by gsb198926
Thu Jul 27, 2017 3:01 pm
Forum: TSO, CLIST & REXX
Topic: to copy dynamic files to a gdg
Replies: 1
Views: 2502

this can be achieved using SORT : //STEP00 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTIN DD DSN=< input.file >,DISP=SHR //SORTOUT DD DSN=output.file.gdg(+1), // DISP=(NEW,CATLG,DELETE), //SYSIN DD * SORT FIELDS=COPY /* are you looking for REXX ?