![](https://secure.gravatar.com/avatar/cd73614d2de783dec4dd6baae479cb0c.jpg?s=120&d=mm&r=g)
28 Nov
2007
28 Nov
'07
9:45 p.m.
Whoops forgot one bit of the error....
Is there a sample tbl file somewhere? When I run the command I get the following:
copy 5 records into vendor_dim from '/tmp/vendor.csv' using delimiters '|', '|\n';
!SQLException:sql:decimal wrong format ....contents of file like the following... !2456|'2456'|'FOO BAR CAFE'||'875 CENTER STREET RM'|'NY'|'NY'|' 96813'||||2456|2004-08-18||2004-08-19 !SQLException:importTable:failed to import table