fconvert - allow a clear option
Right now, when using fconvert to unload and load files, you need to add a step to use ISLOAD to clear the file. It would be great if fconvert supported clearing an isam file or a "load with clear" option. Often, fconvert is used for quick maintenance of data where you want to re-load without creating a brand new file. If load with clear is not possible, then I would like to see an output option that would use the existing file's ipar info to create the new file.
2/14/2019 5:22 PM 0
The second option already exists in fconvert, the command below creates a new empty isam file from the ipar file definition and loads the new file with data in the .txt file.
fconvert -sv -it e:\src\UOM.txt -oif e:\c10\tg\CGS\UOM.DAT -d E:\c10\tg\CGS\UOM.PAR
2/22/2019 2:19 AM 0
My initial desire of a clear option is because in the field, often, I have to fconvert a file into a text file, edit one little piece of it and reload the file. Oops - can't reload the file without either IPARing and sending to a new file or ISLOAD->clear the file first.
While it's not a huge deal for me, I do know that every time I have to go through this, I use some "colorful" language as this would be so easy to add to fconvert - it's a simple call to isclr (or it's equivalent C routine) before loading the file.
2/22/2019 12:45 PM 0
4/10/2019 3:19 PM 1
For example, fconvert -it some_text_file.txt -aic some_isam_file.ism (where -aic is add, isam, clear before adding)
4/12/2019 9:53 AM 0
My approach isn't so much that it has to be in a single command/operation as a jointly executing option (which would be icing on the cake - I agree with Gary), but I want to be able to clear the ISAM file without having to go through ISLOAD. In any event, this is welcome progress.
4/12/2019 10:01 PM 0