Add `cl` and `prepare_sql_execute` request types

Mapepire-IBMi / mapepire-server

Server-side support for Code for IBM i

GNU General Public License v3.0

24 stars 6 forks source link

Add `cl` and `prepare_sql_execute` request types #6

Closed ThePrez closed 1 year ago

ThePrez commented 1 year ago

prepare_sql_execute creates a prepared statement, binds parameters, and executes, all in one step cl calls CL and returns the job log info

Examples

{id: "41","type":"prepare_sql_execute","sql": "INSERT INTO JESSEG.SIMPLE VALUES(?,?)","parameters":[111, "Holy hell"]}
{id:"cltest1","type":"cl", "cmd":"cPYF FROMFILE(JESSEG/SIMPLE) TOFILE(JESSEG/SIMPLE2) MBROPT(*REPLACE) CRTFILE(*YES)"}

ThePrez commented 1 year ago

Fixes #4