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

[Shashidhar Rao A <shdhra@yahoo.com>]

After Create command what is that you are using "Volatile".
  i have not encoutered anything like this in sqr.  I dont think this command 
"Volatile" after create is feasible in sqr.  
   
  If you find the sol please let us know so that we can also know abt this.
   
  Regards,
  shdhra

"Schaetzly, Kent" <KSchaetzly@eprod.com> wrote:
  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


       
---------------------------------
Be a better Globetrotter. Get better travel answers from someone who knows.
Yahoo! Answers - Check it out.

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