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.

Problem with DS

6 posts in ,  DataWindow Powerscript Last posting was on 2008-08-09 01:16:08.0Z
diegoa1015 Posted on 2008-08-07 05:12:11.0Z
From: diegoa1015 <diegoa1015@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow,sybase.public.powerbuilder.powerscript
Subject: Problem with DS
Date: Wed, 6 Aug 2008 22:12:11 -0700 (PDT)
Organization: http://groups.google.com
Lines: 23
Message-ID: <b8238056-02ac-446e-9b77-a3ab2b287278@i76g2000hsf.googlegroups.com>
NNTP-Posting-Host: 190.232.230.76
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1218085931 15533 127.0.0.1 (7 Aug 2008 05:12:11 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 7 Aug 2008 05:12:11 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: i76g2000hsf.googlegroups.com; posting-host=190.232.230.76; posting-account=jrQ5xAoAAABmJ7WQowQvi5xKqsWQlwP1
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; InfoPath.2),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!i76g2000hsf.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87508 sybase.public.powerbuilder.powerscript:26360
Article PK: 416765

Good night,
I'm working with datastore's
After uploading data with the ds (ds_1.retrieve), you must be doing
something? because sometimes it seems that blocks the other machines
using the system, the window where the ds used constantly ds
any recommendation that I can to avoid these blockades

Greetings, now I say thanks for the help they can give me .Excuse my
English

/*
Buenas noches ,
estoy trabajando con datastore's
despues de cargar datos con el ds (ds_1.retrieve ) , se tiene que
hacer algo ?,porque parece que aveces esto bloquea a las demas
maquinas que usan el sistema , la ventana en donde esta el ds usa
constantemente el ds
alguna recomendacion que me puedan , par evitar estos bloqueos

Saludos, desde ya les digo gracias por la ayuda que me puedan brindar

Disculpen mi ingles
*/


Jeremy Lakeman Posted on 2008-08-07 06:34:36.0Z
From: Jeremy Lakeman <jeremy.lakeman@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow,sybase.public.powerbuilder.powerscript
Subject: Re: Problem with DS
Date: Wed, 6 Aug 2008 23:34:36 -0700 (PDT)
Organization: http://groups.google.com
Lines: 35
Message-ID: <e64f3bd8-133c-4b85-9c6d-26eed39eb9db@z72g2000hsb.googlegroups.com>
References: <b8238056-02ac-446e-9b77-a3ab2b287278@i76g2000hsf.googlegroups.com>
NNTP-Posting-Host: 203.122.242.105
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1218090876 10325 127.0.0.1 (7 Aug 2008 06:34:36 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 7 Aug 2008 06:34:36 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: z72g2000hsb.googlegroups.com; posting-host=203.122.242.105; posting-account=euaBtgoAAAC_vDxfsxmpMKlBxHaHpmRS
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.1) Gecko/2008070208 Firefox/3.0.1,gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.1 fly.essential.com.au:3128 (squid/2.5.STABLE8), 1.0 asp.essential.intranet:3128 (squid/2.5.STABLE8)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!z72g2000hsb.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87510 sybase.public.powerbuilder.powerscript:26361
Article PK: 416766


On Aug 7, 2:12 pm, diegoa1015 <diegoa1...@gmail.com> wrote:
> Good night,
> I'm working with datastore's
> After uploading data with the ds (ds_1.retrieve), you must be doing
> something? because sometimes it seems that blocks the other machines
> using the system, the window where the ds used constantly ds
> any recommendation that I can to avoid these blockades
>
> Greetings, now I say thanks for the help they can give me .Excuse my
> English
>
> /*
> Buenas noches  ,
> estoy trabajando con datastore's
> despues de cargar datos con el ds (ds_1.retrieve ) , se tiene que
> hacer algo ?,porque parece que aveces esto bloquea a las demas
> maquinas que usan el sistema , la ventana en donde esta el ds usa
> constantemente el ds
> alguna recomendacion que me puedan , par evitar estos bloqueos
>
> Saludos, desde ya les digo gracias por la ayuda que me puedan brindar
>
> Disculpen mi ingles
> */

Sounds like you have the wrong "transaction isolation level" set in
your database connection.
How you set this may depend on the type of database you are connecting
to.
One of these should point you in the right direction;
sqlca.lock = "RC"
execute immediate 'SET TRANSACTION ISOLATION LEVEL READ COMMITTED'
using sqlca;
sqlca.autocommit=true
commit using sqlca;


KL Posted on 2008-08-07 19:31:34.0Z
Sender: 2dd2.489857c5.1804289383@sybase.com
From: KL
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Problem with DS
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <489b4d96.156d.1681692777@sybase.com>
References: <b8238056-02ac-446e-9b77-a3ab2b287278@i76g2000hsf.googlegroups.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 7 Aug 2008 12:31:34 -0700
X-Trace: forums-1-dub 1218137494 10.22.241.41 (7 Aug 2008 12:31:34 -0700)
X-Original-Trace: 7 Aug 2008 12:31:34 -0700, 10.22.241.41
Lines: 33
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87520
Article PK: 416779

Try:

ds_1.Retrieve()
commit using sqlca;


HTH KL

> Good night,
> I'm working with datastore's
> After uploading data with the ds (ds_1.retrieve), you must
> be doing something? because sometimes it seems that blocks
> the other machines using the system, the window where the
> ds used constantly ds any recommendation that I can to
> avoid these blockades
>
> Greetings, now I say thanks for the help they can give me
> Excuse my English
>
> /*
> Buenas noches ,
> estoy trabajando con datastore's
> despues de cargar datos con el ds (ds_1.retrieve ) , se
> tiene que hacer algo ?,porque parece que aveces esto
> bloquea a las demas maquinas que usan el sistema , la
> ventana en donde esta el ds usa constantemente el ds
> alguna recomendacion que me puedan , par evitar estos
> bloqueos
>
> Saludos, desde ya les digo gracias por la ayuda que me
> puedan brindar
>
> Disculpen mi ingles
> */


diegoa1015 Posted on 2008-08-08 02:50:08.0Z
From: diegoa1015 <diegoa1015@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Problem with DS
Date: Thu, 7 Aug 2008 19:50:08 -0700 (PDT)
Organization: http://groups.google.com
Lines: 49
Message-ID: <e610b693-8937-412a-bb6d-dc85ec025e52@d45g2000hsc.googlegroups.com>
References: <b8238056-02ac-446e-9b77-a3ab2b287278@i76g2000hsf.googlegroups.com> <489b4d96.156d.1681692777@sybase.com>
NNTP-Posting-Host: 190.42.220.99
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1218163808 25200 127.0.0.1 (8 Aug 2008 02:50:08 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 8 Aug 2008 02:50:08 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: d45g2000hsc.googlegroups.com; posting-host=190.42.220.99; posting-account=jrQ5xAoAAABmJ7WQowQvi5xKqsWQlwP1
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; InfoPath.2),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!nntp1.roc.gblx.net!nntp.gblx.net!nntp.gblx.net!nlpi057.nbdc.sbc.com!prodigy.net!nx02.iad01.newshosting.com!newshosting.com!69.16.185.16.MISMATCH!npeer02.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!d45g2000hsc.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87524
Article PK: 416780

Hello,
then I think the best thing would be to put one of these lines
to start conexcion

execute immediate 'SET TRANSACTION ISOLATION LEVEL READ COMMITTED'
or
sqlca.lock = "RC"
This would be sufficient? , it would need to put the following lines

commit using sqlca;
-- to retrieve later, to loosen the "conexcion"

scrip today
SQLCA.DBMS = "MSS Microsoft SQL Server"
SQLCA.Database = "BD_1"
SQLCA.ServerName = "Pc_1"
SQLCA.LogId = "HS"
SQLCA.AutoCommit = False
SQLCA.DBParm = ""

--PB 9.0 SQLServer 2000

Greetings

/*
Hola ,
entonces creo que lo mejor seria poner una de estas lineas
al iniciar la conexcion

execute immediate 'SET TRANSACTION ISOLATION LEVEL READ COMMITTED'
o
sqlca.lock = "RC"
,esto seria suficiente ? ,habria necesidad de poner las siguientes
lineas

commit using sqlca;
--despues de hacer retrieve ,para soltar la "conexcion"

Actualmente estoy usando este scrip
SQLCA.DBMS = "MSS Microsoft SQL Server"
SQLCA.Database = "BD_1"
SQLCA.ServerName = "Pc_1"
SQLCA.LogId = "SA"
SQLCA.AutoCommit = False
SQLCA.DBParm = ""

Saludos
PB 9.0 SQLServer 2000
*/


Adrián Galván Posted on 2008-08-08 22:42:12.0Z
From: "Adrián Galván" <no_spam_agalvan_no_spam_please_at_audisys.com>
Newsgroups: sybase.public.powerbuilder.datawindow,sybase.public.powerbuilder.powerscript
References: <b8238056-02ac-446e-9b77-a3ab2b287278@i76g2000hsf.googlegroups.com>
Subject: Re: Problem with DS
Lines: 35
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <489ccbc4$1@forums-1-dub>
Date: 8 Aug 2008 15:42:12 -0700
X-Trace: forums-1-dub 1218235332 10.22.241.152 (8 Aug 2008 15:42:12 -0700)
X-Original-Trace: 8 Aug 2008 15:42:12 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87529 sybase.public.powerbuilder.powerscript:26364
Article PK: 416787

Tu transacción debe ser RC, Read Commited despues del Retrieve puedes hacer
un commit o bien definir tu transacción con AutoCommit si ya no vas hacer
nada o bien darle un destroy a tu objeto de transacción.

Saludos



"diegoa1015" <diegoa1015@gmail.com> escribió en el mensaje
news:b8238056-02ac-446e-9b77-a3ab2b287278@i76g2000hsf.googlegroups.com...

> Good night,
> I'm working with datastore's
> After uploading data with the ds (ds_1.retrieve), you must be doing
> something? because sometimes it seems that blocks the other machines
> using the system, the window where the ds used constantly ds
> any recommendation that I can to avoid these blockades
>
> Greetings, now I say thanks for the help they can give me .Excuse my
> English
>
> /*
> Buenas noches ,
> estoy trabajando con datastore's
> despues de cargar datos con el ds (ds_1.retrieve ) , se tiene que
> hacer algo ?,porque parece que aveces esto bloquea a las demas
> maquinas que usan el sistema , la ventana en donde esta el ds usa
> constantemente el ds
> alguna recomendacion que me puedan , par evitar estos bloqueos
>
> Saludos, desde ya les digo gracias por la ayuda que me puedan brindar
>
> Disculpen mi ingles
> */


diegoa1015 Posted on 2008-08-09 01:16:08.0Z
From: diegoa1015 <diegoa1015@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow,sybase.public.powerbuilder.powerscript
Subject: Re: Problem with DS
Date: Fri, 8 Aug 2008 18:16:08 -0700 (PDT)
Organization: http://groups.google.com
Lines: 6
Message-ID: <32da94d0-a152-4111-b084-45488d7c95a6@r66g2000hsg.googlegroups.com>
References: <b8238056-02ac-446e-9b77-a3ab2b287278@i76g2000hsf.googlegroups.com> <489ccbc4$1@forums-1-dub>
NNTP-Posting-Host: 190.42.220.10
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1218244569 23554 127.0.0.1 (9 Aug 2008 01:16:09 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sat, 9 Aug 2008 01:16:09 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: r66g2000hsg.googlegroups.com; posting-host=190.42.220.10; posting-account=jrQ5xAoAAABmJ7WQowQvi5xKqsWQlwP1
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; es-ES; rv:1.9) Gecko/2008052906 Firefox/3.0,gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!nntp1.roc.gblx.net!nntp.gblx.net!nntp.gblx.net!nlpi057.nbdc.sbc.com!prodigy.net!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!r66g2000hsg.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87530 sybase.public.powerbuilder.powerscript:26365
Article PK: 416786

ok, thank you very much for the help.
Greetings

ok ,muchas gracias por la ayuda.
Saludos