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

["Schaetzly, Kent" <KSchaetzly@eprod.com>]

Try this

BEGIN-SQL
  BEGIN
    Create volatile table ssn-data
      (ssn char(15) not null)
  END;;
END-SQL

-----Original Message-----
From: sqr-users-bounces+kschaetzly=eprod.com@sqrug.org
[mailto:sqr-users-bounces+kschaetzly=eprod.com@sqrug.org] On Behalf Of
mahesh kadam
Sent: Friday, July 27, 2007 8:01 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Error while creating volatile table through SQR

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


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