 | |
execution of multiple DDL statements from .net
comp.databases comp.databases
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
execution of multiple DDL statements from .net -
02-01-2008
, 07:26 AM
#2
| |||
| |||
|
|
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. |
a NULL statement;
(What's an ET?? End Transaction?, IOW a commit?) It looks like it
means you cannot have both DDL (CREATE) and DML (INSERT, SELECT) in
the same transaction.
Why are you creating tables from the application?
Tables should be designed and implemented outside applications (with a
few exceptions).
So what is the business problem you are trying to solve???
Ed
#3
| |||
| |||
|
|
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. |
a NULL statement;
(What's an ET?? End Transaction?, IOW a commit?) It looks like it
means you cannot have both DDL (CREATE) and DML (INSERT, SELECT) in
the same transaction.
Why are you creating tables from the application?
Tables should be designed and implemented outside applications (with a
few exceptions).
So what is the business problem you are trying to solve???
Ed
#4
| |||
| |||
|
|
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. |
a NULL statement;
(What's an ET?? End Transaction?, IOW a commit?) It looks like it
means you cannot have both DDL (CREATE) and DML (INSERT, SELECT) in
the same transaction.
Why are you creating tables from the application?
Tables should be designed and implemented outside applications (with a
few exceptions).
So what is the business problem you are trying to solve???
Ed
#5
| |||
| |||
|
#6
| |||
| |||
|
#7
| |||
| |||
|
#8
| |||
| |||
|
|
thanks for reply Actually my other and major part of the project is related to this so is there any setting available in BTEQ or other in SQL assiestient to execute it, so i proceed reply |
be Teradata specific.
But I do question again the design that requires creating tables on-
the-fly. You are headed into a database administration nightmare doing
what you propose. Talk to your Teradata DBA. Please.
Sorry I cannot offer more help. I have not yet used Teradata.
Ed
#9
| |||
| |||
|
|
thanks for reply Actually my other and major part of the project is related to this so is there any setting available in BTEQ or other in SQL assiestient to execute it, so i proceed reply |
be Teradata specific.
But I do question again the design that requires creating tables on-
the-fly. You are headed into a database administration nightmare doing
what you propose. Talk to your Teradata DBA. Please.
Sorry I cannot offer more help. I have not yet used Teradata.
Ed
#10
| |||
| |||
|
|
thanks for reply Actually my other and major part of the project is related to this so is there any setting available in BTEQ or other in SQL assiestient to execute it, so i proceed reply |
be Teradata specific.
But I do question again the design that requires creating tables on-
the-fly. You are headed into a database administration nightmare doing
what you propose. Talk to your Teradata DBA. Please.
Sorry I cannot offer more help. I have not yet used Teradata.
Ed
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.