Process Help

INPFIL - enter a data definition and input comma separated data

 

Process Name

Menu Path

Link to Command Table

INPFIL

Data ribbon | Transfer | Text | Input new DD and CSV Data

Click here

 

Introduction

Creates a file and enters free format data into it. Free format data is separated by commas.

How to use

The data may come either from the keyboard, or from a system file external to the database.

INPFIL is the most simple and general way of defining and entering a database file.

Notes

INPFIL may be considered as a combination of INPUTD & INDATA. Records may not start with the character !. This is because the ! symbol acts as the end-of-data character. Thus macro files should not be read in with INPFIL; use INPUTC instead.

Within a macro, the Data Definition cannot be terminated by the ! character, as this will terminate the INPFIL process; instead another special purpose character (such as [) may be used.  

Files, Fields and Parameters

Input Files

Name

Description

I/O Status

Required

Type

Output Files

Name

I/O Status

Required

Type

Description

OUT

Output

Yes

Table

File to be created.

Parameters

Name

Description

Required

Default

Range

Values

PRINT

>=1 to display each record (0).

No

0

0,1

0,1

Example

!INPFIL &OUT(NEWDATA)

INPUT DATA DESCRIPTION FOR FILE newdata .
FILE DESCRIPTION  > New Assay Data <return>

SUPPLY DETAILS OF FIELDS AS FOLLOWS -
NEXT
FIELDNAME     >    BHID<return>
FIELD     1   >    BHID
---------------------
TYPE A/N(N)   > A <return>
LENGTH (1)    > 8 <return>
STORED? (Y)   >   <return>
DEFAULT       >   <return>
NEXT
FIELDNAME     > FROM <return>
FIELD     2   > FROM
---------------------
TYPE A/N(N)   >   <return>
STORED? (Y)   >   <return>
DEFAULT       >   <return>
NEXT
FIELDNAME     > TO<return>
FIELD     3   > TO
---------------------
TYPE A/N(N)   >   <return>
STORED? (Y)   >   <return>
DEFAULT       >   <return>
NEXT
FIELDNAME     > Cu<return>
FIELD     4   > Cu
---------------------
TYPE A/N(N)   >   <return>
STORED? (Y)   >   <return>
DEFAULT       >   <return>
NEXT
FIELDNAME     > ! <return>
END OF DD
CONFIRM   ?   OK  <return>

SYSFILE><return>

DATA     >BH0001,0,12,0,0<return>
DATA     >BH0001,12,14,0.5,0.1<return>
DATA     >BH0001,14,16.3,1.2,0.53<return>
DATA     >!<return>

Error and Warning Messages

Message

Description

Solution

>>>  SYSTEM FILE DOES NOT EXIST <<<

The named file does not exist. Fatal; the process is exited.

 

 

 

 

>>>  NOT A NUMBER <<<
>>>  ERR 57 <<< (numbposn) IN STRDCD

An illegal DATAMINE number has been entered. Warning; the record is ignored.