Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 22 Nov 2002 @ 15:19:17 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Syntax error in Stored Procedure
From:   Syed Arifuddin

I am trying to use variable content in FROM clause of select statement but it gives me error message saying "syntax error expecting something like a name between a from keyword and :"

This is the procedure which i am creating.

replace procedure mydb.listtables()
declare rowcount int;
declare tablenames varchar(100);
CALL DBC.SysExecSQL('create table mydb.tableinfo(TableName varchar (100),Rowcount int)');
for row_cursor as row_cursor1 cursor for
select TableName from dbc.tables where TableKind='T' DO
   set tablenames = row_cursor.Tablename;
   CALL DBC.SysExecSQL('SELECT COUNT(*) INTO :rowcount from :TableNames');
   insert into arifdb.tableinfo values(:row_cursor.TableName,:rowcount);

Your help will be appreciated in this regard.



  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023