Teradata stored procedure and optional IN parameter

General

Teradata stored procedure and optional IN parameter

I am trying to create a stored procedure with two IN parameters ,with one of the being optional .How to do this?
1 REPLY
Enthusiast

Re: Teradata stored procedure and optional IN parameter

If you have to fetch records from a table on basis of that IN parameter u have to write Dynamic SQL in Teradata.