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

vscode-db2i 1.13.0

What's New

• Add new notebook example for job analysis by @forstie & @worksofliam in #394
• New configuration option to select csv column delimiter by @janfh in #400
• Filter and stars by @worksofliam in #401

What's fixed

• RPG symbol name using name or label. Remove non-alphanum chars by @janfh in #391
• Disable peek provider by @worksofliam in #405
• Bump mapepire server version to 2.3.3 by @worksofliam in #406

Full Changelog: 1.12.0...1.13.0

vscode-db2i 1.12.0

What's New

• Use date format = iso by @janfh in #381
• Result view - include label/name in tooltip by @janfh in #383
• Generate RPG data structure from result metadata by @janfh in #368
• Go to Definition support by @forstie and @worksofliam in #278

What's fixed

• Hide schema browser actions from command palette by @janfh in #382
• Don't collapse whitespaces in results and output null in italic by @dferrand in #384

Full Changelog: 1.11.0...1.12.0