'READONLY' input in stored procedure

Database
N/A

'READONLY' input in stored procedure

Hi :)

 

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
AS
BEGIN...

 

I would like to know how i can write this code in TERADATA

 

Thanks!

Have a great week

 

3 REPLIES
N/A

Re: 'READONLY' input in stored procedure

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?

N/A

Re: 'READONLY' input in stored procedure

Hi Dnoeth,

 

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

 

Thanks

 

 

N/A

Re: 'READONLY' input in stored procedure

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:

LOCKING request modifier