Hi,
Would like to know the reason for the behaviour for SA table column
created from select into with a variable has not null constraint by
default?

set temporary option Allow_Nulls_By_Default = 'ON'
set temporary option Non_Ansi_Null_Varchar = 'ON'
create table iqtab(c_rowid integer)
commit
create variable @varclob_retest long varchar
set @varclob_retest = ''
insert into iqtab values (1)
drop table iqtab_new
select *,@varclob_retest into iqtab_new from iqtab-->
From dbtran sql file, sa creates the table with the definition below:
create table DBA.saiqtab_new(
c_rowid integer null,
@varclob_saretest long varchar not null,
)

Thank you,
Aparna

First things first. The feature you are using when you specify
the option NON_ANSI_NULL_VARCHAR is new to IQ15.1
and does not seem to be recognized by SQL Anywhere 11.0.1
or earlier [at least not from dbisql]. So if that is the feature
that is failing you will probably need to contact IQ support or
a newsgroup that is specifically targetted to IQ.

Since I cannot set that option I get the behaviour I would
expect with SQL Anywhere 11.0.1 and earlier and that
matches your result, it would seem to be an IQ speicific
issue. It may also be dependant upon which interactive
SQL utility you are using.



"Aparna Kurada" <akurada1 (AT) yahoo (DOT) com> wrote