Hello,
I'm using SCO 5.0.5, pro4 ver 4.5.32
I've got to add some fields to a C-ISAM file. [THe file has Alternate Indexes].
In the past I've
1-made a new file def. using @CFIL.
2-insert the new fields.
3-rename the indexes for new def.
4-create the new c-isam file
5-then copy the data from the old file to the new.
Is that the only way to add fields to a c-isam file?
Rob
Click the link below to see the new game I'm developing!
C-ISAM, adding fields
Started by
Rob Fantini
, Oct 26 1999 02:48 PM
6 replies to this topic
#2
Rob Donovan
-
- Admin
-
- 1,652 posts
rob@proivrc.com
- Gender:Male
- Location:Spain
Posted 26 October 1999 - 02:50 PM
Hi,
Yep, I'm afraid so!!!!
Rob
Yep, I'm afraid so!!!!
Rob
#4
Mike Schoen
-
- Members
-
- 198 posts
Expert
- Gender:Male
- Location:Guelph, Canada
Posted 26 October 1999 - 07:06 PM
The other option, which we have used, is to leave some spare
fields, ie a few numeric spares and some alpha spares.
Then you can still add some new numerics, and chop up
the alpha spare into pieces.
You do have to watch the record size to make sure you don't
change it, and it does use up space in the file.
(It would be nice if varialble length c-isam was available for
us, but Pro-IV never replies to my requests about how
it works)
Mike
fields, ie a few numeric spares and some alpha spares.
Then you can still add some new numerics, and chop up
the alpha spare into pieces.
You do have to watch the record size to make sure you don't
change it, and it does use up space in the file.
(It would be nice if varialble length c-isam was available for
us, but Pro-IV never replies to my requests about how
it works)
Mike
#5
Rob Donovan
-
- Admin
-
- 1,652 posts
rob@proivrc.com
- Gender:Male
- Location:Spain
Posted 26 October 1999 - 09:00 PM
Mike,
To use variable length CISAM records you have to buy
a new licence from PRO-IV ltd.
Rob
To use variable length CISAM records you have to buy
a new licence from PRO-IV ltd.
Rob
#7
Rob Fantini
-
- Members
-
- 291 posts
ProIV Guru
- Gender:Male
- Location:Haverhill, United States
Posted 26 October 1999 - 09:37 PM
Check 'iscr'. Since sometime around 4.520 there was an '-l' flag added:
iscr -------- PRO-IV ® Create/Clear selected database file(s).
Copyright © 1994, MDIS McDonnell Information Systems.
All rights reserved. Unauthorised use strictly prohibited.
PRO-IV Version : 4.0000 Revision: 5.3.2
usage; iscr [-n] [-k] [-r] [-e] [-f] [-l] file(s)
-l;
Create variable length file(s) if filetype is C-ISAM.
I've been able to create variable len c-isam files. But I've not been able to figure out how to do so and have alternate indexes.
Some of the other 'is' utilities have variable legnth c-isam flags..
I've ask pro4 tech support about their use but have not gotten an answer despite asking many times and ways.
iscr -------- PRO-IV ® Create/Clear selected database file(s).
Copyright © 1994, MDIS McDonnell Information Systems.
All rights reserved. Unauthorised use strictly prohibited.
PRO-IV Version : 4.0000 Revision: 5.3.2
usage; iscr [-n] [-k
-l;
Create variable length file(s) if filetype is C-ISAM.
I've been able to create variable len c-isam files. But I've not been able to figure out how to do so and have alternate indexes.
Some of the other 'is' utilities have variable legnth c-isam flags..
I've ask pro4 tech support about their use but have not gotten an answer despite asking many times and ways.
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
Click the link below to see the new game I'm developing!
