Hello Everyone:
In using the Interactive SQL that comes with Powerbuilder 7.
I'm a bit confused about the output statement. Here is my sql statements.
output to test1.txt;
begin
select * from wcps.policy
where wcps.policy.policy_no = '1234567';
end
In running the above first I get an error stating that there is no current query my options are to continue,stop,cancel. If I choose continue the query runs and gives me the results on the screen and the output file
test1.txt. The second time I run the above, no errors, runs great?
why? it's a puzzle?
If I put the output statement inside the begin end block before the end statement, it errors telling me there is something wrong with the select?
How should I be dealing with the output to statement?
Any Ideas are welcome
Thanks.
In using the Interactive SQL that comes with Powerbuilder 7.
I'm a bit confused about the output statement. Here is my sql statements.
output to test1.txt;
begin
select * from wcps.policy
where wcps.policy.policy_no = '1234567';
end
In running the above first I get an error stating that there is no current query my options are to continue,stop,cancel. If I choose continue the query runs and gives me the results on the screen and the output file
test1.txt. The second time I run the above, no errors, runs great?
why? it's a puzzle?
If I put the output statement inside the begin end block before the end statement, it errors telling me there is something wrong with the select?
How should I be dealing with the output to statement?
Any Ideas are welcome
Thanks.