ODBC in SQRs

[Les Brugere <Les_Brugere@AISMAIL.WUSTL.EDU>]

Hello,

I'm attempting to access a DB2 database using the ODBC command as follows:

BEGIN-SELECT -DBDSN=FIDTFSRL;UID=WPUSTST;PWD=PSHR
Z.ROW_IDENT &Z.ROW_IDENT
FROM DBATEST.FIT_HR_PROF_CHGS Z
END-SELECT

The IBM DB2 ODBC DRIVER is installed and the DSN is called FIDTFSRL.   The
platform is NT/SQL Server.

I continue to recieve this error:

(SQR 1303) Error in SQL (perhaps missing &name after expression):
SELECT ROW_IDENT  FROM DBATEST.FIT_HR_PROF_CHGS
(SQR 1304) Check SELECT columns, expressions and 'where' clause for syntax.

SQR: Program Aborting.

I also used the following 2 variations of the code resulting in the same error
as above:

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
BEGIN-SELECT -DBDSN=FIDTFSRL;UID=WPUSTST;PWD=PSHR
ROW_IDENT &Z.ROW_IDENT
FROM DBATEST.FIT_HR_PROF_CHGS
END-SELECT

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
BEGIN-SELECT -DBDSN=FIDTFSRL;UID=WPUSTST;PWD=PSHR
ROW_IDENT
FROM DBATEST.FIT_HR_PROF_CHGS
END-SELECT

Any thoughts are greatly appreciated!

Thanks,
Les