The current version of Pervasive PSQL v9.5 IS sup****ted on Windows NT,
provided that you have SP6a installed. (Most people do.)
The cost is dependent on the user count. You can get full pricing here:
http://www.goldstarsoftware.com/prices9.asp
For systems with less than 5 concurrent users, you can use the
Workgroup Engine, which is only $25 each, but most people use the
server engine for the added security and performance.
I cannot say if Websphere uses this or not, although it might. When
all is said and done, the PSQLv9 engine provides both the low-level
(ISAM-like) Btrieve access method, as well as a high-level SQL/ODBC
access method, and you can use them both concurrently.
BTW -- if you ever need it, just type "BUTIL" by itself for a complete
list of options and their proper syntax.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach@[EMAIL PROTECTED]
Chicago: Pervasive Service & Sup****t Class - 08/28/2007 ***
Graham Hobbs wrote:
> oh jeez, oh jeez, oh jeez
>
> Mr. Bach,
> am i glad to hear from you.
>
> stuff:
>
> Am going to try what you've said by the weekend (will let you know
> what happens _ whether you like it or not ::--)))
> .
> Would PSQL work in Windows NT (am stuck with NT until i can afford
> Websphere Developer for z/OS).
> How much is PSQL?
> I see Websphere comes with (or is a chargeable add-on) a 'VSAM
> emulator type of thing' - might it be Pervasive's?
>
> My hardcopy do***entation (is part of an IBM CICS manual) gave no
> specific examples or clue that -CREATE was followed by -LOAD and while
> I looked at Pervasive's online docs, there was no way could i print a
> couple of hundred pages and you cant search for something you're not
> aware of (i.e.-LOAD).
>
> Many thanks for your help
> Graham
>
> On Wed, 15 Aug 2007 08:48:39 -0500, "Bill Bach"
> <goldstar@[EMAIL PROTECTED]
> wrote:
>
> > Your description file seems to be correct, and I was able to use it
> > to create a file with the PSQLV8 database engine.
> >
> > You can get full do***entation on the Description files for Btrieve
> > 6.15 from this link:
> > http://ww1.pervasive.com/library/
> >
> >
> > Your problem is not with the DES file, though -- it is with your
> > use of the BUTIL -CREATE tool. Type "BUTIL -CREATE" by itself for
> > the following syntax:
> >
> > BUTIL -CREATE <outputFile> <descriptionFile> [Y|N]
> >
> > Note that the FIRST file must be the new Btrieve filename that you
> > are trying to create. In your case, it was an existing text file,
> > and that may have confused the BUTIL tool.
> >
> > The proper way to create a file and load the data is with two
> > commands: BUTIL -CREATE BTRVFILE.DAT DESFILE.TXT
> > BUTIL -LOAD RECORDS.TXT BTRVFILE.DAT
> >
> > This uses the description file called DESFILE.TXT to create a new
> > Btrieve file called BTRVFILE.DAT, the loads the fixed-length
> > records in from the text file RECORDS.TXT.
> >
> > One last thing, though -- your fixed-length records are NOT in the
> > proper format for im****ting with BUTIL! See the manual for
> > infomration on the "Unformatted File" format, but in a nutshell,
> > each line should start with the 4 characters "100,", then contain
> > the 100 bytes of data, followed by a CR/LF pair. Without the
> > length indicator at the beginning, the system will get all confused
> > during the LOAD part.
> >
> >
> > By the way, Btrieve 6.15 hasn't been sold nor sup****ted since 1999.
> > Pervasive PSQL v9.5, the current version of Btrieve (and still
> > backwards compatible with older applications) may be a better
> > solution for you. It also has some great new features that make it
> > much easier to access COBOL-based data from SQL queries. Well
> > worth the time to investigate anyway...
> > Goldstar Software Inc.
> > Pervasive-based Products, Training & Services
> > Bill Bach
> > BillBach@[EMAIL PROTECTED]
> > http://www.goldstarsoftware.com
> > *** Chicago: Pervasive Service & Sup****t Class - 08/28/2007 ***
> >
> >
> >
> > Graham Hobbs wrote:
> >
> >> Help please...
> >> I have a problem trying to create a KSDS file from a sequential
> file. >> Am using File Manager Version 6.15 and is my first attempt
> to use such >> to create a KSDS.
> >> I cannot interpret the do***entation and the BUTIL-100 error
> message >> is not helpful (like 'what data buffer').
> >> I have to put 200/300 files through this process. If I can get the
> >> first working I feel the remainder will be easy even though some
> will >> require two alternate keys.
> >>
> >> .. so I executed the following .CMD file, in an NT DOS window..
> >>
> >> BUTIL -CREATE E:\CONRAD\VS1A\ZZJ35VSA.FIL
> E:\CONRAD\VS1A\ZZJ35BU2.TXT >>
> >> .. where ZZJ35BU2.TXT contained.all File Manager elements in order,
> >> all lowercase, (page=4096 was desperation),...
> >>
> >> record=100 variable=n truncate=n compress=n
> >> key=1 page=4096 replace=n
> >> fthreshold=20
> >> position=1 length=3 duplicates=n
> >> modifiable=n type=string null=n
> >> segment=n
> >>
> >> ..where ZZJ35VSA.FIL contained (these recs are fixed format and 100
> >> bytes each) ...
> >>
> >> 003ABETTSED ADEN 0071161101341121021103
> >> 006AFFLECK ARCHER
> 0454165105160861066807 >> 009BABAYARO BENTLEY
> 0872139209141101101610 >> 012BRIGHTSMITH BUCHANAN
> 1234567813110841141315 >> 015CALDERDALE CHAPPELL
> 1617177117391581181119 >> 018CONLEY CRANE
> 2015139921571280221923 >> 021DANIELS DESAILLY
> 2464195125160841260827 >>
> >> ..this was the result..
> >>
> >> E:\conrad\vs1a>zzj35bu1
> >>
> >> E:\conrad\vs1a>BUTIL -CREATE E:\CONRAD\VS1A\ZZJ35VSA.FIL
> >> E:\CONRAD\VS1A\ZZJ35BU2
> >> .TXT
> >>
> >> File Manager Version 6.15
> >> Copyright 1982 - 1995, Btrieve Technologies, Inc.
> >> All Rights Reserved.
> >>
> >> BUTIL-14: The file that caused the error is
> >> E:\CONRAD\VS1A\ZZJ35VSA.FIL.
> >> BUTIL-100: Microkernel error = 97. The data buffer is too small.
> >>
> >> BUTIL-9: The command did not complete due to an unrecoverable
> error. >> E:\conrad\vs1a>
> >>
> >> And I know this stuff is absolutely old but I have reasons!
> >> Am having trouble interpreting, finding 'data buffer' parameter
> other >> than in Trace.
> >> Any help mightily appreciated. Please, thanks.
--
|
