Peoplecode

Question 1

Different Data Types

Answer 1

Conventions data types & Object data type

Question 2

Conventional Data types

Answer 2

Any - If type is not defined, then by default it is any. Peopletools determines the type of ‘ANY’ variable based on context at runtime.

Boolean
Date
DateTime
Float
Integer
Number
Object 
String
Time

Question 3

Integer

Answer 3

32-bit signed twos complement number, so it has a range of -2,147,483,648 to 2,147,483,647

Question 4

Float

Answer 4

number represented using the machine floating binary point (double precision) representation.
This type is not suitable for calculation involving decimal fractions, particularty for money transactins.
For ex: .10 + .10 will not be .20 for this type.

Question 5

Number

Answer 5

Size limit of 34 digits not including decimal point. 32 digits to the right of decimal point.
Since the Number type is a floating decimal point representation, it is the appropriate data type for calculations involving money.

Question 6

Operations

Answer 6

Operations other than Division is done using Integer arithmatic
Division is done using Floating point decimal.

Question 7

Recommendation on using Integer, Float, Number

Answer 7

Use Number for most applicable data values
Use Integer when counting item, for ex rows in rowset.
Use Float for

Question 8

Seperator Statements

Answer 8

It seprated one statement from another and is ;

Question 9

Assignment statement

Answer 9

it is =, it can also be used in evaluation statement depending on context

Question 10

Branching statement

Answer 10

If, then, else

Evaluate

Question 11

Looping statement

Answer 11

For, Repeat, While

Question 12

Language constructs

Answer 12

PeopleCode language constructs include:

Branching structures: If and Evaluate.

Loops and conditional loops: For, Repeat, and While.

Break, Continue, and Exit statements loop control and terminating programs.

The Return statement for returning from functions.

Variable and function declaration statements: Global, Local, and Component for variables, and Declare Function for functions.

The Function statement for defining functions.

Class definition statements.

Try, Catch, and Throw statements for error handling.

Question 13

example of a function declaration of a function that is in another FUNCLIB record definition

Answer 13

Declare Function UpdatePSLOCK PeopleCode FUNCLIB_NODES.MSGNODENAME FieldFormula;

Question 14

Function parameter values tip

Answer 14

check the values of parameters that get passed to functions at runtime in the Parameter window of the PeopleCode debugger.

Question 15

Function Naming Conflicts

Answer 15

If you define a function with the same name as a built-in function, the function that you defined takes precedence over the built-in function

Question 16

System Variables

Answer 16

System variables are preceded by a percent (%) symbol whenever they appear in a program. Use these variables to get the current date and time, or to get information about the user, the current language, the current record, page, or component, and more.

Question 17

Metastrings

Answer 17

SQLExec.

Scroll buffer functions (ScrollSelect and its relatives).

PeopleSoft Application Designer to construct dynamic views.

Some rowset object methods (Select, SelectNew, Fill, and so on).

SQL objects.

Application Engine.

Some record class methods (Insert, Update, and so on).

COBOL

Question 18

Variables scopr

Answer 18

Global: Variable valid in entire session
Component: Variable valid in all pages in component
Local: variable valid only locally

Question 19

3 different ways to refer the data in buffer

Answer 19

Similarly, to hide the VISIT scroll area on level three, you specify rows on scroll levels one and two.
Record convention: before 7.5
HideScroll(RECORD.OWNER, &L1ROW, RECORD.PET, &L2ROW, RECORD.VISIT);
To use the SCROLL.scrollname syntax, the previous example could be written as the following:
Post 7.5 - scroll syntax to remove ambiguity as it refers the primary record.
HideScroll(SCROLL.OWNER, &L1ROW, SCROLL.PET, &L2ROW, SCROLL.VISIT);
In PeopleTools 8, the object-oriented version of this is:

Local Rowset &VET_SCROLL, &OWNER_SCROLL, &PET_SCROLL, &VISIT_SCROLL;

&VET_SCROLL = GetLevel0();
&OWNER_SCROLL = &VET_SCROLL.GetRow(1).GetRowSet(SCROLL.OWNER);
&PET_SCROLL = &OWNER_SCROLL.GetRow(2).GetRowSet(SCROLL.PET);
&VISIT_SCROLL = &PET_SCROLL.GetRow(2).GetRowSet(SCROLL.VISIT);

&VISIT_SCROLL.HideAllRows();

Question 20

Fetching values from buffer -different ways

Answer 20

To fetch PET_BREED on level two:

&SOMEBREED = FetchValue(RECORD.OWNER, &L1_ROW, RECORD.PET, &L2_ROW, PET.PET_BREED);
In PeopleTools 8, the object-oriented version of this for the PET rowset is:

&SOMEBREED = &PET_SCROLL(&L2_ROW).PET.PET_BREED;