I am trying to import pipe delimited records and "repmcli" seems to have
a problem with the last field being null (even though I think I have a
condition to handle it). Consider as an input file:
1|Y||01/05/1998|Y|.|0|1||12|0||Y||1||N||
It gives the following error....
Replication server error (-4 : 'protocol error')
But if I add a space (make it not null) to the last field it imports fine.
NOTE: There are other fields that are null that work just fine.
1|Y||01/05/1998|Y|.|0|1||12|0||Y||1||N| |
Here is my input file, what am I doing wrong?
SET DATE USA
DATALOAD TABLE cust_addr
cust_id 1
custa_bill_flag 2
custa_city 3 NULL IF POS 3 = ''
custa_crt_dt 4 NULL IF POS 4 = ''
custa_dir_flag 5
custa_frst_ln 6 NULL IF POS 6 = ''
custa_frt_zone 7
custa_id 8
custa_lstship_dt 9 NULL IF POS 9 = ''
custa_ph_nbr 10 NULL IF POS 10 = ''
custa_route_nbr 11
custa_scnd_ln 12 NULL IF POS 12 = ''
custa_shp_flag 13
custa_state 14 NULL IF POS 14 = ''
custa_tax_area 15
custa_tax_id 16 NULL IF POS 16 = ''
custa_tax_yn 17
custa_zip_cd 18 NULL IF POS 18 = ''
INFILE '/home/tim/conversion/y' COMPRESSED DELIMITER '' SEPARATOR '|'
Thanks.
Tim Nelson
