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 documentation 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.

--
Posted via a free Usenet account from http://www.teranews.com

"Graham Hobbs" <ghobbs (AT) cdpwise (DOT) net> wrote

My guess is that you are specifying a page size of 4096 and the default is
512, or perhaps that's what your page size should be. Try making that
change. If you really need a page size of 4096, then you need to specify
that page size when you start the engine.

I got this Pervasive file manager as part of a COBOL/CICS package from
IBM several years ago, not well written documentation, and since I've
been working on COBOL/CICS/DB2 (on my laptop), never really needed the
VSAM KSDS bit until now. So in the next few days I will look at what
you've said. I cant even find 'buttons' to 'stop/start' the engine!*?
and thanks.
graham
On Sat, 11 Aug 2007 15:36:37 -0400, "Frisbee®"
<billLASTNAME (AT) yahoo (DOT) com> wrote:


--
Posted via a free Usenet account from http://www.teranews.com

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 documentation 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 importing 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 supported 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 (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support 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 documentation (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 (AT) speakeasy (DOT) net> wrote:


--
Posted via a free Usenet account from http://www.teranews.com

The current version of Pervasive PSQL v9.5 IS supported 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 (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 08/28/2007 ***


Graham Hobbs wrote:



--