What Do You Get?
Example Statements and Validation Output
Here we would like to give you some examples of how you can use Mimer SQL-99
Validator, not only to check how your SQL conforms to the current SQL standard, but also how
you can use Mimer SQL-99 Validator to check whether your statements are syntactically correct.
So, what happens if you just click 'Test SQL'?
Of course, if you don't enter anything, it's a syntax error. Mimer SQL-99 Validator says
so and then lists possible input.
What happens if you make a spelling mistake (let's face it, it happens sometimes)?
For example, you type SELEC instead of SELECT, Validator will tell you it's wrong, and give you
the correct spelling.
What if you know something is Core SQL, but you want to know what level
it was in SQL-92?
Just enter your statement in Mimer SQL-92 Validator, click the button and hey presto,
you know exactly which level it conforms to.
WHERE c + d IS NOT NULL
But can Validator distinguish
between features outside Core SQL?
Yes indeed it can. Validator identifies the following as: X001 a Mimer SQL extension and F491 a Constraint management feature.
(BTW, this Mimer SQL extension will become a feature in the next SQL standard, known at the moment as SQL-200x.)
What about complex SQL statements?
Can Validator handle them?
Of course, Validator can handle
complex and long statements.
Want to see if your stored procedures (SQL/PSM) pass the conformity test, or see if you've made a mistake when
Just enter your stored procedure,
click the button and you've got answer.