Populating table through csv file.

[ravi_gupta2u]

Part of code :
define tem-table t-acct like acct.
input stream s-in from a.csv.
repeat transaction:
create t-acct.
import stream s-in delimiter <tab> t-acct except migCreateDate migExtractDate no-error.
--
--
end.

I understand that the program will read a line and will updalod line data into t-acct table but it will exclude the fields migCreateDate and migExtractDate.

My query here is that how will this code map these date fieldsin csv file and table fields acct.migCreateDate and
acct.migExtractDate?
Please let me know on same.
Thanks in advance.

 

[TomBascom]

First of all it is either not a CSV file or you are specifying the wrong delimiter in the IMPORT statement.

Assuming that it is really a tab delimited file the mapping is simply the field order as they are defined in the temp-table definition. The first field in the temp-table is the first field that IMPORT imports etc.