The Execute SQL statements (YEXCSQL) command prepares and executes SQL/400 statements that are contained in a source file member.
Earlier, YEXCSQL worked only for the target object library being an SQL collection. But now, the target object library can be either an SQL collection or a normal library (non-SQL collection).
If an SQL collection is specified as the target object library, the tables, indexes, and views are created in the specified SQL collection, as before. If a normal library is specified as the target object library, the tables, views and indexes are created in that library but are not journaled. While the tables, views, and indexes are being created, you may receive warning messages that the library is a non-SQL collection and that the tables/views/indexes are not journaled. These messages can be ignored for generation purposes.
Warning: If a non-SQL Collection/Library is used as a target object library, then the tables/views/indexes created in it are not journaled automatically.
|
Copyright © 2014 CA.
All rights reserved.
|
|