Display File Field Description (DSPFFD) is a command to find out the field information in a file for use in database processing. With this command we can find out the file record format along with the name of the table field with its attributes. I use this command to get information when creating a program in database processing.Continue reading AS400 Display File Field Description
RUNSQL (Run SQL) is a command to run query statements in the command line. This command can only execute execution commands such as create-drop table, insert-delete-update record.Continue reading AS400 RUNSQL
We can create tables or files on AS400 using the STRSQL command. It is assumed that the reader understands using SQL statements.
Type the following command in SQL Statement then press Enter.
Exit from SQL Statement.
Type the command WRKOBJ SOOLDAT/TESTFILE. The TESTFILE object in the SOOLDAT library already exists.