First, you need to specify line breaks so the program knows when to start a new line on each label. Address labels contain the name, street, city, state, and zip code. Name, street, and city are on separate lines. City, state, and zip code are on one line. The label program recognizes the asterisk (*) as the line break symbol. To produce the desired labels the transaction must include a line break character (*) every place that you want to start a new line. Therefore, you must define several fields to hold the asterisk, and use the CALC command to assign (*) to each field.
To define a field in Super Natural, move the cursor to any blank line on the worksheet, type a new field name, and press Enter. You can choose any name for the field. For simplicity in this example, we'll use AST1. Set the format to Alphanumeric, and the length to 1:
10:18 ***** SUPER NATURAL ***** 96-11-13
SNLABEL - Worksheet - SN3011
Ref DB Field Name ****************** Define User Field ******************
DQ _______________ * Field: AST1 *
DR _______________ * *
DS _______________ * Name or value .. AST1____________________________ *
DT _______________ * Format ......... a *
DU _______________ * Length ......... 1__ *
DV _______________ * Dec. places .... _ *
DW _______________ * Subfield of .... ________________________________ *
DX _______________ * Offset ......... ___ *
DY _______________ * Dynamic input .. _ *
DZ _______________ * *
EA ast1___________ *******************************************************
EB ________________________________ ___ ___ __ __ __ __
EC ________________________________ ___ ___ __ __ __ __
ED ________________________________ ___ ___ __ __ __ __
Command ===>
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Exit Flip Canc
Repeat the field definition process for 2 more fields. Name subsequent fields AST2 and AST3 and define each with a format of A and length of 1. The resulting Worksheet will look something like this.
10:26 ***** SUPER NATURAL ***** 96-11-13
SNLABEL - Worksheet - SN3011
More: -
Ref DB Field Name Seq S/C Func Def Info Del
DQ U AST1 ........................... ___ ___ __ __ __ __
DR U AST2 ........................... ___ ___ __ __ __ __
DS U AST3 ........................... ___ ___ __ __ __ __
DT ________________________________ ___ ___ __ __ __ __
DU ________________________________ ___ ___ __ __ __ __
DV ________________________________ ___ ___ __ __ __ __
DW ________________________________ ___ ___ __ __ __ __
Command ===> CALC
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Next Exit Field Incl Flip - + Sel Run Canc
You may enter all assignment statements on one line as shown below. Now each new line break field has been assigned the value of '*'.
10:32 ***** SUPER NATURAL ***** 96-11-13
SNLABEL - Calculation Editor - SNZUL-C
1 < ADR-TYPE='LPN' > 1
2 < AST1 = '*' AST2 = '*' AST3 = '*' > 2
3 < > 3
4 < > 4
5 < > 5
To produce address labels, you extract data from the mainframe database to a mainframe workfile. In Super Natural, you must change the MODE of the Super Natural transaction to extract data. The command to change modes is MODES:
Command ===> MODES
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Next Exit Field Incl Flip - + Sel Run Canc
The following window appears:
**** Transaction Modes Reporting *****
* *
* Data Selection .. F Full-screen *
* *
* Data Change ..... N None *
* *
* Report Type ..... L List *
* Report Level .... D Detailed *
* *
* Destination ..... W Work file *
* *
* Run Mode ........ O Online *
* *
* Batch printer ... 1 (0 - 31) *
* RJE available ... Y (Y/N) *
* *
**************************************
Set the Destination to W, the RUN Mode to O for online, and the Batch Printer number to 1, if it is not already set, to create a mainframe workfile for address labels. Press Enter after these changes have been made to return to the Worksheet.
Number the fields you want to extract in the Seq column. Insert an AST field after the name and street lines to indicate you want line breaks in your labels at those points.
11:07 ***** SUPER NATURAL ***** 96-11-13
SNLABEL - Worksheet - SN3011
More: +
Ref DB Field Name Seq S/C Func Def Info Del
AC 1S TERM-COLLEGE ................... ___ ___ __ __ __ __
AI 1 2 RT010-SID ...................... ___ ___ __ __ __ __
DE LK 3 AA-SID ......................... ___ ___ __ __ __ __
DF L 3 AA-ST-FULL-NAME ................ 1__ ___ __ __ __ __
DG U ADR-TYPE ....................... ___ ___ __ __ __ __
DH U STREET1 ........................ 3__ ___ __ __ __ __
DI U STREET2 ........................ 5__ ___ __ __ __ __
DJ U CITY ........................... 7__ ___ __ __ __ __
DK U STATE .......................... 8__ ___ __ __ __ __
DL U ZIP ............................ 9__ ___ __ __ __ __
DM U COUNTRY ........................ ___ ___ __ __ __ __
DN U PHONE .......................... ___ ___ __ __ __ __
DO U ADR-TYPE-RETURNED .............. ___ ___ __ __ __ __
DP U AST1 ........................... 2__ ___ __ __ __ __
SNLABEL - Worksheet - SN3011
More: -
Ref DB Field Name Seq S/C Func Def Info Del
DQ U AST2 ........................... 4__ ___ __ __ __ __
DR U AST3 ........................... 6__ ___ __ __ __ __
DT ________________________________ ___ ___ __ __ __ __
Save the transaction at this point. You will run the transaction from the Super Natural Additional Functions screen. When you save the transaction the following window appears. Press Enter when you see this message to continue to save your transaction.
***** Work-/PC File Information *****
* *
* Destination ......... W *
* Output Record Size .. 130 *
* *
* _ Continue *
* _ Write Headers and Continue *
* _ Modify Transaction *
* *
*************************************
11/13/96 LABELS REQUEST 11:13
TRANSACTION OR PROTOTYPE? _ (t or p) Name: _______
Label Request Description (optional) ______________________________
______________________________
Label Type: _ 1 for P35 1-up Number of Copies: 1
3 for P35 3-up
4 for Cheshire labels
OPTIONS: leave fields blank unless selecting option
1. Adjust Name Option for FIRST-NAME first: _ Name Label Line #: 1
Name stored as LAST, FIRST MIDDLE, enter C
Name stored as LAST FIRST MIDDLE, enter B
2. Subset of labels; Specify number desired: _____
OR specify distribution: 1 of every _____ (supply a number)
3. Output format: 0 0=labels only, 1=both, 2=list only
PRESS TO SUBMIT LABELS JOB.
SYSSN:ASLBSUB PF6-Help PF9-Menu PF10-Exit
1. TRANSACTION OR PROTOTYPE:
Type a T if your label program is a Super Natural Transaction.
Type a P if your label program is a Super Natural Prototype.
2. Name:
Enter the name of your transaction or prototype. If the name you type does not exist in your Super Natural Library an error message will appear at the bottom of the screen after you press Enter.
3. Label Request Description (optional):
You may enter 60 characters of description to help you identify this particular label job. The description will appear in the JCL for the job and on the label alignment pages.
4. Label Type:
The choices are 1 label per line (1-up), 3 labels per line (3-up) or 4 labels per line (Cheshire). One-up and 3-up are gummed labels. Cheshire labels are printed on stock computer paper and must be applied with glue to the envelopes. Type 1, 3, or 4 in this field to select the type of labels you desire.
5. Number of Copies:
Enter the number of sets of labels you desire. The default is 1 set.
6. Adjust Name Option for FIRST-NAME first:
Names are stored in SIS as Last, First Middle. This option will change the format of the name field to First Middle Last. If you are using the name field from the SIS file, type C in this field. If you are using the name from the Personel file, type B in this field.
7. Name Label Line #:
If the name on your label is on a line other than the first, change this field to indicate which label line the name will be on. For example, some labels include SSN or Major on line 1 and the name on line 2. In that case, you should change this field to 2.
8. Subset of Labels. Specify number desired:
This field is used for surveys where only a portion of the selected group will receive the mailing. The first xx labels will be printed if you specify a number (xx) in this field.
9. Or specify distribution: 1 of every _____ (supply a number)
This field is used for surveys where a sampling of the selected group will receive the mailing. If you enter a number, for example, 10, the program will print 1 of every 10 labels from the group selected by your transaction.
10. Output Format:
This field gives you the option to receive labels only, a list only in label format printed on 8 1/2 X 11 paper, or labels and a list. It is recommended to test your label program with the list only option to save label paper. Type 0 to get labels only, 1 to get a list and labels, or 2 to get a list only.
When all fields have been entered or skipped, press Enter. Check the bottom of the screen for error messages and fix any errors. You will receive the message, JOB SUBMITTED when the process is completed successfully.
Your label job will run in batch and your labels or list will be delivered through a campus delivery service at the earliest opportunity. The label program requires a minimum of 25 labels or it will not print.