Simple is best:
DSNAME(SYS1.&SYSNAME..MAN1,
SYS1.&SYSNAME..MAN2,
SYS1.&SYSNAME..MAN3)
...
SID(&SYSNAME)Let the system handle it. Shane ... ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html

