Manually creating views on Db2

To configure your Db2® database for your production environment, you must set up and run a series of scripts to create the tables, indexes, sequences, and so forth for your schema.

You must run these scripts only if you are manually creating the views after installation (REINIT_DB=no). In the normal installation mode (REINIT_DB=yes), the views will be applied automatically.

These script files reside in the <INSTALL_DIR>/database/db2/scripts/ directory.

This is the list of scripts to be edited using a SQL tool:

• CustomDBViews/transaction/ImportExport_View.sql
• CustomDBViews/transaction/Interop_Views.sql
• CustomDBViews/transaction/InvSnapshot_vw.sql
• CustomDBViews/transaction/yfs_cross_reference_vw.sql
• CustomDBViews/transaction/yfs_iba_ord_demand_vw.sql
• CustomDBViews/transaction/yfs_iba_resv_demand_vw.sql
• CustomDBViews/transaction/yfs_invtdmddtl_vw.sql
• CustomDBViews/transaction/yfs_noPendMove_nodeInventoryDtl_vw.sql
• CustomDBViews/transaction/yfs_onlyLPN_nodeInventoryDtl_vw.sql
• CustomDBViews/transaction/yfs_onlyLPN_NoPendMove_nodeInventoryDtl_vw.sql
• CustomDBViews/transaction/yfs_order_release_line.sql
• CustomDBViews/transaction/yfs_order_release_line_vw.sql
• CustomDBViews/transaction/yfs_nodeInventoryDtl_vw.sql
• CustomDBViews/configuration/yfs_wave_item_vol_config_vw.sql
• CustomDBViews/master/ycm_pricelist_vw.sql
• CustomDBViews/master/ypm_category_item_vw.sql
• CustomDBViews/master/ypm_item_vw.sql