Re: OLEDB-ODBC-iSeries linked server. Select is fine, Create-Update-Delete do not work

Hello Dmitry,

Since the odbc driver for DB2/AS400 is provided by third party or IBM, you
may want to contact them for more information on how to configure the
options if they exist.

Also, you may want to enable journaling in AS/400 for that particular table
(physical file) for which you want to do an INSERT, UPDATE, or DELETE to
test the situation:

1. Create the journal receiver (CRTJRNRCV).
2. Create the journal (CRTJRN) by inputting the journal receiver created in
step 1.
3. Start the journal physical file (STRJRNPF) by inputting the journal and
journal receiver created in steps 1 and 2 and associating the journal to a
specific SQL table (physical file).

I appreciate your understanding on this. Thank you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

======================================================

This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================




.

Relevant Pages

  • Re: OLEDB-ODBC-iSeries linked server. Select is fine, Create-Update-Delete do not wo
    ... Since the odbc driver for DB2/AS400 is provided by third party or IBM, ... you may want to enable journaling in AS/400 for that particular ... Create the journal by inputting the journal receiver created ... Start the journal physical file by inputting the journal and ...
    (microsoft.public.sqlserver.odbc)
  • Re: Journals
    ... >library), delete all of the journal receivers, and then start journaling ... Once a journal receiver is detached and saved after detaching, ... I don't remember the various commands involved, ...
    (comp.sys.ibm.as400.misc)
  • Re: Journaling DB2 files after the fact ...
    ... Flexible SQL Journaling ... Steps to create a journal and work with journaling: ... CL-Command CRTJRNRCV ... Create Journal with the created Journal Receiver: ...
    (comp.sys.ibm.as400.misc)
Loading