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 desupported 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