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).