Oninit cdi / Archive
Talk to an expert →

Re: Change Column data type on a BIG table

Posted in 2000

Topics: SQL Development & Query Writing, Stored Procedures & SPL, Data Types & Schema Design

Obnoxio The Clown — — source: Informix-list mailing list archive (1991-1998)

From: vtnguyen <vtnguyen@home.com> > >Thanks for the reply, > >1. The Informix version is Online 7.23. >2. My question about the select statement might not very clear. Basically, >I would like to print messages for each SQL statements in the scripts. For >examples: > >PRINT A MESSAGE SAYING "Creating table A...." >Create table A (id int);>PRINT A MESSAGE SAYING "Creating index AIDX..." >Create index aidx on A(id);>... >... >The question is how do I display the messages to the console. > >In Sybase I can do like: > >select "Creating table A...." >Create table A (id int)>select "Creating index AIDX..." >Create index aidx on A(id) select "Creating table A...." from systables where tabid = 1 ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

↪ replying to Obnoxio The Clown
Kirk Wells — — source: Informix-list mailing list archive (1991-1998)

It is also possible to just use dbaccess -e when executing the sql. -e will display the actual sql to standard out when you the sql is running. The only problem is that it does not print the sql statement until the statement has executed. Obnoxio The Clown wrote: > > From: vtnguyen <vtnguyen@home.com> > > > >Thanks for the reply, > > > >1. The Informix version is Online 7.23. > >2. My question about the select statement might not very clear. Basically, > >I would like to print messages for each SQL statements in the scripts. For > >examples: > > > >PRINT A MESSAGE SAYING "Creating table A...." > >Create table A (id int);> >PRINT A MESSAGE SAYING "Creating index AIDX..." > >Create index aidx on A(id);> >... > >... > >The question is how do I display the messages to the console. > > > >In Sybase I can do like: > > > >select "Creating table A...." > >Create table A (id int)> >select "Creating index AIDX..." > >Create index aidx on A(id)> > select "Creating table A...." > from systables > where tabid = 1 > > ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com