6 replies to this topic

[sharky7]

Hello everyone.

 

It's been a while since I messed with Pro-Isam files. My goal here is to purge all the records contained in this temporary file. At the same time maintain all the page sizing of the file. As you can see below, the file has grew to about 135MB. It's been years since this was purge.

 

cs_temp.pro Sep 03 20:09 3072 201326592 135853056 67        639259

 

What is the best way of doing this?

 

Thanks in advance.

 

Sonny

[Ross Bevin]

Hi Sonny,

 

What version are you on? We are on 7.1 so utility .exe's and maximum file sizes may be different.

 

1. You can iscr.exe the file with the desired page size. 7.1 has a max file size of 1.9 GB by using r-16000.

2. Write an update to delete all the records. If you want to reclaim white space use ispack.exe.

 

Regards

Ross

[sharky7]

Ross, we are on version 4.6. Yeah I know. Very old.

 

Can I just delete the file from Unix and then do iscr?

 

What are the switches/option to re-size page for iscr?

 

Hi Sonny,

 

What version are you on? We are on 7.1 so utility .exe's and maximum file sizes may be different.

 

1. You can iscr.exe the file with the desired page size. 7.1 has a max file size of 1.9 GB by using r-16000.

2. Write an update to delete all the records. If you want to reclaim white space use ispack.exe.

 

Regards

Ross

[Ross Bevin]

Hi Sonny,

 

I have a 5.5 manual but no 4.6.

 

You can try this.

 

iscr -k<key size> -r3000 <full path and file name>

 

Regards

Ross

 

PS: Take a backup first.

[Wim Soutendijk]

If I remember correctly, iscr -e will clear the file but keep the original key and record sizes

[sharky7]

I will definitely try this and will let you know.

 

Thanks Wim!

 

 

If I remember correctly, iscr -e will clear the file but keep the original key and record sizes

[DARREN]

Wim is correct in that an iscr -e (for empty) will clear the files and retain they key/page length size.

 

If you were to migrate to a higher version of PROIV then you could use memory files. They are not physical and are automatically cleaned (memory returned) when the session ends.