mainframegurukul.com

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

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 ?