|
 |
| NEUGC Sessions |
 |
 |
|
|
Putting 'Run SQL Scripts' to Work For You
Skip Marchesani
Day: Tuesday - 04/13/2010
Hour: Tuesday Session 14: 14:15 - 15:30
Room: C - Commons II
Type: Session
|
|
|
| Run SQL Scripts – also known as the SQL Script Center or Script Center – is part of the Database function in iSeries or System i Navigator.
It can be said that in part it is the PC or workstation replacement for Interactive SQL (the STRSQL command) on the green screen side of the System i. Run SQL Scripts and Interactive SQL do overlap in function, but each can do things that the other cannot.
When teaching SQL related topics I use Run SQL Scripts to demonstrate various SQL functions and also answer SQL syntax and function questions. Now that the SQL Script Center is becoming more widely known and used, when I teach and use it for demonstrations I am getting more and more questions about how it works. One reason for the increasing number of questions is that there is little information available for Run SQL Scripts via IBM’s System i Information Center web site, and IBM has no softcopy publication available for it. The only documentation available is Help, which has improved over time, but on occasion can still be a challenge when trying to find an answer to a question. So based on the more frequently asked questions I get while teaching, this session will show how you can put Run SQL Scripts to work for you. |
|
|