Meta SQL

Resolve Meta-SQL

Meta-SQL is really handy, it lets you write database independent SQL and there are some really ni...

%EffdtCheck

There is a very handy meta-sql element called %EffdtCheck which writes effective date logic for y...

%TextIn

%TextIn is a Meta-SQL construct which is used for inserting data into PeopleSoft Long Character t...

Regex for Meta-SQL Conversion

I've come up with the following regular expressions to add or remove %Table() meta-sql construct....

%Coalesce Meta-SQL

If you're like me, you might first wonder what the word Coalesce even means? Well in terms of SQL...

Date and Time in Meta-SQL

The Meta-SQL date/time constructs you should know about are: For input/output of the current dat...

%SelectAll

If you ever need to create a view that selects all fields from a particular record, then you shou...

Writing Meta-SQL

Meta-SQL is a great way to abstract SQL logic and ensure consistency in your SQL definitions. It ...