Re: Sample records file
A stored procedure is shipped as part of the system that contains the DDL statements to create DB2 Universal Database? for iSeries sample tables, and the INSERT statements to populate them. The procedure will create the schema specified on the call to the procedure. Since this is an SQL external stored procedure, it can be called from any SQL interface, including interactive SQL and iSeries? Navigator. To call the procedure where SAMPLE is the schema you want to create, issue the following statement:
The schema name must be specified in uppercase. The schema must not already exist.
A stored procedure is shipped as part of the system that contains the DDL statements to create DB2 Universal Database? for iSeries sample tables, and the INSERT statements to populate them. The procedure will create the schema specified on the call to the procedure. Since this is an SQL external stored procedure, it can be called from any SQL interface, including interactive SQL and iSeries? Navigator. To call the procedure where SAMPLE is the schema you want to create, issue the following statement:
Code:
CALL QSYS.CREATE_SQL_SAMPLE ('SAMPLE')
Comment