NEED HELP WITH SIMPLE SQL!!! THANKS
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?
Re: NEED HELP WITH SIMPLE SQL!!! THANKS
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.