Meta-SQL Placement Considerations
Not all meta-SQL can be used by all programs. Some meta-SQL can be used only in Application Engine programs. Other meta-SQL can only be used as part of a SQL statement in a SQL view or dynamic view. The following table lists available meta-SQL elements and where each element can be used.
If a meta-SQL construct, function, or meta-variable is supported in PeopleCode, it is supported in all types of PeopleCode programs—that is, in Application Engine PeopleCode programs (PeopleCode actions), component interface PeopleCode programs, and so on. Meta-SQL elements that are available for Application Engine only are described in Application Engine documentation.
Note: Even if a meta-SQL element is used in PeopleCode, you cannot use meta-SQL like a built-in function. You can use meta-SQL in the SQLExec function, the Select method, the Fill method, and so on.
Note: Meta-SQL is not available in SQR.
The following table indicates which meta-SQL elements can be used in which locations.
Meta-SQL Element Name |
All PeopleCode Programs |
Application Engine SQL Actions |
COBOL |
Dynamic Views and SQL Views |
PeopleSoft Query |
---|---|---|---|---|---|
%Abs |
X |
X |
X |
X |
|
%AEProgram |
X |
||||
%AESection |
X |
||||
%AEStep |
X |
||||
%AsOfDate |
X |
||||
%AsOfDateOvr |
X |
||||
%BINARYSORT |
X |
X |
X |
X |
|
%Bind |
X |
||||
%Cast |
X |
X |
X |
X |
X |
%ClearCursor |
X |
||||
%COALESCE Note: %COALESCE has been deprecated but remains for backward compatibility only. Use your database's native COALESCE function instead. |
* |
* |
* |
||
%Comma |
X |
||||
%Concat |
X |
X |
X |
X |
|
%CurrentDateIn |
X |
X |
X |
X |
X |
%CurrentDateOut |
X |
X |
X |
X |
X |
%CurrentDateTimeIn |
X |
X |
X |
X |
X |
%CurrentDateTimeOut |
X |
X |
X |
X |
X |
%CurrentTimeIn |
X |
X |
X |
X |
X |
%CurrentTimeOut |
X |
X |
X |
X |
X |
%DateAdd |
X |
X |
X |
X |
X |
%DatabaseRelease |
X |
X |
X |
X |
X |
%DateDiff |
X |
X |
X |
X |
X |
%DateIn |
X |
X |
X |
X |
X |
%DateNull |
X |
X |
X |
X |
|
%DateOut |
X |
X |
X |
X |
X |
%DatePart |
X |
X |
X |
X |
|
%DateTimeDiff |
X |
X |
X |
X |
|
%DateTimeDiffExtended |
X |
X |
X |
X |
X |
%DateTimeIn |
X |
X |
X |
X |
X |
%DateTimeNull |
X |
X |
X |
X |
|
%DateTimeOut |
X |
X |
X |
X |
X |
%DecDiv |
X |
X |
X |
X |
X |
%DecMult |
X |
X |
X |
X |
X |
%Delete |
X |
||||
%DTTM |
X |
X |
X |
X |
|
%EffDtCheck |
X |
X |
X |
||
%Execute |
X |
||||
%ExecuteEdits |
X |
||||
%FirstRows |
X |
X |
X |
||
%GetProgText |
X |
||||
%Insert |
X |
||||
%InsertSelect |
X |
X |
X |
||
%InsertSelectWithLongs |
X |
X |
X |
||
%InsertValues |
X |
X |
|||
%JobInstance |
X |
||||
%Join |
X |
X |
X |
||
%KeyEqual |
X |
X |
|||
%KeyEqualNoEffDt |
X |
X |
|||
%LeftParen |
X |
||||
%Like |
X |
X |
X |
X |
|
%LikeExact |
X |
X |
X |
X |
|
%List |
X |
||||
%ListBind |
X |
||||
%ListEqual |
X |
||||
%Mod |
X |
X |
X |
X |
|
%Next and %Previous |
X |
||||
%NoUppercase |
X |
X |
X |
||
%NumToChar |
X |
X |
X |
X |
|
%OldKeyEqual |
X |
X |
|||
%OPRCLAUSE |
X |
||||
%ProcessInstance |
X |
||||
%ResolveMetaSQL |
X |
||||
%ReturnCode |
X |
||||
%RightParen |
X |
||||
%Round |
X |
X |
X |
X |
X |
%RoundCurrency |
X |
||||
%RunControl |
X |
||||
%Select |
X |
||||
%SelectAll |
X |
||||
%SelectByKey |
X |
||||
%SelectByKeyEffDt |
X |
||||
%SelectByRowNum |
X |
||||
%SelectDistinct |
X |
||||
%SelectDummyTable |
X |
X |
|||
%SelectInit |
X |
||||
%Space |
X |
||||
%SQL |
X |
X |
X |
||
%SqlHint |
X |
X |
X |
||
%SQLRows |
X |
||||
%Substring |
X |
X |
X |
X |
X |
%SUBREC |
X |
||||
%Table |
X |
X |
X |
||
%Test |
X |
X |
|||
%TextIn |
X |
X |
X |
||
%TimeAdd |
X |
X |
X |
||
%TimeIn |
X |
X |
X |
X |
X |
%TimeNull |
X |
X |
X |
||
%TimeOut |
X |
X |
X |
X |
X |
%TimePart |
X |
X |
X |
X |
|
%TrimSubstr |
X |
X |
X |
X |
X |
%Truncate |
X |
X |
X |
X |
X |
%TruncateTable |
X |
X |
X |
X |
|
%Update |
X |
||||
%UpdatePairs |
X |
X |
|||
%UpdateStats |
X |
X |
|||
%Upper |
X |
X |
X |
X |
|
%UuidGen |
X |
X |
|||
%UuidGenBase64 |
X |
X |