Process Help INDATA - input comma separated data using an existing data definition |
Process Name |
Menu Path |
Link to Command Table |
INDATA |
ata ribbon | Transfer | Text | Input CSV with Existing DD |
Introduction
Enters free-format data (i.e. with the data items separated by commas) from the keyboard or from a system character file external to the database.
How to use
A data definition must already exist, and is read from file &IN.
The new file is written to &OUT. If &IN and &OUT are the same name then the new data will replace any that may exist in the old. Otherwise a new file is created, leaving the old file intact.
Files, Fields and Parameters
Input Files
Name |
Description |
I/O Status |
Required |
Type |
IN |
File containing Data Definition. |
Input |
Yes |
Table |
Output Files
Name |
I/O Status |
Required |
Type |
Description |
OUT |
Output |
Yes |
Table |
File to be created (may be same as IN; if it is, then original data in file is overwritten). |
Notes
Records may not start with the character !. This is because the ! symbol acts as the end-of-data character. However, macro files, where the command starts with !, may be read if a blank is inserted prior to the ! symbol.
Example
!INDATA &IN(INPROTO),&OUT(DATAFILE)
SYSFILE><return>
DATA >12.6,DATA1234,15,10,9,ABC,X<return>
DATA >11.2,,15,10.3,8,","<return>
DATA >11.6,DATA5678,15,18,,<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. |
|
|
|
|