PeopleCode

Language features

Supported Functions

• Built-in: The standard set of PeopleCode functions. These can be called without being declared.
• Internal: Functions that are defined within the PeopleCode program in which they are called.
• External PeopleCode: PeopleCode functions defined outside the calling program. These are generally contained in record definitions that serve as function libraries.
• External non-PeopleCode: Functions stored in external libraries.

• A built-in function is on a line by itself, and does not have any dependencies.
• A function can be used before instantiating the object.
• A method can only be executed by an object.
• The object must be instantiated first.

  Describing Application Class Structure

• Import any classes that will be used by a class, including the superclass this class extends

 Import PackageName:Superclassname;

• A class is defined using the Class construct.

 Class Classname 
 
 
 
 
 Constant declaration
 End-class;

• The first set of declarations are the properties and methods that are part of the public, external interface.

 Property datatype PropertyName ;
 Method MethodName 

• The private instance variables, constants, and the methods are declared following the keyword Private.
• The keyword end-class follows the declarations of properties, methods, instances, and constants.
• After the end-class keyword and before get and set definitions or method definitions, declare any variable and functions that will be used by methods.
• Get and set methods corresponds to properties declared with the get and set keywords.
• Use a get method definition to execute PeopleCode that will return a value.
• Use a set method definition to execute PeopleCode that will change a value.

 set PropertyName
 
 end-set;

• Method definitions are similar to function definitions.

 method Methodname
 statements;
 end-method;

• A special case of a method definition is the constructor.
• A constructor has the same name as the class and will always run when the class is instantiated.
• A class that does not extend some other class does not need any constructor.
• A class that does extend another class must have a constructor, and in the constructor, it must initialize its superclass.

  Executing SQL in PeopleCode

• Where a SQLExec only delivers a single row, using the SQL class you can retrieve and process multiple rows.
• Instantiate a SQL object with the CreateSQL built-in function.
• * Use CreateSQL to pass a text string to your SQL object.
• * Use GetSQL to get the SQL from a SQL definition.

 &SQL = CreateSQL;

 &SQL = CreateSQL;
 &SQL.Execute;

• For a SQL object containing a Select statement, the Fetch method is used to retrieve the next row from the cursor.