Reference: |
Text fields can be propagated to HOLD and SAVE files that have the following formats: ALPHA, WP, and FOCUS or XFOCUS. However, although a Master File is generated for format ALPHA, you cannot issue a TABLE request against a HOLD file of format ALPHA that contains text fields.
The following rules apply to missing data for text fields in HOLD and SAVE files:
See Handling Records With Missing Field Values.
In environments that support FIXFORM, due to limitations in the use of text fields with FIXFORM, the following restriction applies:
When HOLD files are read using FIXFORM, the interpretation of missing text depends on whether the field's designation is MISSING=ON in the Master File, conditional ©) in the FIXFORM format description, or some combination of the two.
The following request extracts data to a HOLD file named CRSEHOLD:
TABLE FILE COURSE PRINT COURSECODE DESCRIPTN1 ON TABLE HOLD AS CRSEHOLD END
The following request prints the data from the HOLD file:
TABLE FILE CRSEHOLD PRINT * END
The partial output is:
COURSECODE | DESCRIPTN1 |
AMA130 | FOR PROJECT LEADERS AND SYS ANALYSTS. |
AMA680 | FOR INDUSTRIAL MARKETERS. |
AMA800 | FOR MANAGERS AND HUMAN RESOURCE STAFF. |
BIT420 | FOR SENIOR MANAGERS. ANALYZE AND IMPROVE |
BIT640 | FOR ADMINISTRATOR OF LABOR CONTRACTS. |
BIT650 | FOR PROGRAMMERS, PROJECT LEADERS AND |
EDP090 | FOR PRODUCTION MANAGERS. TO DELEGATE AND |
EDP130 | FOR PROGRAMMERS, PROJECT LEADERS AND |
EDP390 | FOR MANAGERS. HELP APPLY MANAGERIAL |
EDP690 | FOR EXEC MANAGERS AND MKTG RESEARCH |
EDP750 | FOR MARKETING MANAGERS. ENABLE TO |
MC230 | FOR PROGRAMMERS, PROJECT LEADERS AND |
MC90 | FOR VICE PRES OF SALES AND MARKETING. |
NAMA40 | FOR MARKETING VICE PRES AND MANAGERS. |
NAMA730 | FOR MANAGERS OF SALESPEOPLE. TO ENHANCE |
NAMA930 | FOR FINANCIAL MANAGERS. EXPLORE CONCEPTS |
PDR330 | FOR EXECUTIVE SECRETARIES. TO KNOW THE |
PDR740 | FOR EXPERIENCED MARKETING MANAGERS. HELP |
PDR870 | FOR DESIGNERS AND TRAINING COORDINATORS. |
PU168 | FOR MARKETING, PRODUCT, ADVERTISING |
PU440 | FOR GENERAL MANAGERS. TO EXPLORE |
SFC280 . . . | FOR MANAGERS AND SECRETARIES. HELP |
WebFOCUS |