PeopleSoft SQR Language

Understanding SQR Data Elements

! Variables
! Variables is storage places for text or numbers so you define and manipulate.
! $ begins a text or date variable.
! # begins a numeric variable.
!% begins a list variable.
! @ begins a variable name for a marker location.

! Columns
! Columns is fields defined in the database.
! SQR for P eople S OFT L anguage REFERENCE
! The character & begins a database column or expression name.

! Literals
! Literals is text or numeric constants.
! A single quote begins and ends A text literal. For example:
!‘ Hello '
! Numerals 0–9 begin numeric literals.
! Numerals that include digits with a optional decimal point and leading sign is acceptable
!numeric literals. For example,–543.21. Numeric literals can also be expressed in scientific
!form. For example, 1.2E5.

PeopleSoft SQR Language