Using Text Fields in Output Files

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.


Top of page

x
Reference: Rules for Text Fields in Output Files

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.



Example: Applying Text Field Rules in HOLD Files

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