As I told you previously (https://linkedibmi.com/2018/01/18/ibm-gymn-come-train/ ) the IBM i GYMN is starting and I am receiving the subscriptions to partecipate. While I am contacting and waiting for other colleagues, I suggest you first to install “System i Navigator” tool. See the following post:
In this while I will publish a few posts dedicated at the FIRST SECTION, that are necessary to introduce you to the arguments. The section will be closed with the main case-study that I will summarize in a post and I will save within the courses section, so you will be able to study when you want.
Subscribers will receive by mail the access to OUR SERVER and will be able to practice based on the case-study I will publish. A support period on a FORUM section will help all the members of the group to share doubts, ideas, experiences and so on.
As first mission of our path on database and the “System I Navigator” tool, we should practice on the base modalities to create and elaborate tables on our schema. Usually we use the following commands:
CREATE TABLE – LABEL ON – ALTER TABLE – COMMENT ON – CREATE ALIAS – DROP TABLE
for example by using STRSQL on native IBM i screen.
Now we should use “System I Navigator” and as first think we must create the new table as this picture shows:
You have to indicate the table name and the description of the table:
If you move in the “Columns” tabbed, you could insert the fields into the new table by indicating, as the usual, the name, the data format and the description:
You could insert all the fields you want and all of them will be showed in the list with their characteristics.
You could visualize the script to create the defined table:
Once the table is create you must see it into the table list:
But you are are to change it by opening his definition:
and by changing his fields ( the same of ALTER TABLE):
At the end you could generate the SQL script for the table, as we previously saw:
You could add a comment on the definition of the table:
and you could see the corresponding SQL instruction (COMMENT ON TABLE):
Another thing you could do is to add an ALIAS to the table:
And as the usual you could check the SQL instruction to do it:
Last thing is to execute the DROP TABLE by the option ‘Cancel’: