Re: Rhyme nor reason

I did do a WRKACTJOBs and did a 5 on each of them, but I was looking
at the files they had open, to make sure they had the exact same file open
(which they did).

I ran a query on the file from both users, and both queries ran, but I noticed
that some of my values had +++++++++ instead of numbers in them.  Another
company had done the DDS for this file a while back, and I had thought it was
correctly, obviously it isn't.  I'm going to have to redo the DDS on this file
(and
it is a rather large one) and make sure everything is 100% correct, which it
obviously isn't.

I can understand UPDDTA not working if the DDS is mapped wrong, I just
can't figure out what makes one user be able to use it (me) and not another.

I guess it's just another one of those "interesting" things which I'll never 
know

the answer too and just fix the problem.

Thanks for all your suggestions everyone.

Regards,

Jim Langston

John Hall wrote:

> Have you tried doing a WRKACTJOB on each of these jobs and checked the
> major items ?
>
> Such as open files - make sure that each job is getting the same file.
> Call stack - is each job running the same program ?
> File Overrides
> Locks
> Job Descriptions
> etc.
>
> Have you tried a DSPOBJD in each job on the file ?
> How about DSPDTA ?
>
> Is it possible that you own a file in a library which is excluded (the
> library) from the other users so that you access one file and they
> access another?
>
> We have a rule in our shop to use when trouble shooting stuff like this
> : 'Assume it's the stupidest thing possible and go from there'
>
> boothm@earth.goddard.edu wrote:
> >
> > It sounds like the only difference is in the user name, which says to me
> > there is some sort of authority problem, and he is the owner of the file
> > and that everyone else is *EXCLUDE or something.
> >
> > That would mean that DFU is sending the wrong message, which may mean that
> > DFU is an IBM marketing tool?
> >
> > Jim, just out of curiosity, can other users do  runqry against the file?
> >
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---