Hi,

I'm new to AS400 and am trying to copy the contents of a table from an
SQL Server 2000 table to a table in AS400, I'm doing this using DTS.
I'm connecting using the iSeries Access ODBC Driver.

Both the tables in both tables are identical in terms of columns and
primary keys etc.

I can copy the data from AS400 to SQL Server without any problems, but
when I try to copy it the other way (SQL Server to AS400) I get an
error. The update statement I'm using in my DTS is:

INSERT
INTO JHTEST ( PARENT, COMPNT, DESC )
VALUES ( ?, ?, ? )

But every time I click the Parse button in DTS the following error
appears:

HResult of 0X80040e14 (-2147217900) returned
Unexpected error occureed. An error result was returned without an
error message.

Is the insert statement running correct?

Does the column DESC need to be in quotes or square brackets as its a
key word as in SQL?

Also could the problem be a problem with concurrency within the AS400?

Any help or alternative to this would be much appreciated.

Thanks

Simon