AS/400 connection error

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
edward_m
Charter Member
Charter Member
Posts: 257
Joined: Fri Jun 24, 2005 9:34 am
Location: Philadelphia,PA

AS/400 connection error

Post by edward_m »

All,

DS Admin created catalog DB for AS/400 on Datastage server to connect to AS/400.When i try to connect as/400 using the above DSN, i am getting the following error
DSR.MetaGeta(GET.TABLES)(SQLConnect('MHSDB','MQBAWEB')): BCI Error:
SQLSTATE=58008,CODE=-30000,[DataStage][SQL Client][ODBC][IBM][CLI Driver] SQL30000N Execution failed because of a Distributed Protocol Error that will not affect the successful execution of subsequent commands or SQL statements: Reason Code "0x1254"("02F1"). SQLSTATE=58008
Could anybody guide me ho eto correct the above error.

Thanks..
NBALA
Participant
Posts: 48
Joined: Tue Jul 11, 2006 11:52 am
Location: IL, USA

Re: AS/400 connection error

Post by NBALA »

Hi,

Check this fix.

[url]http://www-912.ibm.com/a_dir/as4ptf.nsf ... enDocument[/url]

I am not sure, this may be the cause. I hope its not because of DS Server

-NB
Post Reply