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