2 sql statements in a Teradata After Sql-tab

vdr123 · Post by **vdr123** » Sun Oct 31, 2004 9:27 pm

Can anyone let me know if we can put more than 1 SQL statement in teradata's OCI "after SQL"-tab...
I have tried them using a semi-column ';' and it didnot work...

Eg:
Update;
Update

I would like to avoid writing BTEQ script just for this purpose...

Your feedback is highly appreciated...

rasi · Post by **rasi** » Mon Nov 01, 2004 4:46 pm

Only one SQL statement can be executed at once inside the plug-in. If you want to execute Multiple SQL then have to output streams and put you SQL accordingly.

Thanks
Siva

chulett · Post by **chulett** » Mon Nov 01, 2004 4:54 pm

It may depend on the plugin. The OCI stages do support multiple statements, this is pulled from the online help:

If you specify multiple SQL statements, they are executed as one transaction. Do not use a trailing semicolon. Transactions are terminated by a double semi-colon ( ;; ).

I know you can use multiple sql statements in User Defined SQL, but not sure if you can in the 'Before/After' tabs.

Never tried.

You'd need to check the docs for the Teradata plugin.

vdr123 · Post by **vdr123** » Tue Nov 02, 2004 11:51 am

I have tried it again with the same SQL's...

eg:
Update;
Update

It seems to work...it doesnt complain!!!

Thank You for your feedback...