codefori/vscode-db2i

Db2 for IBM i Tools for VS Code

vscode-db2i's Issues

Icon suggestion

Suggest that the arrow icons be reversed for representing IN and OUT parameters.

34b2bf7#r118822201

Improved `alter` support

Request for enhancements: export query results to csv or excel

Hellò everybody. My request is not to report errors or problems but to propose an improvement of the extension, i.e. the possibility to export the results of queries executed through the extension in csv or excel format. Have you already considered this?

Outline view for SQL documents

DB2 for i : Generate SQL

Hi,
I have a SQL function created via IBM ACS.

I tried to use "generate SQL" from DB2 for I , but the generated code has a space for variable names which include a § character.

Generating SQL from ACS works fine.

---

⚠️ REMOVE THIS LINE AND ANY SENSITIVE INFORMATION BELOW! ⚠️

Context	Version
Code for IBM i version	2.1.1
Visual Studio Code version	1.81.1
Operating System	darwin_arm64

Active extensions

Code Coverage for IBM i (code-coverage-ibmi): 0.1.7
Code Runner (code-runner): 0.12.0
Code for IBM i Walkthroughs (vscode-ibmi-walkthroughs): 0.3.1
Db2 for IBM i (vscode-db2i): 0.4.1
Emmet (emmet): 1.0.0
Extension Authoring (extension-editing): 1.0.0
Git (git): 1.0.0
Git Base (git-base): 1.0.0
GitHub (github): 0.0.1
GitHub Authentication (github-authentication): 0.0.2
GitLens — Git supercharged (gitlens): 14.2.1
IBM i Notebooks (vscode-ibmi-notebooks): 0.0.6
JSON Language Features (json-language-features): 1.0.0
Jira and Bitbucket (Atlassian Labs) (atlascode): 3.0.5
Live Server (LiveServer): 5.7.9
Merge Conflict (merge-conflict): 1.0.0
Microsoft Account (microsoft-authentication): 0.0.1
NPM support for VS Code (npm): 1.0.1
Node Debug Auto-attach (debug-auto-launch): 1.0.0
Overtype (overtype): 0.5.0
RPGLE (vscode-rpgle): 0.21.3
TypeScript and JavaScript Language Features (typescript-language-features): 1.0.0
YAML (vscode-yaml): 1.14.0

---

Remote system

Setting	Value
IBM i OS	V7R4M0
Tech Refresh	7
CCSID	1144
SQL	Enabled
Source dates	Disabled

Enabled features

/QOpenSys/pkgs/bin	/usr/bin	/QSYS.lib/ILEDITOR.lib	/QSYS.LIB	/QIBM/ProdData/IBMiDebugService/bin
bash	attr	GENCMDXML.PGM	QZDFMDB2.PGM	startDebugService.sh
chsh	iconv	GETNEWLIBL.PGM
ls	setccsid
md5sum	tar
sort
stat
tn5250

Shell env

BUILDLIB=S
CURLIB=S
HOME=/home/
LIBLS=
LOGIN=
LOGNAME=
MAIL=/var/spool/mail/
OLDPWD=/home/
PATH=/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin
PWD=/home/
SHELL=/QOpenSys/pkgs/bin/bash
SHLVL=1
SSH_CLIENT=
SSH_CONNECTION=
TZ=<CET>-1<CEST>,M3.5.0,M10.5.0
USER= 
USERNAME= 
_=/QOpenSys/usr/bin/env

Variants

{
  "american": "#@$",
  "local": "£§$"
}

Errors

Integrate tracing/debug support into SQL Job Manager

Install server component with correct permissions

Server component is installed with public read authority, perhaps should/could be public *EXCLUDE

$HOME/.vscode has permissions

d rwx r-s r-x

(perhaps inherited from home dir)

No glaring security hole here, but we should:

• determine the proper authorities that should be set
• change the code to set them accordingly (if applicable)

`GENERATE_SQL` generating lines too long

CALL QSYS2.GENERATE_SQL('ACTIVESACTIVESACTIVESACTIVESACTIVESACTIVESACTIVESACTIVESACTIVESACTIVESACTIVESACTIVESACTIVESACTIVESACTIVES', 'SAMPLE', 'ALIAS', CREATE_OR_REPLACE_OPTION => '1', PRIVILEGES_OPTION => '0')

Possible fix is using the parameter to write to the IFS, then read in the IFS contents with a vscode-ibmi API.

https://www.ibm.com/docs/en/i/7.3?topic=services-generate-sql-procedure

tokeniser: Support for `unique` keyword for `index` type

CREATE UNIQUE INDEX XDEPT1
       ON DEPARTMENT (DEPTNO);

CREATE INDEX XDEPT2
       ON DEPARTMENT (MGRNO);

CREATE INDEX XDEPT3
       ON DEPARTMENT (ADMRDEPT); 

`ls undefined` being sent

Looks like when the config is not ready, then undefined is being returned.

https://github.com/halcyon-tech/vscode-db2i/blob/4f56ab8199eff14cd1a306c61125d9fe618e1884/src/connection/serverComponent.ts#L64

/home/CHRISD: ls undefined
{
    "code": 2,
    "signal": null,
    "stdout": "",
    "stderr": "undefined not found"
}

SQL Job Fails to Set Library List if Current Library is Specified in User Library List

It appears as-if the current library is being pre-pended to the user library list when starting a SQL job. As a result, the setting of the library list fails CPF2184. There are two problems:

1. The special value of *CRTDFT is being used by the SQL job as-if it were a valid library name; thus causing an error.

2. If the current library exists in the user portion of the library list, the resulting library list will contain the same library name twice; which is an error.

It should be noted that when the current library is set to a valid library name, the that library is added to the library list between the system (SYS) portion of the library list and the user (USR) portion of the library list. Despite IBM resolving the special value of *CRTDFT to QGPL as needed, IBM does not insert QGPL between the system and user portions of the library list.

Ideally, the setting of the current library should be done by explicitly setting the current library (CHGCURLIB) or the current library should be specified on the CURLIB() parameter of the CHGLIBL command; not included as the first library in the library list.

If the current library cannot be handled in either of the above manners and it must be added to the user library list, then the following guidelines should be considered:

1. If the current library is *CRTDFT, then do not pre-pend the user library list.

2. If the current library is valid library name (not the special value *CRTDFT), pre-pend the user library list with the current library name and remove the current library if it is found in the user library list.

Example 1:
If the user library list on the connection is "MYLIB1,MYLIB2,QTEMP" and the current library is set to *CRTDFT, the SQL job will try to establish the library list as "*CRTDFT,MYLIB1,MYLIB2,QTEMP". Because *CRTDFT is not a valid library name, the setting of the library list will fail.

In this example, the library list should be set to "MYLIB1,MYLIB2,QTEMP". The library QGPL should simply not be included in the library list.

Example 2:
If the user library list on the connection is "ALIB1,BLIB2,MYGPL,QTEMP" and the current library is set to MYGPL, the SQL job will try to establish the library list as "MYGPL,ALIB1,BLIB2,MYGPL,QTEMP". Because MYGPL appears twice in the library list, the setting of the library list will fail.

In this example, assuming the current library must be included in the library list, I would expect the library list to be set to "MYGPL,ALIB1,BLIB2,QTEMP".

---

Context	Version
Code for IBM i version	2.0.2
Visual Studio Code version	1.80.1
Operating System	win32_x64

Active extensions

AWS Toolkit (aws-toolkit-vscode): 1.81.0
C# (csharp): 1.26.0
COBOL (cobol): 9.7.23
Code Coverage for IBM i (code-coverage-ibmi): 0.1.7
Code for IBM i Walkthroughs (vscode-ibmi-walkthroughs): 0.3.1
Db2 for IBM i (vscode-db2i): 0.3.3
Debugger for Java (vscode-java-debug): 0.52.0
Dev Containers (remote-containers): 0.299.0
Docker (vscode-docker): 1.26.0
ESLint (vscode-eslint): 2.4.2
Emmet (emmet): 1.0.0
Error Lens (errorlens): 3.12.0
Git (git): 1.0.0
Git Base (git-base): 1.0.0
GitHub (github): 0.0.1
GitHub Authentication (github-authentication): 0.0.2
GitHub Pull Requests and Issues (vscode-pull-request-github): 0.68.1
GitLens — Git supercharged (gitlens): 14.1.1
HTML CSS Support (vscode-html-css): 1.13.1
IBM i Notebooks (vscode-ibmi-notebooks): 0.0.6
IntelliCode (vscodeintellicode): 1.2.30
JSON Language Features (json-language-features): 1.0.0
JavaScript Debugger (js-debug): 1.80.0
Merge Conflict (merge-conflict): 1.0.0
Microsoft Account (microsoft-authentication): 0.0.1
Node Debug Auto-attach (debug-auto-launch): 1.0.0
Nx Console (angular-console): 18.5.0
Path Intellisense (path-intellisense): 2.8.4
Prettier - Code formatter (prettier-vscode): 9.19.0
Pylance (vscode-pylance): 2023.7.30
Python (python): 2023.12.0
Server Ready Action (debug-server-ready): 1.0.0
TODO Highlight (vscode-todo-highlight): 1.0.5
Todo Tree (todo-tree): 0.0.226
TypeScript and JavaScript Language Features (typescript-language-features): 1.0.0
WSL (remote-wsl): 0.80.2
WSL: Recommender (remote-wsl-recommender): 0.0.19

---

Remote system

Setting	Value
IBM i OS	V7R4M0
Tech Refresh	7
CCSID	37
SQL	Enabled
Source dates	Disabled

Enabled features

/QOpenSys/pkgs/bin	/usr/bin	/QSYS.lib/ILEDITOR.lib	/QSYS.LIB	/QIBM/ProdData/IBMiDebugService/bin
bash	attr	GENCMDXML.PGM	QZDFMDB2.PGM	startDebugService.sh
tn5250	iconv	GETNEWLIBL.PGM
	ls
	setccsid
	tar

Shell env

Variants

{
  "american": "#@$",
  "local": "#@$"
}

Errors

[
  {
    "command": "export BUILDLIB=\"QGPL\" && export CURLIB=\"QGPL\" && export USERNAME=\"BSLEETH3\" && export HOME=\"/home/BSLEETH3\" && export LIBLS=\"QHLPSYS IPMDPGM2 IPTSUTL IPWMPGM IPASPGM IPTSPGM IPTSPCH BSLIB IPSAPGM IPSRFIL3 IPDSFIL3 IPDSPGM3 DCXDTALIB DCXPGMLIB DBU11 IPPAFIL3 IPWMFIL3 IPSAFIL3 IPASFIL3 IPTSFIL3 IPTKLNK IPTSCHG033 IPTSPCH033 IPTSMOD3 QGPL QTEMP\" && env",
    "code": 1,
    "stderr": "bsh: BUILDLIB=QGPL: is not an identifier",
    "cwd": "/home/BSLEETH3"
  },
  {
    "command": "export BUILDLIB=\"QGPL\" && export CURLIB=\"QGPL\" && export USERNAME=\"BSLEETH3\" && export HOME=\"/home/BSLEETH3\" && export LIBLS=\"QHLPSYS IPMDPGM2 IPTSUTL IPWMPGM IPASPGM IPTSPGM IPTSPCH BSLIB IPSAPGM IPSRFIL3 IPDSFIL3 IPDSPGM3 DCXDTALIB DCXPGMLIB DBU11 IPPAFIL3 IPWMFIL3 IPSAFIL3 IPASFIL3 IPTSFIL3 IPTKLNK IPTSCHG033 IPTSPCH033 IPTSMOD3 QGPL QTEMP\" && env",
    "code": 1,
    "stderr": "bsh: BUILDLIB=QGPL: is not an identifier",
    "cwd": "/home/BSLEETH3"
  },
  {
    "command": "export BUILDLIB=\"QGPL\" && export CURLIB=\"QGPL\" && export USERNAME=\"BSLEETH3\" && export HOME=\"/home/BSLEETH3\" && export LIBLS=\"QHLPSYS IPMDPGM2 IPTSUTL IPWMPGM IPASPGM IPTSPGM IPTSPCH BSLIB IPSAPGM IPSRFIL3 IPDSFIL3 IPDSPGM3 DCXDTALIB DCXPGMLIB DBU11 IPPAFIL3 IPWMFIL3 IPSAFIL3 IPASFIL3 IPTSFIL3 IPTKLNK IPTSCHG033 IPTSPCH033 IPTSMOD3 QGPL QTEMP\" && env",
    "code": 1,
    "stderr": "bsh: BUILDLIB=QGPL: is not an identifier",
    "cwd": "/home/BSLEETH3"
  }
]

Update CustomUI instances to use form validation

• The new vscode-ibmi 2.0.0 allows for type validation and it'd be cool if our forms used it too.
• Could we also move this CustomUI instance in to a new file?
  • Perhaps under src/views/schemaBrowser/copyUi.ts?
  • Then also move schemaBrowser.ts to src/views/schemaBrowser/copyUi.ts

https://github.com/halcyon-tech/vscode-db2i/blob/9ceaa928dc72924f041a23ae1e0a225c097bc4da/src/views/schemaBrowser.ts#L246

issue with SQL set command

Describe the bug
set variable = value; causes a java run time error

To Reproduce

Steps to reproduce the behavior:

1. Connect to SQL JOB MANAGER
2. Open any edit tab and make sure language is SQL
3. Create a variable if one does not exist to update, like create or replace variable myvarible char(10);
4. Key a set command like set myvariable = 'ME';
5. java error appears in IBM i: Results output channel.

Expected behavior
Statement is run to completion.

Screenshots

Environment

• OS: Windows 10.0
• Extension Version 0.3.2

Additional context

This is a high priority for me.

Client needs to close SQL cursor before running more queries

Example testcase:

create or replace table qtemp.tt as (
select * from qsys2.syslimits_basic
) with data on replace delete rows;

select * from qtemp.tt;

create or replace table qtemp.tt as (
select * from qsys2.syslimits_basic
) with data on replace delete rows;
select * from qtemp.tt;

This works if you scroll through to force the client to fetch all rows of the select result set (which implicitly closes the cursor). Otherwise, the second create or replace fails with [SQL0951] Object TT in QTEMP not altered. (due to the cursor still being open from the select)

Tokeniser improvement: CREATE with BEGIN and dynamic compound statements

BEGIN
   DECLARE already_exists SMALLINT DEFAULT 0;
   DECLARE dup_object_hdlr CONDITION FOR SQLSTATE '42710';
   DECLARE CONTINUE HANDLER FOR dup_object_hdlr
      SET already_exists = 1;
   CREATE TABLE table1(col1 INT);
   IF already_exists > 0
   THEN
      DELETE FROM table1;
   END IF;
END;

Investigate job connection time

Schema browser need better support for procedure overloading

SQL results view should include which job the statement was run in

Especially when there could be multiple SQL jobs in use, it would be good to get some visual indicator as to which job a query or SQL statement was run in

Client Special Registers not set

Use of generateSQL does not check for active server and fails

If user does not start the SQL JOB MANAGER then does a GENERATE SQL action a run error is returned.

To Reproduce

Steps to reproduce the behavior:

1. Stop or restart VS Code and do not start SQL JOB MANAGER.
2. Click on the DB2 for i view expand a schema
3. Expand any item type (like functions or tables),
4. Right-Click on item and choose Generate SQL
5. Receive error Number of host variables not valid. (07001)
6. Open output channel Code for IBM I :[serverid] to see error

Expected behavior
To be told I need to start a SQL JOB MANAGER job or pop up to have me to just that.

Environment

• OS: [Windows 10]
• Extension Version 0.3.2

Additional context
This is a medium priority issue, for me.

Validate schema when adding to schema browser

Either:

1. validate the user input to ensure the schema exists, or
2. show a list of all schemas the user can filter through instead

Index advice for entire schema

Initial completion item provider (SQL content assist)

Spinning up SQL job never ends

Describe the bug

No trace collection is available. After connecting to IBM i system, DB2 for i extension displays the message "Spinning up SQL job" which never ends. Checking SQL Job Manager shows no job in the list and only allows me to start a new one with the same result.

To Reproduce

Steps to reproduce the behavior:

1. Connect to IBM i system
2. Open DB2 for i extension
3. Expand SQL Job Manager and click on New SQL Job

Expected behavior

It is expected to connect to the system to run SQL statements.

Screenshots

Environment

• OS: Windows
• Extension Version 0.4.0

Q : Change "Query executed with no result set returned." to actually return how many rows were affected

Hi
I have a question, is there any way to enable in the extension so it actually returns how many rows were affected i.e. using sql UPDATE in the ibm i results window. I was looking all over and could not find it in the extension settings.

Thank you
Matt

This is bad thing

Leave a comment

feb3c3c#diff-87342e72eeaa1ab60a5dad8db3c4d2464e1fa66043961d135588854c0e168ab2R140

Ensure manager view is shown after first time installation

Allow various Db connection methods

CAn allow for all of:

• Host servers via TCP
• Host servers via Unix domain sockets
• CLI

Make edit JDBC options view nice

Make it looks like ACS and it will suffice

Error on the text statement created via "Generate SQL" option

Describe the bug

When using "Generate SQL" option on view object the statement's text contains sintax error. Such name of field contain random blanks

To Reproduce

Steps to reproduce the behavior:
Select a view, generate SQL and look at the text created

Expected behavior

Correct sintax in the statement

Environment

• OS: Windows 10
• Extension Version latest avaible when writing

Additional context
I enclose the generated wrong statement
CREATE
OR REPLACE VIEW LND_DW.R_STATIS (
STAG1,
STAG2,
COMIT,
SATSO,
TOTST,
SOCIE,
ISCNA,
ISCRE,
ISCPO,
ISC11M,
ISC11F,
ISC5M,
ISC5F,
ISCALM,
ISCALM5,
ISCALF,
ISCALF5,
ISCGIM,
ISCGIM5,
ISCGIF,
ISCGIF5,
ISCES,
ISCPU,
ISCPC,
ISCPA,
ATTC11M,
ATTC11F,
ATTC5M,
ATTC5F,
ATTC5MP,
ATTC5FP,
TOCAL,
TOFEC,
TOCA1,
TOFE1,
TOCA2,
TOFE2,
TOCA3,
TOFE3,
TOCA4,
TOFE4,
TOCA5,
TOFE5,
TOCA6,
TOFE6,
TOALL,
TOMAS,
TOMED,
DIDRA,
DIDIR,
DIALL,
DIMAS,
DIALT
) AS (
SELECT
STAG1,
STAG2,
COMIT,
SATSO,
COUNT(SATSO) AS TOTST,
COUNT(SOCIE) AS SOCIE,
SUM (ISCNA) AS ISCNA,
SUM(ISCRE) AS ISCRE,
SUM(ISCPO) AS ISCPO,
SUM(I SC11M) AS ISC11M,
SUM(ISC11F) AS ISC11F,
SUM(ISC5M) AS ISC5M,
SUM(ISC5F) AS IS C5F,
SUM(ISCALM) AS ISCALM,
SUM(ISCALM5) AS ISCALM5,
SUM(ISCALF) AS ISCALF,
SUM(ISCALF5) AS ISCALF5,
SUM(ISCGIM) AS ISCGIM,
SUM(ISCGIM5) AS ISCGIM5,
SUM(ISCGIF) AS ISCGIF,
SUM(ISCGIF5) AS ISCGIF5,
SUM(ISCES) AS ISCES,
SUM(ISCPU) A S ISCPU,
SUM(ISCPC) AS ISCPC,
SUM(ISCPA) AS ISCPA,
SUM (SAT1M) AS ATTC11M,
SUM (SAT1F) AS ATTC11F,
SUM (SAT5M) AS ATTC5M,
SUM (SAT5F) AS ATTC5F,
SU M (SAT52) AS ATTC5MP,
SUM(SAT53) AS ATTC5FP,
SUM (TOCAL) AS TOCAL,
SUM(TO FEC) AS TOFEC,
SUM(TOCA1) AS TOCA1,
SUM (TOFE1) AS TOFE1,
SUM (TOCA2) AS TOCA2,
SUM(TOFE2) AS TOFE2,
SUM(TOCA3) AS TOCA3,
SUM(TOFE3) AS TOFE3,
SUM(TOCA4) AS TOCA4,
SUM(TOFE4) AS TOFE4,
SUM(TOCA5) AS TOCA5,
SUM(TOFE5) AS TOFE5,
SUM(TOCA 6) AS TOCA6,
SUM(TOFE6) AS TOFE6,
SUM(TOALL) AS TOALL,
SUM(TOMAS) AS TOMAS,
S UM(TOMED) AS TOMED,
SUM (DIDRA) AS DIDRA,
SUM(DIDIR) AS DIDIR,
SUM(DIALL) AS D IALL,
SUM(DIMAS) AS DIMAS,
SUM(DIALT) AS DIALT
FROM
LND_DW.STASOTES
GROUP BY
STA G1,
STAG2,
COMIT,
SATSO
) RCDFMT R_STATIS;

Handle short form data fetching from server

Currently, SQL query results are fetched from the server as an array of objects (each object has an attribute corresponding to the column name).

Instead, to save transport overhead, just use a two-dimensional array of data. This saves the JSON payload from repeating the same column names over and over.

iASP selection

Need some way for the user to configure which iASP to connect to

Delimited Object Names Are Not Handled Correctly

Problem

Working with schemas and objects that have delimited names is not currently possible due to the case folding done in the code.

Here is the view when attempting to work with a schema named "TestDelimiters". Note that the delimiters in the schema name are preserved, but the case within is not (it's folded to lowercase). That error ripples down the tree, where the queries used to populate the lists fold the schema name to uppercase, resulting in no objects displayed, even though every sub-folder should have an item (see setup script below).

Catalogs and Name Columns

• Ordinary names are stored as uppercase values.
• Delimited names are stored with the case preserved but without the delimiting quotes.

Application code must be aware of these rules when querying the catalog files.

Suggestion

The QSYS2.DELIMIT_NAME function can be used in the queries to properly delimit the name values being retrieved.
Example query that returns the table name "Delimited Table" with the correct case and delimiters.

SELECT QSYS2.DELIMIT_NAME(TABLE_NAME) FROM QSYS2.SYSTABLES WHERE TABLE_SCHEMA = 'TestDelimiters' and TABLE_NAME = 'Delimited Table';

Caveat

Changing the queries in src\database\schemas.ts to delimit the name values improves the front end as the Schema Browser will be able to list the various objects. However, as the user drills deeper, to list table columns for example, the delimited name displayed must be de-delimited when plugged into the QSYS2.SYSCOLUMNS queries in src\database\table.ts or src\database\view.ts.

Setup script

Here is a simple setup script to create a bunch of objects with delimited names.

DROP SCHEMA "TestDelimiters";

CREATE SCHEMA "TestDelimiters";
  
CREATE TYPE "TestDelimiters"."Delimited Type" AS BIGINT;
  
CREATE TABLE "TestDelimiters"."Delimited Table" ("Delimited Column" INTEGER DEFAULT NULL, 
CONSTRAINT "TestDelimiters"."Delimited Key" PRIMARY KEY ("Delimited Column"));

CREATE INDEX "TestDelimiters"."Delimited Index" ON "TestDelimiters"."Delimited Table" ("Delimited Column" ASC);

CREATE TRIGGER "TestDelimiters"."Delimited Trigger" AFTER INSERT ON "TestDelimiters"."Delimited Table" 
FOR EACH ROW MODE DB2SQL BEGIN DECLARE X INT; END;

CREATE VIEW "TestDelimiters"."Delimited View" ("Delimited Column") AS SELECT * FROM "TestDelimiters"."Delimited Table";

CREATE ALIAS "TestDelimiters"."Delimited Alias" FOR "TestDelimiters"."Delimited Table";

CREATE FUNCTION "TestDelimiters"."Delimited Function" ("Delimited Parameter" INTEGER) 
RETURNS INTEGER LANGUAGE SQL BEGIN RETURN "Delimited Parameter"; END;

CREATE PROCEDURE "TestDelimiters"."Delimited Procedure" (INOUT "Delimited Parameter" INTEGER) 
LANGUAGE SQL BEGIN SET "Delimited Parameter" = 13; END;

CREATE VARIABLE "TestDelimiters"."Delimited Global Variable" BIGINT;

Something went wrong

Dear all,

After connect to Ibm I system i got this error.
It' s seem that i m not able to retrieve this json document.
Pc access to internet using a proxy, so i don't know if this could be the problem... Anyway i can update all the addins so it's seem that if i have a problem linked to proxy it's related only to this
Any idea to solve it ?

Thanks

{"name":"HttpError","status":500,"request":{"method":"GET","url":"https://api.github.com/repos/ThePrez/CodeForIBMiServer/releases/tags/v1.0.0-alpha-33","headers":{"accept":"application/vnd.github.v3+json","user-agent":"octokit.js/2.0.14 octokit-core.js/4.2.0 Node.js/16.14.2 (win32; x64)","x-github-api-version":"2022-11-28"},"request":{"retryCount":3,"retries":3,"retryAfter":16}}}

Status bar item to display current SQL Job

• also provide clickable options to change isolation level
• We can change the color of the status bar item when there are uncommitted changes!! That'd be so cool

Better support for `FOR SYSTEM NAME` on create

Unable to use `schemas` actions when long query is running

JDBC configuration problem

Hello
Where can I enable CCSID 65535 translation ? I am having trouble viewing ibm i results and cannot find the ccsid 65535 translation option. I can view the same query results in IBM ACS with this option on and the hexadecimal numbers are correctly translated. Is there any option for that I could have missed in the settings ?

Thank you
Matt

Fix up readme

Make it accurate for 3.0.0

Call statements on the server component

Expose SQLJob API for external extensions

Collect references for `view` and `index`

Improved logging for server updater

Insert from Examples: include tree item for services_info

select service_name, example from qsys2.services_info

Have the client look for a specific server version on launch

Ask user if they want to auto start a job

Improve job log view on SQL Job Manager

Should probably add a few more columns to the display, at a minimum

• SEVERITY
• MESSAGE_TIMESTAMP
• MESSAGE_SECOND_LEVEL_TEXT

Server component: possible bug with string binding parameters

{
  "id": "query7",
  "type": "prepare_sql_execute",
  "sql": "CALL QSYS2.GENERATE_SQL(?, ?, ?, CREATE_OR_REPLACE_OPTION => '1', PRIVILEGES_OPTION => '0')",
  "rows": 2147483647,
  "parameters": [
    "Al's my pal today",
    "CaMel",
    "ALIAS"
  ]
}

{
  "id": "query7",
  "parameter_count": 3,
  "metadata": {
    "parameters": [
      {
        "type": "VARCHAR",
        "mode": "IN",
        "precision": 258,
        "scale": 0,
        "name": "DATABASE_OBJECT_NAME"
      },
      {
        "type": "VARCHAR",
        "mode": "IN",
        "precision": 258,
        "scale": 0,
        "name": "DATABASE_OBJECT_LIBRARY_NAME"
      },
      {
        "type": "VARCHAR",
        "mode": "IN",
        "precision": 10,
        "scale": 0,
        "name": "DATABASE_OBJECT_TYPE"
      }
    ]
  },
  "error": "[SQL0443] Token MY was not valid. Valid tokens: <FLOAT> <BIGINT> <DECIMAL> <INTEGER> <DECFLOAT>.",
  "success": false
}

servercomponent alpha-28 can't run this statement?

SELECT AUTHORIZATION_NAME, STATUS, NO_PASSWORD_INDICATOR, PREVIOUS_SIGNON,
TEXT_DESCRIPTION
FROM QSYS2.USER_INFO
WHERE SPECIAL_AUTHORITIES LIKE '%*ALLOBJ%'
OR AUTHORIZATION_NAME IN (
SELECT USER_PROFILE_NAME
FROM QSYS2.GROUP_PROFILE_ENTRIES
WHERE GROUP_PROFILE_NAME IN (
SELECT AUTHORIZATION_NAME
FROM QSYS2.USER_INFO
WHERE SPECIAL_AUTHORITIES like '%*ALLOBJ%'
)
)
ORDER BY AUTHORIZATION_NAME

Query Result Columns Too Wide

When running a query, the results output column widths appear to be determined based on the column data itself.
In most cases the resulting display is acceptable.

Problem

When the results include a column with a large length, the result columns end up rendering much wider than the view, making it impractical if not impossible to work with the data.

Example

select * from qsys2.sysviews

The SYSVIEWS catalog view includes as the 5th column the following:

VIEW_DEFINITION	TEXT	VARGRAPHIC(5000) CCSID 1200Nullable	The query expression portion of the CREATE VIEW statement. Contains the null value if the view definition cannot be contained in the column without truncation.

In this screenshot it shows how only the first column of the results can be viewed. The width of the data in the column is nominal, but the rendered width is excessive. In order to view the second column one must scroll several pages to the right. The larger the data in the column, the worse it gets.

The relevant code would seem to be in vscode-db2i/src/views/results/html.ts

style="min-width: max-content;"

Perhaps it should use a more conservative value for minimum width, and also set a maximum width so that the columns are no wider than the view itself.