can we combine command window and sql window?

[mqlee]

can you make sql window run DML just like command window? so we dont have to run insert/update through command windows. ( assume you have many insert/update statements, you cannot run it in sql window now as it will pops many many result windows.)

 

[Marco Kalter]

I have added this to the list enhancement requests for a future release.

 

[Stew Stryker]

mqlee,

I'm not understanding what you're asking for (though I'm sure Marco does). If I have a ton of DML statements and don't want a ton of results windows, I just put BEGIN ... END; around them.

But I've never had a problem running with up to 50 statements in a SQL window. What's the issue?

 

[Marco Kalter]

The begin/end option works if you have insert/update/delete statements. If you have DDL statements it is not an option.

We have an enhancement for a "Batch execute" function for the SQL Window that will limit the output (only pages for result sets) and that will quickly allow you to view and navigate errors and warnings on a batch result page.

 

[WexSoft]

You do have the option of using begin/end if you use EXECUTE IMMEDIATE