SQL-92 debugging

[tamhas]

If the script works if manually applied in sqlexp, then it is not a SQL problem.

 

[TomBascom]

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.

 

[Rob Fitzpatrick]

Good catch Tom. I didn't know I had to name the stream on close when there is only one.