Programming

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

Code:

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.

Actually the pc file is not using the fopen, just do the prtstr and the default output is the same pc file name but with .lis extention.

if we don't redirect the output the default output has no problem, so the extra page breaks occur when we do the -o and specify the output name.

I'll check the tty settings.

Thanks