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

["the dragon" <ceprn@hotmail.com>]

Do you need a semi-colon after your sql DDL statement?

peace,
clark 'the dragon' willis



PSA: Salary <> Slavery. If you earn a salary, your employer is renting your 
services for 40 hours a week, not purchasing your soul. Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

I work to live; I don't live to work.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent. Be careful lest you let other people 
spend it for you." -- Carl Sandburg (1878 - 1967)

It is impossible to defeat an ignorant man in argument. -- William G. McAdoo

Religion is regarded by the common people as true, by the wise as false, and 
by the rulers as useful. -- Seneca

"I distrust those people who know so well what God wants them to do because 
I notice it always coincides with their own desires." - Susan B. Anthony




----Original Message Follows----

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

_________________________________________________________________
http://newlivehotmail.com


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