ISeries ODBC Error SQL0104 using DB2 UDB (Replicating Notes data to AS/400)

pts.
Tags:
AS/400
Lotus Domino
SQL
Does anyone know why I get these ODBC errors or what these errors mean while trying to replicate some fields in Notes to a db on the AS/400 Rel 5.2? Starting Replication: REP_POTEST101 03/23/2006 08:00:34 AM Replicating Documents from <LNK_PURCHREQ.NSF: test POReq> to <LNK_POComments_AS400: SUPLIB.PODTLCMT> ...... 03/23/2006 08:00:48 AM 2 Documents remaining to be processed 03/23/2006 08:00:48 AM Error: <ODBC Error> [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0104 - Token ) was not valid. Valid tokens: DAY PATH YEAR LABEL MONTH OPTION RESULT CONNECTION TRANSACTION.; 03/23/2006 08:00:48 AM Error: Error on this Statement: INSERT INTO SUPLIB.PODTLCMT () VALUES) 03/23/2006 08:00:48 AM Error: Error occurred while inserting/updating the document to external data source 03/23/2006 08:00:48 AM Error: Replication to Link <LNK_POComments_AS400> did not complete 03/23/2006 08:00:49 AM End of Replication: REP_POTEST101

Answer Wiki

Thanks. We'll let you know when a new response is added.

Check your Notes setup for replication.

Error on this Statement: INSERT INTO SUPLIB.PODTLCMT () VALUES)

The statement in error has to many “)”. The SQL statement is invalid, and this is causing the replication failure.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Geneburns
    This link is to the SQL Message Finder. Messages that start with SQL are from the SQLCODE. You can also check SQLSTATE at this site. http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/db2/rbafzmst71.htm
    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following