[sqr-users] Error while creating volatile table through SQR

[mahesh kadam <maheshnit@yahoo.co.in>]

Hi All,
   
  I need to create volatile table in teradata through sqr code. 
  here is the sample code I have written:
   
  begin-setup
       begin-sql
             create volatile table ssn_data (
            ssn char(15) not null)
       end-sql
  end-setup
   
  begin-program
   do main
  end-program
   
  begin-procedure main
   
    begin-sql
      insert into ssn_data (ssn) values('111111111')
    end-sql
   
  begin-select
  ssn &ssn (1,10)
  from ssn_data
  end-select
   
  end-procedure
   
   
  But I am getting following error:
   Only ET or null statement is legal after DDL statement.
   
  Please help me out.
   
   
  Regards,
  Mahesh

       
---------------------------------
 Get the freedom to save as many mails as you wish. Click here to know how.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users