What I did (still doing) is any IBMi access needed by the MS SQL side is to create a Stored Procedure to return a data set.
The MS SQL side does not necessarily know the best way to get and splice the data they want together.
The SP use SQL and/or RPG to put together the results they need.
It's ALMOST always runs faster using the SP.
Some of their methods were like pounding a square peg through a round hole using a chicken.
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Welly@OCBCNISP
Sent: Wednesday, December 21, 2016 11:36 PM
To: MIDRANGE-L@xxxxxxxxxxxx
Subject: Object Authority for SQL Use
Hello All,
Need advice
Our developer are building application using SQL on Windows that accessing some PF on iseries, we already giving *USE (GRTOBJAUT) for that PF but when the SQL run, it says that it don't have the authority to access the host resources.. Also when I check using QSYS2.SQL_CHECK_AUTHORiTY some of the files status is 0
Can any body give clue where shouls I set the authority?
Thanks for your help
Br,
Welly Soegiantoro
EST Division
cug : 367090
--
Disclaimer :
Confidential information may be contained in this message.
If you are not the intended recipient, you are strictly prohibited and may be unlawful to use, copy, store, distribute, disclose or communicate any part of it to others and you are obliged to return it immediately to sender or notify us and delete the e-mail and any attachments from your system. Opinions, conclusions and other information in this e-mail that do not relate to the official business of any PT Bank OCBC NISP Tbk shall be understood as neither given nor endorsed by it. No assumption of responsibility or liability whatsoever is undertaken by PT Bank OCBC NISP Tbk in respect of prohibited and unauthorised use by any other person.
--
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.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
Subject to Change Notice:
WalzCraft reserves the right to improve designs, and to change specifications without notice.
Confidentiality Notice:
This message and any attachments may contain confidential and privileged information that is protected by law. The information contained herein is transmitted for the sole use of the intended recipient(s) and should "only" pertain to "WalzCraft" company matters. If you are not the intended recipient or designated agent of the recipient of such information, you are hereby notified that any use, dissemination, copying or retention of this email or the information contained herein is strictly prohibited and may subject you to penalties under federal and/or state law. If you received this email in error, please notify the sender immediately and permanently delete this email. Thank You;
WalzCraft PO Box 1748 La Crosse, WI. 54602-1748
www.walzcraft.com Phone... 608-781-6355
midrange.com
