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
Search found 2 matches
Search found 2 matches • Page 1 of 1
- 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
- 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 ?