Way to deal with procedure in teradata?

Database
Fan

Way to deal with procedure in teradata?

Hello,
can you provide me with info on how ( is it possible? )to create variable in procedure and then save query result in it?

Which of free book's is good to find something more about creating procedure in TD?
5 REPLIES
Senior Apprentice

Re: Way to deal with procedure in teradata?

Hi Egon,
if i understand you correctly, it's easy:

DECLARE i INTEGER;

SELECT count(*) INTO i
FROM tab;

Just check the Stored Procedures and the DDL manual, there are lots of examples in it.

Dieter
Fan

Re: Way to deal with procedure in teradata?

exacly, works fine. Thank you :)

I'll go read some manuals now, maybe i find something interesting in it.

Regards,
Egon
Fan

Re: Way to deal with procedure in teradata?

Again,

something i'd like to know, but i can't find.

Example:
select * from table where column_name = DBC.procedure(ABC)

Is it possible to call procedure from a query?

Of Course above example doesn't work. Is there any solution to call procedure from query?

Re: Way to deal with procedure in teradata?

Hi, I am a new member of forum. Would a newcomer be warmly welcome here? Good day you guys!!!

__________________
__________________
Enthusiast

Re: Way to deal with procedure in teradata?

As far as i know, It is not possible to invoke a procedure in an SQL.