Process Help

FILCOM - convert constant explicit fields into implicit fields

 

Process Name

Menu Path

Link to Command Table

FILCOM

Data ribbon | Data Tools | Tables | Make Fields Implicit

Click here

 

Introduction

Copies any file within the database from the input file to the output file, but compressing the file by turning all those fields with a constant value throughout the file into implicit fields.

How to use

This is of particular use for simple text files - e.g. those established by the INPUTC process - where the alphanumeric field may have been defined in the Data Definition as 80 characters long, but the longest record is only 20 characters. In such alphanumeric fields, compression will be in multiples of 4 characters.


Files, Fields and Parameters

Input Files

Name

Description

I/O Status

Required

Type

IN

Input file.

Input

Yes

Undefined

Output Files

Name

I/O Status

Required

Type

Description

OUT

Output

Yes

Undefined

Output file.


Notes

Retrieval criteria are ignored by this process.


Example

!FILCOM    &IN(FILE1),&OUT(COMFILE1)


Error and Warning Messages

Message

Description

Solution