NASCAR9 Intermediate
Joined: 08 Oct 2004 Posts: 274 Topics: 52 Location: California
|
Posted: Thu Mar 25, 2010 1:02 pm Post subject: |
|
|
Yes,
Below is what I've used in the past.
Code: |
SELECT A.NAME, A.TBNAME, B.tsname, A.COLNO, A.COLTYPE,
A.LENGTH, A.SCALE, A.NULLS, B.REMARKS, A.REMARKS
FROM SYSIBM.SYSCOLUMNS A
LEFT JOIN SYSIBM.SYSTABLES B ON A.TBNAME = B.NAME
WHERE A.NAME = 'RELATION_ID'
A different 'WHERE Condition'
WHERE A.TBCREATOR = 'FDBEL'
and A.TBNAME = 'RETIREE_SIT_TAX_REFUND'
ORDER BY A.TBNAME, A.COLNO; |
_________________ Thanks,
NASCAR9 |
|