- SQL Operations

SQL Operations

SQL operations are one of the more important operation types that can be created with WOW. SQL stands for Structured Query Language. SQL is used to manipulate the data in a database. Although SQL is not a difficult programming language to understand, it is very extensive. The only SQL covered in this guide will be examples on how SQL works with WOW. If you are unfamiliar with SQL, you will still be able to follow the examples in this manual; however, it is highly recommended that you review the following SQL manuals and tutorials before using WOW.

• • W3 Schools SQL (http://www.w3schools.com/sql/default.asp)

  • SQL Course (http://www.sqlcourse.com/)

SQL Limitations: The WOW run-time engine parses the supplied SQL to enable prompting and other parameter support.

Due to varying levels of SQL support and features from database vendors.

WOW only supports a limited subset of SQL features.

UDF Support: User Defined Functions

WOW parses the SQL for variable substitution. To identify a SQL segment as a UDF you must name UDFs like:

myLogic_UDF

IE: SELECT * FROM x.y WHERE my_UDF(aFld) > 77

In this case, "my_UDF" is a function created by the user, we will require WOW users to append "_UDF" in the UDF name.