theprez / codeforibmiserver Goto Github PK

Hi, I tried several times to install Code4i but the server component for DB2for i gets never installed.
I downloaded the jar file and copied it in my .vscode folder.
By connecting to my IBM i box VS code I get the error
"Something went really wrong trying to fetch your come directory"
Source: DB2 for IBM i

What am I doing wrong?
Thanks bye

Hi,

I often got this message :

java.sql.SQLException: INTERNAL ERROR: Creation of DB2Driver object for registering with DriverManager failed. -> com.ibm.db2.jdbc.app.DB2JDBCDataException: CCSID value is not valid.

Do you know why?

Regards,

Olivier.

With the current code flow, if the prepare of the statement to VE fails for any reason (ex: query of a non-existent file), we drop into the catch block, skipping over the call to ENDDBMON.
As a result, any subsequent VE actions on the job fail at the point that the STRDBMON is called, because the job is still being monitored from the failed attempt.
The fail out path needs to ensure that the job monitoring is ended.

Ability to run CL command in the job would be cool

Need binding parameters for procedure calls.

Also input/output support would be nice but not required

I'm wondering if this should instead be calling QSYS.QQQDBVE.
I think it is possible for QIWS.QQQDBVE2 to not exist on the system.
Way back in the day System i Navigator was responsible for creating it.
I think at some point that might have gotten rolled into a system install or IPL path, but I am not certain.
Under the covers, both procedures call the same program.

Right now there is a hardcoded string in the VE API call, but we're likely going to need this parameterized in the future so we can pass in optional values via the request object.

typedef _Packed struct         /* Input structure              */
{
	char   IN_DBMONTBL[10];     /* DBMON table name             */
	char   IN_DBMONLIB[10];     /* DBMON lib   name             */
	char   IN_DATFMT[3];        /* Date Format                  */
	char   IN_DATSEP[1];        /* Date Separator               */
	char   IN_TIMFMT[3];        /* Time Format                  */
	char   IN_TIMSEP[1];        /* Time Separator               */
	char   IN_DECPNT[1];        /* Decimal Point                */
	char   IN_LNGID[3];         /* Language ID                  */
	char   IN_DIAGRAM[1];       /* Type of VE diagram           */
	char   IN_DATAATTR[1];      /* Data attribute option        */
	char   IN_OPTION3[1];       /* Explain current-of-job       */
	char   IN_CURRJOB[26];      /* Job for current-of-job       */
	char   IN_ExpOnly[1];       /* Explain Only                 */
	char   IN_DblHostVar[1];    /* DblByte HostVar values       */
	char   IN_ClsCursor[1];     /* QQQDBVE to close cursor      */
	char   IN_RESRV[8];         /* Open for use                 */
} x;               /* Structure passed to API on input, 72 bytes */

As this won't be tied to Code for IBM i