Connected to AS/400 server through ODBC. Can submit queries, just built a matrix report, looks good.
However I want to incorporate a Parameter and have tried prefacing the parameter COSTCENTER with everything under the sun:
@.COSTCENTER (SQL Server version of parameter declaration)
:COSTCENTER (Oralce version of parameter declaration)
%COSTCENTER
#COSTCENTER
etc. etc.
I keep getting the same error:
Error in WHERE clause near '@.'. Unable to parse query text.
My inquiries are as follows:
1. Can you use parameters with an AS/400 connection?
2. If yes, howshould the parameter be declared?
I searched BOL, GOOGLE, so far nothing...
Which ODBC driver are you using?
No comments:
Post a Comment