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

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

Hi Dragon,
   
  I tried using semi-colon after create table as well as insert statement but 
still getting same error.

the dragon <ceprn@hotmail.com> wrote:
  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



       
---------------------------------
 Do you get hundreds of mails everyday? Delete none. Keep them all.

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