No journaling is required if you change the commit mode to Commit
Immediate (*NONE) as shown in the blog post.
-Jim
On 9/7/2011 9:06 AM, DenesL wrote:
If I remember correctly from my tests a couple of years ago, the AS400
for some reason wants to journal the files (tables) created thru ODBC.
No journal is required when reading from existing tables.
Looking at the files in my WEB2PY library I see a data area specifying
the name of the journal:
Data area . . . . . . . : QDFTJRN
Library . . . . . . . : WEB2PY
Type . . . . . . . . . : *CHAR
Length . . . . . . . . : 100
Text . . . . . . . . . :
Value
Offset *...+....1....+....2....+....3....+....4....+....5
0 'WEB2PY QDFTJRN *FILE '
50 ' '
and the journal and journal receiver files:
Object Type Library
QDFTJRNRCV *JRNRCV WEB2PY
QSQJRNRCV *JRNRCV WEB2PY
QDFTJRN *JRN WEB2PY
QSQJRN *JRN WEB2PY
QDFTJRN *DTAARA WEB2PY
Obviously your user has to be authorized to use these objects.
Hope it helps,
Denes.
On Sep 7, 7:07 am, António Ramos<[email protected]> wrote:
ProgrammingError: ('42000', '[42000] [IBM][Controlador ODBC do iSeries
Access][DB2 UDB]SQL0551 - Not authorized to object AUTH_USER in MYLIB type
*FILE. (-551) (SQLExecDirectW)')
2011/9/7 Omi Chiba<[email protected]>
How about using auth with as400 users. Is it possible?
I'm not sure about it since I'm still new for web2py but your problem
should be related to the permission just like your error says.
My library is like...
Object secured by authorization list . . . . . . . . . . . .
*NONE
Object
User Group
Authority
*PUBLIC
*CHANGE
QSECOFR
*ALL
and my user has...
Special authority . . . . . . . SPCAUT *ALLOBJ
Maybe create new library and connect with the most high authority user
might help.
On Sep 6, 4:49 pm, António Ramos<[email protected]> wrote:
Ok, seems to get someting now.
I have to change in AS400 the permissions to allow my username to create
a
table
ProgrammingError: ('42000', '[42000] [IBM][Controlador ODBC do iSeries
Access][DB2 UDB]SQL0551 - Not authorized to object **** in *N type
*USRPRF.
(-551) (SQLExecDirectW)')
How about using auth with as400 users. Is it possible?
Thank you
Em 6 de setembro de 2011 22:07, António Ramos<[email protected]
escreveu:
I tried the DAL Example and i could not connect to my AS400
does the DAL only works with db2 on windows or linux?
i have my db2 in a OS400 machine
Thank you
António
Em 6 de setembro de 2011 21:56, António Ramos<[email protected]
escreveu:
Great
i tested the example from the python shell and i connected to my
company
AS400 with success.
FANTASTIC!!!!
Tomorrow i will kick the ass of the RPG guy.
:)
2011/9/6 Massimo Di Pierro<[email protected]>
http://ochiba77.blogspot.com/2011/09/how-to-connect-db2-with-python-p...
