RE: Rép. : Re: SQL in SQR

["Jamadagni, Rajendra" <rajendra.jamadagni@ESPN.COM>]

Philippe,

CREATE TABLE is a DDL and I believe in most RDBMS, DDL perform an implicit
COMMIT statement, so you don't actually need a commit for CREATE TABLE, and
even if you have, it won't do any good.

HTH
Raj
______________________________________________________
Rajendra Jamadagni              MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art !

-----Original Message-----
From: LEBLANC Philippe FTC [mailto:p.leblanc@FRANCETELECOM.COM]
Sent: Thursday, April 05, 2001 11:07 AM
To: SQR-USERS@list.iex.net
Subject: Rép. : Re: SQL in SQR

try using this;
BEGIN-SQL  ON-ERROR=SKIP
  CREATE TABLE PMCGEN_TEMP (GENERIC_NAME    VARCHAR2(40))
     TABLESPACE USER_ACCOUNTS STORAGE
        (INITIAL     5000K NEXT         500K);;

  create table pmcapp_temp
   (appl_type     varchar2(1), appl_no       varchar2(6))
     TABLESPACE USER_ACCOUNTS STORAGE
        (INITIAL     5000K NEXT         500K);;
commit;;
end-sql

*********************************************************************

This e-mail message is confidential, intended only for the named recipient(s) 
above and may contain information that is privileged, attorney work product or 
exempt from disclosure under applicable law. If you have received this message 
in error, or are not the named recipient(s), please immediately notify ESPN at 
(860) 766-2000 and delete this e-mail message from your computer, Thank you.

*********************************************************************