The introductory page is now complete and the next page that needs to be create for this tutorial is a page to create some tables and fill them with data to perform the joins against.
In the new 'page' there is a new tag 'SQLFile'. This tag will load the contents of the given file located in the SQL directory of the tutorial into the Ah Hoc frame work.
This file is similar to a script that you would run through the command processor on the command line. Basically it contains a series of SQL statements to run terminated by a termination character (';' by default).
Thing to note about running SQL in a tutorial. First if you click over to the Ad hoc SQL tab, then click on the Options menu. You should see that the default schema is filled in with unique identifier. This is to ensure that each tutorial that is being run exists in its own sandbox. Second within your SQL script when the tutorial framework loads them you can use parameter replacement to substitute in saved global tutorial parameters and TE global constants.
Base global tutorial parameters that you have access to are as follows:
To preform a parameter substitution use '?
SELECT * FROM SYSCAT.TABLES WHERE TABSCHEMA = '?SCHEMA?';
Steps to complete: