469,630 Members | 1,225 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,630 developers. It's quick & easy.

AS400 and SQL DTS

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

Jun 21 '06 #1
1 4542
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
Jun 21 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by alan_sec | last post: by
13 posts views Thread by Sehboo | last post: by
1 post views Thread by Iain | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.