Hi, I am still getting to grips with SQLA/ISQL so I know this might be a rookie error, but any help would be great. Below is my code
The error I am getting is @prod cannot be found. Now I understand that I am not declaring a variable at this point, but if I run the following command
It executes with no errors, but no file is output. Any suggestions? |
Looks like a cross between TSQL and ANSI SQL try this although I haven't tested it...
|
Just to add to Jim: As documented here, a procedure should be written either in Watcom-SQL or Transact-SQL, not in a mixture of both. Here, your procedure is mainly in Transact-SQL but the usage of statement delimiters (';') (and possible other syntax elements) is Watcom-SQL. AFAIK, mixing dialects often leads to strange error messages...
Thanks Volker, I will take a look.