Git Product home page Git Product logo

ibmixmlservicestd's Introduction

IbmiXmlserviceStd

There is a SSH-enabled version of the library commercially available named: IbmiXmlserviceStdSsh. You can visit http://www.mobigogo.net or reach out via email to [email protected] for more info. Documentation can be reviewed here: http://mobigogo.net/files/docs/IbmiXmlserviceStdSsh

IBM i C# and VB.Net XMLSERVICE Data Access Service Wrapper for .Net and .Net Core

This class is used to interface with existing IBM i database, program calls, CL commands, service programs and data queues via the XMLSERVICE service program. It also needs an Apache instance hooked up for XMLCGI calls since this class uses the HTTP interface.

Return data is returned in a usable .Net DataTable format or you can process the raw XML responses yourself.

This class should work with V5R4 and above of the OS400/IBM i operating system running XMLSERVICE.

Requirement: The XMLSERVICE library must also exist and be compiled on the system, including the XMLCGI program. Apache instance must also be set up and running and configured for XMLCGI calls.

Note: For appropriate security you should configure your Apache instance for SSL and for user Authentication. This way all traffic is secured and there is an extra User/Password layer. To enable HTTP authentication use the UseHttpCredentials parameter and set it to True on the SetHttpUserInfo method.

You can always refer to the Yips site for more install info on XMLSERVICE: http://yips.idevcloud.com/wiki/index.php/xmlservice/xmlserviceinstall

Class has been tested with XML Tookit library (XMLSERVICE) V1.9.7.

There is a Nuget package available to install the DLL in to a new .Net 4.6.1+ or .Net Core 2.0.0+ application.

IBM i Multi-platform Xmlservice .Net Wrapper for Dotnet Standard Nuget Site Link https://www.nuget.org/packages/IbmiXmlserviceStd

XMLSERVICE is now typically packaged on the IBMi in library: QXMLSERV as part of the operating system, but if you want to play with the code, here's the current Github location as of 1/23/2019

https://github.com/IBM/xmlservice

Note: 5/12/2019 - When working with the source, make sure to work with the C# code in: IbmiXmlserviceStdCs. The VB code in IbmiXmlserviceStd will not be maintained going forward.

ibmixmlservicestd's People

Contributors

richardschoen avatar

Stargazers

 avatar  avatar  avatar

Watchers

 avatar  avatar  avatar

ibmixmlservicestd's Issues

Ampersands in column data is causing errors.

I'm extremely new to both IbmiXmlserviecStd and XMLService, we have some data in various columns which contain ampersands (e.g. business names, etc). How do I turn on the cdata option for XMLService? I checked in SetUserInfoExt and other places but didn't see any property where I could turn on cdata for the XMLService on the server to return results with cdata. If there is not a way to turn it on using IbmiXmlserviceStd is there some other way to turn cdata on in XMLService? If so, how?

Thanks!

Enhancement request: SSH transport

SSH provides a new, platform-agnistoc way to talk to XMLService. An SSH transport has already been added to the python itoolkit: https://github.com/IBM/python-itoolkit/blob/master/src/itoolkit/transport/ssh.py

And v1.x of the Node.js itoolkit: https://github.com/IBM/nodejs-itoolkit/blob/v1.0-dev/lib/transports/sshTransport.js

This would require itoolkit-utils to be installed to provide the xmlservice-cli command that is used. Communication to xmlxervice can be simply done through stdin/stdout access of the xmlservice-cli process (see the source code for the other toolkits for examples).

Thank you for consideration!

How do we execute a stored procedure and receive one or more result sets?

I had updated to the latest IbmiXmlserviceStd (v1.1.1) via nuget but was unable to figure out how to call a stored procedure that returns one or more result sets. A little later I figured out that IbmiXmlserviceStd 1.1.1 on nuget isn't the latest and that 1.1.2 here on github actually contains the ability to call stored procedures. I pulled down the source for 1.1.2, compiled it and was able to call a stored procedure that returned a result set.

I'd like to know if IbmXmlserviceStd is able to read multiple result sets returned by a stored procedure. Do you have any examples of how to read multiple result sets returned from a stored procedure using IbmiXmlserviceStd?

Thank you, in advance!

p.s. I'm very impressed with IbmiXmlserviceStd.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.