Excel VBA read DB2/400 *without* journaling

R

Roland Biemans

Hi all,

I've created some VBA script to read with recordlevel access some DB2/400
logical files.
I don't use SQL statemens but use OpenIndex and GetBookmark method.
OLEDB provider = IBMDA400
I connect to the box *without* DSN , all connect stuf should be in the VBA

My little proggie works when reading files on the 400 with journal / journal
receiver.

I want to access the file wihout having to create the journal / receivers
since this will only cost diskspace and performance, and useless as I dont
do updates (yet)

I've been playing around with :

cn.IsolationLevel adXactChaos
and
cm.CommandText = "LIB/FILE (*FIRST, *NONE)"

But I keep error messages like :

Error -2147467259 (80005005) while executing:

CPF4328 : section SLP05 not in journal *N

(I'm not sure if this is the exact translation , original message was in
Dutch and I don't want to bother you guys with thath :) )


Can someone try to help me find the light ??

Best regards,

Roland Biemans
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top