Hi,

I have a program in Pro*c when I run it I have no problem with the output but when it runs via the at command and except the output has page breaks every 66 lines. I don't want those page breaks to be in the output.

any idea?

You're talking about running the script in sqlplus, I assume
SET PAGESIZE 0 spool myfile.lis @myscript spool off

SET PAGESIZE 0
spool myfile.lis
@myscript
spool off
        

No this is not it it's a Pro*C program it's not spool.

but thanks anyway

Sorry - you mean the "at" unix command.
Could you please display the at command you're using?

at -f $HOME/submit_test.shl now


submit_test.shl
/usr/bin/expect $HOME/test_ex.shl > $HOME/submit_test.log

test_ex.shl
spawn /app/test.shl

test.shl
$EXE_HOME/test -f -o $OUTPUT/test.lis

the last command will run the test.pc program and the output (test.lis) will have this extra page breaks if I run it directly from my folder there's no extra page breaks

Thanks

Does test.pc write to stdout? ie., does it dup2 stdout and redirect it to the -o argument? If so:

Some default tty settings insert page breaks. Check the LINES environment variable inside test.shl, also insert a stty command in test.shl. You may need to alter your environment settings in test.shl or stop duping stdout.

If you are calling fopen("filename", "w"); I have NO idea what could cause the problem.