sharky7

And also, maybe you can comment if Oracle 11g or 12c will work on Pro-IV Kernel 4.6.

 

Thanks again.

 

Sonny

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

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

George,

You're a genius! I overlooked that the report is printing 175 column and the print setting is 132 column. That's the reason why the text is wrapping around. I feel stupid now.

Thanks for your help.

Sharky7

Hi

Its a long time since I worked on Unix/AIX and cannot recollect print settings in this environment.

the following are some checks I would do to narrow down the background to the problem

the first thing I would do would be to amend the SPOOL options on the report-function to output the results to a text file. I would then check the results in the text file, is it outputting 132 per line. Once you've proven the ouutput to file is OK you can then be more certain that the problem is related to the actual printers.

Outside of Pro-Iv, from the unix command line can you generate output of a text file that has 132 characters per line and prrint this output to the printer. Therefore checking that the printer can print up to 132.

I also have an AIX.pdf which has a lsecrion on on Printing, If you would like this pdf then send on your e-mail to george@peritussolutions.com and I'll forward it to you.

Rgds

George

I'll try that. Thanks!

PS Sorry guys for the multi post. Can somebody clean up? Thanks.

I'm having problems preventing a delete on a /PS/ if a condition is met. Somehow, I've tried putting a DSEL, DSELF, FLD(@FLD), etc. and nothing works.Thanks in advance.

DSEL will not work in a PS. You need to LSEXIT
and use FLD statment and @SPSEQ to return to
the paging area.

HTH.