I want to declare 'READONLY' for input table in stored procedure.
in SQL SERVER it's looks like:
create PROCEDURE X
@nameOfTable Proc_TableType READONLY
I would like to know how i can write this code in TERADATA
Have a great week
There are no table-valued parameters in Teradata, the closest you get is probably a Global Temporary Table.
Can you show the actual source code?
Thanks but I've solved the problem of table-valued already.
My question is if there is Syntax in Teradata that corresponds to 'READONLY' in sql-server
READONLY is SQL Server syntax for table valued parameters.
Of course there syntax to apply a lock, LOCKING TABLE blabla FOR READ SELECT ..., but that's the default anyway: