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 object text column (4099) migrate to PB11.5.1

4 posts in General Discussion Last posting was on 2013-03-22 09:04:13.0Z
EJ Posted on 2013-03-20 16:19:43.0Z
Sender: 33a7.5149cf65.1804289383@sybase.com
From: EJ
Newsgroups: sybase.public.powerbuilder.general
Subject: datawindow object text column (4099) migrate to PB11.5.1
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <5149e19f.36af.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 20 Mar 2013 08:19:43 -0800
X-Trace: forums-1-dub 1363796383 172.20.134.41 (20 Mar 2013 08:19:43 -0800)
X-Original-Trace: 20 Mar 2013 08:19:43 -0800, 172.20.134.41
Lines: 15
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.general:250013
Article PK: 1308517

Hi,

when i migrate some very old datawindow object (pb 6.5.1)
with a text column into PB 11.5.1 using SNC, they cannot be
displayed.

I have to manually edit and change the text column to size
32766 before it can be displayed.

I have many datawindow to be migrated. Is there a shorter
and better method?

Help is appreciated.

EJ


Chris Pollach Posted on 2013-03-20 18:16:54.0Z
From: Chris Pollach <cpollach@travel-net.com>
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:17.0) Gecko/20130307 Thunderbird/17.0.4
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.general
Subject: Re: datawindow object text column (4099) migrate to PB11.5.1
References: <5149e19f.36af.1681692777@sybase.com>
In-Reply-To: <5149e19f.36af.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <5149fd16$1@forums-1-dub>
Date: 20 Mar 2013 10:16:54 -0800
X-Trace: forums-1-dub 1363803414 172.20.134.152 (20 Mar 2013 10:16:54 -0800)
X-Original-Trace: 20 Mar 2013 10:16:54 -0800, vip152.sybase.com
Lines: 44
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.general:250020
Article PK: 1308525

Hi EJ;

You can use the LibraryExport ( ) and LibrayImport ( ) commands to
export the DWO source for a file, do a replace all in PowerScript for
the column size and then Import the modified DWO source back into your
PBL. Using this technique - you could automate the whole DW column size
conversion.

HTH

--

Regards ... Chris
President: OSUG / STD Inc.
Vice President: ISUG-TECH
Blog: http://chrispollach.blogspot.com
SourceForge: http://sourceforge.net/projects/stdfndclass
PBDJ: http://chrispollach.sys-con.com
TKD: http://www.syeoh.com

On 3/20/2013 12:19 PM, EJ wrote:
> Hi,
>
> when i migrate some very old datawindow object (pb 6.5.1)
> with a text column into PB 11.5.1 using SNC, they cannot be
> displayed.
>
> I have to manually edit and change the text column to size
> 32766 before it can be displayed.
>
> I have many datawindow to be migrated. Is there a shorter
> and better method?
>
> Help is appreciated.
>
> EJ
>


Terry Voth [TeamSybase] Posted on 2013-03-22 04:25:11.0Z
From: "Terry Voth [TeamSybase]" <sequel@techno-kitten.com>
Newsgroups: sybase.public.powerbuilder.general
Subject: Re: datawindow object text column (4099) migrate to PB11.5.1
Message-ID: <s3nnk8hifmh0qnddeno5663ogunaha3rgj@4ax.com>
References: <5149e19f.36af.1681692777@sybase.com>
X-Newsreader: Forte Agent 5.00/32.1171
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 21 Mar 2013 20:25:11 -0800
X-Trace: forums-1-dub 1363926311 172.20.134.152 (21 Mar 2013 20:25:11 -0800)
X-Original-Trace: 21 Mar 2013 20:25:11 -0800, vip152.sybase.com
Lines: 52
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.general:250038
Article PK: 1308562

It's not really clear what you're changing from and to. From a larger
number to 32766, or some smaller number to 32766. Is the original
number consistent, or all over the map.

There's probably a few tools in PBL Peeper (see below) that could help
you (most prominent in my mind is the "Synchronize DataWindow Data
Sets" processor, which matches what PB thinks your data type is in the
database to what is in your DataWindow), but it's hard to say from
here; the basic search and replace may be enough.

Good luck,

Terry and Sequel the techno-kitten

On 20 Mar 2013 08:19:43 -0800, EJ wrote:

>Hi,
>
>when i migrate some very old datawindow object (pb 6.5.1)
>with a text column into PB 11.5.1 using SNC, they cannot be
>displayed.
>
>I have to manually edit and change the text column to size
>32766 before it can be displayed.
>
>I have many datawindow to be migrated. Is there a shorter
>and better method?
>
>Help is appreciated.
>
>EJ

*********************************
Build your vocabulary while feeding the hungry
http://www.freerice.com
*********************************
Newsgroup User Manual
=====================
TeamSybase <> Sybase employee
Forums = Peer-to-peer
Forums <> Communication with Sybase
IsNull (AnswerTo (Posting)) can return TRUE
Forums.Moderated = TRUE, so behave or be deleted
*********************************

Sequel's Sandbox: http://www.techno-kitten.com
Home of PBL Peeper, a free PowerBuilder Developer's Toolkit.
Version 4.1.3 now available at http://www.techno-kitten.com/PBL_Peeper/Download/download.html
See the PB Troubleshooting & Migration Guides at the Sandbox
^ ^
o o
=*=


EJ Posted on 2013-03-22 09:04:13.0Z
Sender: 4e4a.514c1cc9.1804289383@sybase.com
From: EJ
Newsgroups: sybase.public.powerbuilder.general
Subject: Re: datawindow object text column (4099) migrate to PB11.5.1
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <514c1e8d.4e9e.1681692777@sybase.com>
References: <s3nnk8hifmh0qnddeno5663ogunaha3rgj@4ax.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 22 Mar 2013 01:04:13 -0800
X-Trace: forums-1-dub 1363943053 172.20.134.41 (22 Mar 2013 01:04:13 -0800)
X-Original-Trace: 22 Mar 2013 01:04:13 -0800, 172.20.134.41
Lines: 75
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.general:250044
Article PK: 1308569


> It's not really clear what you're changing from and to.
> From a larger number to 32766, or some smaller number to
> 32766. Is the original number consistent, or all over the
> map.
>
> There's probably a few tools in PBL Peeper (see below)
> that could help you (most prominent in my mind is the
> "Synchronize DataWindow Data Sets" processor, which
> matches what PB thinks your data type is in the database
> to what is in your DataWindow), but it's hard to say from
> here; the basic search and replace may be enough.
>
> Good luck,
>
> Terry and Sequel the techno-kitten
>
> On 20 Mar 2013 08:19:43 -0800, EJ wrote:
>
> >Hi,
> >
> >when i migrate some very old datawindow object (pb 6.5.1)
> >with a text column into PB 11.5.1 using SNC, they cannot
> be >displayed.
> >
> >I have to manually edit and change the text column to
> size >32766 before it can be displayed.
> >
> >I have many datawindow to be migrated. Is there a
> shorter >and better method?
> >
> >Help is appreciated.
> >
> >EJ
>
> *********************************
> Build your vocabulary while feeding the hungry
> http://www.freerice.com
> *********************************
> Newsgroup User Manual
> =====================
> TeamSybase <> Sybase employee
> Forums = Peer-to-peer
> Forums <> Communication with Sybase
> IsNull (AnswerTo (Posting)) can return TRUE
> Forums.Moderated = TRUE, so behave or be deleted
> *********************************
>
> Sequel's Sandbox: http://www.techno-kitten.com
> Home of PBL Peeper, a free PowerBuilder Developer's
> Toolkit. Version 4.1.3 now available at
>
http://www.techno-kitten.com/PBL_Peeper/Download/download.html
> See the PB Troubleshooting & Migration Guides at the
> Sandbox ^ ^
> o o
> =*=

Dear Terry,

The problem lies in the SNC with PB11.5.1.
When I migrate the PB6.5.1 datawindow object, those with the
database column as text are defaulted to char(4099) which is
the default for PB6.5.1. It has no problem there with
PB6.5.1

With the converted datawindow object, text is also
char(4099), which can be displayed. ** was wondering if it
is a SNC or PB11.5.1 (build 4075) bugs ????.

If i export from the PB11.5.1 PBL and change it to
char(32766), then the problem is solved.

Any advise

EJ