RunSQL statement not respecting Code4i user library list

[rbeckham]

I have a sql script that:

• creates table,
• inserts labels on columns
• assigns permissions to that table.

I used to be able to connect to Code4i, open the script and hit Ctl+E to basically compile (run) all three statements. Everything worked great. My table was created and permissions set.

Something has changed. When I hit Ctl+E it seems like it does try to run one statement, I did find the "Run all" but when I run the sql statements now it does not respect my user library list in code4i ??

How can I run sql code in vscode and not have to hard code libraries now??

[SanjulaGanepola]

@sebjulliand In PR #448, I see we set Explain without running to Ctrl+e. Given that this conflicts with Code4i's code-for-ibmi.runAction command, I think we should change it. How about ctrl+alt+u?

@rbeckham You can get around this issue for now by using the Run Action button directly:

[sebjulliand]

@SanjulaGanepola right, I overlooked that conflict since when Actions are targeted at files other than .sql it's fine.

ctrl+alt+u sounds fine to me. It will differ from ACS' shortcut, but we can't have our cake and eat it 😅

[FLYERFIGHTER66]

Aside from the Ctrl+E issue (which was a key mapping problem) we have identified a similar issue with Db2 for IBM i not honoring the library list. Our investigation has confirmed that, although the the plug-in states that my target library IS in my list, the actual job running on IBM i does NOT contain the libraries specified in the plug-in. We are on version 1.16.0.

To elaborate, when we add a library on the [System] tab in the 'Library list' and Apply changes, the plug-in restarts the associated SQL job and we get a new job number. When I take that job and do a DSPJOB with it, the libraries requested do not appear in '13. Display library list, if active'.

[richardschoen]

I also confirmed the same issue that @FLYERFIGHTER66 reported. If I use ACS, the active IBMi job reflects my configured library list.

If I use the DB2 for i plugin the active job does not reflect the configured library list as noted in the previous comment.

[richardschoen]

A temporary workaround seems to be using a CL command to set the library list from a source member like this:
CL: ADDLIBLE MYLIB

[benetti-marco]

Same problem. the active job does not reflect the configured library list.
Code for IBM i v2.18.0
Db2 for IBM i v1.16.0

[SanjulaGanepola]

Okay so looks like there were 2 issues here and I have proposed fixes for both!

1. Fix library list not set on any SQL jobs #515 - Once this change is in, the job's library list should reflect what is set in the job's settings.
2. Fix conflicting Explain without running keyboard shortcut #514 - Once this change is in, ctrl+e will be Run Action like before and ctrl+alt+u will be Explain without running