Process Help

INDATA - input comma separated data using an existing data definition

 

Process Name

Menu Path

Link to Command Table

INDATA

Data ribbon | Transfer | Text | Input CSV with Existing DD

Click here

 

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 <<<
>>>  ERR 57 <<< (numbposn) IN STRDCD

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