Changelog
3.3.0
System and security insights — what Code for IBM i and Db2 for i users had to look for elsewhere.
- Security Audit Journal: the security audit journal (QAUDJRN) of the last 6 hours to 7 days as a heat map, one row per entry type and one square per hour — authority and sign-on failures in red, changes to authorities, profiles and system values in orange, other activity in blue. Next to it, the users with the most entries (with their AF and PW counts) and the latest failures and security changes; click one for the job log of its job. Needs *AUDIT or *ALLOBJ.
- Disk Units Map: every disk unit grouped by ASP, drawn as a can filled to its % used, with a bar for how busy its disk arm is; orange from 80 % used or 40 % busy, red from 90 % or 60 %. Says when the units of an ASP are filled unevenly (STRASPBAL balances them) and when a disk arm is so busy that jobs wait.
- Embedded SQL Statement Statistics: every SQL statement in the programs of a library (or one program), from QSYS2.SYSPROGRAMSTMTSTAT — how often it ran, total, average and longest time, how often its access plan was rebuilt — slowest first, with hints for statements never run, rebuilt on most runs or reading SELECT *. Right-click a library or a program, or use the command palette.
- VS Code tasks for IBM i: a
vanthrextask type fortasks.jsonthat runs a CL command (with extra libraries on the library list) or a PASE command (in an IFS folder) over the connection, with the Code for IBM i style variables &CURLIB, &USER, &HOST, &NAME, &EXT, &FILENAME and &RELATIVEPATH. Run Task offers ready-made tasks: compile RPG from the IFS, build with makei, show the library list. Bind a task to a key or run it before a launch, like any other task. - Lock Wait Chains: which job blocks which, right now — every object and row a job waits for (QSYS2.OBJECT_LOCK_INFO and RECORD_LOCK_INFO), with the jobs holding it on one side and those waiting on the other, and the head blockers (jobs that hold a lock others wait for and wait for nothing themselves) with how many jobs each blocks, directly or through others. Click a job for its job log, right-click for Work with Active Jobs; refresh every 10 seconds if you like.
- Limits Watch: what is getting close to an IBM i limit (QSYS2.SYSLIMITS) — rows in a table, locks in a job, objects in an IFS directory, members in a file… — as gauges of % of the maximum, the closest first, orange from 75 % and red from 90 %, filtered by category or text.
- Security Scorecard: a score from 0 to 100 for 14 security system values (QSECURITY, QPWDLVL, QPWDEXPITV, QMAXSIGN, QAUDCTL, QCRTAUT, QALWOBJRST…) against common recommendations, each with its current value and why it matters, plus the enabled profiles with *ALLOBJ, with a password older than a year or unused for 180 days. Nothing is changed from the page.
- Function Usage Map: who may use which IBM i function (QSYS2.FUNCTION_INFO and FUNCTION_USAGE) as a grid of functions by users and groups — allowed or denied, by their own entry or through *PUBLIC and the default — with the sensitive functions first (QIBM_DB_SECADM, QIBM_DB_SQLADM, QIBM_DB_ZDA, QIBM_ACCESS_ALLOBJ_JOBLOG…) and a warning for those open to everyone.
- User Storage Map: the storage each profile owns (QSYS2.USER_STORAGE), largest first, with its share of all user storage and how close it is to its MAXSTG; profiles at 90 % or more are called out before they can no longer create objects.
- Reply List Check: the system reply list (QSYS2.REPLY_LIST_INFO) with each message’s text, and what to look at: *ANY entries that answer every inquiry message, entries never reached because an earlier generic entry already matches, and entries that dump the job each time.
- System Health Overview: one page with disk space per ASP, limits close to their maximum, jobs waiting for a lock, jobs waiting for a reply (MSGW) and the security score, each as a card with a traffic light and a button to its detail page, under one overall status (“Everything looks fine”, “Some things are worth a look”, “Something needs attention now”). Each card is read on its own, so one you are not authorized to read says why and the others still work; Refresh every minute keeps it current on a second screen.
- Security Scorecard → Copy as a Markdown report: the score, every system value with its state and recommendation, and the profiles to look at, as Markdown on the clipboard (or in an editor) for an audit file, a ticket or an e-mail.
- Developer Toolbox: 50 more tools (Ctrl+Alt+A, or Vanthrex Tools: … in the command palette):
- Text (any source, on the selection): Sort the lines (A → Z); Sort the lines (Z → A); Remove duplicate lines; Reverse the lines; Trim the lines; Upper case (literals untouched); Lower case (literals untouched); Join the lines with commas; Split a comma list into lines; Quote each line; Number the lines; Count lines, words and characters; Text to an EBCDIC hex literal; EBCDIC hex literal to text; Put the lines in a comment box; Names to camelCase; Names to UPPER_SNAKE (SQL style); Align the selection as a table.
- SQL (on the statement at the cursor): SELECT → SELECT COUNT(*); Wrap in a common table expression (WITH); Add a row number column; Add paging (OFFSET … FETCH NEXT); Read without waiting for locks (WITH UR); CREATE TABLE → CREATE OR REPLACE TABLE; LABEL ON for every column of this CREATE TABLE; COMMENT ON for every column of this CREATE TABLE; INSERT from this CREATE TABLE; SELECT by key from this CREATE TABLE; UPDATE by key from this CREATE TABLE; MERGE (insert or update) from this CREATE TABLE; CREATE INDEX for this SELECT.
- RPG: CLEAR the selected variables; RESET the selected variables; Set the selected variables to empty; DSPLY the selected variables (for testing); DCL-S lines → a parameter list (DCL-PI); Parameter lines → DCL-S; Values → a SELECT / WHEN; Values → an array initialised with them; Insert a READ loop over a file; Insert an SQL cursor loop; Insert the program status data structure (PSDS); Insert a file information data structure (INFDS); Comment out with a date, author and reason.
- CL: Insert RTVJOBA with its variables; Insert CHKOBJ with MONMSG; Insert a RCVF loop over a file; Insert SNDPGMMSG (escape, completion…); Put the selection between OVRDBF and DLTOVR; Insert RTVSYSVAL with its variable.
- Developer Toolbox: 50 more tools, second batch (Ctrl+Alt+A, or Vanthrex Tools: … in the command palette):
- RPG snippets: Insert a date conversion between formats; Insert writing lines to an IFS file (SQL); Insert reading an IFS file line by line (SQL); CL command → RPG call (QSYS2.QCMDEXC); Insert reading and writing a data area; Insert sending and receiving a data queue entry; Insert a job log message (QMHSNDPM); Insert a time measurement (milliseconds); Insert a commit / rollback block; Insert a %LOOKUP in a sorted array; A CSV line from the selected variables; A JSON object from the selected variables (SQL); Getter and setter procedures for the selected variables; Insert a retry loop with a delay; Insert sending an e-mail (SNDSMTPEMM).
- SQL builders: SELECT → one JSON array (JSON_ARRAYAGG); CREATE VIEW from this SELECT; A table from this SELECT (CREATE TABLE AS … WITH DATA); DELETE → SELECT (see the rows first); UPDATE → SELECT (see the rows first); Add audit columns to this CREATE TABLE; Add an identity column to this CREATE TABLE; DROP TABLE IF EXISTS for this CREATE TABLE; Insert an SQL procedure skeleton; Insert an SQL function skeleton; Audit trigger for this CREATE TABLE; Find duplicate rows in this table; Only the last days (date filter); Who has this table locked? (IBM i Services); Size and rows of this table (IBM i Services).
- CL snippets: Insert a CL program skeleton with error handling; Insert a retry loop with DLYJOB; Put the selection between ALCOBJ and DLCOBJ; Submit the selected command to batch (SBMJOB); Insert CPYF (created when missing); Insert saving a library to a save file; Insert a date conversion (CVTDAT); SQL statement → RUNSQL for CL; Insert a question to the user (SNDUSRMSG); Insert RTVOBJD (exists, last used, changed).
- IBM i converters: Convert a date between IBM i formats; Insert today’s date in an IBM i format; Hex ↔ decimal; Short system name for a long SQL name; What is this CCSID?; Copy DSPMSGD for the message ID; SQL types → RPG types; RPG types → SQL types; Seconds ↔ h:mm:ss; Size and range of a numeric type.
- Network Configuration: TCP/IP of the connection, network attributes, the Telnet, SMTP and time (NTP) servers, HTTP servers, relational database entries and the subsystems server jobs are routed to (QSYS2.TCPIP_INFO, NETWORK_ATTRIBUTE_INFO, TELNET_SERVER_ATTRIBUTES, SMTP_ATTRIBUTES, TIME_PROTOCOL_INFO, HTTP_SERVER_INFO, RDB_ENTRY_INFO, SERVER_SBS_ROUTING). Read only.
- Fix Currency: Firmware level against IBM’s, defective PTFs installed and CVEs not yet fixed, plus the Electronic Service Agent status (QSYS2.FIRMWARE_CURRENCY, DEFECTIVE_PTF_CURRENCY, CVE_CURRENCY, ELECTRONIC_SERVICE_AGENT_INFO). Read only.
- Hardware and Devices: The status of lines, controllers and devices, the hardware resources and NVMe devices, failed or damaged ones in red (QSYS2.CONFIGURATION_STATUS, HARDWARE_RESOURCE_INFO, NVME_INFO). Read only.
- Subsystem Setup: For one subsystem or all: autostart jobs, routing entries, prestart jobs, job queue entries, workstation and communications entries and pools (QSYS2.AUTOSTART_JOB_INFO, ROUTING_ENTRY_INFO, PRESTART_JOB_INFO, JOB_QUEUE_ENTRIES, WORKSTATION_INFO, COMMUNICATIONS_ENTRY_INFO, SUBSYSTEM_POOL_INFO). Read only.
- Save Files and Tapes: Save files with what and when they saved, tape cartridges and media libraries (QSYS2.SAVE_FILE_INFO, TAPE_CARTRIDGE_INFO, MEDIA_LIBRARY_INFO). Read only.
- System Diagnostics: Problems logged, recently ended jobs (abnormal ends in red), the largest temporary storage buckets, active watches, Java virtual machines and Collection Services (QSYS2.PROBLEM_INFO, ENDED_JOB_INFO, SYSTMPSTG, WATCH_INFO, JVM_INFO, COLLECTION_SERVICES_INFO). Read only.
- Security Configuration: The security attributes, the certificates applications use and the exit points with their programs (QSYS2.SECURITY_INFO, CERTIFICATE_USAGE_INFO, EXIT_POINT_INFO). Read only.
- Job Internals: For one job: its open files, the IFS objects it uses and its database connections (QSYS2.OPEN_FILES, IFS_JOB_INFO, ACTIVE_DB_CONNECTIONS). Read only.
- Rename Member and Change Descriptions: Rename a member (RNMM) and change the description of a member (CHGPFM) or an object (CHGOBJD) from the Libraries view.
- Library List Order and Clean-up: Move a library up or down in your library list, and remove the libraries that no longer exist.
- Download Members to This PC: One member, a source file or every source file of a library to a local folder, laid out Library → File → Member, File → Member or all in one folder.
- Replace a Member from a File on This PC: Upload a local file into a member: replace a member, or add one to a source file (the name and type come from the file name).
- Compare with an IFS File or a File on This PC: Compare the open member or file side by side with any IFS file or a local file.
- Shared Snippets: Save the selection (or the whole file) as a snippet in an IFS folder and insert snippets from it; point vanthrex.sharedSnippets.folder to a folder the team can write to so everyone shares them.
- Find IFS Files by Name: Find stream files by name or pattern (*.rpgle, order…) under a folder and all its subfolders, and open one.
- Next and Previous Changed Block: Jump to the next or previous block of lines changed since the highlight date (or not saved yet).
- Library Actions: Change the description of a library, copy it to a new library (CPYLIB), rename it, clear it or delete it. Clear and delete ask you to type the library name; IBM libraries (Q…, SYS…, #…) cannot be renamed, cleared or deleted from here, and the library list follows a rename or a delete.
- Clear and Copy Table Data: Clear the rows of a table (CLRPFM, after typing its name), or copy its rows to another table: replace or add them, columns matched by name, or create the copy (CPYF).
- Generate CALL Statement: A ready-to-fill CALL (procedure), VALUES (scalar function) or SELECT … FROM TABLE() (table function), one named parameter per line with its mode and type, read from QSYS2.SYSROUTINES and SYSPARMS.
- SQL from a JSON Sample: The selected (or copied) JSON turned into a VALUES JSON_OBJECT / JSON_ARRAY statement that returns it; replace the sample values with your columns.
- Maintained Temporary Indexes: The temporary indexes the query engine maintains (QSYS2.MTI_INFO), most used first.
- Who Has It Locked? (IFS): Right-click an IFS file or folder (or the editor of an IFS file) to see the jobs that have it open right now (QSYS2.IFS_OBJECT_LOCK_INFO), with their user, number of opens and how they use it. Jobs that keep others from writing it (share-none modes, save locks, check-outs) are first and in red; click one for its job log, or Work with the blocking jobs. On a folder, every stream file directly in it is checked, and Include subfolders checks the whole tree below it. When saving an IFS file fails while other jobs have it open, Vanthrex says how many (and how many keep others from writing it) and offers the page in one click. Each job shows its status in plain words (waiting for a reply, waiting for a lock, running…), its function and subsystem; a job waiting for a reply is marked, since a stuck job is often the one holding the file. Tell me when it is free watches a file every 10 seconds (up to 30 minutes, cancellable) and says when no job keeps others from writing it any more, with a button to open it. Read only; needs IBM i 7.3 TR11, 7.4 TR5 or later.
- System Checks (System Checks… in the command palette or the quick menu): one menu of all the system checks (with the new System Diagnostics, Security Configuration, Fix Currency, Hardware, Network, Subsystem Setup and Save Files pages) and five new pages (
src/features/systemChecksView.ts,src/core/systemChecks.ts):- Backup freshness: every user library with the date of its last save, never saved or older than
vanthrex.backupDays(7 by default) marked. - Sign-on problems: users locked out after invalid sign-on attempts, users close to it, passwords and profiles expired or expiring — each with its fix, opened in the CL prompter (F4) so nothing changes without a look.
- Job descriptions that name a user: job descriptions with USER(name) instead of *RQD, high when *PUBLIC may use them and the user is powerful.
- User objects in IBM libraries: your programs, files and commands in QSYS, QSYS2 or QGPL, at risk on a release upgrade.
- Environment variables: the system and job environment variables, the well-known ones (JAVA_HOME, QIBM_QSH_CMD_OUTPUT, QIBM_MULTI_THREADED, PASE_PATH…) explained; change one in the prompter.
- Backup freshness: every user library with the date of its last save, never saved or older than
- Developer Toolbox: 24 more tools, third batch (Ctrl+Alt+A, or Vanthrex Tools: … in the command palette):
- RPG recipes: Add an SQLSTATE check after every EXEC SQL; Insert GET DIAGNOSTICS (message of the last SQL error); Insert splitting a text into an array; Insert a FOR-EACH loop over an array; Insert sorting a data structure array by a subfield; Insert the first and last day of the month; Insert days, months and years between two dates; Insert SND-MSG (job log or escape message); Insert a multi-row FETCH (100 rows at a time); Insert a check that an object exists (SQL).
- SQL recipes: Top rows per group (ROW_NUMBER); Add a running total column; Add the previous row’s value and the change (LAG); Add each row’s percent of the total; Pivot: one column per value; Values of a column as one list per group (LISTAGG); Rows that differ from another table (EXCEPT); Delete duplicate rows, keep the first (preview first); Missing numbers in a numbered column (gaps); Insert a recursive query (parent / child tree).
- CL recipes: Insert a loop over the objects of a library; Insert a loop over the members of a file; Insert a QShell command that stops on failure; Insert a library list change that is put back.
Fixes
- PDM: work with objects (WRKOBJPDM) showed an empty list with
SQL0104 Token EXISTS not validon some systems (issue #16). The query that marks source files (PF-SRC) used EXISTS inside a CASE, which some Db2 for i levels do not accept; it now uses a LEFT JOIN. The same change was made to the Messages view (which inquiry messages still need a reply). - Members opened for display (PDM option 5) are now marked read-only in a way every VS Code version accepts.
3.2.1
Fixes
- IFS Space Map: opening it on a folder such as
/home/USERfailed withSQL0443 INVALID OMIT_LIST PARAMETER SPECIFIED. The file systems to leave out (QSYS.LIB, QNTC, QFileSvr.400, QOPT, QDLS) are now passed only when they are inside the folder, that is from/; and if a system still refuses the list, the map is read again without it.
3.2.0
Visual insights — see a library and a night of batch work at a glance.
- Library Space Map: every object of a library as a tile sized by its disk space (a treemap), grouped and coloured by kind — programs, files, source files, save files, journals, data objects. Switch to Colour by last used to see what has not been used for a year, type to highlight objects, click a kind in the legend to hide it, click a tile for the object information. Totals, the biggest kind, the space not used for a year and the 15 largest objects are listed under the map. Right-click a library → Library Space Map, or from the quick menu.
- Batch Job Timeline: the batch jobs of the last 6 hours to 7 days as bars on a time axis (from the history log), green when they ended normally, red when abnormally, blue while still running; overlapping jobs get their own lane, so you see what ran at the same time. Filter by job name (
ORD*) or user; click a bar for the job log, right-click for its run history. Tiles show runs, failures, jobs still running, the longest run and the CPU used; the failed and the longest runs are listed below. - Index Advice Chart: the indexes the Db2 optimizer asked for while running queries over a library (QSYS2.SYSIXADV), with advice for the same table merged when the keys start the same way, ranked by how often slow queries asked for them (bar chart), and the temporary indexes (MTI) the system had to build. One click writes the
CREATE INDEX(or encoded vector index) statement — or all of them as one script — into an SQL editor; nothing is created until you run it. Right-click a library → Index Advice Chart (the table report Index Advisor is still there). - IFS Space Map: a treemap of the folders and files below an IFS folder, sized by disk space and coloured by kind (folders, source, logs, archives and save files, data, documents). Click a folder to go in, use the path at the top or Up one level to go back, click a file to open it; the 15 largest files are listed. Right-click a folder in the IFS view → IFS Space Map.
- Source Change Calendar: a year of source changes in a library or source file as a heat map, one square per day; click a day to list the members changed that day and click a member to open it. Tiles show the members changed this year, the active days, the busiest day and the longest run of days; a bar chart shows the changes by source type. Right-click a library or source file → Source Change Calendar.
- Active Jobs Map: every active job as a tile inside its subsystem, sized by CPU time, temporary storage, threads or disk I/O, and coloured by status — red (and pulsing) when it waits for a reply (MSGW), orange in a lock wait, green running, blue waiting. Highlight jobs by typing, refresh every 15 seconds if you like; click a job for its job log, right-click for Work with Active Jobs (option 7 answers the message). The jobs waiting for a reply and the top 10 are listed under the map.
- Journal Activity Heat Map: which tables a journal saw change in the last 6 hours to 7 days, one row per table and one square per hour (the darker, the more changes), with inserts, updates and deletes per table as a stacked bar, the busiest hour and the totals. Click a table for its journal entries — who changed which row, from which program.
Improvements
- Library Space Map: an object that was never used is coloured by its creation date, so an object created last week no longer shows as “not used for over a year”; its tooltip says when it was created. The same library on two systems opens two maps instead of reusing the first one.
- Batch Job Timeline:
_in a job or user name is matched as a character, not as a wildcard (only*is the wildcard), soORD_EXTno longer also showsORDXEXT.
3.1.0
More power in the editor
- DDS checks while you type (PF, LF, DSPF, PRTF;
vanthrex.lint.dds): names longer than 10 characters, a field or record format declared twice, fields with no length (and no reference), more decimals than the length, lengths beyond the data type, key fields that are not in the record, display fields or constants outside the screen (DSPSIZ, *DS3 / *DS4) and display fields on top of each other. Reference fields, logical files and conditioned fields are left alone. DDS members are part of the Code Health Report too. - Format Document for CL (Shift+Alt+F): the prompter layout — labels in column 1, commands in column 14, parameters from column 25, long commands split with
+before column 80. Statements with a comment inside are kept as they are. - RPG semantic highlighting (
vanthrex.editor.semanticHighlighting): parameters, constants and CONST parameters (read-only), data structures and subfields, procedures, files and subroutines each get their own colour, and a global variable used inside a procedure is marked — on top of the existing syntax colours. - Names edited together: renaming a procedure or a data structure on its
DCL-PROC/DCL-DSline changes the name on itsEND-PROC/END-DSline at the same time, and the other way round. - END lines indented as you type (
vanthrex.editor.indentOnType): typing the;of ENDIF, ENDDO, ELSE, WHEN, OTHER, ON-ERROR, END-PROC… moves the line under its opener. - Links that open a member at a line: Copy a Link That Opens This Line (right-click, or Ctrl+Alt+A → Copy) gives a
vscode://…link for tickets, chats and e-mails; whoever clicks it, with Vanthrex installed, opens the same member (or IFS file) at the same line, on the named system after a confirmation. - Clickable IBM i references in every terminal (
vanthrex.editor.terminalLinks):LIB/FILE(MEMBER)opens the member, message IDs such asCPF9801orMCH1210are explained, IFS paths open the file — in the PASE terminal, build output, and any other terminal.
Fixes
- A prototype (
DCL-PR) and the procedure with the same name (DCL-PROC) are no longer reported as a duplicate declaration. - The README and the documentation now have screenshots, a “Try it with examples” page with sample RPG, CL, SQL and DDS sources, and the documentation is organised by area (Getting started, Features, What’s new, Reference, Help).
3.0.0
Vanthrex 3.0 — everything for IBM i development in one extension. AS/400 GO menus and green-screen commands, one-step import from Code for IBM i, team setup files, team coding standards and a code health report for whole libraries, on top of the 2.6 suggestions, checks and Developer Toolbox.
- GO menus, AS/400 style (
GO MAIN,GO PROGRAMMER,GO SYSTEM,GO FILE,GO USER,GO CMN,GO SECURITY,GO PROBLEM; Ctrl+Alt+Shift+M, the quick menu, or typeGOon the command line): the IBM i menus with their option numbers. Type a number, any command, orGO <menu>on the Selection or command line; Back works like F12. - Work with My Jobs: the active jobs of the signed-on user.
- GO RPG — RPG Development menu: 28 RPG tools in one place (compile, code checks, fixed → free, subroutine → procedure, prototypes, binder source, flowchart, DS layout, RPGUnit, debug, where used…), open first in the AS/400 Menus view.
- Favorites and Recent in the AS/400 Menus view: star any option or command (inline button or right-click); the last 8 you used are listed at the top.
- Reliable clicks: tools that work on the open source now say “Open an RPG source first” (with Find a Member…) instead of silently doing nothing; the view is built in memory, so it opens instantly and keeps what is expanded.
- AS/400 Menus view in the side bar: every GO menu with its numbered options, and all 5250 commands that open a screen, A to Z by area (jobs, database, objects, security…). Click to open; right-click or the inline button to prompt the command on the command line (F4).
- About 30 more green-screen commands on the 5250-style command line open the matching screen:
DSPPFM,UPDDTA/STRDFU,STRQRY/WRKQRY,WRKDTAQ,WRKDTAARA,EDTDTAARA,WRKMSGF/WRKMSGD,WRKBNDDIR,STRDBG,WRKJRN,DSPJRN,WRKAUTL,EDTOBJAUT,DSPLOG,WRKPTF,WRKSYSACT,EDTLIBL,WRKLNK,WRKLIB,WRKF/WRKPGM/WRKSRVPGM/WRKMOD/WRKCMD,SIGNOFFandGO.
Everything in Vanthrex, for one person or a whole team
- Import My Code for IBM i Setup: connections (host, port, user, SSH key), library lists, current library, home folder, library list profiles (as Vanthrex library list sets) and compile actions (variables such as
&OPENLIB,&OPENSPF,&OPENMBR,&BUILDLIBconverted), from your Code for IBM i settings and the workspace.vscode/actions.json. You choose what to import; passwords are never read — you type each one at the first connection. Both extensions can stay installed while you try Vanthrex. - Team setup file: export the connections (without user names, passwords or key paths), library list sets, CL macros, compile actions, checks, team standards and AI privacy settings to one JSON file; colleagues import it, type their user profile once, and work with the same setup.
- Team coding standards (
vanthrex.standards, all off until chosen): constants in upper case, names written as declared, QUALIFIED data structures, no globals in procedures, no global or local subroutines, no OCCURS or CTDATA, no SQL joins or EXECUTE IMMEDIATE in programs, a description above each procedure, conditions in parentheses, indentation, prototypes with EXTPGM / EXTPROC, directive case, a naming pattern and a procedure size limit — checked while you type. Import Coding Standards from rpglint.json reads the rules a team already uses with Code for IBM i. -
Code Health Report of a Library: every Vanthrex check (RPG, CL, SQL and your standards) on every indexed member of a library — or all of them — in seconds and offline: a score and grade, the members to look at first (click to open), and the findings by check, with CSV and Excel export. Run it before a release and compare after.
- Marketplace listing: clearer name (Vanthrex – IBM i Development Tools (RPG, CL, SQL)) and description, 30 search keywords (IBM i, AS400, iSeries, RPGLE, ILE RPG, SQLRPGLE, CL, Db2 for i, IFS, DSPPGMREF, F4 prompt, PDM, SEU, fixed to free…) and the Linters, Formatters and Notebooks categories.
- README rewritten for new visitors: install and connect in three steps (with
code --install-extension gauravgupta0612.vanthrex-ibmi), why teams use it, what you can do by task, who it is for, the new shortcuts, and where to get help; the full feature table by version stays below.
2.6.0
Daily RPG development — about 150 small features for the code you write every day. Everything works on the open source, with no round trip to the IBM i, so it is instant and works offline.
19 new code checks (each one can be switched off in vanthrex.lint.rules)
- Old fixed-format operation codes (MOVE, Z-ADD, CAT, SCAN…) with their free-form equivalent, and a quick fix that converts the line.
- CHAIN not followed by
%FOUND, embedded SQL whose SQLCODE / SQLSTATE is never tested, cursors opened but never closed. DSPLYleft in the code, statements after RETURN / LEAVE / ITER that never run, empty IF / DOW / FOR / MONITOR blocks, SELECT without OTHER.- A literal longer than the field it is assigned to, a name declared twice, blocks nested deeper than
vanthrex.lint.maxNesting(6). - Procedures: input parameters that could be CONST, unused parameters, a return value with no RETURN, procedures neither exported nor called, more than 8 parameters.
- Free-form programs without CTL-OPT, code after column 80 in column-limited sources, large blocks of commented-out code.
- Quick fixes for most of them: add CONST, remove the DSPLY or unreachable line, insert CTL-OPT, an
IF NOT %FOUND, an SQLCODE test or OTHER, wrap the long line.
Editing
- Close the Open Block (Ctrl+Alt+.) and automatic
ENDIF/ENDDO/ENDFOR/ENDSL/ENDMON/ENDSR/END-PROCon Enter (vanthrex.editor.autoCloseBlocks). - Surround With… (Ctrl+Alt+W): IF, MONITOR, DOW, FOR, SELECT, BEGSR or a comment around the selection.
- Convert IF / ELSEIF to SELECT / WHEN.
- Toggle RPG Comment (Ctrl+/):
//in free form,*in column 7 in fixed form. - Change Keyword Case…: operation codes and keywords to lower or upper case, names and literals untouched.
- Sort Declarations by Name and Align Declarations for a block of DCL-S / DCL-C.
- Wrap Long Line at
vanthrex.editor.wrapColumn(80 in column-limited sources), Insert Column Ruler, Clear Change Markers (columns 1-5). - Format Embedded SQL under the cursor, in place.
- Insert Procedure Skeleton… and a documentation header from the procedure interface.
- Add DCL-PR From the Source Index: the prototype of a procedure of another member, built from its DCL-PI.
- Expand selection by statement and block (Shift+Alt+→) in RPG and CL.
- 10 new snippets: PSDS, INFDS, NOMAIN module, procedure with MONITOR, SQL INSERT / UPDATE with SQLCODE test, SQL cursor loop, QCMDEXC, DATA-INTO JSON, date arithmetic.
Navigation and help
- Go to Next / Previous Procedure (Ctrl+Alt+PageDown / PageUp) and the current procedure in the status bar.
- Parameter names shown before call arguments (inlay hints), reference counts above procedures (
vanthrex.editor.referenceCodeLens, off by default). - Call hierarchy (Shift+Alt+H) for procedures and subroutines; procedures of all indexed sources in Go to Symbol in Workspace (Ctrl+T).
- Completion of the names declared in the source, procedure calls with their parameters, and subroutines after EXSR.
- Hover on
/COPYand/INCLUDEshows the start of the member. - Fixed-format RPG: the column fields of the current line are shaded with their name on hover.
- Open IBM Documentation for the Word under the cursor (release in
vanthrex.editor.docsRelease).
Suggestions while you type (grey text, Tab accepts, Esc ignores)
- The next statement you usually write, offline and instant:
IF %FOUND(file)after CHAIN,READE/READafter SETLL,EXEC SQL OPENafter DECLARE CURSOR andFETCH NEXTafter OPEN, an SQLCODE test after SELECT INTO / INSERT / UPDATE / DELETE / FETCH,DCL-PIafterDCL-PROC, CTL-OPT right after**FREE. - The type of a new variable from its name and from the variables already declared (
dcl-s custName→ the type ofshipName;…Date→date,…Total→packed(11:2),is…→ind,…Count→int(10),…Stmt→varchar(3000)). - The file of
%FOUND(/%EOF(/%EQUAL(from the last CHAIN, SETLL or READ, the parameters of a call (calc(→custNo: amount);),*INLR = *ON;, the usual CTL-OPT, DCL-F and DCL-DS keywords. - CL: the MONMSG that usually follows a command, with its message (CHKOBJ → CPF9801, DLTF → CPF2105, CRTLIB → CPF2111, ADDLIBLE → CPF2103… 29 commands), DCL for the PGM PARM parameters not declared yet, and a TYPE / LEN from the variable name.
- Nothing is suggested inside a comment or a literal, in the middle of a line, or in fixed-format specs. Turn IBM i Suggestions On or Off (
vanthrex.editor.inlineSuggestions). - AI suggestions (off by default):
vanthrex.ai.inlineSuggestionsalso asks your AI model when you pause typing (vanthrex.ai.inlineDelay, 500 ms) and no offline suggestion applies, in RPG, CL, SQL and DDS. The code around the cursor goes through the same guard as the chat (secrets and personal data replaced, denied libraries and protected systems never sent, every request in the audit trail); after three failures in a row it stops until turned on again. AI: Turn Suggestions While Typing On or Off asks for confirmation first.
Developer Toolbox — every tool in one menu (Ctrl+Alt+A, the $(tools) IBM i button in the status bar, or right-click)
- The menu shows only what fits where you are: the language of the file (RPG, CL, SQL, DDS) and whether text is selected, grouped (Rewrite, Generate, SQL, Edit, Copy, Select, Fix all, Help), searchable. The 2.6 commands are in it too, so nothing has to be remembered.
- Rewrite RPG: compound assignments (
x = x + 1→x += 1, only when the meaning stays the same), EVAL / CALLP removed, a condition negated (=↔<>, NOT added or removed),= *ON/= *OFFsimplified, a value wrapped with a built-in (%TRIM, %CHAR, %DEC, %UPPER, %SCANRPL… 23 of them), DCL-S lines grouped in a qualified DS, a subroutine converted to a procedure (EXSR x → x(), LEAVESR → RETURN),NAME valuelines to DCL-C. - Generate: SQL INSERT / SELECT INTO / UPDATE from a data structure, a DS template from CREATE TABLE and CREATE TABLE from a DS, a program header (author, date, change history), a section separator, date / time / timestamp literals, a global CL error handler (MONMSG CPF0000 → ERROR: that resends the message).
- SQL: how many rows will change (
SELECT COUNT(*)added above an UPDATE / DELETE), limit a SELECT to 100 rows, SQL to embedded SQL (?→:host) and embedded SQL to a runnable script, SQL keywords upper / lower, lines to anIN (…)list, CSV lines to VALUES / INSERT, and WHERE suggested while typing after UPDATE … SET or DELETE FROM. - Fix all at once: declare every undeclared SQL host variable, add CONST to every read-only parameter, remove every DSPLY (after a confirmation), declare every undeclared CL variable.
- Edit and copy: keep a line as a comment (with your name and the date) before changing it, a literal from the selection, aligned
=signs and end-of-line comments, blank lines removed, the source cleaned (tabs, trailing blanks, invisible spaces), CL in upper case and long CL commands wrapped with+; copy as Markdown, a reference to the line (LIB/FILE(MBR) line 42), the compile command of the member (CRTBNDRPG, CRTSQLRPGI, CRTBNDCL, CRTPF, CRTDSPF… 14 types), a CL command asCALL QSYS2.QCMDEXC(…), the DCL-PR or a call of the procedure. - Select the current block or procedure; What is new in 2.6 opens this page.
- Hovers: a literal shows its length (bytes for
X'…'), a declared RPG variable its storage size (vanthrex.editor.sizeHovers).
CL checks while you type (vanthrex.lint.cl, each one also in vanthrex.lint.rules)
- Variables used but not declared (quick fix: a DCL with a type from the name) and declared but never used (quick fix: remove the DCL).
- GOTO to a label that does not exist; DO / DOWHILE / DOUNTIL / DOFOR / SELECT / SUBR not closed, or an ENDDO too many.
- DCL / DCLF after the first command; a literal longer than the
*CHARvariable (it is cut); text that is not a number put in a*DEC/*INTvariable (MCH1202 at run time). - Library names written in commands (QSYS, QTEMP, QGPL… are fine). A DCLF or INCLUDE turns the undeclared-variable check off, since they bring variables the source does not show.
SQL checks in SQL scripts (vanthrex.lint.sql) and in embedded SQL in RPG
- UPDATE or DELETE without WHERE (quick fix in scripts: WHERE 1 = 1 when every row is meant), DROP / TRUNCATE flagged as irreversible,
= NULL/<> NULLthat is never true, SELECT INTO without WHERE (SQLCODE -811). - Statements inside CREATE PROCEDURE / FUNCTION / TRIGGER are left alone; text in literals and comments is ignored.
More snippets: CL RCVF loop, DOWHILE, SELECT / WHEN / OTHERWISE, create-if-missing with CHKOBJ, OVRDBF … DLTOVR, SBMJOB, RTVJOBA, SUBR; SQL safe UPDATE (COUNT first), duplicate keys, table sizes, columns of a table, programs using a file.
7 checks on how variables are used (from their declared type, free and fixed form; also in vanthrex.lint.rules)
%SUBSTwith a start or length beyond the field (RNX0100 at run time) and array indexes outside 1-DIM (RNX0121).- Numeric literals too big for the field (
packed(5:2)= 1234.5,int(5)= 40000) and text literals assigned to a number, with a quick fix that converts with%DEC/%INT. - Numbers compared with
*BLANKS, with a quick fix to compare with 0. - SQL host variables (
:name) that are not declared, with a quick fix that declares them with a type guessed from the name. EXSRof a subroutine that is not in the source, with a quick fix that creates the BEGSR … ENDSR.- These checks stay silent when they cannot be sure: a /COPY, an EXTNAME / LIKEREC structure or a declared file may bring the name.
More help while typing
- After
DCL-PIin a procedure whose DCL-PR is already written, its parameters are suggested (and END-PI if missing);WHENafterSELECT; MONMSG after RCVF (CPF0864), RTVDTAARA / CHGDTAARA, CRTDTAQ, MOVOBJ and GRTOBJAUT. - Toggle Value (Ctrl+Alt+Shift+T):
*ON↔*OFF,*YES↔*NO,AND↔OR,=↔<>,<↔>=,SETLL↔SETGT,READ↔READP,*START↔*END… at every cursor, keeping the case. - Very large sources (over 3 MB) keep the basic checks only, so the editor stays responsive.
6 checks for errors found late (also in vanthrex.lint.rules)
- A DCL-PR that no longer matches the DCL-PI of its procedure (parameter count, types, CONST, return value), with a quick fix that updates the prototype from the interface.
- Calls with fewer arguments than the required parameters or more than the procedure has (
*NOPASSunderstood, colons inside literals ignored). - A CONST parameter that is changed, LEAVE or ITER outside a loop, DOW / DOU loops on a constant condition with no LEAVE or RETURN inside.
- Library names written in EXTFILE / EXTDESC / EXTNAME or in embedded SQL (QSYS2, SYSIBM, QTEMP… are fine).
Modules and service programs
- Generate Binder Source From the Exports: STRPGMEXP with a named signature; an open binder source is updated in place, keeping its export order and adding new exports at the end.
- Generate a Prototype Copybook From the Exports: every exported procedure’s DCL-PR, with a
/DEFINEguard against a second /COPY. - Add a Header to Every Procedure that has no comment above it, with its parameters and return value.
- Join the Lines of a Statement (the reverse of Wrap Long Line), refused when a
//comment or a continued literal would break the code. - Remove Unused Declarations…: one-line DCL-S / DCL-C never used, after a confirmation listing them (one Ctrl+Z restores them).
- 6 more snippets:
*PSSR, procedure with ON-EXIT, array of data structures, GET DIAGNOSTICS, SET OPTION, DCL-ENUM.
Robustness
- Each document is parsed once per change and shared by hints, completion, lenses, call hierarchy and the status bar; sources over 40,000 lines skip the per-line decorations.
- A provider that meets an unexpected source returns nothing instead of failing, and each group of checks runs on its own, so one never hides the others.
- Automatic END lines are never added during undo / redo, with several cursors, or when the line changed meanwhile.
- Snippet text (Surround With, call completion, headers) escapes
$,}and\, so names like$amountstay intact. - Format Embedded SQL keeps a comment after the
;; Wrap Long Line works from the Problems view; the deprecated-opcode fix is offered only when the conversion is complete.
2.5.0
AI with your data protected
Everything sent to the AI now goes through one guard, and nothing the AI does can change the IBM i.
- Secrets never leave your computer: passwords (CL
PASSWORD(…)andCHGVARof a password variable,pwd = …,DB_PASSWORD=…,password: …, ODBC / JDBC connection strings, FTPPASSandUSER name password, SQLUSING '…'and encryption passwords, constants named like a password), API keys, tokens (GitHub, GitLab, npm, AWS, Slack, Google, JWT, Basic and Bearer), private keys and credentials in URLs are replaced by placeholders (xxxx1, xxxx2…) before anything is sent — in the source, query results, job logs, tool results and the chat history. The AI keeps the placeholders; the real values are put back only on your computer, in the answer you read and in the code you apply. Special values (*NONE,*USRPRF) and variables (&PWD,:host) are left alone. - Personal data and internal names hidden: e-mail addresses, payment card numbers (Luhn-checked), IBANs (checksum-checked), US social security numbers, international phone numbers, IP addresses, the host names of your connections, and your own list of words (customer names, project code names) — each can be switched in the settings.
- Sensitive columns masked: query results the AI reads show
xxxxfor columns such as PASSWORD, EMAIL, PHONE, IBAN, CARD, SALARY, BIRTH (your own list invanthrex.ai.sensitiveColumns). - Production stays private: on protected connections the AI reads source and catalog facts (object descriptions, columns, members, indexes, command definitions, message help) but cannot run queries of its own, read spooled files or non-source IFS files (
vanthrex.ai.productionData: metadata / full / none);vanthrex.ai.otherSystemsDatadoes the same for the other systems. - Safer AI queries: a query the AI writes may not call functions that reach other servers or read files, spooled output, journals, data queues or data areas (HTTP_GET, IFS_READ, SPOOLED_FILE_DATA, DISPLAY_JOURNAL, QCMDEXC…); a sensitive column renamed with AS or used in an expression is refused; unqualified tables are refused when a hidden library is in the library list; card numbers stored as numbers are hidden too.
- Source means source: the AI reads members of source files only (never members of data files), refuses /QSYS.LIB paths and key, certificate and credential files.
- No way out through links: real values are put back only for placeholders sent in that request, and never inside a link or URL of an answer (so injected text cannot make the answer send a secret anywhere). Values shown in an answer are hidden again when the chat history is sent back.
- Libraries never shared:
vanthrex.ai.deniedLibraries(wildcards likePAY*) — sources, objects, queries and authorities in them are refused, even when named inside a string. - No surprise reads: IFS files that look like keys, credentials or system files are refused; every query still asks first and is read-only.
- Prompt-injection guard: source, rows, job logs and messages are sent as framed data the model is told never to obey.
- Audit trail and transparency: after an answer you see how many values were hidden; AI: Privacy and Security shows the settings, what was hidden this session and every request (time, system, feature, size — never the content), also kept in the Vanthrex AI Audit output and a file; AI: Preview What the AI Sees shows the open file side by side with what would be sent.
New AI features
- AI: Change the Selected Code… (Ctrl+Alt+E): say what to change (“add MONITOR around the I/O”, “rename x to customerNumber”, “convert to free form”); the proposal opens as a diff and is applied only when you click Apply (one Ctrl+Z undoes it), never if the source changed meanwhile.
- ✨ Explain · Document · Tests above every RPG procedure and subroutine (
vanthrex.ai.codeLens). - /tune — Make This SQL Faster: reads each table’s size, its indexes (and how often queries used them) and the optimizer’s index advice, then rewrites the statement and writes the CREATE INDEX worth creating.
- /sqlio — Convert File I/O to Embedded SQL: CHAIN, READ, SETLL, WRITE, UPDATE… to cursors and SELECT INTO, with SQLSTATE checks and the locking notes.
- /changes — Review My Changes: only the lines you changed are sent and reviewed — against Git HEAD for local files, the copy on the IBM i for unsaved changes, or the latest change day of the source dates for members.
- /cl — Write CL from a description, using the real command definitions of your system.
- /data — Test data for a table: realistic invented INSERTs that respect types, keys and foreign keys — only the table’s structure is read, never its rows.
- /health — Is the system healthy?: CPU, storage, jobs waiting for a reply, top CPU jobs, QSYSOPR, subsystems — what needs attention first and the next step.
- /security — Review authorities of an object or a library: *PUBLIC exposure, owners, adopted authority, with the GRTOBJAUT / RVKOBJAUT / CHGOBJOWN to fix each finding.
- /spool — Explain a spooled file (right-click it): a dump, a job log, a compile listing or a report in plain words.
- Four more tools for the AI and Copilot agent mode:
#ibmiMessage(IBM message help),#ibmiMembers(members of a source file),#ibmiCommand(CL command definitions),#ibmiIndexes(table size, indexes and index advice) — all read-only and through the same guard.
Several systems, projects and documentation
- Run SQL on Several Systems… and Run CL Command on Several Systems… (Connections toolbar with two or more systems connected, SQL editor right-click, quick menu): the same statement on DEV, TEST and PROD at once; rows found on only some systems come first, each system’s time or error is shown; statements that can change data and every CL command ask first, with the list of systems.
- Create IBM i Project (iproj.json, Rules.mk)… (Explorer right-click on a folder): IBM i Project Explorer / Bob files for a local source folder —
iproj.json(include path from the folders with copybooks, current library, library list),.ibmi.json, and aRules.mkper folder with one target per source (ord01.pgm.rpgle→ORD01.PGM,.rpgle→ module,.pf/.dspf→ file,.bnd→ service program,.cmd→ command) and its/COPYdependencies; the build command is set tomakei build. Existing files are only replaced when you say so. - Document This Library (Markdown) (right-click a library): every object, each program with the files it reads / writes / updates and what it calls, each file with its columns and the programs that use it, the CRUD matrix and a Mermaid diagram — opened with the preview beside it, ready for a wiki.
- CRUD Matrix (right-click a library): which program Creates, Reads, Updates or Deletes which file (from DSPPGMREF), with a filter, and Save as CSV.
Sources and reports
- Generate RPG Program for This Display File (right-click a .dspf source): a
**FREEskeleton with the WORKSTN file (SFILEfor each subfile,INDDSwhen the file uses INDARA, with the indicators it uses named after their function keys), the mainEXFMTloop with every CA / CF key, and for each subfileload…/process…procedures that clear, load, display (SFLDSP / SFLCLR / SFLEND indicators read from the DDS) and read back changed rows with READC. - Problem characters underlined in RPG, CL, DDS, SQL and COBOL sources when opened or saved: tabs, control characters, no-break spaces, zero-width and byte-order marks, curly quotes and dashes, characters lost in a CCSID conversion — with Fix every problem character in the light bulb (
vanthrex.editor.checkCharacters). - TODO and FIXME Notes in Open Sources…: TODO / FIXME / HACK / XXX / BUG in RPG (
//,*in column 7), CL (/* */), SQL (--) and DDS comments, one click to the line. - Report to CSV (Excel)… (right-click a spooled file, or on an open report): the columns of a printed report are found (header above the underline, page headers and totals left out), IBM i number formats (
1.234,50-,12,000.00-) become plain numbers, saved as a CSV a spreadsheet opens directly (vanthrex.csvSeparator).
Jobs
- Job Run History…: how long each run of a batch job took over the last 30 days (
vanthrex.jobHistoryDays) from the history log — start, end, elapsed and CPU time, end code — with the average, the longest, failed runs in red and runs twice as long as usual marked; click a run for its job log. - Find a Message in Job Logs…: where a message ID (CPF4131, CPF41*) or words of a message (“level check”) appeared in the job logs of a user’s recent jobs, with the program that sent it; click for the whole job log.
Database care
- Unused Indexes of a Library… (right-click a library, quick menu): indexes and keyed logical files no query used and nothing opened for 180 days (
vanthrex.unusedIndexDays), largest first, with the space they take; unique, primary-key and constraint indexes and new ones are never proposed; Drop… on a row shows theDROP INDEX/DLTFand asks first. - Journal Coverage of a Library… (right-click a library): every physical file with its journal and images, files not journaled in red, and Commands to journal the files…:
STRJRNPFcommands (50 files each,*BOTHor*AFTER,OMTJRNE(*OPNCLO)) opened for review and run only when you confirm. - Programs That Would Get a Level Check… (right-click a file): compares the record format level of the file now with the level each program was compiled with (DSPFD / DSPPGMREF, in the file library or the user library list) and lists the programs to recompile before they end with CPF4131.
- Take a Library Snapshot / Compare Library With Snapshot… (right-click a library): the list of objects with size, change date and source member saved on this computer (never data); after a release, see what was added, changed or removed.
- Enable / Disable this trigger in the options of a trigger in the schema browser (
ALTER TRIGGER … ENABLE / DISABLE, after a confirmation).
SQL generators
- Create Table From CSV or Excel File… (Explorer right-click on a .csv / .xlsx, quick menu): column names made valid for Db2, types guessed from the data (INTEGER, BIGINT, DECIMAL with its precision, DATE, TIMESTAMP, VARCHAR; codes with leading zeros stay text; nullable when a value is missing),
LABEL ONwith the original headers; the statements open for review, then Create and Import creates the table from the editor text and imports the rows. - JSON_TABLE Query From a JSON Sample (Explorer right-click on a .json, selected JSON in an editor): a
SELECToverJSON_TABLEwith one typed column per value, nested objects flattened andNESTED PATHfor arrays of objects — reading from an IFS file (GET_CLOB_FROM_FILE), a table column or a host variable. - Find a Text in Spooled Files…: an order number or an error text across the recent spooled files of a user (
vanthrex.spoolSearchDays), the lines found with one click to open the spooled file.
Editor
- Comment blocks fold in RPG and CL: three or more comment lines in a row (
//,*in column 7,/* */) fold like code, and Fold All Block Comments folds them all.
Understand and modernize code
- Flowchart of This Procedure (right-click an RPG or CL source): the control flow of the main line, a procedure or a subroutine drawn as boxes — runs of statements, IF / ELSEIF / ELSE and SELECT / WHEN decisions, DOW / DOU / FOR loops with their way back, MONITOR / ON-ERROR, RETURN, LEAVE and ITER — for free-form RPG, fixed C specs and CL (IF THEN(DO), ELSE, DOWHILE, SELECT…); click a box to go to its line, zoom, Copy as Mermaid.
- Matching blocks in RPG and CL: put the cursor on IF, ELSE, DOW, WHEN, MONITOR, LEAVE or an END and the whole block is highlighted (
vanthrex.editor.matchBlocks); Go to Matching IF / ELSE / END jumps between them (Ctrl+Shift+\). - Create SQL Procedure for This Program…:
CREATE PROCEDURE … EXTERNAL NAMEover an RPG or CL program (parameters read from the dcl-pi, *ENTRY PLIST or PGM PARM; CONST / VALUE become IN, the others INOUT), orCREATE FUNCTIONover an exported procedure that returns a value — so Java, Python, Node, ODBC and SQL can call it. - Convert DDS to SQL: a physical file becomes
CREATE TABLE … RCDFMT(types, ALWNULL, DFT, ALIAS, the unique key as PRIMARY KEY, TEXT and COLHDG as labels); a keyed logical file becomesCREATE INDEX … RCDFMT … ADD(programs keep working after a recompile), select / omit a view; what needs a check is written at the top. - Generate SQL Statements… (right-click a table): SELECT INTO, INSERT, UPDATE, DELETE by key, MERGE (upsert) and a cursor, with host variables, identity columns left out and nullable columns pointed out.
- Expand SELECT * (light bulb in SQL and RPG): the
*replaced by the column list of the table. - Extract to Named Constant (DCL-C) (light bulb on a selected literal in RPG): a name proposed from the text, every occurrence replaced if you want.
- Add Change Log Entry: date, user, ticket and text at the top of the source, in its comment style (
vanthrex.editor.changeLogTemplate).
Codes and converters
- SQLCODE, SQLSTATE and RPG status explained on hover in RPG, SQL and CL (
if sqlcode = -803,sqlstate = '02000',%status = 1218) and with Explain SQLCODE / SQLSTATE / RPG Status… (-803,SQL0204,23505,01211,RNQ1218): what it means and what to do, offline. - Developer Converters: packed, zoned and binary to and from hex (what a dump or DSPPFM shows); a date in every IBM i format (*ISO, *USA, *EUR, *MDY, *DMY, *YMD, *JUL, *LONGJUL, *CYMD, *CMDY, *CDMY, day of week, RPG and SQL literals) from any of them; timestamps and epoch; text to and from EBCDIC hex for any CCSID, converted by the system itself. Pick a result to copy it.
Data quality
- Data Profile of a Table… (right-click a table): for each column the nulls, distinct values, smallest and largest, with columns always null, holding one value, unique (key candidates), mostly null or with dummy dates pointed out; click a column for its most frequent values (
vanthrex.profileSampleRows). - Find Orphan Rows… (right-click a table): rows whose parent is missing, for a declared foreign key or any relation you give, grouped by key with counts.
- Columns Close to Their Limit… (right-click a table): numeric columns near the largest value they can hold (a DECIMAL(5,0) counter at 99,000) and text columns filled to their length (values probably cut) (
vanthrex.capacityWarnPercent). - Unused Objects of a Library… (right-click a library): objects not used for a year (or never), largest first, with the commands to save them to a save file and delete them, opened for review (
vanthrex.unusedObjectDays). - Time This SQL Statement: run a SELECT 2 to 50 times and see the first run, the average after it, median, 90th percentile and each run (
vanthrex.benchmarkRows).
System audits
- Program Attributes Audit… (right-click a library): programs that adopt the authority of QSECOFR or an *ALLOBJ owner, adopt their owner, run dynamic SQL as the owner, use adopted authority, or target an old release — with what to do.
- Job Schedule for the Next Days: every scheduled entry laid out day by day with its time, command and user (weekly days, month start / end, “first Monday”…), held entries apart (
vanthrex.scheduleDays). - Objects Hidden in the Library List: programs, files, commands and data areas that exist in two libraries of the library list — which one is used and which ones are never reached.
- NetServer File Shares: every share with its path, permissions and users; write access to the root or QSYS.LIB is marked.
Speed
- Instant reopen (member cache): members you open are kept on this computer with their change time; when a member did not change on the IBM i it opens again from the cache — one small query instead of copying the member (
vanthrex.memberCache.enabled,vanthrex.memberCache.maxMembers, Clear the Member Cache). What you save is cached too. - Index Source Libraries for Instant Search… (right-click a library): the sources of the chosen libraries are copied to this computer with 150 members per round trip and several source files at a time (
vanthrex.index.membersPerTrip,vanthrex.index.parallel); afterwards only new and changed members are read again. - Instant Search in Indexed Sources… (Ctrl+Alt+Shift+F): results appear as you type, in milliseconds, with
re:for regular expressions andw:for whole words; pick a line to open the member there. - Go to Anything (Ctrl+Alt+J): every member of the library list’s source files, every program, file, command, data area and more, and your recently opened members and IFS files, filtered as you type from a list kept in memory; objects open with their most useful actions (information, source, call graph, data, where used, locks) (
vanthrex.goTo.maxItems,vanthrex.goTo.refreshMinutes). - Warm-up after connecting: in the background, the SQL job is started, the Go to Anything list loaded, the source index refreshed and the most recent members put in the cache, so the first actions are instant (
vanthrex.warmUp.enabled,vanthrex.warmUp.members, Get This Connection Ready). - Batch compile in parallel: several members compiled at the same time in separate jobs (
vanthrex.compile.parallel, default 4). - Recompile the Programs That Use This File… (right-click a file, or Recompile the programs now in the level check report): finds every program that uses the file, its source, and recompiles them all in parallel, with a report.
- Go to Definition across members: F12 on a procedure call that is not defined in the source jumps to its
dcl-procin another member — found instantly in the source index, or through the service program that exports it and its bound modules. - Clickable IBM i references in sources, spooled files and logs:
LIB/FILE(MBR)opens the member,PGM(LIB/OBJ)andLIB/OBJ *TYPEthe object information,/home/…the IFS file,CPF4131the message help,123456/USER/JOBthe job log (vanthrex.editor.referenceLinks). - Speed Test of This Connection: SSH round trip, QSH start, SQL statement, download and upload speed, graded, with what to change to make Vanthrex faster.
Flexible workflow
- Copy, CSV and Excel on every report table: every table of every report page (active jobs, unused objects, data profile, CRUD matrix, audits…) has Copy (paste into a spreadsheet), CSV and Excel buttons.
- File and field help in RPG: hover a file of a
dcl-for an F spec to see its fields with types and texts from Db2 (EXTFILE, EXTDESC, PREFIX and QUALIFIED understood); hover a field to see its type, text and file; field names are completed (also afterfile.for qualified files); Ctrl+click on the file opens its DDS source (vanthrex.editor.fileFieldHelp). - SQL watches: a value from a SELECT in the status bar, refreshed every N seconds, with an alert when it changes or meets a condition (
> 0,= ACTIVE,contains MSGW); ready-made watches for messages waiting for a reply, jobs in MSGW, system ASP and job queues; watches start again after VS Code restarts. - CL macros (
vanthrex.macros): a named list of CL commands with${VARIABLES}asked when it runs (with defaults, remembered),${USER},${CURLIB},${DATE},${TIME}; the commands are shown first, run in order and stop at the first error. - Run Selection as CL or SQL (Ctrl+Alt+R): the selected text — in any file, comments included — runs as SQL or as CL (continuation lines joined, several commands run in order).
- Bookmarks on lines of members and IFS files (Ctrl+Alt+B, list with Ctrl+Alt+Shift+B), kept across sessions and systems.
- Sets of sources: save the members and IFS files open now under a name (a ticket, a project) and open them all again later.
2.4.0
Local development (like Code for IBM i, with less setup)
- Deploy Changes to IBM i (IFS) (right-click in the Explorer, quick menu): keep your source in a local Git folder and upload only new and changed files to an IFS folder of their own (
${home}/builds/<folder>by default,vanthrex.deploy.directory). Missing folders are created, files are tagged CCSID 1208 so the compilers read them right,.git,node_modules,.vscode, keys and logs are never sent (vanthrex.deploy.ignore). Deploy All Files sends everything again;vanthrex.deploy.onSaveuploads each file as you save it. A protected system asks once for the whole deploy. - Compile Local File on IBM i (editor title button, right-click, and the normal Compile key on a local file): deploys the file (and every changed copybook, so
/COPYand/INCLUDEsee your latest version), compiles it from the stream file with your compile actions, and shows the errors on the local file — and on the local copybook when the error is in one. - Build Project on IBM i: runs your build command (
makei buildfor Bob / IBM i Project Explorer,gmake, your own script) in PASE in the deploy folder, with the open-source tools on the PATH andCURLIB/LIBLfrom the connection. Output in the Vanthrex Build panel, the message IDs it found and the exit code in the summary. - PASE terminal (Ctrl+Alt+P, connection right-click, the terminal + menu as IBM i (PASE), Open PASE Terminal Here on IFS folders): a real interactive shell on the IBM i in VS Code’s terminal panel, over the connection you already have — no second sign-on,
/QOpenSys/pkgs/binfirst on the PATH, resizes with the panel.
SQL and Db2 for i
- IBM i notebooks (
.vxnb, New IBM i Notebook): SQL, CL and PASE shell cells with Markdown notes in one file — a runbook, a health check, an investigation you can share. Results are tables (and stay out of the file), CL cells show every message and printed output, shell cells their output; Export Notebook to Markdown for a ticket or a wiki. - Charts from SQL: put
-- chart: bar|line|pie Titleabove a query in a notebook and the result is drawn (labels from the first column, up to four number columns);-- rows: 5000reads more rows. - SQL Error Log (Who Gets Which SQL Error?): the SQL Error Logging Facility (SELF) shows which programs and jobs get which SQLCODE, how often and with which statement — most frequent first, each one explained in a click. Turn SQL Error Logging On or Off… for the whole system (
*ERR,*ALL, chosen codes,*NONE) or only your session. - Browse Schema (SQL Objects) (right-click a library, quick menu): every table, view, index, procedure, function, trigger, sequence and global variable of a schema with long and system names, counts by kind and a filter; click one for its CREATE statement, its data, what depends on it, or to call it. Kinds a release does not have are reported and the rest still shows.
- Call Stored Procedure…: finds the procedure, asks for each parameter with its SQL type (numbers and lengths checked as you type,
NULL, empty = default), remembers your last values, and shows the OUT / INOUT values and the result set — OUT values come back through global variables in QTEMP, no host program needed.
Editor
- Folding for RPG (free and fixed form: procedures, DS / PR / PI, IF, DO, FOR, SELECT, MONITOR, BEGSR, P-specs) and CL (DO / ENDDO including
THEN(DO), SELECT, SUBR). - Parameter hints while typing an RPG call: the parameters of the procedure or prototype (free and fixed D-specs) with the current one highlighted, and of the common built-in functions (%SUBST, %SCAN, %DEC, %DATE, %SPLIT…).
- Format Document for fully free RPG (
**FREE): re-indents by block (ELSE / WHEN / ON-ERROR one level back, continuation lines keep their offset, compile-time data untouched);vanthrex.editor.rpgIndent. - Fixed-format fields: the status bar shows the RPG or DDS field under the cursor (spec, name, columns); Ctrl+Alt+] / Ctrl+Alt+[ jump to the next / previous field, Fields of This Line… lists every field with its value.
- CL language support: an outline (variables with type and length, files, labels, subroutines), Go to Definition for
&variables,GOTOlabels andCALLSUBR, Find All References, highlights, and hovers with the declaration.
CL and RPG editing
- CL command help from your own system: hover a command in a CL source for what it does and every parameter (keyword, prompt, default, allowed values, required ones marked); while typing, the keywords not used yet are offered (required first, with their default filled in) and inside
KWD(its allowed values. Read from the command definitions on the connected system (the same ones F4 uses), so your own commands work too;vanthrex.editor.clCommandHelp. - Quick fixes for compile errors: on RNF7030 name not defined the light bulb offers Declare it here (a
dcl-sin the procedure that uses it, after its interface) or Declare it globally, with the type picked from a list; fixed-format sources get a D-spec in the right columns. Unused declarations (RNF7031) are now shown faded, with Remove unused declaration. - Command definition sources (.cmd): problems CRTCMD would reject are underlined as you type (duplicate keywords, a TYPE pointing to no QUAL/ELEM label, MIN larger than MAX, DFT on a required parameter, RSTD(*YES) without values, DEP on an unknown parameter, missing prompts), and Preview Command Prompt (F4) from Source shows the prompt screen before compiling — try values and copy the command they build.
- Retrieve CL Source (RTVCLSRC) on a CL program: the source of a program created with ALWRTVSRC(*YES) opens in an editor, no source file needed.
SQL and code generation
- Run / Explain / RPG code links above every statement of an SQL file (
vanthrex.editor.sqlCodeLens): work through a script one statement at a time without selecting. - Generate RPG for This Query: a cursor loop with a multi-row FETCH and a data structure whose subfields have the real column types (read from the system), null indicators when a column can be null.
- Generate RPG from a JSON Sample: select JSON, copy it, or right-click a .json file — qualified templates for nested objects,
dim()arrays with their count fields, names made RPG-valid (with the JSON name as a comment), and the DATA-INTO / DATA-GEN statements for YAJL. - Find a Value in Table Data… (right-click a file): every row where any column holds the value — text anywhere in text columns (any case), numbers in number columns, dates by their start — with the column it was found in.
- Copy Rows as SQL INSERT Script… (right-click a file): the rows you choose with a WHERE condition as
INSERT … WITH NCstatements, to load a test system or keep a data fix. - My SQL Job: the job that runs Vanthrex’s SQL, F4 and command line — its library list and its job log (newest first, message IDs explained in a click).
IFS and work management
- Compare Folder with IFS…: a local folder against an IFS folder — newer on the PC, newer in the IFS, different, only on one side — with a diff, upload or download for each file.
- Extract Here… (.zip, .jar, .tar, .tar.gz, .gz) and Compress (zip / tar)… on the IFS, with
unzip/zipwhen installed andjarotherwise. - Copy To… and Move or Rename… for IFS files and folders (whole folders, CCSID tags and permissions kept, one question before replacing).
- Work with Job Descriptions (WRKJOBD): user, job queue, initial library list and logging of every job description of a library; change the library list or the job queue (CHGJOBD after a confirmation), or use the library list for your connection.
IFS
- Upload Files or a Folder Here… and drag and drop from the Explorer or the desktop onto the IFS view: whole folder trees, parents created,
.gitskipped, one question before replacing, one progress bar. - Download to This PC… on any IFS file or folder (folders with everything in them).
2.3.0
Create from anywhere
- Create Library… (Libraries view toolbar, quick menu, System Tracker, F6 in PDM): name, text, *TEST or *PROD, and in the same step add it to your library list, make it your current library and create the usual source files (QRPGLESRC, QCLLESRC, QDDSSRC, QSQLSRC, QCPYSRC, QSRVSRC, QCMDSRC) — then open it in PDM.
- Create IFS Folder or File… (IFS view toolbar, right-click a folder, quick menu, System Tracker): any path, missing parent folders created, new files tagged UTF-8 (CCSID 1208) and opened in the editor, optional permissions (chmod).
More stable connections
- Automatic reconnect: when the connection drops (network, VPN, laptop sleep), Vanthrex reconnects by itself with your saved sign-on — 5 attempts over about 2 minutes, shown in the status bar — and makes that system active again (
vanthrex.connections.autoReconnect). Disconnecting on purpose never reconnects. - Connection health: every minute a tiny query checks that the active system still answers; a slow answer shows its response time in the status bar, and a system that stops answering is reconnected even when SSH did not notice (
vanthrex.connections.healthCheckSeconds, Check Connection Health, Reconnect Now). - No lost saves: if a member or IFS file cannot be saved because the connection is gone, the change is kept on this computer and offered for saving as soon as the system is back (Save Now, Show, Discard; Changes Kept While Offline…).
- Editors come back: member and IFS tabs that could not be read while offline (for example after restarting VS Code) reopen by themselves once you are connected.
- Disconnect asks first when members or IFS files have unsaved changes (Save and Disconnect / Disconnect Anyway).
Call, sign-on and notes
- Call Program (Typed Parameters)… (right-click a program, PDM option 16): reads the parameters from the program’s source — free-form
dcl-pi, fixedD … PI,*ENTRY PLISTor a CLPGM PARM(…)— asks for each value with its type, checks it as you type, and builds a CALL the program receives exactly: packed, zoned and integer values become the right hex or zoned literals instead of the packed(15,5) that a plain CALL passes, and long character parameters are padded. Run it, submit it to batch or copy the command; your last values are remembered. - Who Is Signed On (Jobs view toolbar, quick menu, System Tracker): every 5250 session and the server connections per user (ODBC/JDBC, file server, remote command, SSH…); for a session: details, job log, a break message or ending it (asked first); Message everyone signed on.
- Member notes: right-click a line → Add Note to This Line; notes show at the end of the line and as a 📝 N notes lens at the top, follow the line when code moves, and are listed with All Member Notes…. Share them with your team through an IFS file (
vanthrex.notes.sharedFile).
Layout, includes, signatures and failed jobs
- Data Structure Layout (right-click in an RPG source): every subfield of the data structure at the cursor with its type, from and to positions and length in bytes — free and fixed form, POS, OVERLAY (also
*NEXT), DIM, LIKE and LIKEDS within the source, and EXTNAME / externally described structures with their fields read from the database. Hover a subfield definition to see its positions; copy the layout as a Markdown table. - Show Source with /COPY Expanded (right-click in an RPG source): a read-only copy of the source with every /COPY and /INCLUDE merged in place (nested ones too, each marked with where it starts and ends), so you can read or search the whole program the way the compiler sees it.
- Check Service Program Signatures (right-click a service program): every program and service program bound to it, with the ones that would fail with a signature violation at the next call shown first, and a one-click re-bind (UPDPGM / UPDSRVPGM with MODULE(*NONE), asked first) — one object or all of them.
- Failed Jobs (Jobs view toolbar, quick menu, System Tracker): jobs that ended abnormally in the last hour, day or week from the history log, with the meaning of each end code, which job names fail most, and their job log one click away.
Green screen
- Open 5250 Session (right-click the active connection, the Connections toolbar or the quick menu): opens a real 5250 session on the system you work with — in IBM i Access Client Solutions when it is installed (found automatically, or
vanthrex.5250.acsPath), in tn5250 inside a VS Code terminal, or with your own emulator (vanthrex.5250.commandwith${host},${user},${device}). Device name, TLS and port can be set. - Command line (5250 style) (Ctrl+Alt+K):
===>like on a green screen, with F4 prompt, F9 / ↑ retrieve, F12 clear and the history of your commands. Every command shows its full messages (completion, diagnostic, escape — click a message ID for IBM’s help), display commands such as DSPLIBL, DSPFD, DSPOBJAUT or DSPJOB show their printed output right there (OUTPUT(PRINT) is added for you and the spooled file removed again), and interactive commands open the Vanthrex screen that does the same: WRKACTJOB, WRKOBJLCK, DSPJOBLOG, WRKJOB, DSPMSG / WRKMSGQ, WRKSYSVAL, WRKUSRPRF, WRKOUTQ, WRKJOBQ, WRKSBS, WRKJOBSCDE, NETSTAT, DSPOBJD, DSPFD, STRSQL, STRSEU, WRKSAVF and the PDM commands. Commands that need a display (STRSDA, SIGNOFF…) offer to open a 5250 session. *Run CL Command opens the same screens for interactive commands. - Work with Active Jobs (Jobs view toolbar, connection menu, System Tracker, or WRKACTJOB on the command line): jobs grouped by subsystem with the familiar option field — 3 hold, 4 end (controlled or immediately, asked once for all), 5 work with, 6 release, 7 display and answer the message a MSGW job waits for, 8 spooled files, 10 job log, 11 call stack, L live job log — F5 refresh, F10 restart statistics, F11 other columns (threads, temporary storage, CPU time, disk I/O, pool, priority), filters by subsystem, user, job and status, position to, and refresh every 5 to 60 seconds. MSGW jobs are shown in red, LCKW in orange.
AI-powered development (with GitHub Copilot Chat or another VS Code chat model, through @vanthrex)
- Explain compile errors (
/errors, AI: Explain Compile Errors, the light bulb on an error, or Explain with AI when a compile fails): every error explained in plain words with the source lines around it and IBM’s own help text for the message, errors with the same cause grouped, and the smallest fix for each — without rewriting the source. - Generate RPG documentation (
/document): the header now describes the files the compiled program really uses and how (read, update…), the programs it calls and its service programs, read from the system; comments follow the source’s style (free or fixed form), plus a short wiki summary. - Suggest unit tests (
/test): first the behaviours worth testing for each procedure (normal cases, boundaries, error paths, each branch), using the real procedure signatures and data structure layouts, then the RPGUnit test source and the RUCRTRPG / RUCALLTST commands. - Explain program dependencies (
/depends LIB/PGM, right-click a program or service program → AI: Explain Program Dependencies): modules and their sources, service programs, files used and how, programs and data areas referenced (DSPPGMREF), who is bound to a service program, and what to recompile, re-bind or promote together when something changes. - Recommend fixes from real job logs (
/joblog number/user/name, right-click a job, Failed Jobs → Ask AI why it failed, or the job log analysis page): reads the job log — or the spooled QPJOBLOG of an ended job —, finds the user program and statement where it failed, opens its source at that statement (SRCSEQ / *SRCSTMT mapping), and asks for the root cause and a concrete fix; a button opens the failing line.
Faster and more reliable
- Pages open at once: the 90 report pages (job details, object information, who is signed on, failed jobs, security, Work with…) open straight away with a loader — a spinner, what is being read, the seconds it takes and the outline of the page — instead of only a message in the status bar; refreshing a page shows a thin busy bar on it, as VS Code does. PDM, the System Tracker, the dashboard and the data editor use the same loader.
- System Tracker opens at once: the last page of the system is shown immediately while it refreshes, and the Overview is drawn as soon as its own figures are back; libraries, network, journals and the other tabs fill in when they arrive (loading the rest…).
- PDM shows the member list first: who has a member locked and whether its object is older than the source follow a moment later, without moving the cursor; options wait for them, so a locked member is still never deleted.
- Report pages with thousands of rows open at once: rows are drawn 300 at a time (Show more), the filter is instant, and every column sorts with a click.
- Less waiting for the same list: the library list, the objects of a library and the members of a source file are shared between the views for a short time instead of being read again by each one; Refresh (and any change you make) reads them again. Two views asking the same question at the same time now run it once.
- The SQL engine starts as soon as you connect, so the first view does not wait for Java on the IBM i; queries slower than 3 seconds and slow start-up steps are written to the Vanthrex log to find what is slow.
- One look everywhere: all pages share the same styles, loader, busy bar and paged / filtered / sortable table (
src/features/ui/kit.ts), so they look and behave alike in light, dark and high-contrast themes. - Clearer code: the modules that were named after release batches are now one module per subject (for example
dataStructures,programCall,jobTools,security,memberToolsView,sourceAnalysisView), with their tests named the same way.
New tools
- Source Quality Report (right-click a source file): every RPG member checked — code checks, share of fixed format, numbered indicators, GOTO / CABxx, subroutines and procedures — with a score and a grade from A to E, lowest first, and the most frequent findings for the whole file.
- Library list from a job description or a user profile: see what changes, then replace your library list or add the missing libraries (*SYSVAL follows QUSRLIBL).
- *PUBLIC Authority Scan (right-click a library, or *PUBLIC in the System Tracker): objects that give *ALL or *CHANGE to everybody, riskiest first, with a one-click fix to *PUBLIC *USE (asked first).
- Copy to Another System… (right-click a member or IFS file, or the editor menu, with two systems connected): copy a member or a stream file from one system to another — the target source file and member are created when missing, and you see how many lines change before anything is written; protected systems still ask.
- Compare System Values with Another System (Connections view with two systems connected, or the All systems tab): what differs between DEV and PROD, with the values that differ on purpose (dates, serial numbers, devices) kept apart.
2.2.0
New: System Tracker — the whole system in one place
- One button (the pulse icon in the Connections view, the inline button on the active connection, Ctrl+Alt+T, or the quick menu) opens a page with tabs:
- Overview: system and release, CPU, system ASP use, jobs, waiting jobs, QSYSOPR replies, time since IPL, PTF level, libraries and your compile results as colour-coded tiles — and Needs attention: ASP almost full, inquiry messages, MSGW / LCKW jobs, high CPU, sources that did not compile, library list entries that do not exist, expired passwords — each with a button that takes you there.
- Libraries: every library on the system with type, text, owner, created and last-used dates and its place in your library list; filter, sort, hide IBM libraries, and calculate objects and size on request. Each row: open in PDM, add to the library list, pin, storage advisor.
- Jobs: waiting jobs (MSGW, LCKW), the top jobs by CPU and the subsystems — with details, job log and live job log on every job.
- Storage, QSYSOPR (latest messages, inquiries highlighted, Explain, the sender’s job log), Users (enabled, disabled, not signed on for 90 days, expired passwords, *ALLOBJ / *SECADM profiles), PTFs & software and My work (your jobs, spooled files, members changed in your library list in the last 7 days, broken compiles, pins).
- Libraries tab shows every library (it showed only QSYS:
OBJECT_STATISTICS('QSYS', '*LIB')returns QSYS itself). Libraries are now read withOBJECT_STATISTICS('*ALL', '*LIB'), completed from the SQL catalog (SYSSCHEMAS). The same fix applies to PDM (WRKLIBPDM), Self-check and Add library, which could report existing libraries as missing. - Libraries tab: tiles for libraries you can see, user and TEST libraries, your library list (and missing entries), libraries not used for a year (cleanup candidates), measured size and your special authorities; with ALLOBJ every library is listed. Filter *Not used for a year; Calculate objects and size now measures every library that passes the filters (not only the rows on screen), and sizes are remembered per system.
- Storage tab: largest libraries (measured). Every table: Export CSV. Auto-refresh every minute (header).
- Jobs: the counts are exact (the badge showed the 200-row query limit). The badge counts jobs waiting for a reply (MSGW); LCKW is counted only for batch and interactive jobs.
- Health score: the Overview opens with one number from 0 to 100 (✓ healthy, ⚠ keep an eye on it, ✗ action needed) and the reasons that lowered it (disk, messages waiting, MSGW jobs, CPU, QSECURITY, security settings…), with its trend.
- Trends: CPU, system ASP and jobs keep their history between refreshes (per system) and show a small trend line; CPU and ASP also show a meter. Problems are listed red first.
- Queues tab: job queues (held, or not attached to a subsystem, while jobs wait — flagged) and output queues by number of spooled files, with Hold / Release (asked first, protection respected).
- Network tab: every listening port with the service behind it (SSH, Telnet, host servers, Mapepire, DRDA…), its open connections, which services are not encrypted, and the addresses with the most connections.
- Security settings on the Users tab: QSECURITY, QPWDLVL, QMAXSIGN, QPWDEXPITV, QPWDMINLEN, QAUDCTL, QCRTAUT, QINACTITV and QALWOBJRST with ✓ / ⚠ / ✗ and what to change.
- Copy summary: a short Markdown summary of the system (score, key numbers, what needs attention) to paste into a chat or a ticket.
- Scheduled jobs tab: the whole job schedule (next run first, today’s runs highlighted, held entries flagged) with Hold / Release.
- Journals tab: journals in user libraries, largest first — receivers kept, total size, journaled objects; 50+ receivers or 10 GB+ flagged for cleanup.
- What changed tab: objects changed today or in 7 days, or the largest objects — in your library list (fast) or every user library — with information, PDM and locks on each.
- All systems tab: every system you are connected to side by side (health score, CPU, ASP, MSGW, QSYSOPR replies) — Open switches to it.
- Subsystems with status and maximum jobs (full ones flagged), and failed sign-on attempts on the Users tab.
- Save report: the whole tracker as one HTML page (light theme, prints well) to send to your team or keep as a record.
- Every part is read independently: if one IBM i service is missing on a release or you are not authorized to it, the rest of the page still works and that part says why.
Fixed
- Members could not be saved after PDM option 5 (issue #3): Display marked the member read-only for the whole VS Code session, so editing it later (option 2 or the Libraries view) showed a 🔒 and Ctrl+S did nothing. Option 5 now opens a separate read-only view; members already stuck are made editable again as soon as you switch to them.
- A save no longer fails when the source-date save hits a technical problem (QTEMP, SQL job…): the member is saved without source dates and you are told. Data problems (line too long, characters the CCSID cannot hold) still stop the save, so nothing is lost.
- PDM option 14 compiled the active editor instead of the member on the row; it now compiles each member you typed 14 on.
New: history, live job logs and pins
- Compile History (Libraries view menu, quick menu): every compile on this computer — when, which source, which object, ✓ / ✗ with errors and warnings, on which system. Broken right now lists the sources whose last compile failed, with Recompile the broken sources in one click.
- Show My Changes Since the Last Compile (editor menu, member menu, PDM option SC, or from Objects Built from This Source): highlights the lines changed after the program was last compiled, with a list to jump to each one.
- Live Job Log (right-click a job, or quick menu): new job log messages stream into an output panel every few seconds; escape messages and severity 30+ pop up with Explain; it stops by itself when the job ends.
- Pinned view: pin the members, source files, libraries, objects and IFS files you use every day (right-click → Pin / Unpin, or PN in PDM). One click opens a member, a source file or library in PDM, an object’s information or an IFS file; pins are kept per system and can be reordered.
- Batch compiles no longer stop on the first failure: the error notification no longer has to be closed before the next member of a PDM option 14 batch, compile on save or Recompile broken runs.
New: knowing what your source became
- Objects Built from This Source (right-click a member or in the editor, or PDM option OB): every program and service program compiled from the member (QSYS2.PROGRAM_INFO for OPM, BOUND_MODULE_INFO for ILE modules), when, and whether the source changed after the compile — with Compile now.
- Member status bar: while you edit a member, the status bar shows ✓ the program it went into, ⚠ how many objects are out of date with your source, or that it was never compiled — and 🔒 who else has the member open. Click for details (
vanthrex.memberStatusBar). - Compile on save (
vanthrex.compileOnSave: off / ask / always, optionally only for some source types): copy members are never compiled. - Find & Open Member… (Ctrl+Alt+M) now searches your library list or every user library, accepts a source type (
ORD* RPGLE), sorts by library-list order (first = what *LIBL would use) and opens the result in the editor, in PDM, or shows the objects built from it.
New: PDM in one screen — Work with Libraries, Objects and Members using PDM
- The PDM you know, in VS Code: right-click a library, a source file or a file and choose Work with Using PDM… (or the list button on the Libraries view, the quick menu, or type
WRKMBRPDM FILE(LIB/QRPGLESRC),WRKOBJPDM LIB(X),WRKLIBPDM LIB(A*)orSTRPDMin Run CL Command). - Type options and press Enter, on as many rows as you like, with the PDM numbers: members 2 edit, 3 copy, 4 delete, 5 display (read-only), 6 print, 7 rename, 8 description, 13 change text and type, 14 compile, 15 create module, 16 local history, 25 find string, 54 compare two members; objects 4, 5, 7, 8, 11 move, 12 work with members, 13, 15 duplicate, 16 call, 18 edit data, 34 debug; libraries 5 / 12 work with objects, 8, 13. Deletes are confirmed once for the whole batch.
- Function keys: F3 exit, F5 refresh, F6 create (member, source file or library), F9 undo delete, F12 back, F13 repeat an option down the list, F16 user-defined options, F17 subset, F21 export the list to CSV, F23 more options. Shift+F1…F12 work as F13…F24 like in a 5250 emulator; ↑ / ↓ move between option fields.
- All source files at once: type
*ALL(or a generic name likeQ*SRC) in File — orWRKMBRPDM FILE(MYLIB/*ALL), or option AM on a library — to list the members of every source file of a library in one list, with a File column; every option works across files. - Subset and position to: generic names (ORD, *CUST*), type, text, changed since, *Needs compile, In use, or click a type chip (RPGLE 120, CLLE 30…); click a column to sort, double-click a row for its usual option.
- User-defined options (F16) with PDM variables &L &F &N &T &A &O &U &X, and parameters from the command line appended (for example
CB+TGTRLS(V7R4M0)). Built-in: CB, CS, CC, DF, PF, RS (RUNSQLSTM) (vanthrex.pdm.userOptions). - Robust by design:
- Undo delete (F9): members removed with option 4 are copied first and can be put back with F9 (or
UNDOon the command line); copies are also kept on disk. Members in use by another job are not deleted or renamed. - Failed options stay on their rows with the IBM i message (CPF…) in the Status column, so you fix and press Enter again — like PDM, but with the reason.
- Batches show progress and can be cancelled; more than 10 changing options ask first. Renames to an existing name are stopped before they run.
- Undo delete (F9): members removed with option 4 are copied first and can be put back with F9 (or
- See more at a glance: an Object column (✓ up to date, ⚠ source changed after the last compile, ○ not compiled yet — in your object library), an In use by column with the job that has the member open, and a preview pane (tick Preview, click a member or move with the arrow keys).
- Extras PDM never had: Git history (GH), unused code (UC), hard-coded libraries (HL), where used (WU), who has it locked (LK), what depends on this file (DP), source files only (SF), add to library list (LL), set current library (CL), a status column per row and recently used lists.
2.1.0
New: Security Admin center for users with *SECADM
- Shown only to security administrators. Vanthrex checks whether you (or one of your group profiles) have SECADM special authority; the *Security Admin button and commands appear only then. Everyone else does not see them.
- User profiles in one place: every non-IBM profile with status, class, special authorities, group, last sign-on, failed sign-ons and password expiry; profiles with *ALLOBJ / *SECADM and locked-out profiles are highlighted.
- Create a user with a guided form (class, special authorities, group, current library, first password that must be changed at first sign-on — or no password for service accounts and groups), or copy an existing user (same class, authorities, groups, library, menu and job description).
- Change, reset, enable / disable, expire the password, delete a profile. Deleting asks what to do with the objects it owns (give them to another profile or delete them) and requires typing the profile name.
- Unused profiles: enabled profiles that have not signed on for 30–365 days, with Disable all.
- Powerful profiles: who has *ALLOBJ, *SECADM, *AUDIT, *SERVICE or a *SECOFR / *SECADM class, including the members of powerful groups.
- Group profiles with their members, and authorization lists: create one, add or remove users, change authorities, and see the objects it secures.
- Passwords are never shown, stored or logged: they are typed in hidden fields, and every command, confirmation, log line and error has them masked.
Also new in 2.1
- Objects out of sync with their source (right-click a library): programs, service programs, modules, commands and files whose source member changed after the last compile — or whose source member is gone — so you know what runs code that is not what the source shows.
- What changed (release notes) (right-click a library): source members and objects changed in the last 1–90 days, with Copy as Markdown for release notes or a code review.
- New member from a template (right-click a source file): RPG program, NOMAIN module, SQLRPGLE with a cursor, CL with error handling, binder source, SQL table, display file, physical file — or your own templates (
vanthrex.templates). - Retrieve binder source of a service program (RTVBNDSRC) and work with binding directories (add / remove entries).
- Who is locking rows? (right-click a file): every locked row with its job, status and the first columns of the row; open the job log or end the job.
- Running SQL statements (Jobs view toolbar): what SQL runs now and for how long, with Cancel (QSYS2.CANCEL_SQL).
- Exit points and exit programs: registered exit programs, and which network exit points (ODBC, FTP, remote command, file server…) have none.
- Change owner or authority of many objects (right-click a library): CHGOBJOWN for every matching object, or one GRTOBJAUT / RVKOBJAUT with a generic name.
- Installed software and license keys: every installed product option, and license keys with usage limits and expiry (expiring within 60 days highlighted).
- Is this PTF installed?: paste PTF IDs from an IBM page and see applied / loaded / superseded / not on the system.
- Journals (quick menu or right-click a library): every journal with its attached receiver, receiver count and size, objects journaled; change the receiver now (CHGJRN *GEN) or journal every new table of a library (STRJRNLIB).
- IFS permissions (right-click a file or folder): who has which data authority, the owner; change authority or owner, for a folder optionally everything below it.
- Compare the structure of a table between two libraries — or two connected systems: columns (type, length, nulls, default) and indexes, plus an ALTER TABLE script that makes the second copy match.
- Find unused code in an RPG source: standalone fields, constants, prototypes, subroutines and internal procedures nothing refers to.
- Find hard-coded libraries in a source or a whole source file: LIB/OBJECT names written into RPG, CL and SQL that break when code moves from DEV to PROD (
vanthrex.scan.allowedLibraries). - Work with any message queue (QSYSOPR by default): reply to waiting inquiry messages, remove messages, explain them, open the sender’s job log, or send a message.
- What is this job doing? (right-click a job): status, current user, CPU, temporary storage, the SQL it runs, what it waits for, its call stack (your programs highlighted), the locks it holds and its activation groups.
- System history log (QHST): messages of the last hours or days, filtered by severity, message ID or text, with Explain.
- What depends on this file? (right-click a file): logical files, indexes, views, constraints, triggers and foreign keys that use it.
- Indicator usage (right-click in an RPG or DDS editor): where each numbered indicator is set and tested, and the ones that are set but never tested (or the reverse).
- IFS character set (CCSID) (right-click a file or folder): the CCSID of each file, tag one file or a whole folder tree (CHGATR), or convert a file’s text to UTF-8 or another CCSID.
- Can the IBM i reach this host?: PING from the IBM i itself, so firewall and DNS problems show up where the programs run.
- Call a web API from the IBM i: GET or POST through QSYS2.HTTP_*_VERBOSE, with headers, status and a formatted body — Authorization headers are never remembered.
2.0.0
Vanthrex for IBM i 2.0 — 20 new features
Development
- Generate RPG code for a table (right-click a file): a qualified data structure plus get / add / update / delete procedures and a cursor loop in embedded SQL, using the table’s key.
- Format SQL: Db2 for i statements formatted with keywords in capitals and one clause per line (Shift+Alt+F in
.sqlfiles, or right-click → Format SQL). - Find and replace in a source file (right-click a source file): text, whole word or regular expression across every member, with a preview of each line before anything changes; source dates are kept and changed lines get today’s date; members someone has open are skipped.
- Compile changed members (right-click a source file): compile everything changed today, this week or this month — or pick members — with a result per member.
- Print preview for printer files: a PRTF drawn on a page, following SKIPB / SPACEB / SKIPA / SPACEA, with a field table that jumps to the source line.
- Copy members to another source file (CPYSRCF, keeps sequence numbers and dates) and copy objects to another library (CRTDUPOBJ, with or without data); rename or move an object.
- Find a CL command by a word from its name or description, then prompt it with F4.
Data
- Export as SQL INSERT statements, next to Excel, CSV and JSON.
- Generate test data for a table: rows that fit each column’s type and length, keys continuing after the highest existing key, previewed before insert.
- Find duplicate rows by any columns.
- Table statistics of a library: rows, deleted rows, size, last change and last use.
Operations
- Submit to batch and watch: SBMJOB, then a status-bar spinner and a notification when the job ends — normally or not, with the job log and analysis one click away. Watch This Job does the same for any job in the Jobs view.
- My recent jobs: your jobs of the last days, abnormal ends highlighted.
- Compare two spooled files side by side — handy to check a program change did not alter a report.
- Follow an IFS file like
tail -f, refreshed every 2 seconds. - Search text in IFS files of a folder, optionally only some file names.
- Library list sets: save named library lists (DEV, TEST, a project…) per system and switch between them in one click.
All new screens are translated into the 7 languages.
1.3.0
New: see your screens and your database, compare two systems, and share spooled files
- Screen preview for display files. Open a DSPF member and click Preview Screen (editor title): the record format is drawn as it looks on a 5250 — constants, input fields (underlined), output fields, colors and display attributes, 24×80 or 27×132, windows, and a subfile control with its subfile rows. It follows the record your cursor is in and updates as you type; click a field to jump to its source line.
- Database diagram. Right-click a library → Database Diagram: the tables with their columns and primary keys, the foreign keys between them, and — because many IBM i databases never declared them — relationships inferred from column names (dashed). Click a table to highlight its links, zoom, Copy as Mermaid for Markdown / GitHub / wikis, or Save as SVG.
- Compare with another system. With two systems connected, compare a source member (VS Code diff), the objects of a library, the rows of a table by key, the system values, or the PTF group levels between DEV and PROD — the data is read from each system, so they never need to reach each other.
- Spooled files to PDF and e-mail. Right-click a spooled file → Save as PDF… or Send by E-mail…; in a
.sqleditor, E-mail Query Result sends the result as an Excel file. PDFs are made in VS Code from the spool text (or by the IBM i withvanthrex.spool.pdfMode: server); e-mail is sent by the IBM i with SNDSMTPEMM. - All new screens are translated into the 7 languages.
1.2.0
New: safer and sturdier — protection for production systems, a self-check, and errors that explain themselves
- Protect production systems. Mark a connection as Production (every change asks first, with Allow once or Allow for 15 minutes) or Read-only (Vanthrex refuses every change). It covers CL commands, SQL that changes data or objects, member saves and IFS writes — Vanthrex’s own work in QTEMP and its temporary files is not affected. The status bar shows a shield or a lock and turns red / amber so you always know where you are. Set it in the connection form or with Set Protection… on a connection.
- Self-check. Self-Check (Is This System Ready?) tests SSH and SQL round-trip times, QSH and CL, the SQL engine and Java version, your profile’s CCSID (65535 is flagged), home directory, library list, IBM i release and Db2 PTF group, your special authorities, RPGUnit and the debug service — and lists which IBM i services Vanthrex uses are missing on this system and which features they affect. Every problem comes with how to fix it, and Copy the report makes support issues easy. It also runs quietly the first time you connect to a system and warns only about real problems (
vanthrex.selfCheck.onConnect). - Errors that say what to do. Error messages from IBM i, Db2 and SSH now end with a plain-language hint — a missing IBM i service points to the Db2 PTF group, “not authorized” points to Check Authority, SQL7008 suggests WITH NC or journaling, locks point to Who Has It Locked?, lost connections say how to reconnect — in all 8 languages.
1.1.0
New: data, performance, code quality and unit tests
- Export table data to Excel, CSV or JSON (right-click a file): with an optional WHERE filter; numbers stay numbers in Excel and the header row is frozen. Export Query Result does the same for the SQL statement under the cursor in a
.sqleditor. - Import a CSV or Excel file into a table (right-click a file): columns are matched by name, a preview shows the mapping, the first rows and any values that don’t fit (too long, not a number, too many decimals) before anything is written. Add to the table or replace its rows.
- Performance monitor (Jobs view toolbar, quick menu or right-click the active connection): live charts of CPU, system ASP, active jobs and temporary storage with hover values, top jobs by CPU and by disk I/O (click for the job log) and memory pools — refreshed every 5 seconds.
- Code metrics (right-click a source file, or a member’s editor menu): lines, free vs fixed, procedures, subroutines, SQL, complexity, nesting, numbered indicators and GOTOs per member, with a grade A–D and modernization advice.
- Generate documentation for the open RPG or CL source as Markdown: description, parameters, files, calls, copybooks, procedures with their comments, and metrics.
- RPGUnit tests: generate a test member for the exported procedures of the open source (one test per procedure, with the right
aEqual/iEqual/nEqual), and run tests from VS Code’s Testing view — RUCRTRPG compiles, RUCALLTST runs, and each test shows as passed or failed with its message. Test members are found when you open them or with Find RPGUnit Tests… on a source file. Needs iRPGUnit on the IBM i. - All new screens are translated into the 7 languages.
1.0.0
Vanthrex for IBM i 1.0 — stable release
1.0 brings together everything since 0.1: editing and compiling with SEU habits kept, SQL and data tools, debugging, the AI assistant, insights, system tools, the Work with… screens and 8 languages. New in 1.0:
- Storage & cleanup advisor (quick menu, or right-click a library): libraries and objects by size, objects not used for 90–730 days, files with many deleted rows (one-click RGZPFM), saved journal receivers older than 30 days (DLTJRNRCV), and spooled files older than 30 days by user (delete them in one go) — with an estimate of the space you can free. IFS folders by size does the same for the IFS.
- Live alerts (turn on in the Jobs view toolbar → Live Alerts, or
vanthrex.alerts.enabled): a VS Code notification when one of your jobs — or anyone’s, withvanthrex.alerts.scope: all— waits for a reply (MSGW), an inquiry arrives on QSYSOPR (reply straight from the notification), a batch job ends abnormally, or the system ASP passes 85%. A bell in the status bar counts what is waiting. - Message files (right-click a
*MSGF): every message description with its text, help and severity; add (with the next free ID proposed), change, copy as ADDMSGD or remove. - Field finder: find every file, table and view that has a field — by name, wildcard or description — see where the same field is defined with different types or lengths, and jump to the programs using each file.
- Object promotion (DEV → TEST → PROD) (right-click objects or a library): pick objects, compare them with the target first (new, newer in source, newer in target, physical files that carry data), then copy them with SAVOBJ / RSTOBJ after an automatic backup of the objects being replaced. Every promotion is recorded in a promotion log, from which you can undo it.
- All new screens are translated into the 7 languages added in 0.10.
0.11.0
New: the IBM i “Work with” screens, in VS Code
Open them all from IBM i: Work with… (quick menu, the Jobs view toolbar, or right-click the active connection). Every list can be filtered, and clicking a row shows its options; every command is shown before it runs.
- Work management: subsystems (start, end, the jobs in each — WRKSBS), job queues (hold, release, clear, and release / hold / prioritise / end the waiting jobs — WRKJOBQ), output queues and the spooled files on any of them (open, hold, release, move, delete — WRKOUTQ), and the job scheduler (add, hold, release, remove entries — WRKJOBSCDE).
- Users & security: user profiles with filters (non-IBM, disabled, special authorities, groups) — enable, disable, expire the password, see a user’s active jobs and owned objects (WRKUSRPRF); all system values with the important ones explained (WRKSYSVAL, read-only); and the security audit journal QAUDJRN — authority failures, invalid passwords, profile and system value changes, deleted objects… — for a time range and user.
- Save / restore: save files in a library and what is inside them, SAVLIB / SAVOBJ to a save file (target release, compression, run now or in batch), RSTLIB / RSTOBJ (also into another library), and download / upload a save file between the IBM i and your PC. Right-click a library or a save file.
- Network & services: TCP/IP connections with the job and user behind each (end a connection), listening ports, the TCP/IP servers (SSH, host servers, DDM, FTP, Telnet, HTTP admin, NetServer, SMTP) with start / end, and IP interfaces and routes.
- All of it is translated into the 7 languages added in 0.10.
0.10.0
New: Vanthrex speaks your language
- The whole user interface — commands, menus, views, settings, the Getting Started walkthrough, messages, prompts and report titles — is now available in French, Spanish, German, Italian, Portuguese (Brazil), Japanese and Simplified Chinese, in addition to English.
- Vanthrex follows the VS Code display language: Ctrl+Shift+P → Configure Display Language, pick the language (install its language pack if asked) and restart VS Code.
- IBM i names stay as they are on the system — commands (CHGDTAARA, GRTOBJAUT…), object types (*FILE, *PGM…), message IDs and SQL — and the translations use IBM’s own IBM i terminology for each language.
0.9.0
New: system tools
- Journal Explorer: Who Changed This Table? (right-click a file): row changes from the journal for a time range — added, updated, deleted, by which user, program and job — with before/after images of updates, a “who changed it” summary and the history of a single row. Offers
STRJRNPFwhen the file isn’t journaled. - Check Authority (Can a User Use This?) (right-click any object): resolves a user’s authority in IBM i order (*ALLOBJ → own → groups → authorization list → *PUBLIC), checks the library too, explains where the authority comes from and what is missing, and offers the
GRTOBJAUTfix. - Data queues & data areas (right-click a
*DTAQ/*DTAARA): peek at data queue entries without removing them, send a test entry, clear the queue; view a data area and change its value with type, length and decimal checks. - PTF & System Health (quick menu, or right-click the active connection): PTF groups compared with IBM’s latest levels, PTFs waiting for an IPL, system ASP use, certificates expiring within 60 days, and user profiles with default or expiring passwords — worst first, with what to do.
0.8.0
New: insights for faster troubleshooting
- Index Advisor (right-click a library, or the quick menu): every index Db2 for i itself recommended while your application ran (
QSYS2.SYSIXADV) across your libraries, most requested first, with the cost of the most expensive query. Click a suggestion to create the index — a name is proposed and the SQL is shown before it runs. Show Queries Running Now lists the active SQL on the system. - Compare table data (DEV ↔ PROD) (right-click a file): compares the rows of the same table in two libraries by key (primary key pre-selected) — exact counts of rows only in one copy and changed rows, a field-by-field list of what changed (
BALANCE: 10.00 → 12.50), and CSV export. - Message help everywhere: hover any message ID (CPF9801, MCH1211, RNQ0102, SQL0204…) in any editor — job logs, compile listings, spooled files, comments — to see IBM’s text, severity, plain-language advice and the full help text. Explain Message ID… does the same on demand.
- Job log analyzer (right-click a job → Analyze Job Log): groups the errors, highlights the most likely root cause (not the generic CPF9999 function check) and says what to do.
0.7.1
New: SQL editor with results, right where you are
- Run SQL Query… on any library, source file, member or object in the Libraries & Source view (right-click), in the call graph (Run SQL… button, or click an object), on Object information, Who calls each exported procedure? and in the quick menu.
- It opens an SQL editor already filled with a useful query for what you clicked — first 100 rows, row count and columns of a file; program information, bound modules, exports and the programs bound to a service program; objects, tables and source members of a library; lock holders; and more. Pick another ready-made query from the list or write your own.
- ▶ Run (or Ctrl+Enter) shows the data underneath: sort by clicking a column, filter rows, copy as CSV, or open the query in an SQL scratchpad. Destructive statements still ask first.
0.7.0
New: Who calls each exported procedure?
- Right-click a service program → Who Calls Each Exported Procedure?… (also on the object information page, Modules & Exports and the call graph). Vanthrex finds the programs bound to it (QSYS2.BOUND_SRVPGM_INFO, or the DSPPGMREF cross-reference), reads their RPG and CL source — with the prototypes in their /COPY members — and lists, for every exported procedure, each program, source line and statement that calls it.
- Prototypes are followed:
EXTPROC('SYMBOL'),EXTPROC(*DCLCASE), fixed-formPRspecs (long names too),CALLB,%PADDRand CLCALLPRC. - Exported procedures nobody calls in the analysed libraries are marked, as are calls matched by name only because a /COPY member could not be read. Click a call to open the source at that line.
New: dynamic calls in the call graph
- Find dynamic calls scans the source of the programs in the graph for calls whose target is only known at run time —
CALLwith a variable in RPG, prototypes withEXTPGM(variable)/EXTPROC(variable), CLCALL PGM(&VAR)— and shows them as dashed red nodes. Click one to open the call. DSPPGMREF cannot see these calls, so the graph now tells you where it is blind.
0.6.1
- Stable release: Vanthrex for IBM i is no longer marked as Preview on the VS Code Marketplace.
- Releases are published to the Marketplace automatically when a version tag is pushed (needs the
VSCE_PATrepository secret).
0.6.0
New: AI assistant for IBM i (@vanthrex)
- Type @vanthrex in the VS Code chat (GitHub Copilot Chat or any chat model) and ask about IBM i in plain language. Commands:
/explain,/document,/review,/modernize(fixed format → modern **FREE RPG),/test(RPGUnit tests),/fix(explain and fix compile errors),/sql(Db2 for i SQL written against your real tables and columns) and/object LIB/NAME *TYPE. - The assistant knows the connected system (library list, IBM i release) and can look things up: object descriptions, table columns and indexes, source members, object search, system status and read-only queries.
- Safe by design: it only reads. Queries must be a single SELECT / WITH / VALUES (data-change statements and functions with side effects such as QCMDEXC are refused), and Vanthrex asks before every query and before reading an IFS file.
- Right-click in a source → Vanthrex AI (Explain, Document, Review, Modernize, Unit tests, Fix compile errors, Write SQL); the 💡 on an IBM i compile error offers Ask AI to explain and fix; right-click an object → AI: Explain This Object.
- The same tools work in Copilot agent mode:
#ibmiQuery,#ibmiSource,#ibmiObject,#ibmiSearch,#ibmiStatus. - Settings:
vanthrex.ai.enabled,vanthrex.ai.useTools,vanthrex.ai.allowQueries,vanthrex.ai.confirmQueries,vanthrex.ai.maxSourceChars.
New: Git for IBM i source
- Git: Export Source to a Git Repository (right-click a library or source file): saves every member as
library/sourcefile/member.type, then offers to create the repository, make the first commit and publish it (GitHub, GitLab, Azure DevOps…). - Git: Get Changes from IBM i brings in only the members changed on the system since the last sync; Git: Upload Changed Files to IBM i sends only the files you changed — to their own libraries or to another one (for example your development library). Files changed on both sides are flagged, never silently overwritten.
- Git: History of This Member: every committed version of the member you are editing — compare with the IBM i copy, compare with the previous version, open it, or restore it into the editor.
- Git: Commit & Push with the author from your Git configuration or from
vanthrex.git.authorName/vanthrex.git.authorEmail.
New: call graph & impact analysis
- Call Graph (right-click a program, service program or file): an interactive diagram of who calls the object (callers, the impact of a change) and what it uses (programs, service programs, files with input/output/update usage), several levels deep. Pan, zoom, change depth, hide files, click any object for its actions, and Copy as Mermaid for docs and pull requests.
- Impact Analysis (Who Uses This?): the callers view directly, with a count of the programs and libraries affected.
New: several systems at once
- Connect to more than one IBM i (for example DEV and PROD) and switch instantly with Switch IBM i System (quick menu, status bar or the Connections view). Other systems stay connected in the background.
- A member or IFS file is always saved to the system it was opened from — saving while another system is active is refused with a clear message.
New: SQL performance — Explain
- Explain SQL (Performance) in a SQL editor (also on the editor title): runs the query under a database monitor and summarises the access plan — table scans and why, indexes used, temporary indexes, sorts — with tips, the optimizer’s advised indexes and the index advisor history, plus a ready-to-review
CREATE INDEXstatement.
Better: fixed → free conversion
- Convert Fixed Format to Free now converts H, F, D and P specs too:
ctl-opt,dcl-f(usage, keyed, devices, program-described files),dcl-s,dcl-c,dcl-ds/end-ds(overlay →pos, externally described, LIKEDS),dcl-pr/dcl-piwith parameters,dcl-proc/end-proc, long names, continued keywords and literals. Compile-time data is left untouched and long statements are wrapped at column 80.
Other
- Requires VS Code 1.95 or later.
0.5.0
New: IBM i debugger
- Debug Program (Ctrl+Alt+G, the 🐞 button on a program, or the editor title of an RPG/CL source): runs the program in a batch job under the IBM i debugger and opens a full VS Code debug session — breakpoints, step over/into/out, variables, watch and call stack. Parameters for the CALL are remembered per program.
- Uses IBM’s free IBM i Debug extension as the debug client and the IBM i Debug Service on the server; Vanthrex installs the client on request, reads the service’s port and certificate locations, downloads and trusts the certificate, and starts the session for you.
- Debugger Setup Check: one page that checks the client, the Debug Service (installed, running, certificate) and this PC’s certificate, with buttons to fix each item — including Start Debug Service.
- Settings:
vanthrex.debug.port,vanthrex.debug.ignoreCertificateErrors,vanthrex.debug.updateProductionFiles,vanthrex.debug.trace.
0.4.0
Fixes
- Members now always open. With the Mapepire SQL engine, opening a member could fail with “The editor could not be opened due to an unexpected error” (log: Result set was null). Statements that return no rows are now handled correctly, and if reading with source dates ever fails the member opens without dates instead of failing.
- Lock information works on all releases: the lock check used a column name (
MEMBER_NAME) thatQSYS2.OBJECT_LOCK_INFOdoes not have.
New: object & job tools
- Object information page: owner, created/changed/last used, days used, size, source member, journaling and every other attribute — click any object in the Libraries view. Buttons to open the source, see locks, where used, edit data and generate SQL.
- Who has this object locked? for any object, with job log, Ask to release and End job per lock holder.
- Compare two libraries (for example DEV and PROD): objects and source members that are only in one library or different, with a side-by-side diff of changed members.
- Modules & exports of a service program or ILE program, with modules whose source changed after they were compiled highlighted.
New: SQL power tools
- Generate SQL (DDL) for any table, view, index, procedure or function (
QSYS2.GENERATE_SQL). - Run SQL Script (Ctrl+Shift+Enter): runs every statement in the file and shows each result, row count or error. Stops at the first error unless
vanthrex.sql.scriptStopOnErroris off. - SQL history and saved queries: rerun, open, insert or copy a statement; star the ones you use often.
New: procedure & copybook tools (RPG)
- Generate prototype from procedure: builds the DCL-PR from a procedure’s DCL-PI, ready for your prototype copybook.
- Extract to procedure: moves selected free-form lines into a new procedure and calls it — refused when that would change behaviour (local variables, early exits, unbalanced blocks).
- Check /COPY usage: lists each copybook with the declarations the source actually uses, and comments out unused ones on request.
0.3.1
- Documentation site: full user documentation is now online at https://gauravgupta0612.github.io/vanthrex-ibmi-docs/ (installation, IBM i setup, every feature, commands, settings, troubleshooting and FAQ).
- New command Vanthrex: Open Documentation, also in the quick menu (Ctrl+Alt+I) and in the
…menu of the Connections view. - The Marketplace page links to the documentation.
- Release workflow fix: GitHub Packages publishing no longer runs the Marketplace publish script.
0.3.0
- New name: Vanthrex for IBM i (formerly Silverlake), first release on the VS Code Marketplace. Settings now start with
vanthrex.; connections are set up again after installing. - SEU-style source dates: every member line shows its change date (and optionally its sequence number). Saving keeps the dates of lines you did not touch; changed lines get today’s date. Ctrl+Alt+D cycles the display.
- Highlight lines changed since… a date (7 / 30 / 90 days or any date), with a list to jump between them.
- Lock information in the editor: a banner shows who has the member open (name, user, job, lock state), with Ask to release (break message), Notify me when free and End their job.
- Edit conflict protection: warns before saving over a member that someone changed after you opened it (with Compare first), or that is locked by another job.
- F4 prompter for fixed-format RPG (H, F, D, P, C specs) and DDS: edit the columns in a labelled form.
- CL command prompter: F4 on a CL command (or Prompt and Run CL Command) builds a form from the command’s real definition on the IBM i.
- Member list: last change date in the tree, sort by name or date, filter by “changed in the last N days”.
- Safer member saves: lines are staged in QTEMP and the member is replaced in one step, with automatic restore if the replace fails.
- Releases are also published to GitHub Packages.
0.2.0
- System dashboard: CPU, ASP, jobs, memory, top jobs, QSYSOPR messages and PTF groups, refreshing automatically.
- Active Jobs view: filter by me, user, subsystem or all; job log, hold, release, end.
- Messages view: QSYSOPR and your own queue, inquiry messages first, reply and remove, send messages.
- Table data editor: filter, page, edit, insert and delete rows, with type validation before writing.
- Object search (Ctrl+Alt+O), source code search (Ctrl+Alt+F), Where used, Open program source.
- RPG navigation: go to definition (including /COPY members), references, scoped rename, occurrence highlight, /COPY links, declaration hover.
- SQL autocomplete and hover for tables, views and columns from the Db2 for i catalog.
- Local history: versions of every member and IFS file you open or save; compare, restore, compare with the IBM i copy, compare two members.
- RPG code checks with quick fixes and per-rule switches.
- The extension now reports start-up problems instead of failing silently.
0.1.0 (first release)
- Guided connection form with Test connection; passwords kept in the VS Code secret store.
- Status bar menu (Ctrl+Alt+I) for quick actions.
- Libraries & Source browser: source files, members, objects; add/remove libraries, set the current library.
- Find a member by name pattern across the library list.
- Edit source members and IFS files in place (UTF-8 transfer through CCSID 1208).
- One-key compile with configurable actions and inline errors from EVFEVENT.
- Db2 for i SQL: Mapepire over SSH (no server install, needs Java), Mapepire daemon or db2util; results grid with sort, filter and CSV export.
- CL command runner with history.
- Spooled file viewer: open, save, delete.
- RPG: syntax highlighting (free and fixed), outline, hovers for BIFs/opcodes, fixed-format column hints,
%completion, snippets, fixed C-spec → free conversion. - CL and DDS syntax highlighting and snippets.
Full release history: GitHub Releases.