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.

Tempdb in Stored Procedures

3 posts in PB Infomaker Report Writer Last posting was on 1998-05-25 11:47:40.0Z
Steve Hittle Posted on 1998-05-14 12:10:15.0Z
Newsgroups: sybase.public.infomaker.general
Date: Thu, 14 May 1998 08:10:15 -0400
From: Steve Hittle <SHittle@hsc.healthplan.com>
Organization: Harrington ISD
X-Mailer: Mozilla 3.0 (Win95; I)
MIME-Version: 1.0
Subject: Tempdb in Stored Procedures
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 15
Message-ID: <348_355ADF27.74C6@hsc.healthplan.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:2588
Article PK: 237186

I have created a number of reporting stored procedures that summarize
data before printing. These stored procedures work fine when
running standalone or from within InfoMaker 5, but when an
executable is created using InfoMaker, the following error appears:

Select error: The 'CREATE TABLE' command is not allowed within a
multi-statement transaction within the 'tempdb' database.

I have built other reports using this same method and their executables
are now in production. Does anyone have an idea as to what is
causing this error?

TIA,

Steve


Terry Dykstra [TeamPS] Posted on 1998-05-14 21:55:58.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra [TeamPS]" <no_spam_tdykstra@cfol.ab.ca>
Subject: Re: Tempdb in Stored Procedures
Date: Thu, 14 May 1998 15:55:58 -0600
Lines: 25
Organization: Canadian Forest Oil Ltd.
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <348_EI$DSm3f9GA.214@forums.powersoft.com>
References: <348_355ADF27.74C6@hsc.healthplan.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:2587
Article PK: 237184

That error would happen when you are running a SQLAnywhere runtime-only
database (invoked with rtdsk50). You must use a SQLAnywhere server
(dbeng50) when using stored procedures.

--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.

Steve Hittle wrote in message <355ADF27.74C6@hsc.healthplan.com>...
>I have created a number of reporting stored procedures that summarize
>data before printing. These stored procedures work fine when
>running standalone or from within InfoMaker 5, but when an
>executable is created using InfoMaker, the following error appears:
>
>Select error: The 'CREATE TABLE' command is not allowed within a
>multi-statement transaction within the 'tempdb' database.
>
>I have built other reports using this same method and their executables
>are now in production. Does anyone have an idea as to what is
>causing this error?
>
>TIA,
>
>Steve


John McVicker Posted on 1998-05-25 11:47:40.0Z
Newsgroups: sybase.public.infomaker.general
Date: Mon, 25 May 1998 07:47:40 -0400
From: John McVicker <mcvicker@sybase.com>
Reply-To: mcvicker@sybase.com
Organization: Sybase Professional Services
X-Mailer: Mozilla 4.04 [en] (WinNT; I)
MIME-Version: 1.0
To: Steve Hittle <SHittle@hsc.healthplan.com>
Subject: Re: Tempdb in Stored Procedures
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 32
Message-ID: <348_35695A5C.883E6790@sybase.com>
References: <348_355ADF27.74C6@hsc.healthplan.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:2586
Article PK: 237185

Steve,
Most likely, it is due to your connection property called Autocommit.
Look at the Database connection profile. If Autocommit is not checked,
please check it. When you connect to the server, if you use autocommit
= false (the default), PB and Infomaker will do a "BEGIN TRAN" for you
upon connection. (See the master..syslogshold table as well as do
a simple little report with select @@trancount from sysobjects where id
= 1). The @@trancount should be 0 when creating tables such as with
the SELECT * INTO #TMP style of copying data.

John McVicker
Sybase Professional Services
Philadelphia, PA
610-260-4308

Steve Hittle wrote:
>
> I have created a number of reporting stored procedures that summarize
> data before printing. These stored procedures work fine when
> running standalone or from within InfoMaker 5, but when an
> executable is created using InfoMaker, the following error appears:
>
> Select error: The 'CREATE TABLE' command is not allowed within a
> multi-statement transaction within the 'tempdb' database.
>
> I have built other reports using this same method and their executables
> are now in production. Does anyone have an idea as to what is
> causing this error?
>
> TIA,
>
> Steve