Archives of the TeradataForum
Message Posted: Wed, 16 Jan 2002 @ 11:15:47 GMT
| Subj: || || Re: Arrays in Stored Procedures |
| From: || || Mat Ginman |
| ||How to use arrays in Stored procedures?|| |
You cannot used arrays in stored procedures. Instead you could use a temporary table.
| ||How to direct query result into a txt file with in the stored procedure?|| |
You can not. You could write rows to a table instead.
| ||Where should i see the output of debug statement "print" present in stored procedure? If I execute the stored procedure from
queryman can I see the output of debug statement?|| |
The "print" goes to the DBWindow only, a program you can start at the server.
Note that if you plan to use stored procedure for massive data operations use the stored procedures as shell layer only and do the actual
operations inside SQL statements to take advantage of the paralellism of Teradata. E.g cursors should not be used.