× 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.



I cannot get this simple webservice to work. I need the help of the guru's
on this one puh leez.

The details are below.

There are no input parameters but there is one output parameter.

When I call the service, it does not appear to be calling the service
correctly. I do get the JSON message below.

The service is call as follows:

*http://my_system:10010/web/service/isGateOpen
<http://my_system:10010/web/service/isGateOpen>*


Can someone help with what's not right?

TIA, Darryl Freinkel.

URI path template: = /

Secure transport required: = No

Protect using authentication method: = *NONE

Database system: = localhost

Default schema: = qsys2

Naming convention: = *SQL

Library list: = *LIBL

Procedure name = isGateOpen

SQL statement/Parameter name = select data_area_value from
table(qsys2.data_area_info(DATA_AREA_LIBRARY => 'THE_LIBRARY',
DATA_AREA_NAME => 'THE_DATA_AREA'))

Usage = No options to enter any values.

Data Type = No options to enter any values.

SQL result type: = Single-row result set

Trim mode for output fields = None

SQL state information in response: = On errors

User-defined error message: = Invalid request for iSGateOpen.

HTTP status code on SQL success: = 200

HTTP status code on SQL failure: = 500

Procedure name: = isGateOpen

URI path template for resource: = /

HTTP request method: GET

URI path template for method: *NONE

HTTP header information: = *NONE

Allowed input media types: = *ALL

Returned output media types: = JSON

Identifier for input wrapper element: = isGateOpenInput

Identifier for output wrapper element: = isGateOpenResult

Use existing ID = entered the user ID




This is what was returned in the JSON:


{

"SQLStateInfo": {

"rowsAffectedCounts": null,

"SQLError": null,

"SQLWarnings": [

{

"SQLState": "HY001",

"SQLCode": 1301,

"message": "Invalid request for iSGateOpen."

}

]

}

}

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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.