NEED HELP WITH SIMPLE SQL!!! THANKS

[John Seifert]

Hello,

I know that this is not a SQL forum, but I know that someone out
there reading this can help me with the following questions. I
really appreciate it. Thanks in advance.

How is an SQL command terminated?
How is an SQL command executed?
Can you cancel a running SQL query? How?

[mjpell]

I think they are typically terminated with a semi-colon (;)
I think they are executed with a 'run;' statement.

For example:
Select * from tableName where x=y;
run;


If you calling the sql from Java, then I don't know of a way to cancel.

Typical disclaimers apply, as it's been a while since I've done this.