How to Use a Nesting Table on an IS400
If you are running a database on your IBM IS400 server computer, then you can use nested table expressions to build more complex queries from your database. As with almost all database types, you control the queries into your database using SQL commands. SQL commands can be issued from the command line, but if you want to issue a nested table expression, you would do this in a script. This script may either be a Web script or a localized shell script.
Other People Are Reading
Instructions
-
-
1
Open your script you are working on in your preferred editing software. The Unix-based systems use a variety of text editors for editing.
-
2
Browse through the script to the location, where you want to insert a nested table expression.
-
-
3
Type the first line of your command you want to issue. Use the "FROM" command on the next line; this will be the first line of your nested table expression. Type your specification for the general location here.
-
4
Type, on the following lines, your nested table expressions. These table expressions help specify your content further. So, for example, if you are trying to select a general expression with your first command, but want to specify it only from the top 15 results, you can nest your top 15 script into the "FROM" tag. Use any commands you typically would with SQL.
-
5
Complete your expression on the following lines.
-
1
