I'm trying to simply insert a 9 digit account id from a flat file into a table. I've set up my flat file so that it simply has one record that consists of only the a sample 9 digit account id and no other characters or blanks after the account id.
I keep getting the following error message: The length of: ACCOUNT_ID in row: 1 was greater thandefined.Defined: 9, Received: 12594
Any recommendations? Here is the code:
sessions 2; errlimit 100; logon db/user1,pwd01; set record vartext; DROP TABLE static;
CREATE TABLE static ( account_id char(9) );
set record unformatted;
define account_id (varchar(9)) file=static.input; show; begin loading static errorfiles errors_2, errors_1; insert into static ( :account_id ); end loading;