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.

Unable create table in Jaguar Component

6 posts in General Discussion (old) Last posting was on 2000-03-03 03:57:04.0Z
chenhongjiu Posted on 2000-03-02 08:25:23.0Z
Newsgroups: sybase.public.easerver
From: "chenhongjiu" <chenhongjiu@163.net>
Subject: Unable create table in Jaguar Component
Date: Thu, 2 Mar 2000 16:25:23 +0800
Lines: 15
Organization: emproson
X-Newsreader: Microsoft Outlook Express 4.72.3612.1700
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3612.1700
NNTP-Posting-Host: 202.104.40.118
Message-ID: <347_iUUMsGCh$GA.201@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27354
Article PK: 158765

I use Jaguar 3.0.1 and PB 7.0.1.
I execute dynamic sql syntax in order to create a table in Jaguar
component.The code like this:

as_syntax = "create table ..."
sqlca.autocommit = true
EXECUTE IMMEDIATE :as_syntax;
sqlca.autocommit = false

I am sure the as_syntax is correct.
I execute the component's function,but it do nothing.Why?How to do?
Help me,please.Thank you.


Jim O'Neil [Sybase] Posted on 2000-03-02 14:56:49.0Z
Newsgroups: sybase.public.easerver
Date: Thu, 02 Mar 2000 09:56:49 -0500
From: "Jim O'Neil [Sybase]" <joneil@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en]C-CCK-MCD (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Unable create table in Jaguar Component
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 21
NNTP-Posting-Host: joneil-nt.sybase.com 204.167.42.111
Message-ID: <347_38BE8131.2764C7C9@sybase.com>
References: <347_iUUMsGCh$GA.201@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27327
Article PK: 158738


chenhongjiu wrote:

> I use Jaguar 3.0.1 and PB 7.0.1.
> I execute dynamic sql syntax in order to create a table in Jaguar
> component.The code like this:
>
> as_syntax = "create table ..."
> sqlca.autocommit = true
> EXECUTE IMMEDIATE :as_syntax;
> sqlca.autocommit = false
>
> I am sure the as_syntax is correct.
> I execute the component's function,but it do nothing.Why?How to do?
> Help me,please.Thank you.

AutoCommit would work here in normal PowerBuilder, but it's ignored in
Jaguar because Jaguar is handling the transactions, so Dave's suggestion
is one way. Another is to set the database to allow DDL within the
scope of a transaction. You can do this with ASE, but I'm not sure from
your message what backend you are using.
--
Jim O'Neil
Senior Technical Support Engineer
Sybase, Inc


chenhongjiu Posted on 2000-03-03 02:37:42.0Z
Newsgroups: sybase.public.easerver
From: "chenhongjiu" <chenhongjiu@163.net>
Subject: Re: Unable create table in Jaguar Component
Date: Fri, 3 Mar 2000 10:37:42 +0800
Lines: 38
Organization: emproson
X-Newsreader: Microsoft Outlook Express 4.72.3612.1700
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3612.1700
NNTP-Posting-Host: 202.104.40.71
Message-ID: <347_fxI3PpLh$GA.201@forums.sybase.com>
References: <347_iUUMsGCh$GA.201@forums.sybase.com> <347_38BE8131.2764C7C9@sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27261
Article PK: 154514


Jim O'Neil [Sybase] wrote in message <38BE8131.2764C7C9@sybase.com>...
>chenhongjiu wrote:
>
>> I use Jaguar 3.0.1 and PB 7.0.1.
>> I execute dynamic sql syntax in order to create a table in Jaguar
>> component.The code like this:
>>
>> as_syntax = "create table ..."
>> sqlca.autocommit = true
>> EXECUTE IMMEDIATE :as_syntax;
>> sqlca.autocommit = false
>>
>> I am sure the as_syntax is correct.
>> I execute the component's function,but it do nothing.Why?How to do?
>> Help me,please.Thank you.
>
>AutoCommit would work here in normal PowerBuilder, but it's ignored in
>Jaguar because Jaguar is handling the transactions, so Dave's suggestion
>is one way. Another is to set the database to allow DDL within the
>scope of a transaction. You can do this with ASE, but I'm not sure from
>your message what backend you are using.
>--
>Jim O'Neil
>Senior Technical Support Engineer
>Sybase, Inc
>
>

Thanks a lot.My Jaguar is for NT 4.0 and my Database is Sybase 11.0.3 for
SCO Unix.
Can I set the database to allow DDL within the scope of a transaction. If
yes then how can I do it?

Thanks.


Dave Wolf [Sybase] Posted on 2000-03-03 02:44:54.0Z
Newsgroups: sybase.public.easerver
From: "Dave Wolf [Sybase]" <dwolf@sybase.com>
Subject: Re: Unable create table in Jaguar Component
Date: Thu, 2 Mar 2000 21:44:54 -0500
Lines: 57
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: 158.159.8.10
Message-ID: <347_Qt0TAsLh$GA.285@forums.sybase.com>
References: <347_iUUMsGCh$GA.201@forums.sybase.com> <347_38BE8131.2764C7C9@sybase.com> <347_fxI3PpLh$GA.201@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27260
Article PK: 154513

Yes

use master
go
sp_dboption "mydb","ddl in tran","true"
go
use mydb
go
checkpoint
go


Dave Wolf
Internet Applications Division

"chenhongjiu" <chenhongjiu@163.net> wrote in message
news:fxI3PpLh$GA.201@forums.sybase.com...
>
> Jim O'Neil [Sybase] wrote in message <38BE8131.2764C7C9@sybase.com>...
> >chenhongjiu wrote:
> >
> >> I use Jaguar 3.0.1 and PB 7.0.1.
> >> I execute dynamic sql syntax in order to create a table in Jaguar
> >> component.The code like this:
> >>
> >> as_syntax = "create table ..."
> >> sqlca.autocommit = true
> >> EXECUTE IMMEDIATE :as_syntax;
> >> sqlca.autocommit = false
> >>
> >> I am sure the as_syntax is correct.
> >> I execute the component's function,but it do nothing.Why?How to do?
> >> Help me,please.Thank you.
> >
> >AutoCommit would work here in normal PowerBuilder, but it's ignored in
> >Jaguar because Jaguar is handling the transactions, so Dave's suggestion
> >is one way. Another is to set the database to allow DDL within the
> >scope of a transaction. You can do this with ASE, but I'm not sure from
> >your message what backend you are using.
> >--
> >Jim O'Neil
> >Senior Technical Support Engineer
> >Sybase, Inc
> >
> >
>
> Thanks a lot.My Jaguar is for NT 4.0 and my Database is Sybase 11.0.3 for
> SCO Unix.
> Can I set the database to allow DDL within the scope of a transaction. If
> yes then how can I do it?
>
> Thanks.
>
>
>


Dave Wolf [Sybase] Posted on 2000-03-02 13:37:11.0Z
Newsgroups: sybase.public.easerver
From: "Dave Wolf [Sybase]" <dwolf@sybase.com>
Subject: Re: Unable create table in Jaguar Component
Date: Thu, 2 Mar 2000 08:37:11 -0500
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: PPPa10-ResaleAnnapolis1-1R7308.saturn.bbn.com 4.48.176.71
Message-ID: <347_FSNMyzEh$GA.202@forums.sybase.com>
References: <347_iUUMsGCh$GA.201@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27335
Article PK: 158746

Mark the component to not support transactions.

Dave Wolf
Internet Applications Division

"chenhongjiu" <chenhongjiu@163.net> wrote in message
news:iUUMsGCh$GA.201@forums.sybase.com...
> I use Jaguar 3.0.1 and PB 7.0.1.
> I execute dynamic sql syntax in order to create a table in Jaguar
> component.The code like this:
>
> as_syntax = "create table ..."
> sqlca.autocommit = true
> EXECUTE IMMEDIATE :as_syntax;
> sqlca.autocommit = false
>
> I am sure the as_syntax is correct.
> I execute the component's function,but it do nothing.Why?How to do?
> Help me,please.Thank you.
>
>
>


chenhongjiu Posted on 2000-03-03 03:57:04.0Z
Newsgroups: sybase.public.easerver
From: "chenhongjiu" <chenhongjiu@163.net>
Subject: Re: Unable create table in Jaguar Component
Date: Fri, 3 Mar 2000 11:57:04 +0800
Lines: 29
Organization: emproson
X-Newsreader: Microsoft Outlook Express 4.72.3612.1700
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3612.1700
NNTP-Posting-Host: 202.104.40.71
Message-ID: <347_Sbc4iVMh$GA.295@forums.sybase.com>
References: <347_iUUMsGCh$GA.201@forums.sybase.com> <347_FSNMyzEh$GA.202@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27258
Article PK: 158163

Thank you.Thank you. I used this approach and I succeeded!

Dave Wolf [Sybase] wrote in message ...
>Mark the component to not support transactions.
>
>Dave Wolf
>Internet Applications Division
>
>"chenhongjiu" <chenhongjiu@163.net> wrote in message
>news:iUUMsGCh$GA.201@forums.sybase.com...
>> I use Jaguar 3.0.1 and PB 7.0.1.
>> I execute dynamic sql syntax in order to create a table in Jaguar
>> component.The code like this:
>>
>> as_syntax = "create table ..."
>> sqlca.autocommit = true
>> EXECUTE IMMEDIATE :as_syntax;
>> sqlca.autocommit = false
>>
>> I am sure the as_syntax is correct.
>> I execute the component's function,but it do nothing.Why?How to do?
>> Help me,please.Thank you.
>>
>>
>>
>
>