I'am a Mercator 6.7 newbie and struggling with the following problem :
I'am trying to read the result of a Sybase 12.5.1 stored procedure (only 1 row with 1 column and no input params) in an input card "varRunID" (defined as integer) while using the following GET > COMMAND -line (not a .mdq file)
-DBTYPE SYBASE -SOURCE MyServer\\MyDB -STMT exec dbo.MyStoPro -USER xxxxx -PASSWORD xxxxxx -TRACE mapTraceSQL.log
When I try to compile the map, I receive the following error :
M1012 ERROR :
Could not retrieve query information
varRunID
Sybase open client is installed, access to the db is ok
When using the DID, connection can be made and the StoPro is seen...
What am I doing wrong ?
I'am trying to read the result of a Sybase 12.5.1 stored procedure (only 1 row with 1 column and no input params) in an input card "varRunID" (defined as integer) while using the following GET > COMMAND -line (not a .mdq file)
-DBTYPE SYBASE -SOURCE MyServer\\MyDB -STMT exec dbo.MyStoPro -USER xxxxx -PASSWORD xxxxxx -TRACE mapTraceSQL.log
When I try to compile the map, I receive the following error :
M1012 ERROR :
Could not retrieve query information
varRunID
Sybase open client is installed, access to the db is ok
When using the DID, connection can be made and the StoPro is seen...
What am I doing wrong ?