connection.setConnAttr fails about nodejs-idb-pconnector HOT 4 CLOSED

Hi @lae0901

This package uses constants provided from idb-connector within that package looks like the value of SQL_ATTR_DBC_SYS_NAMING is equal to 10004.

You can gain access to the available constants from requiring idb-pconnector:

const { Connection, SQL_ATTR_DBC_SYS_NAMING, SQL_TRUE } = require('idb-pconnector');

const connection = new Connection({ url: '*LOCAL' });

await connection.setConnAttr(SQL_ATTR_DBC_SYS_NAMING, SQL_TRUE);

from nodejs-idb-pconnector.

thanks Abdirahim. this works.

to set the library list I have to call an SQL procedure thru the Connection and run the CHGLIBL command?

I tried to run "set current path = myLib1, myLib2" and it had no affect. Maybe because I have switched to system naming mode?

    {
      const stmt = new Statement(connection);
      const sql = 'set current_path = couri7, aplusb1fcc';
      const rv1 = await stmt.prepare(sql);
      await stmt.execute();
    }

Would be ideal to specify the library list when the code opens the connection. That is how it works in PHP.

-Steve

from nodejs-idb-pconnector.

Yes you would need to call CHGLIBL command through QSYS2.QCMDEXC stored procedure as mentioned here

Something like should do the trick

await connection.exec("CALL QSYS2.QCMDEXC('CHGLIBL (LIB LIB2 ...)')")

I am considering adding a function connection.setLibraryList()

That would call QCMDEXC under the covers

from nodejs-idb-pconnector.

Hi Steve, did a call to QSYS2.QCMDEXC solve the issue?

from nodejs-idb-pconnector.