conditional drop table

4 views
Skip to first unread message

cjd

unread,
Nov 15, 2011, 10:42:49 AM11/15/11
to iqug
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

unread,
Nov 15, 2011, 1:22:49 PM11/15/11
to iq...@googlegroups.com
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

unread,
Nov 16, 2011, 2:21:15 AM11/16/11
to iq...@googlegroups.com
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
Reply all
Reply to author
Forward
0 new messages