I would like to run a unix shell script, which starts a bteq script to create a anonymous procedure in teradata.
I would like to have the options available in stored procedures, but on a onetime basis. (as described in the official td document 'sql stored procedures and embedded sql - Release 13.10).
(note: i can not create procedures or tables in terradata. Just run a unix script.) Within oracle pl/sql i would create a anonymous procedure.)
How do i do this in teradata?. Can you help?
The concept of "anonymous blocks" doesn't exist in Teradata.
Why do you think you need it? You need to talk to your DBA, he might grant you the neccessary rights, good luck :-)
Btw, you might be able to create a VOLATILE table (unless you DBA restricted that, too).