Where has all the time gone? It seems between E-mail, Conference Calls and Content Development. Its past time to update you on my progression through "Getting Started with IBM Data Studio" ebook. Chapter 4 deals with creating SQL and XQuery scripts within Data Studio. I created a Data Project in Data Studio,selected my Database Connection and Default Schema. I was off to the races building SQL statements!
After creating a project, you'll find an "SQL Scripts" directory. Right clicking on it, you'll see the following: New > SQL Script which brings up the SQL editor.
You can create and run your own SQL scripts, just like what I've created below.
If your typing challenged like me, be sure to use the Command Completion feature by pressing Ctl+Space. To run your statement, simply right click and select "Run SQL"
Another neat feature in Data Studio is the SQL Builder. This Menu driven GUI builds the SQL statement for you. All you need to do is follow the prompts selecting Tables, Columns and if needed Conditions
You can view the SQL results in the lower right hand corner of Data Studio.
That's all there is to creating SQL Scripts! Remember, all you need to do is select New> Data Development Project, Name it, Connect it. When your Project is created right click on the SQL Directory and select New > SQL Script and start building your SQL. Next up is Developing Stored Procedures in Chapter 5
Where has the time gone? Creating SQl and XQuery scripts using Data Studio