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.

change field size

2 posts in DataWindow Last posting was on 2009-03-04 21:57:19.0Z
The Other Mike Posted on 2009-03-04 20:53:23.0Z
From: "The Other Mike" <mdunlap@nospam.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: change field size
Lines: 7
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6001.18000
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6001.18049
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49aeea43@forums-1-dub>
Date: 4 Mar 2009 12:53:23 -0800
X-Trace: forums-1-dub 1236200003 10.22.241.152 (4 Mar 2009 12:53:23 -0800)
X-Original-Trace: 4 Mar 2009 12:53:23 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88905
Article PK: 418156

Is there a way to do a mass update in PB11.5? I have to change a field in
SQL 2000 from varchar(15) to varchar(20) and must have 50 datatwindows to
change.

Thanks
Mike


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2009-03-04 21:57:19.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <49aeea43@forums-1-dub>
Subject: Re: change field size
Lines: 19
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; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49aef93f$1@forums-1-dub>
Date: 4 Mar 2009 13:57:19 -0800
X-Trace: forums-1-dub 1236203839 10.22.241.152 (4 Mar 2009 13:57:19 -0800)
X-Original-Trace: 4 Mar 2009 13:57:19 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88906
Article PK: 418158

http://www.techno-kitten.com/PBL_Peeper/pbl_peeper.html has a search and
replace uility. As with any such tool, apply with caution, backups, and
testing!

--
Report Bugs: http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

"The Other Mike" <mdunlap@nospam.com> wrote in message
news:49aeea43@forums-1-dub...
> Is there a way to do a mass update in PB11.5? I have to change a field in
> SQL 2000 from varchar(15) to varchar(20) and must have 50 datatwindows to
> change.
>
> Thanks
> Mike