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.

Query about transaction object

3 posts in Objects Last posting was on 2003-09-22 18:56:02.0Z
viclee Posted on 2003-09-22 07:21:40.0Z
Sender: 4f08.3f6ea2ea.1804289383@sybase.com
From: viclee
Newsgroups: sybase.public.powerbuilder.objects
Subject: Query about transaction object
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f6ea304.4f0a.846930886@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 22 Sep 2003 00:21:40 -0700
X-Trace: forums-1-dub 1064215300 10.22.241.41 (22 Sep 2003 00:21:40 -0700)
X-Original-Trace: 22 Sep 2003 00:21:40 -0700, 10.22.241.41
Lines: 37
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:7603
Article PK: 734884

Hi all,

Can two transation objects co-exist in application (PB
6.5)at the same time? Such that executing SQL at specified
transaction object.

Let's say ...

// Set up Login Transaction object SQLCA
SQLCA.ServerName = "@SER1"
SQLCA.DBMS = "O73 ORACLE 7.3"
SQLCA.AutoCommit = false
SQLCA.LogId = "AAA"
SQLCA.LogPass = "AAA"
CONNECT USING SQLCA;

transaction checker
checker = create transaction
checker.ServerName = "@SER2"
checker.DBMS = "O73 ORACLE 7.3"
checker.AutoCommit = false
checker.LogId = "BBB"
checker.LogPass = "BBB"
connect using checker;

Now ..

//SQLCA
UPDATE SER1_TAB
SET F1 = 'DUMMY';

//By checker
UPDATE SER2_TAB
SET F2 = 'DUMMY'
USING checker;

Is that ok?


Olivier Posted on 2003-09-22 10:33:22.0Z
From: "Olivier" <ociteau-NOCANSPAM@yahoo.fr>
Newsgroups: sybase.public.powerbuilder.objects
Organization: 81.80.240.237
References: <3f6ea304.4f0a.846930886@sybase.com>
X-Newsreader: AspNNTP 1.50 (Tri Hoang)
Subject: Re: Query about transaction object
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: transinc-win02.netoptex.com
X-Original-NNTP-Posting-Host: transinc-win02.netoptex.com
Message-ID: <3f6ecff2$1@forums-1-dub>
Date: 22 Sep 2003 03:33:22 -0700
X-Trace: forums-1-dub 1064226802 206.169.167.22 (22 Sep 2003 03:33:22 -0700)
X-Original-Trace: 22 Sep 2003 03:33:22 -0700, transinc-win02.netoptex.com
Lines: 44
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:7604
Article PK: 734885

Please do not cross-post

On 22 Sep 2003 00:21:40 -0700,
in sybase.public.powerbuilder.objects

<viclee> wrote:
>Hi all,
>
>Can two transation objects co-exist in application (PB
>6.5)at the same time? Such that executing SQL at specified
>transaction object.
>
>Let's say ...
>
>// Set up Login Transaction object SQLCA
>SQLCA.ServerName = "@SER1"
>SQLCA.DBMS = "O73 ORACLE 7.3"
>SQLCA.AutoCommit = false
>SQLCA.LogId = "AAA"
>SQLCA.LogPass = "AAA"
>CONNECT USING SQLCA;
>
>transaction checker
>checker = create transaction
>checker.ServerName = "@SER2"
>checker.DBMS = "O73 ORACLE 7.3"
>checker.AutoCommit = false
>checker.LogId = "BBB"
>checker.LogPass = "BBB"
>connect using checker;
>
>Now ..
>
>//SQLCA
>UPDATE SER1_TAB
>SET F1 = 'DUMMY';
>
>//By checker
>UPDATE SER2_TAB
>SET F2 = 'DUMMY'
>USING checker;
>
>Is that ok?

Olivier Citeau from Paris, France


Terry Dykstra Posted on 2003-09-22 18:56:02.0Z
From: "Terry Dykstra" <dontreply_tddykstra@forestoil.ca.x>
Newsgroups: sybase.public.powerbuilder.objects
References: <3f6ea304.4f0a.846930886@sybase.com>
Subject: Re: Query about transaction object
Lines: 50
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 209.115.237.14
X-Original-NNTP-Posting-Host: 209.115.237.14
Message-ID: <3f6f45c2$1@forums-1-dub>
Date: 22 Sep 2003 11:56:02 -0700
X-Trace: forums-1-dub 1064256962 209.115.237.14 (22 Sep 2003 11:56:02 -0700)
X-Original-Trace: 22 Sep 2003 11:56:02 -0700, 209.115.237.14
X-Authenticated-User: Teamps
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:7605
Article PK: 734886

Yes, that's OK.

--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://www.pb9books.com
product enhancement requests:
http://www.isug.com/cgi-bin/ISUG2/submit_enhancement

<viclee> wrote in message news:3f6ea304.4f0a.846930886@sybase.com...
> Hi all,
>
> Can two transation objects co-exist in application (PB
> 6.5)at the same time? Such that executing SQL at specified
> transaction object.
>
> Let's say ...
>
> // Set up Login Transaction object SQLCA
> SQLCA.ServerName = "@SER1"
> SQLCA.DBMS = "O73 ORACLE 7.3"
> SQLCA.AutoCommit = false
> SQLCA.LogId = "AAA"
> SQLCA.LogPass = "AAA"
> CONNECT USING SQLCA;
>
> transaction checker
> checker = create transaction
> checker.ServerName = "@SER2"
> checker.DBMS = "O73 ORACLE 7.3"
> checker.AutoCommit = false
> checker.LogId = "BBB"
> checker.LogPass = "BBB"
> connect using checker;
>
> Now ..
>
> //SQLCA
> UPDATE SER1_TAB
> SET F1 = 'DUMMY';
>
> //By checker
> UPDATE SER2_TAB
> SET F2 = 'DUMMY'
> USING checker;
>
> Is that ok?