2843 - 在 VS Code 中运行 Db2 for i.pdf

1、Orlando,FLOctober 69IBM TechXchange20252843Db2 for i inside of VS CodeSbastien JULLIANDi and me,Tech Lead R&DDb2 for i Db2 for i insideinside of VS Codeof VS CodeDb2 for IBM iWhos this guy?-Sbastien(Seb)Julliand-Code for IBM i core team member-IBM i Pipeline Steps Jenkins plugin maintainer-IBM Champ

2、ion 2024/2025-Tech Lead R&D at i and meDb2 for IBM iDb2 for IBM i VS Code extension-Open source project-Owned by the community-driven Code4i organization-Maintained by the community(non-IBMers and IBMers alike)-Requires Code for IBM i-Uses Mapepire undercover-https:/codefori.github.io/docs/extension

3、s/db2i/Db2 for IBM iMapepire undercover-Automatically installed/updated-Reads/respond on standard shell I/O-Uses a persistent DB jobDb2 for IBM iJob manager-Spawn/kill DB job-Change JDBC settings-Save and reuse-Display job log-Change SELF level-Get tracesDb2 for IBM iSchema browser-Browse SQL object

4、s-Generate SQL-Delete-View-Permissions-Authorities-LocksDb2 for IBM iSchema browser-tables-Display content(aka.Select*shortcut)-Specific options-Clear(CLRPFM)-Copy Data(CPYF)-Advised/Maintained Temporary indexesDb2 for IBM iStatement history-Past executed statements-Stored by LPAR and past-Day-Week-

5、Month-OlderDb2 for IBM iExamples-Browse built-in examples-List available services-Add custom examples-Linked to a local folder-Not connection dependantDb2 for IBM iRunning queries-Basics-Open an SQL type document-Execute statements-Ctrl+r-Run menu-Syntax checker-Content assistDb2 for IBM iRunning qu

6、eries-Bindings-Write a single query-Execute with different values-Binds to?And:var markers-Lookup the most previous statement in the document to bind to when executed-Usage:Select*From MY_TABLE Where COL1=?And COL2=?;bind:val1 val2bind:val1_bis val2 _bisDb2 for IBM iRunning queries Syntax checking-A