Executing multiple SQL (execute Script) in Informix

Sometimes we need to execute multiple SQL syntax at the same time in ADO, how do we handle it,

For example the following:

        //Check basic information        Private Static voidtestqry () {DataTable Dtreturn=NewDataTable (); //Find the Basics            Try            {                //Simulation Inquiry raw Material                stringSTRSQL1 =@"Select id,name from [email protected]:tablenameunionselect id,name from [email protected]:tablenameinto temp TMP_ TableName with no log;"; stringSTRSQL2 =@"select * from Tmp_tablename;"; stringSTRSQL3 =@"drop table tmp_tablename;"; using(Ifxconnection conn =Newifxconnection (GSCONNSTR)) {                    using(Ifxcommand cmd =NewIfxcommand (STRSQL1, conn)) {Conn.                        Open (); //Cmd.commandtype =CommandType.Text; Cmd.commandtext=STRSQL1; Cmd.                        ExecuteNonQuery (); using(Ifxdataadapter ad =NewIfxdataadapter (STRSQL2, conn)) {AD.                        Fill (Dtreturn); } Cmd.commandtype=CommandType.Text; Cmd.commandtext=StrSql3; Cmd.                        ExecuteNonQuery (); Conn.                    Close (); }                }            }            Catch(Exception ex) {Dtreturn=NULL; Console.WriteLine (ex.            Message); }        }

Executing multiple SQL (execute Script) in Informix