ca.portal.admin

ADS SQL Access Module problems

Discussion created by ca.portal.admin on Jul 6, 2006
Hello All:

Kay Rozeboom and I are having difficulty getting an ADS dialog to access
an SQL access module. I'm sure my explanation will create more
questions,
but the gist is this:

ADS dialog with embedded SQL which can be executed successfully in OCF.
Compiled the dialog, the created the access module in the same schema
indicated in ADSC Database Specifications screen.

When the dialog is executed, it always returns an SQLSTATE=42503
(42=Syntax error.... 503=Authorization failure) and SQL error
message DB00552 1 T26018 C-4M321: Missing authorization for <access-
module name>.

What we can't figure out is why?

Thanks,

Tim Gortner
State of Iowa
Department of Human Services

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: ADS SQL Access Module problems
"i am not a SQealL guy for IDMS, but the first think that jumps out at me:

is it possible that ADS is using some other auth id than what you expect?

how about granting execute on the access module to public, and see if
that helps (that would narrow it down)

if I am waaaaay of base on this, please forgive me

with all my DB2 work (v8 here we go) .. I just dont have time for
IDMS anymore ....

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: ADS SQL Access Module problems
"Access modules are securable resources (or not depending on what the SRTT
says). The signed on user executing the ADS dialog (or any other program
for that matter) requires the EXECUTE privilege on the access module and
appropriate privileges on the underlying tables.

Alan Fields
VF Corporation
Greensboro, NC
336-424-4773
Alan_Fields@vfc.com


IDMS Public Discussion Forum <IDMS-L@LISTSERV.IUASSN.COM> wrote on
07/06/2006 04:44:40 PM:
Hello All:
Kay Rozeboom and I are having difficulty getting an ADS dialog to access
an SQL access module. I'm sure my explanation will create more
questions,
but the gist is this:
ADS dialog with embedded SQL which can be executed successfully in OCF.
Compiled the dialog, the created the access module in the same schema
indicated in ADSC Database Specifications screen.
When the dialog is executed, it always returns an SQLSTATE=42503
(42=Syntax error.... 503=Authorization failure) and SQL error
message DB00552 1 T26018 C-4M321: Missing authorization for <access-
module name>.
What we can't figure out is why?
Thanks,
Tim Gortner
State of Iowa
Department of Human Services
This email is intended solely for the use of the individual(s) to whom it is addressed and may contain information that is privileged, confidential or otherwise required to be protected from disclosure. If the reader of this email is not the intended recipient, you are hereby notified that any dissemination, distribution, copying or other use of this communication or its attachments is strictly prohibited. If you have received this communication in error, please delete it as well as all copies or backups of it entirely from your email system and notify me that you received this email in error. Thank you.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Thought for the Day
"(From INFORMATIONWEEK)

Quote Of The Day:
""The most likely way for the world to be destroyed, most experts agree,
is by accident. That's where we come in; we're computer professionals.
We cause accidents."" - Nathaniel Borenstein

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
TCP/IP question
"Does the new TCP/IP functionality (R16 SP2) make it possible to call an
external web service from within IDMS?
Does it make it possible to have a web service within IDMS that can be
called from external sources?

Kay Rozeboom
State of Iowa
Information Technology Enterprise
Department of Administrative Services
Telephone: 515.281.6139 Fax: 515.281.6137
Email: Kay.Rozeboom@Iowa.Gov

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: TCP/IP question
"The TCP/IP interface by itself does not let you ""consume"" a web service
or provide a web service ""server"". You have to realise that there are a
number of protocols involved - both communication layers using TCP/IP as
the transport mechanism as well as message formatting layers. For
example - while the low level web service might consume and publish XML
- to get at the XML transaction content you need to get through the SOAP
that's wrapped around that, the ""SOAP envelope"" that's wrapped around
that and so forth. Even parsing and publishing the XML can be a
non-trivial exercise - so you just have to imagine peeling away the
other layers to get a feel for what is involved.

These would be some of the reasons why most people seem to involve a 3rd
party software vendor to help them out with this. When a 3rd party is
involved your service would most likely get an (IDD) work record as
either input/output or one record as input and another as output (a
COMMAREA in CICS terms). I believe that some of this is simpler with
facilities that are provided in CICS. We were trying to do it inside
IDMS-DC using DC-Cobol - which can parse XML, although it is more of an
art than a science. There are a variety of XML publishing tools -
including the XML functions in IDMS/SQL - which works a treat although
we don't do this in Production yet.

And that doesn't even address security which seems to keep going into
the ""too hard"" basket - as does web services in general for the moment -
although this is the long term direction based on our ""architecture"" for
the future.

HTH - happy to answer any further questions you might have about our
""proof of concept"" project for providing web services from IDMS-DC.

Cheers - Gary

Outcomes