× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Change the job to LOG(4 00 *SECLVL).

To make it "permanent" ( do remember to change it back unless you really
like using storage for spool files) change the job description QDFTSVR in
QGPL to the same log level.

--
Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mark
Walter
Sent: Thursday, July 30, 2015 8:33 AM
To: Midrange Systems Technical Discussion
Subject: RE: Calling a stored procedure from a VB6 program using the DB2
database driver

He's not sure how to do that. Can you be more specific.

Thanks,

Mark Walter

Business to Business Data Integration Specialist Certified IBM System i
Specialist Paragon Consulting Services, Inc.
mwalter@xxxxxxxxxxxxxxx
717-764-7909 ext. 20


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Gary
Thompson
Sent: Thursday, July 30, 2015 9:22 AM
To: Midrange Systems Technical Discussion
Subject: RE: Calling a stored procedure from a VB6 program using the DB2
database driver

Mark,

If you can identify the QRWTSRVR job servicing the request, then I think a
"verbose" log of that job would have the details of the object(s) to which
"you" don't have access (running without *allobj).

Your admin should be able to set your job up so the job will produce a
"verbose" log, which means you should see a very detailed list of all errors
and system messages produced by the iSeries server, and get a list of any
objects to which you do not have access.

I'm not sure, but the change to get a verbose job log may require a
"shotgun" effort because I don't know that your admin can know in advance
which of the QRWTSRVR jobs will handle your particular request. If I
remember
these are subsystem "pre-start" jobs and it's kind of a first come/first
served resource assignment process . . .

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mark
Walter
Sent: Thursday, July 30, 2015 6:47 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Calling a stored procedure from a VB6 program using the DB2
database driver

Hello all,

I have a stored procedure on an iSeries that I created. I'm trying to fire
that SP from a VB6 program (Don't ask), using the Microsoft OLE DB Provider
for DB2. When I log into the application using my user id, I'm getting an
error that I don't have authority to "something". The message is not very
clear as to what I don't have access. I know I have authority to the program
behind the procedure. I'm the owner and it has *public *all. I'm thinking
it's one of the underlying programs or files that tells the iSeries how to
convert a SP to a program, for lack of a better explanation.

I can find the QRWTSRVR job that is servicing the request. When the admin
gives me *allobj authority (I'm a consultant here), the procedure works fine
and I can see the results of the job in the joblog of the QRWTSRVR job. But,
that joblog gives me no clue as to what I don't have access.

Any ideas on how I can lock this down?

Thanks,

Mark Walter

Business to Business Data Integration Specialist Certified IBM System i
Specialist Paragon Consulting Services, Inc.
mwalter@xxxxxxxxxxxxxxx<mailto:mwalter@xxxxxxxxxxxxxxx>
717-764-7909 ext. 20

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.


-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2015.0.6081 / Virus Database: 4392/10331 - Release Date: 07/29/15
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.