Hi Sukanya, here is the log, thanks for your help.
214 libname Harris 'H:\Harris\SAS Progs';
NOTE: Libref HARRIS was successfully assigned as follows:
Physical Name: H:\Harris\SAS Progs
215 /* Dump out the AIRB table into a SAS dataset */
216 PROC SQL;
217 CONNECT TO ODBC (database=HBR user=gxann using=XXXXXXXX);
218 DESCRIBE TABLE HBR.BSL_HRR_CAPITAL_RISK_F;
ERROR: Libname HBR is not assigned.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.06 seconds
cpu time 0.03 seconds
To use the SAS SQL DESCRIBE statement, you have to use the LIBNAME approach to connecting to the remote database. To use the pass-through query, I think that you need to use the SAS EXECUTE statement (assuming DESCRIBE is a valid command in the remote DBMS)..