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.

Datawindow and 3 way data piping

4 posts in DataWindow Last posting was on 2008-09-01 11:08:39.0Z
Farah Posted on 2008-08-29 21:51:56.0Z
From: Farah <nfam@earthlink.net>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Datawindow and 3 way data piping
Date: Fri, 29 Aug 2008 14:51:56 -0700 (PDT)
Organization: http://groups.google.com
Lines: 20
Message-ID: <53d04004-476b-4da3-adab-d03ca12a557e@z6g2000pre.googlegroups.com>
NNTP-Posting-Host: 12.129.196.36
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1220046716 5263 127.0.0.1 (29 Aug 2008 21:51:56 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 29 Aug 2008 21:51:56 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: z6g2000pre.googlegroups.com; posting-host=12.129.196.36; posting-account=THtk6gkAAAD2svFiSGuXORoYQ9kT4Xga
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727; MS-RTC LM 8),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!z6g2000pre.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87674
Article PK: 416931

Hi,
I have a datawindow that should handle the following simelatneously
and I don't know how to make it to work:
1- Receive data and Accept it - as often as required by runing
processes.
2- Update the database - every one second
3- Retrieve data from the database - every one second

The application executes and monitors jobs (Scheduler Monitor) that
has been scheduled by another application (Scheduler Manager). So in
the Scheduler Monitor I have a datawindow that receives the status of
runing jobs at the same time it is refreshed every one second. When
it is refreshed it updates the database and then it does a retrieve to
pull in new shceduled jobs or changes to current jobs. The problem I
am having is it is not able to receive status messages from running
jobs unless I stop the refreshing cycle.

Does any one know how to resolve this issue?

Thank you in advance to taking the time to help me.


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2008-08-29 23:09:33.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <53d04004-476b-4da3-adab-d03ca12a557e@z6g2000pre.googlegroups.com>
Subject: Re: Datawindow and 3 way data piping
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48b881ad$1@forums-1-dub>
Date: 29 Aug 2008 16:09:33 -0700
X-Trace: forums-1-dub 1220051373 10.22.241.152 (29 Aug 2008 16:09:33 -0700)
X-Original-Trace: 29 Aug 2008 16:09:33 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87675
Article PK: 416930

How are you receiving status from running jobs?
It sounds to me like you need a cycle rather than a simple timer - maybe
with a half second sleep between steps.
Is some other process updating the database so that you need to retrieve
what you have just saved? It seems to me that you risk concurrency problems
if there is.
Please give us more detail.

"Farah" <nfam@earthlink.net> wrote in message
news:53d04004-476b-4da3-adab-d03ca12a557e@z6g2000pre.googlegroups.com...
> Hi,
> I have a datawindow that should handle the following simelatneously
> and I don't know how to make it to work:
> 1- Receive data and Accept it - as often as required by runing
> processes.
> 2- Update the database - every one second
> 3- Retrieve data from the database - every one second
>
> The application executes and monitors jobs (Scheduler Monitor) that
> has been scheduled by another application (Scheduler Manager). So in
> the Scheduler Monitor I have a datawindow that receives the status of
> runing jobs at the same time it is refreshed every one second. When
> it is refreshed it updates the database and then it does a retrieve to
> pull in new shceduled jobs or changes to current jobs. The problem I
> am having is it is not able to receive status messages from running
> jobs unless I stop the refreshing cycle.
>
> Does any one know how to resolve this issue?
>
> Thank you in advance to taking the time to help me.


Farah Posted on 2008-09-01 08:49:38.0Z
From: Farah <nfam@earthlink.net>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Datawindow and 3 way data piping
Date: Mon, 1 Sep 2008 01:49:38 -0700 (PDT)
Organization: http://groups.google.com
Lines: 43
Message-ID: <a131bb6b-00b3-4308-b283-083dafde3276@z72g2000hsb.googlegroups.com>
References: <53d04004-476b-4da3-adab-d03ca12a557e@z6g2000pre.googlegroups.com> <48b881ad$1@forums-1-dub>
NNTP-Posting-Host: 24.171.149.94
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1220258978 9013 127.0.0.1 (1 Sep 2008 08:49:38 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 1 Sep 2008 08:49:38 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: z72g2000hsb.googlegroups.com; posting-host=24.171.149.94; posting-account=THtk6gkAAAD2svFiSGuXORoYQ9kT4Xga
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)
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:87680
Article PK: 416936

The running processes send status messages to the monitor DW. Because
each running process is a thread I cannot control it using sleep and
the cycle would not work. There is another application that is used
to create and change scheduled jobs, which gets picked up by the DW
retrieve.

On Aug 29, 4:09 pm, "Jerry Siegel [TeamSybase]"

<jNOsSPAMsiegel@yahoo!.com> wrote:

> How are you receiving status from running jobs?
> It sounds to me like you need a cycle rather than a simple timer - maybe
> with a half second sleep between steps.
> Is some other process updating the database so that you need to retrieve
> what you have just saved? It seems to me that you risk concurrency problems
> if there is.
> Please give us more detail.
>
> "Farah" <n...@earthlink.net> wrote in message
>
> news:53d04004-476b-4da3-adab-d03ca12a557e@z6g2000pre.googlegroups.com...
>
> > Hi,
> > I have a datawindow that should handle the following simelatneously
> > and I don't know how to make it to work:
> > 1- Receive data and Accept it - as often as required by runing
> > processes.
> > 2- Update the database - every one second
> > 3- Retrieve data from the database - every one second
>
> > The application executes and monitors jobs (Scheduler Monitor) that
> > has been scheduled by another application (Scheduler Manager).  So in
> > the Scheduler Monitor I have a datawindow that receives the status of
> > runing jobs at the same time it is refreshed every one second.  When
> > it is refreshed it updates the database and then it does a retrieve to
> > pull in new shceduled jobs or changes to current jobs.  The problem I
> > am having is it is not able to receive status messages from running
> > jobs unless I stop the refreshing cycle.
>
> > Does any one know how to resolve this issue?
>
> > Thank you in advance to taking the time to help me.


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2008-09-01 11:08:39.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <53d04004-476b-4da3-adab-d03ca12a557e@z6g2000pre.googlegroups.com> <48b881ad$1@forums-1-dub> <a131bb6b-00b3-4308-b283-083dafde3276@z72g2000hsb.googlegroups.com>
Subject: Re: Datawindow and 3 way data piping
Lines: 50
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.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48bbcd37$1@forums-1-dub>
Date: 1 Sep 2008 04:08:39 -0700
X-Trace: forums-1-dub 1220267319 10.22.241.152 (1 Sep 2008 04:08:39 -0700)
X-Original-Trace: 1 Sep 2008 04:08:39 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87681
Article PK: 416939

I'd say you are trying to do too much with one DW. Why not have the thread
that captures the changed status do the data updates and simply retrieve
them for display on a timer cycle?

"Farah" <nfam@earthlink.net> wrote in message
news:a131bb6b-00b3-4308-b283-083dafde3276@z72g2000hsb.googlegroups.com...
The running processes send status messages to the monitor DW. Because
each running process is a thread I cannot control it using sleep and
the cycle would not work. There is another application that is used
to create and change scheduled jobs, which gets picked up by the DW
retrieve.

On Aug 29, 4:09 pm, "Jerry Siegel [TeamSybase]"

<jNOsSPAMsiegel@yahoo!.com> wrote:

> How are you receiving status from running jobs?
> It sounds to me like you need a cycle rather than a simple timer - maybe
> with a half second sleep between steps.
> Is some other process updating the database so that you need to retrieve
> what you have just saved? It seems to me that you risk concurrency
> problems
> if there is.
> Please give us more detail.
>
> "Farah" <n...@earthlink.net> wrote in message
>
> news:53d04004-476b-4da3-adab-d03ca12a557e@z6g2000pre.googlegroups.com...
>
> > Hi,
> > I have a datawindow that should handle the following simelatneously
> > and I don't know how to make it to work:
> > 1- Receive data and Accept it - as often as required by runing
> > processes.
> > 2- Update the database - every one second
> > 3- Retrieve data from the database - every one second
>
> > The application executes and monitors jobs (Scheduler Monitor) that
> > has been scheduled by another application (Scheduler Manager). So in
> > the Scheduler Monitor I have a datawindow that receives the status of
> > runing jobs at the same time it is refreshed every one second. When
> > it is refreshed it updates the database and then it does a retrieve to
> > pull in new shceduled jobs or changes to current jobs. The problem I
> > am having is it is not able to receive status messages from running
> > jobs unless I stop the refreshing cycle.
>
> > Does any one know how to resolve this issue?
>
> > Thank you in advance to taking the time to help me.