Re: Informix Gateway with DRDA connection to V5R2 iSeries...

Hi, Can you provide more information as to what is the message text of SQLCODE -29000? The Gateway is designed such that any errors returned by DB2/iSeries are encapsulated inside Gateway SQLCODE -29000 Thanks, -Manas On 12/16/05, iSeriesDude <nowhere@nowhere.com> wrote: > > Looking for some details on what is necessary on the AS/400 side to > support Informix? We have a Unix server running Informix Gateway with DRDA > that is trying to connect to the system however we keep getting this > generic -29000 error and I can find no good documentation detailing what > needs to be done on the AS/400 side. > > Right now on the system (running V5R2) DDM is configured to require a > password, a profile and password was created and is being used to connect > to the system from the Unix box. > > Thanks, > iSeriesDude sending to informix-list

The exact error message is, -29000: Application Server error ( ie as400) -204 42704 QSQ05020 QSYS.xxxxxxxxx, COLLECTION. Thanks, iSeriesDude On Fri, 16 Dec 2005 17:08:51 -0600, Manas Dadarkar wrote: > > Hi, > Can you provide more information as to what is the message text of > SQLCODE -29000? The Gateway is designed such that any errors returned by > DB2/iSeries are encapsulated inside Gateway SQLCODE -29000 > > Thanks, > -Manas > > On 12/16/05, iSeriesDude <nowhere@nowhere.com> wrote: >> >> Looking for some details on what is necessary on the AS/400 side to >> support Informix? We have a Unix server running Informix Gateway with DRDA >> that is trying to connect to the system however we keep getting this >> generic -29000 error and I can find no good documentation detailing what >> needs to be done on the AS/400 side. >> >> Right now on the system (running V5R2) DDM is configured to require a >> password, a profile and password was created and is being used to connect >> to the system from the Unix box. >> >> Thanks, >> iSeriesDude > sending to informix-list