db2 support patch included in 1.58
db2 support tested on DB2/400 with OS V5R3.
To get auto journaling going on V5R3
using iSeries Access ODBC
with a system DSN that has
SQL default library = web2py
connected with user = test:
CRTLIB WEB2PY
CRTDTAARA DTAARA(WEB2PY/QDFTJRN) TYPE(*CHAR) LEN(100) VALUE('WEB2PY
QDFTJRN *FILE ')
CRTJRNRCV JRNRCV(WEB2PY/QDFTJRNRCV)
CRTJRN JRN(WEB2PY/QDFTJRN) JRNRCV(WEB2PY/QDFTJRNRCV)
GRTOBJAUT OBJ(WEB2PY/QDFTJRN) OBJTYPE(*JRN) USER(TEST) AUT(*ALL)
in model:
db=SQLDB('db2:DSN=dsn_name;UID=test;PWD=pass')
On V5R2 it seems to require journal QSQJRN (with receiver) also but
the results have not been consistent... still testing.
Denes.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
