Can the screen be cleared in RPT?

From: Steve Frampton <frampton_at_vicuna.ocunix.on.ca>
Date: 23 Dec 92 01:25:52 GMT
Message-ID: <THo8VB1w165w_at_vicuna.ocunix.on.ca>

Hi everyone:

Just 3 quick questions:

(1) I am writing an RPT where I wish to display a bunch of stuff to the
user, accept some input, etc. I would like the screen to be "pretty" and was wondering if there was some way of clearing the screen under RPT
(besides outputting 25 lines). Oh, this should be a VAX/VMS solution
(VT220/VT320 emulator).

I tried something to the effect of:

.define clrscrn a4

.define get_clrscrn_value

   select chr(27)||'[2J'
   into clrscrn
   from dual
..

.define my_proc

   .execute get_clrscrn_value
   .tell ""clrscrn
   .tell "Welcome to my report..."

..

This method certainly works under DCL, but does nothing under both SQL*Plus and RPT.

Is there an easy way to clear the screen?

(2) Is there a way to pass a variable from a DCL script to an RPT
program? If so, how?

(3) Is there a way for RPT to execute a DCL command from within the
report? If so, how?

I would appreciate any information you can provide. Please respond via e-mail to preserve bandwidth, I shall be quite happy to follow-up here with a summary.

Thanks in advance!

+--------+< Unabashed Shabba Ranks Fan! >+------+--------------------+
| Steve Frampton - frampton_at_vicuna.ocunix.on.ca | Steve Frampton     |
| I collect postcards!  If you send me one from | 501-A Princess St. |

| your area, I'll send one in return. Send to >| Kingston, Ontario | | (Don't forget both email and mailing address) | CANADA K7L 1C3 |

+-----------------------------------------------+--------------------+

Received on Wed Dec 23 1992 - 02:25:52 CET