Dynamic Tables in MVS/DB2

[Les Hancock <les_hanc@YAHOO.COM>]

In trying (1) or (2)in MVS DB2:

!--------------------------------
! (1)
!--------------------------------
let $TBL = 'pshrprod.ps_dept_tbl'
begin-select
'X'
  let $found_sw = 'Yes'

from [$TBL]
where deptid  = $deptid
end-select


!--------------------------------
! (2)
!--------------------------------
let $TBL = 'pshrprod.ps_dept_tbl'
begin-select
'X'
  let $found_sw = 'Yes'

from [pshrprod.ps_dept_tbl : $TBL]
where deptid  = $deptid
end-select


I get

 (SQR 5528) DB2 SQL PREPARE/DECLARE error -104 in cursor 1:

     DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL "?". SOME SYMBOLS
THAT MIGHT BE LEGAL ARE: ( <IDENTIFIER>



If anyone has any ideas, please let me know.

Thanks

Les_Hanc@yahoo.com
_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com