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 |
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 |
|
>=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 <<< |
An illegal DATAMINE number has been entered. Warning; the record is ignored. |
|
|
|
|