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.

SaveAsAscii/FormattedText without headers

3 posts in DataWindow Last posting was on 2008-07-28 13:06:46.0Z
Castanova Posted on 2008-07-25 21:09:47.0Z
From: Castanova <master.jacobs@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: SaveAsAscii/FormattedText without headers
Date: Fri, 25 Jul 2008 14:09:47 -0700 (PDT)
Organization: http://groups.google.com
Lines: 12
Message-ID: <db274c5e-de9b-437f-ade5-972189ff3ef1@34g2000hsf.googlegroups.com>
NNTP-Posting-Host: 63.168.131.24
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1217020187 3683 127.0.0.1 (25 Jul 2008 21:09:47 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 25 Jul 2008 21:09:47 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: 34g2000hsf.googlegroups.com; posting-host=63.168.131.24; posting-account=4gSLPQoAAACOtJpckohpQNEeY8BQKxEx
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!34g2000hsf.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87459
Article PK: 416716

I need to output a data window to a text file without headers. Right
now I'm using SaveAs successfully except for one problem. I have
fields with a Decimal(13,9) data type. When these fields are outputted
to the text file, they look like this 25.256000000. This is
unacceptable so I used formatting in the data window.

But now I find out that I can't use SaveAsFormattedText because it has
no option to remove the headers!! Is there ANY WAY around this? Or do
I need to resort to some process outside of PowerBuilder to handle
this issue.

That this problem even exists is absolutely mind boggling!!


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2008-07-25 22:52:23.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <db274c5e-de9b-437f-ade5-972189ff3ef1@34g2000hsf.googlegroups.com>
Subject: Re: SaveAsAscii/FormattedText without headers
Lines: 20
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.5512
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <488a5927$1@forums-1-dub>
Date: 25 Jul 2008 15:52:23 -0700
X-Trace: forums-1-dub 1217026343 10.22.241.152 (25 Jul 2008 15:52:23 -0700)
X-Original-Trace: 25 Jul 2008 15:52:23 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87461
Article PK: 416717

No hint in help about how PB determines what the header is. What if you copy
the data to a DW with no headers (detail band only) and SaveAsFormattedText
on that? (I think ShareData would pass the function to the source DW).

"Castanova" <master.jacobs@gmail.com> wrote in message
news:db274c5e-de9b-437f-ade5-972189ff3ef1@34g2000hsf.googlegroups.com...
>I need to output a data window to a text file without headers. Right
> now I'm using SaveAs successfully except for one problem. I have
> fields with a Decimal(13,9) data type. When these fields are outputted
> to the text file, they look like this 25.256000000. This is
> unacceptable so I used formatting in the data window.
>
> But now I find out that I can't use SaveAsFormattedText because it has
> no option to remove the headers!! Is there ANY WAY around this? Or do
> I need to resort to some process outside of PowerBuilder to handle
> this issue.
>
> That this problem even exists is absolutely mind boggling!!


Castanova Posted on 2008-07-28 13:06:46.0Z
From: Castanova <master.jacobs@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: SaveAsAscii/FormattedText without headers
Date: Mon, 28 Jul 2008 06:06:46 -0700 (PDT)
Organization: http://groups.google.com
Lines: 5
Message-ID: <8ec4b6ea-6883-4103-87fb-ec0e225d6005@y21g2000hsf.googlegroups.com>
References: <db274c5e-de9b-437f-ade5-972189ff3ef1@34g2000hsf.googlegroups.com> <488a5927$1@forums-1-dub>
NNTP-Posting-Host: 141.160.4.34
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1217250407 2659 127.0.0.1 (28 Jul 2008 13:06:47 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 28 Jul 2008 13:06:47 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: y21g2000hsf.googlegroups.com; posting-host=141.160.4.34; posting-account=4gSLPQoAAACOtJpckohpQNEeY8BQKxEx
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!y21g2000hsf.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87467
Article PK: 416723

I gave up. Luckily, I was already doing some manipulation on the
output file with a C# program afterward so I just removed the header
line in that program. I wish this functionality was present in the
program, though, and I can't imagine it would be terribly time
consuming to add it in.