Re: [EXTERNAL] Re: Problem with iToolkit in Node on Windows

...then do what we've done with Java but in NodeJs 😊 Forget about executing arbitrary SQLs and commands on the IBM i and concentrate on only calling stored procedures, write yourself an IBM i NodeJs app which just does this and then use either pure SQL SPs or wrapper your existing Cobol code with SP interfaces. It's actually quite easy, unfortunately I don't have time to re-implement my existing Java framework in Node at the moment, but ultimately it's the plan.


________________________________
From: WEB400 <web400-bounces@xxxxxxxxxxxx> on behalf of Kelly Cookson <KCookson@xxxxxxxxxxxx>
Sent: 22 March 2018 13:58
To: Web Enabling the IBM i (AS/400 and iSeries)
Subject: Re: [WEB400] [EXTERNAL] Re: Problem with iToolkit in Node on Windows

I think we mostly want to be able to able to run SQL against DB2 files and call CL/COBOL programs. Other functionality would be great. But these two capabilities are key for us. I'll keep looking around. Plus, I'll get back to Node on the IBM i as well. Cover all of the bases.

Thanks,

Kelly Cookson
IT Project Leader
Dot Foods, Inc.
217-773-4486 ext. 12676
https://nam02.safelinks.protection.outlook.com/?url=www.dotfoods.com&data=02%7C01%7C%7Cb18ed92d271049b08cfe08d58ff49e40%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573203145241851&sdata=lkCxd0Yu9C2IdAjQjeZxYFclfA%2FFLldPwgqzYlJiF5U%3D&reserved=0<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.dotfoods.com&data=02%7C01%7C%7Cb18ed92d271049b08cfe08d58ff49e40%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573203145241851&sdata=B%2BSE85Q72dWhr5sR1MyK%2F5yqpLZF%2B5Lta7N5FSYeYxY%3D&reserved=0>

From: WEB400 [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Aaron Bartell
Sent: Thursday, March 22, 2018 7:55 AM
To: Web Enabling the IBM i (AS/400 and iSeries) <web400@xxxxxxxxxxxx>
Subject: [EXTERNAL] Re: [WEB400] Problem with iToolkit in Node on Windows

Forgot to relay a repo that does an implementation of db2sock in Node.js.
Check it out here: https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbitbucket.org%2Ffreschesolutions%2Fdb2sock-itoolkit&data=02%7C01%7C%7Cb18ed92d271049b08cfe08d58ff49e40%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573203145241851&sdata=scPRi8aZhOi%2BGumWV6o0mrzLCG%2B01ALQSTKC47WmbVg%3D&reserved=0<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbitbucket.org%2Ffreschesolutions%2Fdb2sock-itoolkit&data=02%7C01%7C%7Cb18ed92d271049b08cfe08d58ff49e40%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573203145241851&sdata=scPRi8aZhOi%2BGumWV6o0mrzLCG%2B01ALQSTKC47WmbVg%3D&reserved=0>

It is only focusing on program calls and not DB2. DB2 will come eventually.

Aaron Bartell
IBM i hosting, starting at $157/month. litmis.com/spaces<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Flitmis.com%2Fspaces&data=02%7C01%7C%7Cb18ed92d271049b08cfe08d58ff49e40%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573203145241851&sdata=bEnyQEztuRokj%2BePpMuQg8l7%2B%2FpGjkfk6bYcoXT72BQ%3D&reserved=0>


On Thu, Mar 22, 2018 at 7:40 AM, Aaron Bartell <aaronbartell@xxxxxxxxx<mailto:aaronbartell@xxxxxxxxx>>
wrote:

Java developers need a package that lets them remotely connect to the

IBM i (jt400.jar), but Node developers don't?

Something to keep a pulse on is this project: https://bitbucket.
org/litmis/db2sock

And read these threads in the Issues:

https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbitbucket.org%2Flitmis%2Fdb2sock%2Fissues%2F1%2Fgeneral-look-feel-of-async&data=02%7C01%7C%7Cb18ed92d271049b08cfe08d58ff49e40%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573203145241851&sdata=c1jq1YhlToGVDhfg4j4%2FlqnLNoDoSjYKqNNjcAwhI8k%3D&reserved=0<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbitbucket.org%2Flitmis%2Fdb2sock%2Fissues%2F1%2Fgeneral-look-feel-of-async&data=02%7C01%7C%7Cb18ed92d271049b08cfe08d58ff49e40%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573203145241851&sdata=c1jq1YhlToGVDhfg4j4%2FlqnLNoDoSjYKqNNjcAwhI8k%3D&reserved=0>
https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbitbucket.org%2Flitmis%2Fdb2sock%2Fissues%2F5%2Fmake-connection-using-odbc&data=02%7C01%7C%7Cb18ed92d271049b08cfe08d58ff49e40%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573203145241851&sdata=NSXPLOtyksihl0%2BHbgT5TRfmegmIhY%2Fh08y6fZX9eWs%3D&reserved=0<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbitbucket.org%2Flitmis%2Fdb2sock%2Fissues%2F5%2Fmake-connection-using-odbc&data=02%7C01%7C%7Cb18ed92d271049b08cfe08d58ff49e40%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573203145241851&sdata=NSXPLOtyksihl0%2BHbgT5TRfmegmIhY%2Fh08y6fZX9eWs%3D&reserved=0>


FWIW, Ruby is in the same boat. Not sure about Python or PHP.

Aaron Bartell
IBM i hosting, starting at $157/month. litmis.com/spaces<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Flitmis.com%2Fspaces&data=02%7C01%7C%7Cb18ed92d271049b08cfe08d58ff49e40%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573203145241851&sdata=bEnyQEztuRokj%2BePpMuQg8l7%2B%2FpGjkfk6bYcoXT72BQ%3D&reserved=0>


On Thu, Mar 22, 2018 at 7:25 AM, Kelly Cookson <KCookson@xxxxxxxxxxxx<mailto:KCookson@xxxxxxxxxxxx>>
wrote:

Dear IBM,

Java developers need a package that lets them remotely connect to the IBM
i (jt400.jar), but Node developers don't?

Thanks,

Kelly Cookson
IT Project Leader
Dot Foods, Inc.
217-773-4486 ext. 12676
https://nam02.safelinks.protection.outlook.com/?url=www.dotfoods.com&data=02%7C01%7C%7Cb18ed92d271049b08cfe08d58ff49e40%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573203145241851&sdata=lkCxd0Yu9C2IdAjQjeZxYFclfA%2FFLldPwgqzYlJiF5U%3D&reserved=0<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.dotfoods.com&data=02%7C01%7C%7Cb18ed92d271049b08cfe08d58ff49e40%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573203145241851&sdata=B%2BSE85Q72dWhr5sR1MyK%2F5yqpLZF%2B5Lta7N5FSYeYxY%3D&reserved=0><https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.dotfoods.com&data=02%7C01%7C%7Cb18ed92d271049b08cfe08d58ff49e40%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573203145241851&sdata=B%2BSE85Q72dWhr5sR1MyK%2F5yqpLZF%2B5Lta7N5FSYeYxY%3D&reserved=0<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.dotfoods.com&data=02%7C01%7C%7Cb18ed92d271049b08cfe08d58ff49e40%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573203145241851&sdata=B%2BSE85Q72dWhr5sR1MyK%2F5yqpLZF%2B5Lta7N5FSYeYxY%3D&reserved=0>>

--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx<mailto:WEB400@xxxxxxxxxxxx>
To subscribe, unsubscribe, or change list options,
visit: https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fweb400&data=02%7C01%7C%7Cb18ed92d271049b08cfe08d58ff49e40%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573203145241851&sdata=g%2BDcjT8x9FEWj%2F%2FUp7924xHZ6YO5tiMmpqP0CqvQlNg%3D&reserved=0<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fweb400&data=02%7C01%7C%7Cb18ed92d271049b08cfe08d58ff49e40%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573203145241851&sdata=g%2BDcjT8x9FEWj%2F%2FUp7924xHZ6YO5tiMmpqP0CqvQlNg%3D&reserved=0>
or email: WEB400-request@xxxxxxxxxxxx<mailto:WEB400-request@xxxxxxxxxxxx>
Before posting, please take a moment to review the archives
at https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fweb400&data=02%7C01%7C%7Cb18ed92d271049b08cfe08d58ff49e40%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573203145241851&sdata=YLFNl%2BByWIIJFyPyBEXqKwPy8GJnX30EKRt6Tde7kns%3D&reserved=0<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fweb400&data=02%7C01%7C%7Cb18ed92d271049b08cfe08d58ff49e40%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573203145241851&sdata=YLFNl%2BByWIIJFyPyBEXqKwPy8GJnX30EKRt6Tde7kns%3D&reserved=0>.
--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fweb400&data=02%7C01%7C%7Cb18ed92d271049b08cfe08d58ff49e40%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573203145241851&sdata=g%2BDcjT8x9FEWj%2F%2FUp7924xHZ6YO5tiMmpqP0CqvQlNg%3D&reserved=0
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fweb400&data=02%7C01%7C%7Cb18ed92d271049b08cfe08d58ff49e40%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573203145241851&sdata=YLFNl%2BByWIIJFyPyBEXqKwPy8GJnX30EKRt6Tde7kns%3D&reserved=0.