scottklement.com

Hi,

Thanks to all collaboration, in the end the next code calls the library using itoolkit:


import { Connection, ProgramCall } from 'itoolkit';
import { XMLParser } from 'fast-xml-parser';

const conn = new Connection({
transport: 'odbc',
transportOptions: { dsn: '*LOCAL' },
});

const ...

It's a long story, we have a propietary program that calls QDCXLATE with an hexadecimal data (4 bits) ascii, the call to QDCXLATE has the bitmaps to decode some iso8583 frames with transparent mode. I'm not an as400 expert, and need to call this program from nodejs with itoolkit.

Hi,

We need to call QDCXLATE from itoolkit, to convert from hex ascii to ebcdic, but don't know how to. Until we can see the as400 doesn't have iconv; may be is too old.

Any help will be appreciated !!

Thanks
Hans

Initially Ii compiled it manually to assemble as archive libodbcinst.a and not as .so that comes with the rpm package, this file is a depdendency of libsqora.so, but lattely i just used ar to create it. Now i've found the "invalid magic number" error that tells that there is no binary compatibilty ...

Hi Scott, thanks for caring,

I've downloaded binaries from Oracle for ppc64, they should work in PASE, i've created the required depdencencies, i.e. creating expected libodbcinst.a with libodbcinst.so.2 using ar, in all this effort, i''ve compiled successfully unixodbc using gcc in pase ...

Can't make Oracle unixodbc driver work in the ibmi.

We have an app that uses unixodbc to call db2, and works fine, know we need to add some oracle databases, but can't make unixodbc to load the oracle drivers, we've tried LIBPATH, dump -H, and ar -rv, all to create the dependencies of the oracle ...