Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Databases General > execution of mu...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 6 Topic 3091 of 3212
Post > Topic >>

execution of multiple DDL statements from .net

by Tara database Guidliance <meetsatishg@[EMAIL PROTECTED] > Feb 1, 2008 at 04:26 AM

hi i want to execute following satement in .net

TDStrSQL = "create volatile table tab1(somename varchar(100)) on
commit preserve rows;create volatile table tab2(somenames
varchar(100)) on commit preserve rows;" 'insert into tab1 values
('a'); insert into tab2 values ('b'); select * from tab1 union select
* from tab2;"


TDODBCcn.Open()
        TDODBCcmdSelect = New Odbc.OdbcCommand(TDStrSQL, TDODBCcn)

        TDODBCdtr = TDODBCcmdSelect.ExecuteReader

and database is teradata i the error is

ERROR [25000] [NCR][ODBC Teradata Driver][Teradata Database] Only an
ET or null statement is legal after a DDL Statement.
 




 6 Posts in Topic:
execution of multiple DDL statements from .net
Tara database Guidliance   2008-02-01 04:26:30 
Re: execution of multiple DDL statements from .net
Ed Prochak <edprochak@  2008-02-01 06:20:13 
Re: execution of multiple DDL statements from .net
Tara database Guidliance   2008-02-03 22:44:42 
Re: execution of multiple DDL statements from .net
Ed Prochak <edprochak@  2008-02-04 05:47:15 
Re: execution of multiple DDL statements from .net
Tara database Guidliance   2008-02-05 04:53:50 
Re: execution of multiple DDL statements from .net
Ed Prochak <edprochak@  2008-02-05 10:43:33 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Tue Jul 8 22:52:56 CDT 2008.