SQLP 2.2.2 and SQLEP 1.7.1 Tutorial

###The tutorial is updated for SQLP 2.2.2+ and SQLEP 1.7.1+

###Introduction The new features of the SQL Processor (SQLP) version 2.2.2 and the SQL Processor Eclipse Plugin (SQLEP) version 1.7.1 are

• new control directive metagen-optional-features
• improve generated INSERT statement for not required cloumns
  • new control directive metagen-optimize-insert
  • new SQLP {= columns (...) } for INSERT
• optional features in the statement's execution scope
  • extended SqlControl
• fixed bug in pojogen-ignore-one-to-many
• improved count() SQL
• input parameters checking

###Control directive metagen-optional-features Using this control directive, for example

metagen-optional-features SELECT_COUNTRY IOPT=SURROUND_QUERY_MIN_LEN=1;

we can inject into generated META SQL statement this optional feature

SELECT_COUNTRY(QRY,IOPT=SURROUND_QUERY_MIN_LEN=1,inx=Country,outx=Country,tab=country)=
... 

TODO