IBM DB2 Universal Database V6 1--App Development ...correct tool. Analyze an SQL statement using EXPLAIN and VISUAL EXPLAIN. Unit 4: Dynamic SQL Programming Duration: 2 Hour(s) Identify the characteristics of dynamic embedded SQL. Match the SQLDA data structure elements with the information they contain. Code statements using SQL keywords specific to dynamic SQL applications. Code a dynamic SQL statement using parameter markers. more...
IBM DB2 Universal Database V6 1--Administration ...sing the FORCE command. Capture EXPLAIN data to use with VISUAL EXPLAIN. Analyze the access plan from the EXPLAIN tables using the VISUAL EXPLAIN graphical interface. Create an Event Monitor using the CREATE EVENT MONITOR statement. Collect snapshot data using the GET SNAPSHOT command. Change configuration parameters related to performance using DB2 commands. Identify the purposes of the more...
IBM DB2 Universal Database V6 1--Administration ...sing the FORCE command. Capture EXPLAIN data to use with VISUAL EXPLAIN. Analyze the access plan from the EXPLAIN tables using the VISUAL EXPLAIN graphical interface. Create an Event Monitor using the CREATE EVENT MONITOR statement. Collect snapshot data using the GET SNAPSHOT command. Change configuration parameters related to performance using DB2 commands. Identify the purposes of the more...