Hi Rob and Jonathan Wilson...
Thanks a lot for you help
The problem is closed now... and it's just a security problem :(
They did not tell me about their working directory (schema and Package
Collection), so when I give *use to the schema(library) it working fine
So here is the summary of what I have been done
1. Give proper authority to the object the access
- *Use for all the PF
- *USE for the LF (don't forget to give *use to the PF of that LF too)
- Go to STRSQL and then Grant Select to all that PF
=> GRANT SELECT ON 'object' TO 'user'
2. Check the Collection package and Schema setting, give proper authority
for that Schema(Library).
Sorry for the trouble...
Many many thanks for the help and attention
Thanks for your help
Br,
Welly Soegiantoro
EST Division
cug : 367090
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rob
Berendt
Sent: Selasa, 27 Desember 2016 19.32
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: SQL package MSNC001 in 'USER' not found at DRDA Server.
I used a utility to scan message files for "SQL package"
SCNMSGF FILE(QSQLMSG)
The one at the top of the list was
Message Sev Text
SQL0805 30 SQL package &1 in &2 not found at DRDA Server.
DSPMSGD RANGE(SQL0805) MSGF(QSQLMSG)
The text provided with this message seems to assume you are receiving the
message on the IBM i in talking to itself, or to another platform.
However, much of it is very applicable. Suggest you look at that DSPMSGD
command. See if you agree with my interpretation. It might possibly be one
of the following:
- It is trying to build an SQL package on the fly but the remote request
does not have the security to add an *SQLPKG object to that library.
I forget my other possibilities...
This may not be a definitive answer but it may help point you in a
direction.
Other than the above I've found no hard and fast answers. They're all a
little vague, or product specific.
http://www-01.ibm.com/support/docview.wss?uid=nas8N1017528
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail
to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
From: Jonathan Wilson <piercing_male@xxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 12/23/2016 08:56 AM
Subject: Re: SQL package MSNC001 in 'USER' not found at DRDA
Server.
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
On Fri, 2016-12-23 at 11:31 +0700, Welly@OCBCNISP wrote:
HI All,
Got a new problem with this SQL thing
User create SQL and run it from WinServer, but when it run it give error
on
Joblog
==> SQL package MSNC001 in 'USER' not found at DRDA Server.
The only references I can find are similar to this:
https://msdn.microsoft.com/en-us/library/ee252427%28v=bts.10%29.aspx
My guess is its again down to authorisations... there is a mention near
the bottom of the page about needing specific autl levels to the
"collection" which is the "library" and what they should be set as.
Any clue or step to solve this?
Please help
Thanks for your help
Br,
Welly Soegiantoro
EST Division
cug : 367090
midrange.com
