PeopleSoft开发指南：PeopleTools与PeopleCode解析(601页PDF)

2星需积分: 9 166 浏览量更新于2024-08-01 收藏 8.04MB PDF 举报

"Peoplesoft developer's guide for peopletool & peoplecode(PDF 601pages)"，这是一本专门针对PeopleSoft开发人员的指南，涵盖了PeopleTools的基础知识、PeopleSoft页面、PeopleCode、高级PeopleCode、XML Publisher、PeopleSoft查询以及结构化查询报告和应用程序引擎等关键主题。在Peoplesoft开发中，PeopleTools是Oracle PeopleSoft应用框架的核心组成部分，它提供了一系列用于构建、部署和管理企业级应用的工具。PeopleTools的基本概念包括： 1. **PeopleSoft Pages**：PeopleSoft页面是用户与系统交互的主要界面。它们由多个组件（如文本字段、按钮、列表框等）组成，通过PeopleTools的Page Designer进行设计和配置。 2. **PeopleCode**：PeopleCode是一种基于事件的编程语言，用于驱动PeopleSoft应用的行为。它与页面组件紧密关联，可以在特定事件（如页面加载、按钮点击等）上执行代码。 3. **Advanced PeopleCode**：高级PeopleCode引入了更复杂的编程特性，如类、对象和方法，使得开发人员可以创建更复杂的应用逻辑和模块化代码。 4. **XML Publisher**：这是一个强大的报表和文档生成工具，能够将数据从各种源（如数据库、XML文件等）转换成专业格式的文档，如PDF、Excel或HTML。 5. **PeopleSoft Query**：这是PeopleSoft内置的查询工具，允许用户自定义查询来获取所需的数据，而无需编程知识。开发人员可以进一步定制查询以满足特定需求。 6. **Structured Query Reporting (SQR)**：SQR是一种强大的报表编写语言，用于生成高度格式化的批量报表。在System9 Release 9.3.1中，它提供了详细的开发者指南，涵盖语言参考，帮助开发人员编写高效的SQR脚本。 7. **Application Engine**：应用程序引擎是一种批处理框架，用于运行后台任务，如数据导入/导出、定时作业等。开发人员可以通过编写定义作业逻辑的PeopleCode来利用此功能。了解这些技术对于Peoplesoft开发人员至关重要，因为它们共同构成了构建和维护PeopleSoft解决方案的基础。此外，文档中强调了版权和许可证协议的重要性，提醒用户遵守使用、披露和复制软件的规定，以及对逆向工程、拆解或反编译程序的限制，这些都是合法使用软件的关键方面。文档内容可能随时更新，用户遇到问题时应书面报告给供应商，并理解文档可能存在错误，不提供任何保证。

let

%listname

[

num_var

num_lit

]=list(

col_var

str_var

num_var

str_lit

num_lit

[,…])

● Access a list variable—Use the following syntax:

let

str_var

num_var

%listname

[

num_var

num_lit

#colname

● Modify a list variable—When you modify a list variable, you can modify a specific row

element of any list item.

In list-variable arguments, the value between the brackets indicates either the number of rows

in the list for the definition case or the row within the list to be modified or assigned.

If no brackets exist, there is no need to predefine; assign the types based on the given variable

types. For multirow lists, the assignment must be compatible with the types given in the

definition.

NUMBER field has the same characteristics as an undeclared

#var

; the underlying storage

depends on the contents, and the

DEFAULT-NUMERIC setting applies.

The usual SQR Production Reporting rules for variable assignment apply to list access.

Assignment is prohibited only between Date and Numeric types. Assignment of a numeric

column to a string variable returns the string representation of the numeric value; assignment

of a date variable to a string variable returns the default-edit-mask representation of the date.

SQR Production Reporting Reserved Variables

When you create multiple reports, the variables apply to the current report. SQR Production

Reporting reserves a library of predefined variables for general use.

Note:

All of SQR Production Reporting's reserved variables are global variables. Reference reserved

variables in local procedures with a leading underscore. For example, #_sqlstatus or $_sql-

error. See “BEGIN-PROCEDURE” on page 67 for information on defining local procedures.

Table 3 SQR Production Reporting Reserved Variables

Variable

Description

#current-column Current column on the page.

$current-date Current date-time on the local machine when SQR Production Reporting starts running

the program.

#current-line

Current line on the page. This value is the physical line on the page, not the line in

the report body.

Line numbers are referenced in PRINT and other SQR Production Reporting commands

used for positioning data on the page. Optional page headers and footers, defined

Introduction

Variable Description

BEGIN-HEADING and BEGIN-FOOTING, have their own line sequences. Line 2 of the

heading is different from line 2 of the report body or footing.

#end-file Set to one (1) if end of file occurs when reading a flat file; otherwise, set to zero (0).

Your program should check this variable after each

READ command. (See “READ” on

page 261 for more information.)

#page-count Current page number.

#return-status Value returned to the operating system when SQR Production Reporting exits. Can be

set in your report. #return-status is initialized to the “success” return value for the

operating system.

#sql-count Count of rows affected by a DML statement (INSERT, UPDATE, or DELETE). This is

equivalent to ROWCOUNT in Oracle and Sybase.

$sql-error Text message from the database explaining an error. This variable is rewritten when

a new error is encountered.

#sql-status Value of #SQL-STATUS set whenever BEGIN-SELECT executes. Normally this variable

is checked from within an ON-ERROR procedure so its value describes the error

condition (whereas the $SQL-ERROR variable contains the error message). The actual

meaning of #SQL-STATUS is database dependent. Consult the proper database

manual to fully interpret its meaning.

$sql-text

Last SQL statement sent to the database by SQR Production Reporting.

The variable contents are valid after SQR Production Reporting processes BEGIN-

SQL, BEGIN-SELECT, or LOAD-LOOKUP , or within the ON-ERROR-procedure for BEGIN-

SQL and BEGIN-SELECT.

The variable is populated for ODBC, Sybase, Oracle, Informix, Teradata, DB2, and

DDO.

$sqr-connected-db

{sqr-connected-db}

Class of the backend database from the initial connection or from CONNECT.

For ODBC, the class is: ODBC, Sybase, Oracle, Informix, Redbrick, Teradata, or DB2.

For DDO, the class is: XML, CSV, SAP, MSOLAP, Essbase, SQLServer, Sybase, Oracle,

Informix, or DB2.

The information is derived from $sqr-connected-db-name / {sqr-connected-db-

name}.

$sqr-connected-db-name

{sqr-connected-db-name}

Name of the database driver from the initial connection or from CONNECT.

SQR Production Reporting Data Elements

剩余451页未读，继续阅读

tonyibm

粉丝: 4
资源: 3

PeopleSoft开发指南：PeopleTools与PeopleCode解析(601页PDF)

PeopleSoft 8.48 安全 hoạt động指南

PeopleSoft应用设计器开发者指南

Oracle PeopleSoft 开发指南：Application Designer 中文翻译

PeopleSoft Developer's Guide for PeopleTools and PeopleCode

PeopleSoft Developer's Guide for PeopleTools

PeopleSoft.Developers.Guide.for.PeopleTools.and.PeopleCode.2009

peoplesoft security activity guide

peoplesoft peoplecode PPT

Peoplesoft Peoplecode介绍

Peopletools Application Designer Developer's Guide

最新资源