Schema File only reading first column - no delim -

[jweir]

Hello,

I am trying to read a flat file using a schema file. I am able to read the first column correctly, but all other columns come back as NULL. The source file has no delimiters. What can be causing this? Below is my schema file:

Code: Select all

record
  {final_delim=end, delim=none, record_delim_string='\n', quote=none}
(
UNIQ_ID:nullable string[max=13] {null_field=''};
PRVDR_OSCAR_NUM:nullable string[max=6] {null_field=''};
BENE_HIC_NUM:nullable string[max=11] {null_field=''};
CLM_TYPE_CD:nullable string[max=2] {null_field=''};
CLM_FROM_DT:nullable string[max=10] {null_field=''};
)

Thanks in advance.

[ray.wurlod]

If there are no delimiters how do you know where one field ends and the next begins? You either have to specify a field width for each field, or specify string (Char) data type for each field, which implicitly defines the width.

Put another way, without field width or delimiter you cannot have VarChar.