How to find errors in SQR?
NOTE : [I][This question was asked by Raj][/I]
Printable View
How to find errors in SQR?
NOTE : [I][This question was asked by Raj][/I]
You can write show statements in the code where you are setting the variables or before and after each Procedure.. this way you will be able to know the values of the variables and the extent to hich the program is running smoothly
Error handling: It divided in 2 stages.
[B]Compile stage:[/B] Process all #commands, validate sqr syntax, validate sql commands, it will check the database connectivity.Create the buffer.[B] Execution stage:[/B] It will process the program section, process the header section, process the footer section, write the buffer to file.