vscode-db2i 2.0.1

What's Changed

• Improve column content assist metadata for SQL and system names by @forstie in #547
• fix: Status Bar Commit button was calling ROLLBACK instead of COMMIT by @forstie in #548
• fix: column autocomplete not working against SYSTEM_TABLE_NAME by @forstie in #550
• Fix validate_statement to not rely on hardcoded library by @julesyan in #552

New Contributors

• @forstie made their first contribution in #547

Full Changelog: 2.0.0...2.0.1

vscode-db2i 2.0.0

What's Changed

• Fix: Parser Updates for Statement Types and Handling of Unsupported Keywords by @mounigopisetti1162 in #513
• Updating dependency packages by @venky225 in #536
• Add Statement and DbCache to exported API by @SanjulaGanepola in #538
• Add ability to generate SQL with constraints by @julesyan in #540
• Fixed CL Notebook output for Code for IBM i v3 by @sebjulliand in #530
• Fix retrieval of SQL syntax checker components by @SanjulaGanepola in #537
• Update to use library qualifiers by @julesyan in #525
• Component update by @julesyan in #539

New Contributors

• @mounigopisetti1162 made their first contribution in #513

Full Changelog: 1.17.0...2.0.0

vscode-db2i 1.17.0

What's New

• Added Clear Results button and action by @sebjulliand in #506
• Allow CTE to be used with UDTF and RPG prefixes by @sebjulliand in #507
• New SQL examples for Db2 for i Services, SYSTOOLS and IBM i Services by @venky225 in #510
• Add button to retrieve more/all rows, and refresh result by @SanjulaGanepola in #516
• Exclude column label if same as column name by @SanjulaGanepola in #519
• Add support for md prefix to generate markdown tables by @SanjulaGanepola in #518
• Bump mapepire to 2.3.5 by @SanjulaGanepola in #520
• Add statements with prefixes to the history by @SanjulaGanepola in #522

What's fixed

• Update unix timestamp for existing statement history items by @SanjulaGanepola in #497
• Refresh query history when connecting by @sebjulliand in #501
• Fixed schema browser issues by @sebjulliand in #502
• Fix Visual Explain view crashing on multi-parents nodes by @sebjulliand in #489
• Fix library list not set on any SQL jobs by @SanjulaGanepola in #515
• Fix conflicting Explain without running keyboard shortcut by @SanjulaGanepola in #514
• Fix UDTF prefix bugs by @SanjulaGanepola in #517
• Fix syntax errors impacting parsing of subsequent statements by @SanjulaGanepola in #523

Other

• Bump to 1.17.0 by @SanjulaGanepola in #521

New Contributors

• @venky225 made their first contribution in #510

Full Changelog: 1.16.0...1.17.0

vscode-db2i 1.16.0

What's New

• Updated keyboard shortcuts for explaining and running by @sebjulliand in #448
• Enable SELF view for 7.6 by @sebjulliand in #455
• Add keyboard shortcut for new SQL document by @chrjorgensen in #412
• Make columns resizable and improve Null values handling by @dferrand in #409
• Add Collapse All button to all tree views by @SanjulaGanepola in #483
• Save update prefix statement to statement history by @SanjulaGanepola in #484
• Add udtf SQL prefix by @SanjulaGanepola in #459
• Add exported API to retrieve SQL examples by @SanjulaGanepola in #480
• Add support for setting any default JDBC option and setting default saved configurations by @SanjulaGanepola in #492
• Add more database object types to the Schema Browser by @SanjulaGanepola in #449
• Bump Mapepire-Server to 2.3.4 by @sebjulliand in #495

What's fixed

• Fixed runEditorStatement command crashing when invoked with no editor opened by @sebjulliand in #456
• fix for #466 Update status could also be UP_TO_DATE by @drahreg in #467
• Add missing pr_testing_template by @janfh in #369
• Fix missing whitespace in job log's MESSAGE_TEXT and MESSAGE_SECOND_LEVEL_TEXT by @SanjulaGanepola in #485
• Fix single character empty cells not being updatable by @SanjulaGanepola in #486
• Add missing Open SQL Document shortcut to package.json by @SanjulaGanepola in #487
• Fixed SQLJobManager::endAll() crashing when disconnecting by @sebjulliand in #490
• Fix actions on quoted database objects by @SanjulaGanepola in #482

Other

• Bump to v1.16.0 by @SanjulaGanepola in #488

New Contributors

• @drahreg made their first contribution in #467

Full Changelog: 1.15.1...1.16.0

vscode-db2i 1.15.1

What's Changed

• Fix view contents button when no active editor by @SanjulaGanepola in #446
• Bump to v1.15.1 by @SanjulaGanepola in #447

Full Changelog: 1.15.0...1.15.1

vscode-db2i 1.15.0

What's Changed

• Fix comment for multiline statement in generated RPG by @janfh in #425
• Ignore commented lines when using update prefix by @SanjulaGanepola in #431
• Add ability to set Java version in VS Code settings by @worksofliam in #433
• Feature/output parameters by @worksofliam in #434
• Fixed syntax checker update method by @sebjulliand in #441
• Create INSERT statement based on imported csv or json by @julesyan in #435
• Add support for adding custom examples to Examples view by @SanjulaGanepola in #436
• Update version to 1.15.0 by @julesyan in #443

New Contributors

• @julesyan made their first contribution in #435

Full Changelog: 1.14.0...1.15.0

vscode-db2i 1.14.0

What's Changed

• Support for SQL parameters and binding by @forstie and @worksofliam in #420

Full Changelog: 1.13.3...1.14.0

vscode-db2i 1.13.3

What's fix

• Notebooks:
  • Fix issue with column data being undefined.
  • Fix issue where zero and null were treated the same
• Fix bug where incorrect JDBC properties were sent when spinning up a new job through the Job Manager

Full Changelog: 1.13.2...1.13.3

vscode-db2i 1.13.2

Redeploy due to VS Code Marketplace.

Full Changelog: 1.13.1...1.13.2

vscode-db2i 1.13.1

What's Changed

• Preserve starred status in query history by @worksofliam in #410

Full Changelog: 1.13.0...1.13.1