AS400 and SQL DTS

[accyboy1981]

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

[Larry]

accyboy1981 wrote:

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

This sounds like a question for Microsoft. You need to find out whether
DTS has capabilities to provide seamless access to the AS/400 or not. I
suspect it doesn't. If it's using ODBC or one of the Microsoft APIs, you
can use IBM's DB2 Connect to access DB2 on the AS/400.

Larry Edelstein