Re: Empty lines in CREATE TABLE statement?

From: Alexei Olkhovskii <aolkhov_at_messages.to>
Date: Mon, 12 Mar 2001 17:47:59 -0800
Message-ID: <3aad7df1@news.infinetgroup.com>

Heiko Gottschling <gottschl_at_in.tum.de> wrote in message news:98at58$bm1$03$1_at_news.t-online.com...
> if I insert an empty line between the column definitions, I get an
> error message:
>
> CREATE TABLE test (
> a NUMBER,
>
> b NUMBER
> );
>
> >SP2-0042: unknown command "b NUMBER" - rest of line ignored.
> >SP2-0042: unknown command ")" - rest of line ignored.
>
> I find this very annoying, since I need to add some comments in the table
> definition, and not being able to insert empty lines clutters the code :-(
>
> Is this behavior a bug or a feature, and is there a way to turn it off (=
> treat newlines as normal whitespace)?

This is a feture, SET SQLBL[ANKLINES] ON to disable it. When set to ON, use SQLTERMINATOR (';') to run the statement, or BLOCKTERMINATOR ('.') to discard it.

Best regards, Alexey
.. Life is like a shower - one wrong turn and you are in hot water. Received on Mon Mar 12 2001 - 19:47:59 CST