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...
