accept l_user char PROMPT 'Enter username
(e.g. SCOTT) : '
accept l_pwd char PROMPT 'Enter
the Password
: ' HIDE
accept l_conn char PROMPT 'Enter
connect string INCLUDING @ (press [Enter] for local db): '
connect &l_user/&l_pwd&l_conn
You can create a query like;
select &p_col_1
customer_id,
&p_col_2
customer_name
from &p_table1
where &p_where1.
The &stuff are parameters in the report and you can change their
values (before they are evaluated).
For example, &p_table1 could contain "customers cust, cust_accounts
cacc, cust_term cterms".
Here are the common PCL5 Printer commands for the HP Lasetjet Printers
.
Job Control Commands
--------------------
Reset
EcE
Number of Copies Ec&l#X
1 to 999
Page Control Commands
---------------------
Paper Source
Ec&l#H 0 = prints or
ejects current page
1 = Tray 2
2 = manual feed, paper
3 = manual feed, envelope
4 = Tray 1
5 = Tray 3
6 = Envelope Feeder
7 = auto select
8 = Tray 4
10-69 = external trays
Paper Size
Ec&l#A 1 = Executive
2 = Letter
3 = Legal
25 = A5
26 = A4
45 = B5-JIS
80 = Monarch
81 = Commercial 10
90 = DL
91 = International C5
100 = B5
101 = Custom
Orientation
Ec&l#O 0 = Portrait
1 = Landscape
2 = Reverse Portrait
3 = Reverse Landscape
Top margin Ec&l#E # = number of lines
Text Lenght
Ec&l#F # = number of lines
from to margin
Font Selection
---------------
Symbol Sets
Ec(# 8U = HP Roman-8
Symbol Set
10U = IBM PC-8 ( Code page 437 )
12U = IBM PC-850 ( Code page 850 )
8 M = Math-8
19U = Windows 3.1 Latin 1
9E = Windows Latin2 ( Eastern Europe )
5T = Windows Latin5 ( Turkey )
579L = Wingdings Font
Primary Spacing Ec(s#P
0 = fixed
1 = proportional
Primary Pitch Ec(s#H # = characters/inch
Set Pitch Mode Ec&k#S
0 = 10
4 = 12 (elite)
2 = 16.5 - 16.7 (compressed)
Primary Height Ec(s#V # = points
Primary Style
Ec(s#S 0 = upright (solid)
1 = italic
4 = condensed
5 = condensed italic
Primary Stroke Wt. Ec(s#B
0 = medium (book or text)
1 = semi bold
2 = bold
3 = extra bold
Typeface
Ec(s#T Print a PCL 5e font list
to view the command for each internal
font
More detail at:
http://www.hp.com/cposupport/printers/support_doc/bpl02705.html
There is a great general technical reference at:
http://www.sxlist.com/techref/language/pcl/index.htm
On the Windows NT platform, the r25run32.exe executable is used for both postscript and ASCII text printing.
Postscript printer definition files are required only on character-mode
platforms like Unix. In a bitmap platform, like Windows NT, the SRW driver
is not used for printing postscript reports; however, the driver
is used for ASCII text reports. Some generic postscript drivers are psport.prt
for portrait, psl132.prt for landscape, and psl180.prt for landwide.