SQL-92 debugging
- Thread starter Rob Fitzpatrick
- Start date
TomBascom
Curmudgeon
Look at my previous post -- your code has a bug.
You are generating your SQL code to a BUFFERED output stream. Which is still open when you execute the OS-COMMAND because you did a simple "output close" without the stream name. The SQL script is not complete on disk -- that's why you are getting an error in the middle of the statement when run from within the session but everything looks fine once the session has ended and you run it manually.
Fix the bug and it will run fine.
You are generating your SQL code to a BUFFERED output stream. Which is still open when you execute the OS-COMMAND because you did a simple "output close" without the stream name. The SQL script is not complete on disk -- that's why you are getting an error in the middle of the statement when run from within the session but everything looks fine once the session has ended and you run it manually.
Fix the bug and it will run fine.
Rob Fitzpatrick
ProgressTalk.com Sponsor
Good catch Tom. I didn't know I had to name the stream on close when there is only one.