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.

Curious Pipeline Feature/Bug

2 posts in Objects Last posting was on 2004-04-28 21:41:07.0Z
Doug Harding Posted on 2004-04-23 21:47:15.0Z
X-Newsreader: Groupwise 6.5
From: "Doug Harding" <DHARDING@utah.gov>
Subject: Curious Pipeline Feature/Bug
Newsgroups: sybase.public.powerbuilder.objects
X-Original-NNTP-Posting-Host: fidrh.fi.as.ex.state.ut.us
Message-ID: <40898edf$1@forums-2-dub>
X-Original-Trace: 23 Apr 2004 14:47:11 -0700, fidrh.fi.as.ex.state.ut.us
Lines: 41
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 23 Apr 2004 14:47:12 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 23 Apr 2004 14:47:15 -0700
X-Trace: forums-1-dub 1082756835 10.22.108.75 (23 Apr 2004 14:47:15 -0700)
X-Original-Trace: 23 Apr 2004 14:47:15 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:7885
Article PK: 735158

Hi all,

I am running PowerBuilder 8.0.1 build 9056. I am running on a windows 2k
operating system and using Adaptive Server 12.0 as my database.

I noticed something odd with the Pipeline object a couple of days ago that I
had never seen before.

I had several tables that I needed to create in our production environment
along with moving the data in those tables to the production environment
too.

I created the pipeline objects to create the tables and move the data and
everything went off without a hitch. (or so I thought). When it came time
to create the foreign keys between the tables I started running into all
sorts of problems. Most of them involved PowerBuilder just taking a powder
and shutting down. After many hours of investigating, I discovered that
PowerBuilder was doing me a favor? when it created the new tables. In every
case where the source datatype was an int, the pipeline would change it to a
datatype of real. In everycase where a datatype was of type numeric, the
pipeline would change it to a decimal with no decimal places.

Has anyone else experienced this phenomenon? I know now to watch for this
sort of thing and to change the changed datatype in the receiving table.
The question is why is it doing this. I know that the pipeline is supposed
make its best guess as to datatype when moving data from one database to
another, but for Pete sakes, both the databases on the source and receiving
ends are Sybase Adaptive Server Enterprise version 12.0. Why would the
pipeline change these data styles when both sending and receiving databases
are the same. I have read the instructions on this object and searched
google for any discussion on this type of situation.

Does anyone have a solution for this situation?

If this isn't the right news group for this question please tell me and I
will move it there.


Thanks,

Doug Harding


Doug Harding Posted on 2004-04-28 21:41:07.0Z
References: <40898edf$1@forums-2-dub>
X-Newsreader: Groupwise 6.5
From: "Doug Harding" <DHARDING@utah.gov>
Subject: Re: Curious Pipeline Feature/Bug
Newsgroups: sybase.public.powerbuilder.objects
NNTP-Posting-Host: fidrh.fi.as.ex.state.ut.us
X-Original-NNTP-Posting-Host: fidrh.fi.as.ex.state.ut.us
Message-ID: <409024f3$1@forums-1-dub>
Date: 28 Apr 2004 14:41:07 -0700
X-Trace: forums-1-dub 1083188467 168.179.253.56 (28 Apr 2004 14:41:07 -0700)
X-Original-Trace: 28 Apr 2004 14:41:07 -0700, fidrh.fi.as.ex.state.ut.us
Lines: 6
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:7893
Article PK: 735166

Please ignore this message. I have re-posted it over in the
PowerBuilder.General forum.

Thanks,

Doug