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

["Peter Burton" <peter.burton@oracle.com>]

Mahesh,

Change  

begin-sql
create volatile table ssn_data (
ssn char(15) not null)
end-sql

To

begin-sql
create volatile table ssn_data (ssn char(15) not null) ; COMMIT WORK
end-sql

Peter

-----Original Message-----
From: sqr-users-bounces+peter.burton=oracle.com@sqrug.org 
[mailto:sqr-users-bounces+peter.burton=oracle.com@sqrug.org] On Behalf Of 
mahesh kadam
Sent: Friday, July 27, 2007 9:46 AM
To: the dragon; sqr-users@sqrug.org
Subject: RE: [sqr-users] Error while creating volatile table through SQR

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


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