The following example shows sample trace output from the items_pct procedure as it appears in the file that was named in the SET DEBUG FILE TO statement. The output reveals the values of procedure variables, procedure arguments, return values, and error codes.
trace expression :begin trace trace on expression: (select (sum total_price) from items) evaluates to $18280.77 ; let tp = $18280.77 expression: (select (sum total_price) from items where (= manu_code, mac)) evaluates to $3008.00 ; let mc_tot = $3008.00 expression:(/ mc_tot, tp) evaluates to 0.16 let pct = 0.16 expression:(> pct, 0.1) evaluates to 1 expression:(- 745) evaluates to -745 raise exception :-745, 0, '' exception : looking for handler SQL error = -745 ISAM error = 0 error string = = '' exception : no appropriate handler
For more information about how to use the TRACE statement to diagnose logic errors in SPL routines, see Creating and Using SPL Routines.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]