conditional drop table

[cjd]

What's the IQ option that affects the behaviour of the
"drop table if exists mytable" command ?
That is: To avoid any message or error if "mytable" does not exist.
Please discard the on error continues. Although it helps .
Thank you.
cjd

[Mark Mumy]

Can you reproduce this? If so, shoot out a script. I've never seen it error out.

Mark

============================================================

--
You received this message because you are subscribed to the Google Groups "iqug" group.
To post to this group, send email to iq...@googlegroups.com.
To unsubscribe from this group, send email to iqug+uns...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/iqug?hl=en.

[cjd]

Mark,

In MPX

drop table if exists mytable ;
create table mytable ( i int ) ;
select i from mytable ;

If table does not exist . It errs !

In simplex it works.

---------------------------------------------

Do you know a better way ( faster ) to
select count( distinct Col ) from T  -- Where Col is a varchar 32K with WD index.

Would it be different with CLOB ? We don't have that license for me to test it.

Thank you,
Carlos