Archives of the TeradataForum
Message Posted: Fri, 05 Mar 2004 @ 20:48:14 GMT
Teradata has a very different syntax for SELECT INTO!
Normally we say "SELECT COUNT(*) INTO :outparam FROM mytab WHERE...",
Or in the case of SQL Server we say "SELECT @outparam = COUNT(*) FROM mytab WHERE...";
but Naresh's working example showed the INTO has to be placed after the table name:
>replace procedure sp (out j int) >begin >select count(*) from mytab into :j where c2 like 'a%'; >end;
I just wonder if anybody know the history of Teradata's decision to design SELECT INTO into the current syntax.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|