CODEWITHSUNDEEP
javasqlgoogle-sheetsdb2
Maged Almaweri
Maged Almaweri

Reputation: 352

Export DB2 DDL from One Cell in Google Spreadsheet

I have a database change template to used by the team, it was accepted but the only thing needed is:

1- Can we have syntax formatting for SQL within the same form?

2- How can we get only the DDL part out of this to generate a simple text field/file?

Note: This template will be used once per a month and it will have all the database changes, I'm looking for a way to make the syntax to be formatted like the SQL format, and is there a way where I could extract or Export only the queries to one text file even programmatically by using java or any similar programming language.

Please advice and thank you.

enter image description here

Upvotes: 0

Views: 128

Answers (1)

Jacques-Guzel Heron
Jacques-Guzel Heron

Reputation: 2598

Based on the comments I understand that you want to capture a cell value by using Values.get(). You can easily do that by following a quickstart tutorial (available on Java and Node.js as requested). That will help you to set up a working environment with Sheets API. After completing it, you only have to update the code to include Values.get(). Please ask me any additional doubt if required.

Upvotes: 1

Related Questions