FPSAPP.BLD_TABLE_QUERIES_SLOW

>

> FPSAPP.WIP_WAFER_HIST_LOOP

View FPSADMIN.BLD_TABLE_QUERIES_SLOW

This view builds the delete, insert, update, and select statements needed for the APF report XXX_QUERY used to populate table XXX by the Load_FPS_DWH.sh shell script. Simply paste the results of this view into the delete_query, insert_query, and/or update_query function blocks. Example use: select sql_query from bld_table_queries where table_name = 'RTG_PRDS' and query_type = 'INSERT'; Honestly this entire view is ridiculously tricky but one particularly tricky part is the need to check if NUMBER columns are allowed to be null. This is because APF will return "[Not Set]" if you convert a null number to a string therefore we must check if null and only convert to string if not.