Commands

All 684 commands contributed by Vanthrex for IBM i 3.3.0. Run any of them from the Command Palette (Ctrl+Shift+P, type Vanthrex). Most are also on right-click menus and view toolbars.

Command ID Keys
*PUBLIC Authority Scan vanthrex.publicAuthorityScan  
A CSV line from the selected variables vanthrex.dev.rpgCsvLine  
A JSON object from the selected variables (SQL) vanthrex.dev.rpgJsonObject  
A table from this SELECT (CREATE TABLE AS … WITH DATA) vanthrex.dev.sqlCreateTableAs  
Active Jobs Map (Visual) vanthrex.jobsMap  
Add a global error handler vanthrex.dev.clErrorHandler  
Add a Header to Every Procedure vanthrex.rpg.documentAll  
Add a row number column vanthrex.dev.addRowNumber  
Add a running total column vanthrex.dev.sqlRunningTotal  
Add an identity column to this CREATE TABLE vanthrex.dev.sqlIdentity  
Add an SQLSTATE check after every EXEC SQL vanthrex.dev.rpgSqlChecks  
Add audit columns to this CREATE TABLE vanthrex.dev.sqlAuditColumns  
Add Binding Directory Entry… vanthrex.bnddir.add  
Add Change Log Entry vanthrex.changeLogEntry  
Add CONST to every read-only parameter vanthrex.dev.constEverywhere  
Add DCL-PR From the Source Index vanthrex.rpg.addPrototype  
Add each row’s percent of the total vanthrex.dev.sqlPercent  
Add IBM i Connection… vanthrex.addConnection  
Add Job Schedule Entry… vanthrex.addJobSchedule  
Add Library to Library List vanthrex.tracker.addLibrary  
Add Library… vanthrex.addLibrary  
Add Message Description… vanthrex.messageFile.add  
Add Note to This Line… vanthrex.notes.add  
Add paging (OFFSET … FETCH NEXT) vanthrex.dev.addPaging  
Add the previous row’s value and the change (LAG) vanthrex.dev.sqlPrevious  
Add to Favorites vanthrex.menus.addFavorite  
Add User to Authorization List… vanthrex.secadm.addAutlEntry  
AI: Ask the IBM i Assistant… vanthrex.ai.open  
AI: Change the Selected Code… vanthrex.ai.edit Ctrl+Alt+E
AI: Convert File I/O to Embedded SQL vanthrex.ai.sqlio  
AI: Document This Code vanthrex.ai.document  
AI: Explain & Fix Compile Errors vanthrex.ai.fix  
AI: Explain Compile Errors vanthrex.ai.errors  
AI: Explain Program Dependencies vanthrex.ai.dependencies  
AI: Explain This Code vanthrex.ai.explain  
AI: Explain This Object vanthrex.ai.explainObject  
AI: Explain This Spooled File vanthrex.ai.explainSpool  
AI: Generate Test Data for This Table vanthrex.ai.testData  
AI: Generate Unit Tests (RPGUnit) vanthrex.ai.test  
AI: Is the System Healthy? vanthrex.ai.health  
AI: Make This SQL Faster vanthrex.ai.tune  
AI: Modernize to Free-Form RPG vanthrex.ai.modernize  
AI: Open SQL in Scratchpad vanthrex.ai.openSql  
AI: Preview What the AI Sees vanthrex.ai.previewRedaction  
AI: Privacy and Security vanthrex.ai.privacy  
AI: Review Authorities vanthrex.ai.security  
AI: Review My Changes vanthrex.ai.changes  
AI: Review This Code vanthrex.ai.review  
AI: Show Audit Trail vanthrex.ai.showAudit  
AI: Turn Suggestions While Typing On or Off vanthrex.ai.toggleInlineSuggestions  
AI: Why Did This Job Fail? vanthrex.ai.jobLog  
AI: Write CL from a Description… vanthrex.ai.cl  
AI: Write SQL from a Description… vanthrex.ai.sql  
Align Declarations vanthrex.rpg.alignDeclarations  
Align end-of-line comments vanthrex.dev.alignComments  
Align the = signs vanthrex.dev.alignAssignments  
Align the selection as a table vanthrex.dev.alignColumns  
All Member Notes… vanthrex.notes.all  
Analyze Job Log vanthrex.analyzeJobLog  
Apply Replace vanthrex.replaceInSourceFile.apply  
Audit trigger for this CREATE TABLE vanthrex.dev.sqlAuditTrigger  
Authorization List Entries vanthrex.secadm.autlEntries  
Authorization List Entry Options vanthrex.secadm.autlRow  
Authorization Lists vanthrex.secadm.autl  
Backup Freshness (Libraries Not Saved Lately) vanthrex.backupFreshness  
Batch Job Timeline (Visual) vanthrex.jobTimeline  
Bookmarks vanthrex.bookmark.list Ctrl+Alt+Shift+B
Browse Schema (SQL Objects)… vanthrex.schemaBrowser  
Build Project on IBM i vanthrex.build  
Call a Web API from the IBM i… vanthrex.callWebApi  
Call Graph… vanthrex.callGraph  
Call Program vanthrex.objectCall  
Call Program (Typed Parameters)… vanthrex.callTyped  
Call Stored Procedure… vanthrex.callProcedure  
Can the IBM i Reach This Host? (Ping)… vanthrex.networkTest  
Cancel SQL Statement… vanthrex.activeSql.cancel  
Change Character Set (CCSID)… vanthrex.ifsCcsid.change  
Change Data Area Value… vanthrex.editDataArea  
Change Keyword Case… vanthrex.rpg.keywordCase  
Change Library Description… vanthrex.changeLibraryText  
Change Member Description… vanthrex.changeMemberText  
Change Object Description… vanthrex.changeObjectText  
Change Owner or Authority of Many Objects… vanthrex.bulkOwnerAuthority  
Change Permission… vanthrex.ifsPermissions.row  
Changes Kept While Offline… vanthrex.pendingSaves  
Character Set (CCSID)… vanthrex.ifsCcsid  
Check /COPY Usage (Find Unused Copybooks) vanthrex.checkCopybooks  
Check Authority (Can a User Use This?)… vanthrex.checkAuthority  
Check Connection Health vanthrex.connection.health  
Check for Problem Characters vanthrex.checkCharacters  
Check Service Program Signatures vanthrex.signatureCheck  
Choose Which Jobs to Show… vanthrex.filterJobs  
CL command → RPG call (QSYS2.QCMDEXC) vanthrex.dev.rpgCl  
CL in upper case vanthrex.dev.clUppercase  
Clean Up Library List (Remove Missing Libraries) vanthrex.cleanupLibraryList  
Clean up the source vanthrex.dev.cleanSource  
Clear Change Markers (Columns 1-5) vanthrex.rpg.clearChangeMarkers  
Clear Compile History vanthrex.compileHistory.clear  
Clear Data Queue… vanthrex.clearDataQueue  
Clear Library (Delete All Objects)… vanthrex.clearLibrary  
Clear Recent vanthrex.menus.clearRecent  
Clear SQL History vanthrex.clearSqlHistory  
Clear Table Data… vanthrex.clearTableData  
Clear the Member Cache vanthrex.memberCache.clear  
CLEAR the selected variables vanthrex.dev.clearVars  
Close the Open Block (ENDIF, ENDDO…) vanthrex.rpg.closeBlock Ctrl+Alt+.
Code Health Report of a Library… vanthrex.codeHealth  
Code Metrics vanthrex.codeMetrics  
Columns Close to Their Limit… vanthrex.capacityCheck  
Command Line (5250 Style) vanthrex.commandLine Ctrl+Alt+K
Command Line Function Key vanthrex.commandLine.key F12 / F4 / F9
Commands to Save and Delete Unused Objects vanthrex.unusedObjects.commands  
COMMENT ON for every column of this CREATE TABLE vanthrex.dev.commentOn  
Comment out with a date, author and reason vanthrex.dev.commentOut  
Compare Folder with IFS… vanthrex.compareWithIfs  
Compare Library With Snapshot… vanthrex.compareSnapshot  
Compare Options vanthrex.ifsSync.row  
Compare System Values with Another System… vanthrex.compareSystemValues  
Compare Table Data (DEV ↔ PROD)… vanthrex.compareData  
Compare Table Structure… vanthrex.compareStructure  
Compare Two Libraries… vanthrex.compareLibraries  
Compare with Another Member… vanthrex.compareMembers  
Compare with Another Spooled File… vanthrex.spoolCompare  
Compare with Another System… vanthrex.compareSystems  
Compare with Copy on IBM i vanthrex.compareWithServer  
Compare with File on This PC… vanthrex.compareWithLocalFile  
Compare with IFS File… vanthrex.compareWithIfsFile  
Compare with Selected vanthrex.compareWithSelected  
Compile Changed Members… vanthrex.batchCompile  
Compile Current Source vanthrex.compile Ctrl+Alt+C
Compile History vanthrex.compileHistory  
Compile Local File on IBM i vanthrex.compileLocal  
Compile With… vanthrex.compileWith  
Compress (zip / tar)… vanthrex.ifsCompress  
Connect vanthrex.connect  
Convert a date between IBM i formats vanthrex.dev.ibmiDate  
Convert a Date or Timestamp (*ISO, *CYMD, *JUL…)… vanthrex.convertDate  
Convert a subroutine to a procedure vanthrex.dev.subrToProc  
Convert DDS to SQL (CREATE TABLE / INDEX) vanthrex.ddsToSql  
Convert Fixed Format to Free (H, F, D, P and C Specs) vanthrex.convertToFree  
Convert IF / ELSEIF to SELECT / WHEN vanthrex.rpg.ifToSelect  
Convert Packed / Zoned / Binary ↔ Hex… vanthrex.convertNumber  
Convert Text ↔ EBCDIC Hex… vanthrex.convertEbcdic  
Copy a call of this procedure vanthrex.dev.copyCall  
Copy a Link That Opens This Line vanthrex.copyLink  
Copy a reference to this line vanthrex.dev.copyLineRef  
Copy as an SQL call (QSYS2.QCMDEXC) vanthrex.dev.toQcmdexc  
Copy as embedded SQL for RPG vanthrex.dev.sqlToEmbedded  
Copy as Markdown vanthrex.dev.copyMarkdown  
Copy Data Structure Layout vanthrex.dsLayout.copy  
Copy DSPMSGD for the message ID vanthrex.dev.ibmiMessage  
Copy IFS Path vanthrex.ifsCopyPath  
Copy Library… vanthrex.copyLibrary  
Copy Members to Another Source File… vanthrex.copyMembers  
Copy Objects to Another Library… vanthrex.copyObjects  
Copy Release Notes vanthrex.changeReport.copy  
Copy Rows as SQL INSERT Script… vanthrex.exportInserts  
Copy Self-Check Report vanthrex.selfCheck.copy  
Copy System Summary vanthrex.tracker.copySummary  
Copy Table Data To… vanthrex.copyTableData  
Copy the compile command vanthrex.dev.copyCompile  
Copy the prototype of this procedure vanthrex.dev.copyPrototype  
Copy to Another System… vanthrex.copyToSystem  
Copy To… vanthrex.ifsCopyTo  
Copy User Profile… vanthrex.secadm.copyUser  
Count lines, words and characters vanthrex.dev.countText  
Create Advised Index vanthrex.createAdvisedIndex  
Create Authorization List… vanthrex.secadm.createAutl  
Create IBM i Project (iproj.json, Rules.mk)… vanthrex.createProject  
Create IFS Folder or File… vanthrex.createIfs  
CREATE INDEX for this SELECT vanthrex.dev.indexForSelect  
Create Library… vanthrex.createLibrary  
Create SQL Procedure for This Program… vanthrex.sqlWrapper  
CREATE TABLE → CREATE OR REPLACE TABLE vanthrex.dev.createOrReplace  
Create Table From CSV or Excel File… vanthrex.csvToTable  
CREATE TABLE from this data structure vanthrex.dev.tableFromDs  
Create User Profile… vanthrex.secadm.createUser  
CREATE VIEW from this SELECT vanthrex.dev.sqlCreateView  
CRUD Matrix (Which Program Uses Which File) vanthrex.crudMatrix  
CSV lines to SQL VALUES / INSERT vanthrex.dev.csvToValues  
Data Profile of a Table… vanthrex.profileTable  
Data structure from CREATE TABLE vanthrex.dev.dsFromTable  
Data Structure Layout (Positions and Lengths) vanthrex.dsLayout  
Database Diagram vanthrex.databaseDiagram  
DCL-S lines → a parameter list (DCL-PI) vanthrex.dev.varsToParms  
Debug Program vanthrex.debugProgram Ctrl+Alt+G
Debugger Setup Check vanthrex.debugSetup  
Declare a Name vanthrex.fix.declare  
Declare all undeclared CL variables vanthrex.dev.declareClVars  
Declare all undeclared SQL host variables vanthrex.dev.declareHostVars  
Delete vanthrex.ifsDelete  
DELETE → SELECT (see the rows first) vanthrex.dev.sqlDeleteToSelect  
Delete a Saved Set of Sources… vanthrex.sourceSet.delete  
Delete duplicate rows, keep the first (preview first) vanthrex.dev.sqlDeleteDups  
Delete Library… vanthrex.deleteLibrary  
Delete Member vanthrex.deleteMember  
Delete Object vanthrex.objectDelete  
Delete Spooled File vanthrex.spoolDelete  
Deploy All Files to IBM i (IFS) vanthrex.deployAll  
Deploy Changes to IBM i (IFS) vanthrex.deploy  
Developer Converters (Packed, EBCDIC, Dates)… vanthrex.converters  
Disable Unused Profiles vanthrex.secadm.disableInactive  
Disconnect vanthrex.disconnect  
Disconnect All Systems vanthrex.disconnectAll  
Disk Units Map (Visual) vanthrex.diskUnitsMap  
Document This Library (Markdown) vanthrex.documentLibrary  
Download Members to This PC… vanthrex.downloadMembers  
Download Save File… vanthrex.downloadSaveFile  
Download to This PC… vanthrex.ifsDownload  
DROP TABLE IF EXISTS for this CREATE TABLE vanthrex.dev.sqlDrop  
Drop Unused Index vanthrex.dropIndex  
DSPLY the selected variables (for testing) vanthrex.dev.traceVars  
E-mail Query Result (Excel)… vanthrex.emailQuery  
EBCDIC hex literal to text vanthrex.dev.fromEbcdicHex  
Edit Connection… vanthrex.editConnection  
Edit Table Data… vanthrex.editData  
Embedded SQL Statement Statistics… vanthrex.sqlStatementStats  
End Job… vanthrex.endJob  
Environment Variables (System and Job) vanthrex.environmentVariables  
Exit Points and Exit Programs vanthrex.exitPoints  
Expand SELECT * Into Columns vanthrex.expandStar  
Explain Message ID… vanthrex.explainMessage  
Explain SQL (Performance) vanthrex.explainSql  
Explain SQLCODE / SQLSTATE / RPG Status… vanthrex.explainCode  
Export a Team Setup File… vanthrex.team.export  
Export Data Differences (CSV)… vanthrex.exportDataCompare  
Export Notebook to Markdown vanthrex.notebook.exportMarkdown  
Export Query Result (Excel, CSV, JSON)… vanthrex.exportQuery  
Export Table Data (Excel, CSV, JSON)… vanthrex.exportData  
Extract Here… vanthrex.ifsExtract  
Extract to Named Constant (DCL-C) vanthrex.extractConstant  
Extract to Procedure… vanthrex.extractProcedure  
Failed Job Options vanthrex.failedJobs.row  
Failed Jobs (Ended Abnormally) vanthrex.failedJobs  
Field Finder… vanthrex.fieldFinder  
Filter Members by Last Change… vanthrex.filterMembersByDate  
Find & Open Member… vanthrex.findMember Ctrl+Alt+M
Find a CL Command… vanthrex.findCommand  
Find a Message in Job Logs… vanthrex.findMessageInJobLogs  
Find a Text in Spooled Files… vanthrex.searchSpooledFiles  
Find a Value in Table Data… vanthrex.findInTable  
Find and Replace in Source File… vanthrex.replaceInSourceFile  
Find duplicate rows in this table vanthrex.dev.sqlDuplicates  
Find Duplicate Rows… vanthrex.findDuplicates  
Find Hard-Coded Libraries vanthrex.hardcodedLibraries  
Find IFS Files by Name… vanthrex.ifsFindByName  
Find Orphan Rows (Missing Parent)… vanthrex.orphanRows  
Find RPGUnit Tests… vanthrex.rpgunit.discover  
Find Unused Code vanthrex.unusedCode  
Fix Currency (Firmware, PTFs, CVEs) vanthrex.fixCurrency  
Fix Problem Characters vanthrex.fixCharacters  
Fixed Format: Fields of This Line… vanthrex.fixedFields  
Fixed Format: Next Field vanthrex.nextField Ctrl+Alt+]
Fixed Format: Previous Field vanthrex.previousField Ctrl+Alt+[
Flowchart of This Procedure vanthrex.flowchart  
Follow File (tail -f) vanthrex.followIfsFile  
Format Embedded SQL vanthrex.rpg.formatEmbeddedSql  
Format SQL vanthrex.formatSql  
Function Usage Map (Visual) vanthrex.functionUsageMap  
Generate a Prototype Copybook From the Exports vanthrex.rpg.prototypeCopybook  
Generate Binder Source From the Exports vanthrex.rpg.binderSource  
Generate CALL Statement for a Procedure or Function… vanthrex.generateCall  
Generate Documentation (Markdown) vanthrex.generateDocs  
Generate Prototype from Procedure vanthrex.generatePrototype  
Generate RPG Code for This Table vanthrex.generateRpgForTable  
Generate RPG for This Query vanthrex.queryToRpg  
Generate RPG from a JSON Sample… vanthrex.jsonToRpg  
Generate RPG Program for This Display File vanthrex.rpgFromDspf  
Generate RPGUnit Tests… vanthrex.rpgunit.generate  
Generate SQL (DDL) vanthrex.generateDdl  
Generate SQL Statements (SELECT, INSERT, UPDATE, DELETE, MERGE)… vanthrex.crudSql  
Generate Test Data… vanthrex.generateTestData  
Get This Connection Ready (Warm-up) vanthrex.warmUp  
Getter and setter procedures for the selected variables vanthrex.dev.rpgGetSet  
Getting Started vanthrex.openWalkthrough  
Git: Commit & Push IBM i Source… vanthrex.git.commitPush  
Git: Export Source to a Git Repository… vanthrex.git.export  
Git: Get Changes from IBM i vanthrex.git.download  
Git: History of This Member… vanthrex.git.memberHistory  
Git: Upload Changed Files to IBM i vanthrex.git.upload  
GO Menus (AS/400 Style)… vanthrex.goMenu Ctrl+Alt+Shift+M
Go to Anything (Members, Objects, Recent)… vanthrex.goToAnything Ctrl+Alt+J
Go to IFS Directory… vanthrex.ifsChangeRoot  
Go to Line vanthrex.gotoLine  
Go to Matching IF / ELSE / END vanthrex.gotoMatchingBlock Ctrl+Shift+\
Go to Next Changed Block vanthrex.nextChangedBlock  
Go to Next Procedure vanthrex.rpg.nextProcedure Ctrl+Alt+Pagedown
Go to Pinned Folder vanthrex.pin.ifsDir  
Go to Previous Changed Block vanthrex.previousChangedBlock  
Go to Previous Procedure vanthrex.rpg.previousProcedure Ctrl+Alt+Pageup
Grant Missing Authority vanthrex.grantAuthority  
Group Profiles vanthrex.secadm.groups  
Group the variables in a data structure vanthrex.dev.groupInDs  
Hardware and Devices vanthrex.hardwareStatus  
Hex ↔ decimal vanthrex.dev.ibmiHex  
Highlight Lines Changed Since… vanthrex.changedSince  
Hold Job vanthrex.holdJob  
How many rows will change? (COUNT first) vanthrex.dev.countFirst  
IBM i Tools for This Source… vanthrex.dev.toolbox Ctrl+Alt+A
IBM i: Work with… vanthrex.workWith  
IFS Folders by Size… vanthrex.ifsStorage  
IFS Space Map (Visual)… vanthrex.ifsSpaceMap  
Impact Analysis (Who Uses This?)… vanthrex.impactAnalysis  
Import a Team Setup File… vanthrex.team.import  
Import Coding Standards from rpglint.json… vanthrex.standards.importRpglint  
Import CSV or Excel into Table… vanthrex.importData  
Import My Code for IBM i Setup (Connections, Library Lists, Actions)… vanthrex.importCodeForIbmi  
Index Advice Chart (Visual)… vanthrex.indexAdviceChart  
Index Advisor vanthrex.indexAdvisor  
Index Source Libraries for Instant Search… vanthrex.index.build  
Indicator Usage vanthrex.indicatorUsage  
Insert a %LOOKUP in a sorted array vanthrex.dev.rpgLookup  
Insert a check that an object exists (SQL) vanthrex.dev.rpgObjectExists  
Insert a CL program skeleton with error handling vanthrex.dev.clProgram  
Insert a commit / rollback block vanthrex.dev.rpgCommit  
Insert a date / time literal vanthrex.dev.dateLiteral  
Insert a date conversion (CVTDAT) vanthrex.dev.clConvertDate  
Insert a date conversion between formats vanthrex.dev.rpgDateConv  
Insert a file information data structure (INFDS) vanthrex.dev.infds  
Insert a FOR-EACH loop over an array vanthrex.dev.rpgForEach  
Insert a job log message (QMHSNDPM) vanthrex.dev.rpgJobLog  
Insert a library list change that is put back vanthrex.dev.clLibl  
Insert a loop over the members of a file vanthrex.dev.clMemberLoop  
Insert a loop over the objects of a library vanthrex.dev.clObjectLoop  
Insert a multi-row FETCH (100 rows at a time) vanthrex.dev.rpgMultiFetch  
Insert a program header vanthrex.dev.programHeader  
Insert a QShell command that stops on failure vanthrex.dev.clQsh  
Insert a question to the user (SNDUSRMSG) vanthrex.dev.clAskUser  
Insert a RCVF loop over a file vanthrex.dev.clReadLoop  
Insert a READ loop over a file vanthrex.dev.readLoop  
Insert a recursive query (parent / child tree) vanthrex.dev.sqlHierarchy  
Insert a retry loop with a delay vanthrex.dev.rpgRetry  
Insert a retry loop with DLYJOB vanthrex.dev.clRetry  
Insert a section separator vanthrex.dev.separator  
Insert a time measurement (milliseconds) vanthrex.dev.rpgElapsed  
Insert an SQL cursor loop vanthrex.dev.cursorLoop  
Insert an SQL function skeleton vanthrex.dev.sqlFunction  
Insert an SQL procedure skeleton vanthrex.dev.sqlProcedure  
Insert CHKOBJ with MONMSG vanthrex.dev.clCheckObject  
Insert Column Ruler vanthrex.rpg.ruler  
Insert CPYF (created when missing) vanthrex.dev.clCopyFile  
Insert days, months and years between two dates vanthrex.dev.rpgDateDiff  
INSERT from this CREATE TABLE vanthrex.dev.insertFromCreate  
Insert GET DIAGNOSTICS (message of the last SQL error) vanthrex.dev.rpgDiagnostics  
Insert Procedure Skeleton… vanthrex.rpg.procedureHeader  
Insert reading an IFS file line by line (SQL) vanthrex.dev.rpgIfsRead  
Insert reading and writing a data area vanthrex.dev.rpgDataArea  
Insert RTVJOBA with its variables vanthrex.dev.clRtvjoba  
Insert RTVOBJD (exists, last used, changed) vanthrex.dev.clObjectInfo  
Insert RTVSYSVAL with its variable vanthrex.dev.clSystemValue  
Insert saving a library to a save file vanthrex.dev.clSaveSavf  
Insert sending an e-mail (SNDSMTPEMM) vanthrex.dev.rpgEmail  
Insert sending and receiving a data queue entry vanthrex.dev.rpgDataQueue  
Insert Shared Snippet… vanthrex.insertSharedSnippet  
Insert SND-MSG (job log or escape message) vanthrex.dev.rpgSndMsg  
Insert SNDPGMMSG (escape, completion…) vanthrex.dev.clSendMessage  
Insert sorting a data structure array by a subfield vanthrex.dev.rpgSortDs  
Insert splitting a text into an array vanthrex.dev.rpgSplit  
Insert Test Data vanthrex.generateTestData.run  
Insert the first and last day of the month vanthrex.dev.rpgMonthBounds  
Insert the program status data structure (PSDS) vanthrex.dev.psds  
Insert today’s date in an IBM i format vanthrex.dev.ibmiToday  
Insert writing lines to an IFS file (SQL) vanthrex.dev.rpgIfsWrite  
Installed Software and License Keys vanthrex.installedSoftware  
Instant Search in Indexed Sources… vanthrex.index.search Ctrl+Alt+Shift+F
IP Interfaces and Routes vanthrex.wrkInterfaces  
Is This PTF Installed?… vanthrex.ptfLookup  
Job Description Options vanthrex.jobd.row  
Job Descriptions That Name a User vanthrex.jobdUsers  
Job Internals (Open Files, IFS, Connections)… vanthrex.jobInternals  
Job Run History (How Long Each Run Took)… vanthrex.jobRunHistory  
Job Schedule for the Next Days vanthrex.scheduleCalendar  
Jobs in Subsystem vanthrex.wrkSubsystemJobs  
Jobs on Job Queue vanthrex.wrkJobQueue  
Join the Lines of a Statement vanthrex.rpg.joinLines  
Join the lines with commas vanthrex.dev.joinComma  
Journal Activity Heat Map (Visual)… vanthrex.journalHeatMap  
Journal Coverage of a Library… vanthrex.journalCoverage  
Journal Explorer: Who Changed This Table? vanthrex.journalExplorer  
Journal Options vanthrex.journals.row  
Journals vanthrex.journals  
JSON_TABLE Query From a JSON Sample vanthrex.jsonTable  
Keep the line as a comment before changing it vanthrex.dev.keepAsComment  
LABEL ON for every column of this CREATE TABLE vanthrex.dev.labelOn  
Library List from a Job Description or User Profile… vanthrex.libraryListFromJobd  
Library List Sets… vanthrex.librarySets  
Library Space Map (Visual)… vanthrex.spaceMap  
Limit to 100 rows vanthrex.dev.limitSelect  
Limits Watch (Visual) vanthrex.limitsWatch  
Lines to an SQL IN list vanthrex.dev.inList  
Lines to named constants vanthrex.dev.linesToConstants  
Live Alerts vanthrex.alerts.show  
Live Job Log vanthrex.jobLogLive  
Lock Wait Chains (Visual) vanthrex.lockWaitChains  
Lower case (literals untouched) vanthrex.dev.lowerCase  
Maintained Temporary Indexes vanthrex.temporaryIndexes  
Manage SQL Watches vanthrex.sqlWatch.manage  
Member Lock: Ask Holder to Release… vanthrex.lockAskRelease  
Member Lock: Check Again vanthrex.lockRefresh  
Member Lock: End Holder’s Job… vanthrex.lockEndJob  
Member Lock: Notify Me When Free vanthrex.lockWatch  
Member Lock: Options… vanthrex.lockActions  
MERGE (insert or update) from this CREATE TABLE vanthrex.dev.mergeFromCreate  
Message Everyone Signed On… vanthrex.signedOn.broadcast  
Message Options vanthrex.messageQueue.row  
Missing numbers in a numbered column (gaps) vanthrex.dev.sqlGaps  
Most Frequent Values vanthrex.profileTable.top  
Move Down vanthrex.pin.moveDown  
Move Down in Library List vanthrex.moveLibraryDown  
Move or Rename… vanthrex.ifsMoveTo  
Move Up vanthrex.pin.moveUp  
Move Up in Library List vanthrex.moveLibraryUp  
My Recent Jobs vanthrex.myRecentJobs  
My SQL Job (Library List and Job Log) vanthrex.mySqlJob  
Names to camelCase vanthrex.dev.camelCase  
Names to UPPER_SNAKE (SQL style) vanthrex.dev.upperSnake  
Negate the condition vanthrex.dev.negateCondition  
NetServer File Shares vanthrex.netServerShares  
Network Configuration vanthrex.networkConfig  
New File… vanthrex.ifsNewFile  
New Folder… vanthrex.ifsNewFolder  
New IBM i Notebook (SQL, CL, Shell) vanthrex.newNotebook  
New Member from Template… vanthrex.newFromTemplate  
New Member… vanthrex.newMember  
New Source File… vanthrex.newSourceFile  
New SQL Scratchpad vanthrex.newSqlScratchpad  
Notes on This Member vanthrex.notes.show  
Number the lines vanthrex.dev.numberLines  
Object Information vanthrex.objectInfo  
Objects Built from This Source vanthrex.builtFrom  
Objects Hidden in the Library List vanthrex.shadowedObjects  
Objects Out of Sync with Source vanthrex.outOfSync  
Only the last days (date filter) vanthrex.dev.sqlLastDays  
Open vanthrex.menus.run  
Open 5250 Session vanthrex.open5250  
Open a Saved Set of Sources… vanthrex.sourceSet.open  
Open ALTER Script vanthrex.compareStructure.script  
Open Documentation vanthrex.openDocs  
Open IBM Documentation for the Word vanthrex.rpg.ibmDocs  
Open IBM i Reference vanthrex.openRef  
Open Local History Folder vanthrex.openHistoryFolder  
Open Member vanthrex.codeMetrics.open  
Open PASE Terminal (IBM i Shell) vanthrex.paseTerminal Ctrl+Alt+P
Open PASE Terminal Here vanthrex.paseTerminalHere  
Open Pinned Item vanthrex.pin.open  
Open Program Source vanthrex.openProgramSource  
Open Source vanthrex.compileHistory.open  
Open Source at Line vanthrex.openSourceAtLine  
Open Source at Line vanthrex.ai.openAt  
Open Spooled File vanthrex.spoolOpen  
Open System Dashboard vanthrex.openDashboard  
Open this embedded SQL as a script vanthrex.dev.embeddedToSql  
Options vanthrex.extras.row  
Parameter lines → DCL-S vanthrex.dev.parmsToVars  
PDM Function Key vanthrex.pdm.key F12 / F13 / F16 / F17 / F21 / F23 / F3 / F5 / F6 / Shift+F1 / Shift+F11 / Shift+F4 / Shift+F5 / Shift+F9
PDM: User-Defined Options (F16)… vanthrex.pdm.userOptions  
Performance Monitor vanthrex.performanceMonitor  
Permissions… vanthrex.ifsPermissions  
Pin / Unpin vanthrex.pin  
Pivot: one column per value vanthrex.dev.sqlPivot  
Powerful User Profiles vanthrex.secadm.powerful  
Preview Command Prompt (F4) from Source vanthrex.previewCommandSource  
Preview Data (first rows) vanthrex.objectQuery  
Preview Screen (Display File) vanthrex.previewDspf  
Print Preview (Printer File) vanthrex.previewPrtf  
Program Attributes Audit (Adopted Authority)… vanthrex.programAudit  
Programs That Would Get a Level Check… vanthrex.levelCheck  
Promote Objects (DEV → TEST → PROD)… vanthrex.promoteObjects  
Promotion Log vanthrex.promotionLog  
Prompt (F4) vanthrex.prompt F4
Prompt and Run CL Command (F4)… vanthrex.promptCl  
Prompt on Command Line (F4) vanthrex.menus.prompt  
PTF & System Health vanthrex.systemHealth  
Put the lines in a comment box vanthrex.dev.boxComment  
Put the selection between ALCOBJ and DLCOBJ vanthrex.dev.clAllocate  
Put the selection between OVRDBF and DLTOVR vanthrex.dev.clOverride  
Quote each line vanthrex.dev.quoteLines  
Re-bind All Failing Objects vanthrex.signatureCheck.rebindAll  
Re-bind to the Current Signature vanthrex.signatureCheck.rebind  
Read without waiting for locks (WITH UR) vanthrex.dev.readUncommitted  
Recompile Broken Sources vanthrex.compileHistory.recompileBroken  
Recompile the Programs That Use This File… vanthrex.rebuildImpacted  
Reconnect Now vanthrex.connection.reconnectNow  
Refresh vanthrex.refreshLibraries  
Refresh vanthrex.refreshIfs  
Refresh vanthrex.refreshSpool  
Refresh vanthrex.refreshJobs  
Refresh vanthrex.refreshMessages  
Refresh SQL Table & Column Cache vanthrex.refreshSqlCache  
Release Job vanthrex.releaseJob  
Remove all DSPLY vanthrex.dev.removeDsply  
Remove Binding Directory Entry… vanthrex.bnddir.remove  
Remove blank lines vanthrex.dev.removeBlank  
Remove Connection vanthrex.deleteConnection  
Remove duplicate lines vanthrex.dev.uniqueLines  
Remove EVAL and CALLP vanthrex.dev.removeEval  
Remove from Favorites vanthrex.menus.removeFavorite  
Remove Library from List vanthrex.removeLibrary  
Remove Message vanthrex.removeMessage  
Remove the Local Source Index vanthrex.index.clear  
Remove Unused Declarations… vanthrex.rpg.removeUnusedDeclarations  
Rename Library… vanthrex.renameLibrary  
Rename Member… vanthrex.renameMember  
Rename or Move… vanthrex.moveRenameObject  
Reply List Check (Visual) vanthrex.replyListCheck  
Reply to Inquiry Message vanthrex.alerts.reply  
Reply… vanthrex.replyMessage  
Report to CSV (Excel)… vanthrex.reportToCsv  
RESET the selected variables vanthrex.dev.resetVars  
Restore from Save File… vanthrex.restoreFromSaveFile  
Retrieve Binder Source vanthrex.retrieveBinderSource  
Retrieve CL Source (RTVCLSRC) vanthrex.retrieveClSource  
Reverse the lines vanthrex.dev.reverseLines  
Row Lock Options vanthrex.rowLocks.row  
Rows that differ from another table (EXCEPT) vanthrex.dev.sqlCompare  
RPG types → SQL types vanthrex.dev.ibmiRpgToSql  
Run a CL Macro… vanthrex.runMacro  
Run CL Command on Several Systems… vanthrex.clOnSystems  
Run CL Command… vanthrex.runCl Ctrl+Alt+L
Run Import vanthrex.importData.run  
Run Promotion vanthrex.promote.run  
Run Queue Command vanthrex.tracker.cl  
Run RPG Code Checks vanthrex.lintCurrent  
Run Selection as CL or SQL vanthrex.runSelection Ctrl+Alt+R
Run SQL on Several Systems… vanthrex.sqlOnSystems  
Run SQL Query… vanthrex.sqlQuery  
Run SQL Script (All Statements) vanthrex.runSqlScript Ctrl+Shift+Enter
Run SQL Statement vanthrex.runSql Ctrl+Enter
Run SQL Statement Here vanthrex.sqlLens  
Running SQL Statements vanthrex.activeSql  
Save as PDF… vanthrex.spoolPdf  
Save as Shared Snippet… vanthrex.saveSharedSnippet  
Save CRUD Matrix as CSV vanthrex.crudMatrix.csv  
Save Files and Tapes vanthrex.saveMedia  
Save Library or Objects to a Save File… vanthrex.saveToSaveFile  
Save Query… vanthrex.saveQuery  
Save Spooled File As… vanthrex.spoolDownload  
Save the Open Sources as a Set… vanthrex.sourceSet.save  
Saved Queries… vanthrex.savedQueries  
Schema Object Options vanthrex.schema.row  
Search Objects… vanthrex.searchObjects Ctrl+Alt+O
Search Source Code… vanthrex.searchSource Ctrl+Alt+F
Search Text in Files… vanthrex.searchIfs  
Seconds ↔ h:mm:ss vanthrex.dev.ibmiDuration  
Security Admin (*SECADM) vanthrex.securityCenter  
Security Audit Journal (QAUDJRN)… vanthrex.auditJournal  
Security Audit Journal (Visual) vanthrex.auditJournalMap  
Security Configuration vanthrex.securityConfig  
Security Scorecard (Visual) vanthrex.securityScorecard  
SELECT → one JSON array (JSON_ARRAYAGG) vanthrex.dev.sqlToJson  
SELECT → SELECT COUNT(*) vanthrex.dev.selectToCount  
SELECT by key from this CREATE TABLE vanthrex.dev.selectFromCreate  
Select for Compare vanthrex.selectForCompare  
Select the current block vanthrex.dev.selectBlock  
Select the current procedure vanthrex.dev.selectProcedure  
Selection to a literal vanthrex.dev.toLiteral  
Self-Check (Is This System Ready?) vanthrex.selfCheck  
Send by E-mail… vanthrex.spoolEmail  
Send Data Queue Entry… vanthrex.sendDataQueue  
Send Message to Queue… vanthrex.messageQueue.send  
Send Message… vanthrex.sendMessage  
Session Options vanthrex.signedOn.row  
Set *PUBLIC Authority vanthrex.publicAuthority.set  
Set as Current Library vanthrex.setCurrentLibrary  
Set IFS Deploy Folder… vanthrex.deployFolder  
Set Protection (Production / Read-Only)… vanthrex.setProtection  
Set the selected variables to empty vanthrex.dev.initVars  
Short system name for a long SQL name vanthrex.dev.ibmiSystemName  
Show IBM i Quick Menu vanthrex.showMenu Ctrl+Alt+I
Show Job Log vanthrex.jobLog  
Show Local History… vanthrex.showHistory  
Show Modules & Exports vanthrex.serviceProgramInfo  
Show My Changes Since the Last Compile vanthrex.changedSinceCompile  
Show Output Log vanthrex.showOutput  
Show Queries Running Now vanthrex.activeQueries  
Show Save File Contents vanthrex.saveFileContents  
Show Source with /COPY Expanded vanthrex.expandCopies  
Sign-on Problems (Locked Out, Expired Passwords) vanthrex.signonProblems  
Simplify “= *ON” / “= *OFF” vanthrex.dev.simplifyIndicators  
Size and range of a numeric type vanthrex.dev.ibmiNumericInfo  
Size and rows of this table (IBM i Services) vanthrex.dev.sqlTableSize  
Sort Declarations by Name vanthrex.rpg.sortDeclarations  
Sort Members by Name / Date vanthrex.sortMembers  
Sort the lines (A → Z) vanthrex.dev.sortLines  
Sort the lines (Z → A) vanthrex.dev.sortLinesDesc  
Source Change Calendar (Visual)… vanthrex.changeCalendar  
Source Quality Report vanthrex.sourceQuality  
Speed Test of This Connection vanthrex.speedTest  
Split a comma list into lines vanthrex.dev.splitComma  
Spooled Files on Output Queue vanthrex.wrkOutputQueue  
SQL Error Log (Who Gets Which SQL Error?) vanthrex.sqlErrorLog  
SQL from a JSON Sample (JSON_OBJECT) vanthrex.jsonToSql  
SQL History… vanthrex.sqlHistory  
SQL INSERT / SELECT / UPDATE from this data structure vanthrex.dev.dsSql  
SQL keywords in upper / lower case vanthrex.dev.sqlCase  
SQL statement → RUNSQL for CL vanthrex.dev.clRunSql  
SQL types → RPG types vanthrex.dev.ibmiSqlToRpg  
Start Journaling the Files Not Journaled vanthrex.journalCoverage.start  
Stop Live Job Log vanthrex.jobLogLive.stop  
Storage & Cleanup Advisor… vanthrex.storageAdvisor  
Submit the selected command to batch (SBMJOB) vanthrex.dev.clSubmit  
Submit to Batch and Watch… vanthrex.submitAndWatch  
Subsystem Setup… vanthrex.subsystemSetup  
Surround With (IF, MONITOR, DOW, FOR…)… vanthrex.rpg.surround Ctrl+Alt+W
Switch IBM i System… vanthrex.switchConnection  
System Checks (Backups, Sign-on, Security…)… vanthrex.systemChecks  
System Diagnostics vanthrex.systemDiagnostics  
System Health Overview (Visual) vanthrex.healthOverview  
System History Log (QHST)… vanthrex.historyLog  
System Tracker (Everything in One Place) vanthrex.systemTracker Ctrl+Alt+T
Table Statistics vanthrex.tableStatistics  
Take a Library Snapshot vanthrex.librarySnapshot  
Team Coding Standards… vanthrex.standards.edit  
Tell Me When It Is Free vanthrex.ifsLocks.watch  
Text to an EBCDIC hex literal vanthrex.dev.toEbcdicHex  
Time This SQL Statement (Several Runs) vanthrex.sqlBenchmark  
TODO and FIXME Notes in Open Sources… vanthrex.sourceNotes  
Toggle Bookmark vanthrex.bookmark.toggle Ctrl+Alt+B
Toggle RPG Comment vanthrex.rpg.toggleComment Ctrl+/
Toggle Source Dates (SEU) vanthrex.toggleSourceDates Ctrl+Alt+D
Toggle Value (*ON / *OFF, AND / OR, = / <>…) vanthrex.rpg.toggleValue Ctrl+Alt+Shift+T
Top rows per group (ROW_NUMBER) vanthrex.dev.sqlTopPerGroup  
Trim the lines vanthrex.dev.trimLines  
Turn IBM i Suggestions On or Off vanthrex.toggleInlineSuggestions  
Turn Live Alerts On/Off vanthrex.alerts.toggle  
Turn Off a Code Check vanthrex.disableLintRule  
Turn SQL Error Logging On or Off… vanthrex.sqlErrorLog.settings  
Undo Promotion vanthrex.promote.undo  
Unpin vanthrex.unpin  
Unused Indexes of a Library… vanthrex.unusedIndexes  
Unused Objects of a Library… vanthrex.unusedObjects  
Unused User Profiles… vanthrex.secadm.inactive  
UPDATE → SELECT (see the rows first) vanthrex.dev.sqlUpdateToSelect  
UPDATE by key from this CREATE TABLE vanthrex.dev.updateFromCreate  
Upload a File from This PC (Replace Member)… vanthrex.uploadMember  
Upload Files or a Folder Here… vanthrex.ifsUpload  
Upload Save File from this PC… vanthrex.uploadSaveFile  
Upper case (literals untouched) vanthrex.dev.upperCase  
Use compound assignments (x += 1) vanthrex.dev.compoundAssign  
User Objects in IBM Libraries (QSYS, QSYS2, QGPL) vanthrex.ibmLibraryObjects  
User Profile Options vanthrex.secadm.row  
User Storage Map (Visual) vanthrex.userStorageMap  
Values → a SELECT / WHEN vanthrex.dev.valuesToSelect  
Values → an array initialised with them vanthrex.dev.valuesToArray  
Values of a column as one list per group (LISTAGG) vanthrex.dev.sqlValueList  
View Data Area vanthrex.dataArea  
View Data Queue Entries vanthrex.dataQueue  
Watch an SQL Value in the Status Bar… vanthrex.sqlWatch.add  
Watch This Job (Notify When It Ends) vanthrex.watchJob  
What Changed (Release Notes)… vanthrex.changeReport  
What Depends on This File? vanthrex.tableDependents  
What is new in 3.3 vanthrex.dev.whatsNew  
What is this CCSID? vanthrex.dev.ibmiCcsid  
What Is This Job Doing? vanthrex.jobDetails  
Where Used… vanthrex.whereUsed  
Who Calls Each Exported Procedure?… vanthrex.procedureCallers  
Who Has It Locked? vanthrex.ifsLocks  
Who Has This Object Locked? vanthrex.objectLocks  
Who has this table locked? (IBM i Services) vanthrex.dev.sqlWhoLocks  
Who Is Locking Rows? vanthrex.rowLocks  
Who Is Signed On vanthrex.signedOn  
Work with Active Jobs vanthrex.wrkactjob  
Work with Active Jobs Function Key vanthrex.wrkactjob.key F10 / F11 / F5
Work with Binding Directory vanthrex.bindingDirectory  
Work with Job Descriptions vanthrex.wrkJobDescriptions  
Work with Job Queues vanthrex.wrkJobQueues  
Work with Job Schedule Entries vanthrex.wrkJobSchedule  
Work with Message Descriptions vanthrex.messageFile  
Work with Message Queue… vanthrex.messageQueue  
Work with My Jobs vanthrex.myJobs  
Work with Output Queues vanthrex.wrkOutputQueues  
Work with Save Files vanthrex.wrkSaveFiles  
Work with Subsystems vanthrex.wrkSubsystems  
Work with System Values vanthrex.wrkSystemValues  
Work with TCP/IP Connections (NETSTAT) vanthrex.wrkConnections  
Work with TCP/IP Servers vanthrex.wrkTcpServers  
Work with User Profiles vanthrex.wrkUserProfiles  
Work with Using PDM… vanthrex.pdm  
Work with: Options vanthrex.ww.row  
Wrap in a common table expression (WITH) vanthrex.dev.wrapInCte  
Wrap Long Line vanthrex.rpg.wrapLine  
Wrap the long CL command (+) vanthrex.dev.clWrap  
Wrap with a built-in function… vanthrex.dev.wrapWithBif  
Write CREATE INDEX for Advised Index vanthrex.explain.createIndexSql  

On a Mac, use Cmd instead of Ctrl. Some keys only work in a matching editor (for example Ctrl+Enter in .sql files).