Way to deal with procedure in teradata?

[Egon_]

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?

[dnoeth]

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

[Egon_]

exacly, works fine. Thank you :)

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

Regards,
Egon

[Egon_]

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?

[sharonk868]

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

__________________
__________________

[ravi_videla]

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