Comments (2)
kadler
commented on May 30, 2024
Original comment by Aaron Bartell (Bitbucket: aaronbartell, GitHub: aaronbartell).
Works perfect! Closing issue.
from xmlservice.
kadler
commented on May 30, 2024
Original comment by Tony Cairns (Bitbucket: rangercairns, GitHub: rangercairns).
Wrong stored proc iPLUG4K has I/O last parm (forbidden). Switch to iPLUGR4K for a natural result set (below).
FYI -- Although on a personal note, languages and toolkits are for normal people (you shell hacker).
#!shell
bash-4.3$ alias db2='function _db2(){ echo "Running $1"; system -i "call QSYS/QZDFMDB2 parm('\''$1'\'')"; };_db2'
bash-4.3$ db2 "CALL XMLSERVICE.iPLUGR4K(''*na'', ''*here'', ''<?xml version="1.0"?><script><sh>ls</sh></script>'')"
Running CALL XMLSERVICE.iPLUGR4K(''*na'', ''*here'', ''<?xml version=1.0?><script><sh>ls</sh></script>'')
**** CLI ERROR *****
SQLSTATE: 0100C
NATIVE ERROR CODE: 466
1 result sets are available from procedure IPLUGR4K in XMLSERVICE.
OUT151
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
<?xml version=1.0?><script><sh>
README.md
READNOTES.txt
contributors.txt
iayecmd.rpgle
iayedata.rpgle
iayeds.rpgle
iayejunk.rpgle
iayelic.rpgle
iayelic_h.rpgle
iayeos.rpgle
iayeos_h.rpgle
iayeparm.rpgle
iayeperf.rpgle
iayeperf_h.rpgle
iayepgm.rpgle
iayerun.rpgle
iayerun_h.rpgle
iayesh.rpgle
iayesql.rpgle
iayesrv.rpgle
iayesrv_h.rpgle
iayexml.rpgle
iayexml_h.rpgle
make.sh
testbig.rpgle
testloop.rpgle
testpgm.rpgle
testpgm2.rpgle
</sh>
</script>
1 RECORD(S) SELECTED.
bash-4.3$
from xmlservice.
Related Issues (20)
- DATA tags in output have wrong converted chars after migrated to new build environment HOT 8
- Is there any example to show how to call stored procedures? HOT 18
- XMLSTOREDP service program not exporting RUNASCII HOT 1
- xmlcgi only supports password length less/equal to 10 HOT 1
- Multiple result sets HOT 2
- Add support for Free Format parameter declaration HOT 3
- Changing 'commit' option in XML SQL statement does NOT work HOT 7
- Itoolkit's iPgm - Library setup HOT 17
- How to deal with DBCS chars at IBMi db2 HOT 1
- How to fix IPLUG15M in QXMLSERV type *N not found. error HOT 2
- Stored procedures truncate result HOT 3
- How to use pure xml to call PGM/CMDwith Chinese Chars (937)? HOT 5
- Drop calling /usr/lib/start32 to bring PASE up
- spawn call overwrites instead of ORs flags HOT 1
- [feature] job name will always be XMLSERVICE HOT 2
- Qp0sDisableSignals ??? HOT 5
- Call to service program functions don't have %PARMS() set properly - ie with *NOPASS parameters and <pgm mode="ile"> HOT 3
- Calls to programs or service program functions with mode="opm" do not handle *OMIT parameters properly HOT 1
- Fix copyright headers on source files
- Properly escape content in built CDATA blobs HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
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.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from xmlservice.