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


  1.  Home
  2. WEB400
  3. March 2018

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

"If we can call a program, we can do almost anything."
..not to labour the point, but if we can call a stored procedure we can do almost anything 😊 better still, stored procedures have a very consistent interface so writing generic code to call them and process the resulting data is very easy.


________________________________
From: WEB400 <web400-bounces@xxxxxxxxxxxx> on behalf of Bradley Stone <bvstone@xxxxxxxxx>
Sent: 22 March 2018 14:04
To: Web Enabling the IBM i (AS/400 and iSeries)
Subject: Re: [WEB400] [EXTERNAL] Re: Problem with iToolkit in Node on Windows

I agree with Kelly... SQL and calling commands/programs (with parms) would
be the 2 MAIN things. And calling programs should be synchronous, or at
least an easy option (ie, call vs callsync). If we want them async well
call submit it to batch.

If we can call a program, we can do almost anything.

Save the dataq, data area, other object manipulation to when that is all
ironed out.





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

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://nam01.safelinks.protection.outlook.com/?url=www.dotfoods.com&data=02%7C01%7C%7C7a6a64ff4bcf4eaf335708d58ff57887%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573206805693965&sdata=HNNxaX%2FBovIkKgr4%2FTyctHnHWMQWwfCTmJhW1jCCWiM%3D&reserved=0<https://nam01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.dotfoods.com&data=02%7C01%7C%7C7a6a64ff4bcf4eaf335708d58ff57887%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573206805693965&sdata=yfijollZtp6oSWAISYJCxBQO44GiGrOgqZwdtRx7PdY%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://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbitbucket.org%2Ffreschesolutions%2Fdb2sock-itoolkit&data=02%7C01%7C%7C7a6a64ff4bcf4eaf335708d58ff57887%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573206805693965&sdata=uGUOrkQRYPqSWdzY%2FkaxTY%2BMcxx0YpMJsjDGqtHgZgo%3D&reserved=0
<https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbitbucket.org%2Ffreschesolutions%2Fdb2sock-itoolkit&data=02%7C01%7C%7C7a6a64ff4bcf4eaf335708d58ff57887%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573206805693965&sdata=uGUOrkQRYPqSWdzY%2FkaxTY%2BMcxx0YpMJsjDGqtHgZgo%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<http://
litmis.com/spaces>


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://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbitbucket.org%2Flitmis%2Fdb2sock%2Fissues%2F1%2Fgeneral-look-feel-of-async&data=02%7C01%7C%7C7a6a64ff4bcf4eaf335708d58ff57887%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573206805693965&sdata=HPp7VXy5Ac9wugFGYtB5Oyh1HzemMiNkKvzCtxsGCjE%3D&reserved=0
<https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbitbucket.org%2Flitmis%2Fdb2sock%2Fissues%2F1%2Fgeneral-look-feel-of-async&data=02%7C01%7C%7C7a6a64ff4bcf4eaf335708d58ff57887%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573206805693965&sdata=HPp7VXy5Ac9wugFGYtB5Oyh1HzemMiNkKvzCtxsGCjE%3D&reserved=0>
https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbitbucket.org%2Flitmis%2Fdb2sock%2Fissues%2F5%2Fmake-connection-using-odbc&data=02%7C01%7C%7C7a6a64ff4bcf4eaf335708d58ff57887%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573206805693965&sdata=JFORg1LfLctt8H%2F3kXCbdwXBMukEgkgK%2FYxafTHSXIg%3D&reserved=0
<https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbitbucket.org%2Flitmis%2Fdb2sock%2Fissues%2F5%2Fmake-connection-using-odbc&data=02%7C01%7C%7C7a6a64ff4bcf4eaf335708d58ff57887%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573206805693965&sdata=JFORg1LfLctt8H%2F3kXCbdwXBMukEgkgK%2FYxafTHSXIg%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<http://
litmis.com/spaces>


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://nam01.safelinks.protection.outlook.com/?url=www.dotfoods.com&data=02%7C01%7C%7C7a6a64ff4bcf4eaf335708d58ff57887%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573206805693965&sdata=HNNxaX%2FBovIkKgr4%2FTyctHnHWMQWwfCTmJhW1jCCWiM%3D&reserved=0<https://nam01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.dotfoods.com&data=02%7C01%7C%7C7a6a64ff4bcf4eaf335708d58ff57887%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573206805693965&sdata=yfijollZtp6oSWAISYJCxBQO44GiGrOgqZwdtRx7PdY%3D&reserved=0><https://nam01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.dotfoods.com&data=02%7C01%7C%7C7a6a64ff4bcf4eaf335708d58ff57887%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573206805693965&sdata=yfijollZtp6oSWAISYJCxBQO44GiGrOgqZwdtRx7PdY%3D&reserved=0<
https://nam01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.dotfoods.com&data=02%7C01%7C%7C7a6a64ff4bcf4eaf335708d58ff57887%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573206805693965&sdata=yfijollZtp6oSWAISYJCxBQO44GiGrOgqZwdtRx7PdY%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://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fweb400&data=02%7C01%7C%7C7a6a64ff4bcf4eaf335708d58ff57887%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573206805693965&sdata=WmEcclX8MsS1F3LvaVuZRv%2BLLaRfYIfBPFBw1smIeJM%3D&reserved=0<https:
//lists.midrange.com/mailman/listinfo/web400>
or email: WEB400-request@xxxxxxxxxxxx<mailto:WEB400-request@xxxxxxxxxxxx>
Before posting, please take a moment to review the archives
at https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fweb400&data=02%7C01%7C%7C7a6a64ff4bcf4eaf335708d58ff57887%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573206805693965&sdata=ARzTWsZ%2Fe9HxxoESSHpTZmwbMjnPx8kR1jka5UqAPvQ%3D&reserved=0<https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fweb400&data=02%7C01%7C%7C7a6a64ff4bcf4eaf335708d58ff57887%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573206805693965&sdata=ARzTWsZ%2Fe9HxxoESSHpTZmwbMjnPx8kR1jka5UqAPvQ%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://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fweb400&data=02%7C01%7C%7C7a6a64ff4bcf4eaf335708d58ff57887%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573206805693965&sdata=WmEcclX8MsS1F3LvaVuZRv%2BLLaRfYIfBPFBw1smIeJM%3D&reserved=0
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fweb400&data=02%7C01%7C%7C7a6a64ff4bcf4eaf335708d58ff57887%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573206805693965&sdata=ARzTWsZ%2Fe9HxxoESSHpTZmwbMjnPx8kR1jka5UqAPvQ%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://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fweb400&data=02%7C01%7C%7C7a6a64ff4bcf4eaf335708d58ff57887%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573206805693965&sdata=WmEcclX8MsS1F3LvaVuZRv%2BLLaRfYIfBPFBw1smIeJM%3D&reserved=0
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fweb400&data=02%7C01%7C%7C7a6a64ff4bcf4eaf335708d58ff57887%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636573206805693965&sdata=ARzTWsZ%2Fe9HxxoESSHpTZmwbMjnPx8kR1jka5UqAPvQ%3D&reserved=0.


As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
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.