hi
when i run the load script from sybase. it works perfectly fine and loads 10 rows. but when i load sybase table from unix 0 rows affected. pls let me know wats to be done.
LOAD TABLE table_acct(
ACCT_TYP_CODE ASCII(10),
ACCT_TYP_ID_CODE ASCII(3),
DESC_TEXT ASCII(60),
ACCT_UNIT_CODE ASCII(5),
UPD_DATE ASCII(8),
MIS_DATE ASCII(8)
)
from '/dir1/file1.txt'
format ascii
skip 1
row delimited by '\n'
escapes off;

the unix script i use is
isql -Ublah -Pblah -Sblah -Dblah <<EOF
> LOAD table_acct
> (
> ACCT_TYP_CODE ASCII(10),
> ACCT_TYP_ID_CODE ASCII(3),
> DESC_TEXT ASCII(60),
> ACCT_UNIT_CODE ASCII(5),
> UPD_DATE ASCII(8),
> MIS_DATE ASCII(8)
> )
> from '/dir1/file1.txt'
> format ascii
> skip 1
> row delimited by '\n'
> escapes off
> go
> EOF
(0 rows affected)