I am trying to read row from a sequential file using column defn from a schema file.
The schema file has
Code: Select all
record (
account_number: decimal[4, 0];
phone_nbr: decimal[1, 0];
)
Code: Select all
1111,1
2222,2
3333,3
4444,4
1.) I am not able to view data unless and otherwise I provide the column defn.s in the column tab. Why?
2.) When I run this job (without col defn), it returns the warning message for each row, which is some like below
Why does this appear as the data matches the column requirements?Sequential_File_0,0: Field "account_number" has import error and no default value; data: {1 1 1 1 , 1}, at offset: 0
3.) How to make this job work?
Thanks in advance.