search

IBM / db2forzosdeveloperextension-about

IBM Db2 for z/OS Developer Extension for VS Code
https://IBM.github.io/db2forzosdeveloperextension-about/
Other
12 stars 7 forks source link

Add option to show SQL outputs in text only mode #68

Open scotdb opened 2 years ago

scotdb commented 2 years ago

While the current tabular view of data is useful in some situations, we always found the "text only" output mode in Data Studio very useful in a lot of cases.

Typical examples are -

a) When we need to "cut and paste" some sample output into an email to show to colleagues b) When we wish to produce a file of data output that we can then import into a spreadsheet for further work

Would it be possible to allow us to toggle the results between a complex tabular widget and plain text display?

FALLAI-Denis commented 2 years ago

Hi,

Do you consider "export as csv" for use cases you give ? Perhaps add an "export to text" choice to have a true plaintext version of data.

katsoohoo commented 2 years ago

Hi @scotdb,

Thanks for you suggestions. We'll consider representing the the result set data with different options. For you second example (b), the feature to export SQL results in a csv file may help with this.

scotdb commented 2 years ago

Katherine,

I already use the export facility extensively, and do indeed export data to then cut and paste it elsewhere. It would just be nice to have the option directly in the tool itself.

Phil

On Mon, 9 May 2022 at 21:52, Katherine Soohoo @.***> wrote:

Hi @scotdb https://github.com/scotdb,

Thanks for you suggestions. We'll consider representing the the result set data with different options. For you second example (b), the feature to export SQL results in a csv file https://ibm.github.io/db2forzosdeveloperextension-about/docs/working-with-sql/saving-sql-results-to-a-file may help with this.

— Reply to this email directly, view it on GitHub https://github.com/IBM/db2forzosdeveloperextension-about/issues/68#issuecomment-1121570051, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAAP7FUZ4ZLOHOYLAQ4FDF3VJF3JRANCNFSM5HVUPO3Q . You are receiving this because you were mentioned.Message ID: @.***>

b-tsao commented 5 months ago

With developer extension 2.1.5, you can now execute SQL in a notebook interface. The executed SQL will display in plain text as the result output right below the executed cell. Refer to the doc for more details about notebook editor.