Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

[Q]Create Table Command

2 posts in Windows NT Last posting was on 1997-10-23 23:00:28.0Z
anonymous Posted on 1997-10-22 04:05:01.0Z
From: "anonymous" <fake@isp.com>
Subject: [Q]Create Table Command
Message-ID: <01bcdea8$b6178d00$LocalHost@jsz07>
X-Newsreader: Microsoft Internet News 4.70.1157
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Date: Wed, 22 Oct 1997 00:05:01 -0400
Lines: 14
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5468
Article PK: 1081546

Hi,all
1)I am using PowerBuilder 5.0 and SQL Server 6.0,when this
command execute:
string s
s="create table (......)"
Execute immediate :s
system return error,the error message is "Create Table Command
was not allowed within multi-statement",what is this?How to create a
table in program?
2)How to make SQL Server speed up?(Somwone tell me name pipe
can speed up SQL Server,how can I do it?

--
Any help would be appreciated and please reply by news.
Thanks a million.


Mark A. Parsons Posted on 1997-10-23 23:00:28.0Z
Message-ID: <344FD70C.848@compuserve.com>
Date: Thu, 23 Oct 1997 19:00:28 -0400
From: "Mark A. Parsons" <Iron_Horse@compuserve.com>
Reply-To: Iron_Horse@compuserve.com
Organization: Iron Horse, Inc.
X-Mailer: Mozilla 3.01 (Win95; I)
MIME-Version: 1.0
Subject: Re: [Q]Create Table Command
References: <01bcdea8$b6178d00$LocalHost@jsz07>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 27
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5460
Article PK: 1081536

Concerning your 'create table' error ... you have a transaction open
('begin tran') somewhere in your code before you do your 'execute
immediate'; either move your 'create table' command outside the
transaction (modification to your coding) or enable the creation of ddl
within a tran (a TSQL command). You don't have AUTOCOMMIT=FALSE do you
???

Concerning the speed up? Care to provide some details of what you're
talking about?

Mark Parsons
Iron Horse, Inc.

anonymous wrote:
>
> Hi,all
> 1)I am using PowerBuilder 5.0 and SQL Server 6.0,when this
> command execute:
> string s
> s="create table (......)"
> Execute immediate :s
> system return error,the error message is "Create Table Command
> was not allowed within multi-statement",what is this?How to create a
> table in program?
> 2)How to make SQL Server speed up?(Somwone tell me name pipe
> can speed up SQL Server,how can I do it?
>
> --
> Any help would be appreciated and please reply by news.
> Thanks a million.