ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Validating SQL syntax

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Validating SQL syntax

    What is the best way to validate an SQL statement before I execute it?
    I have looked at API QSQCHKS but cannot get it to work. Is this the only method available?

  • #2
    For Checking the SQL Syntax I normally execute the SQL PREPARE Statement.

    Comment


    • tdavis
      tdavis commented
      Editing a comment
      That is an excellent solution! Thank you! That works!
Working...
X