PeopleTools 8.4: SQR for PeopleSoft Language Reference - Oracle

PeopleTools 8.4: SQR for

PeopleSoft Language Reference

PeopleTools 8.4: SQR for PeopleSoft Language Reference

SKU Tr84SQL-B 0302

PeopleBooks Contributors: Teams from PeopleSoft Product Documentation and

Development.

Copyright ? 2002 PeopleSoft, Inc. All rights reserved.

Printed in the United States.

All material contained in this documentation is proprietary and confidential to PeopleSoft,

Inc. ("PeopleSoft"), protected by copyright laws and subject to the nondisclosure provisions

of the applicable PeopleSoft agreement. No part of this documentation may be reproduced,

stored in a retrieval system, or transmitted in any form or by any means, including, but not

limited to, electronic, graphic, mechanical, photocopying, recording, or otherwise without the

prior written permission of PeopleSoft.

This documentation is subject to change without notice, and PeopleSoft does not warrant that

the material contained in this documentation is free of errors. Any errors found in this

document should be reported to PeopleSoft in writing.

The copyrighted software that accompanies this document is licensed for use only in strict

accordance with the applicable license agreement which should be read carefully as it

governs the terms of use of the software and this document, including the disclosure thereof.

PeopleSoft, the PeopleSoft logo, PeopleTools, PS/nVision, PeopleCode, PeopleBooks,

PeopleTalk, and Vantive are registered trademarks, and "People power the internet." and Pure

Internet Architecture are trademarks of PeopleSoft, Inc. All other company and product

names may be trademarks of their respective owners. The information contained herein is

subject to change without notice.

Contents

SQR for PeopleSoft Language Reference Preface

About This PeopleBook..................................................................................................... ix

Before You Begin.............................................................................................................. ix

PeopleSoft Application Fundamentals ............................................................................... x

Related Documentation ...................................................................................................... x

Hard-copy Documentation.......................................................................................... xi

PeopleBooks Standard Field Definitions........................................................................... xi

Typographical Conventions and Visual Cues.................................................................. xiii

Page and Panel Introductory Table.................................................................................. xiv

Comments and Suggestions...............................................................................................xv

Chapter 1

Understanding SQR for PeopleSoft

Understanding SQR for PeopleSoft Tools....................................................................... 1-1

Understanding SQR......................................................................................................... 1-1

SQR Program Structure ............................................................................................ 1-2

SQR Syntax Conventions.......................................................................................... 1-3

Rules for Entering SQR Commands ......................................................................... 1-3

Understanding the SQR Command Line ......................................................................... 1-4

SQR Command-Line Arguments.............................................................................. 1-4

SQR Command-Line Flags....................................................................................... 1-5

Understanding SQR Data Elements .............................................................................. 1-13

Columns .................................................................................................................. 1-13

Variables ................................................................................................................. 1-14

Literals .................................................................................................................... 1-18

Viewing Sample Reports............................................................................................... 1-18

Chapter 2

SQR Command Reference

ADD.......................................................................................................................... 2-2

ALTER-COLOR-MAP............................................................................................. 2-2

ALTER-CONNECTION .......................................................................................... 2-4

ALTER-LOCALE..................................................................................................... 2-6

ALTER-PRINTER.................................................................................................. 2-13

PEOPLESOFT PROPRIETARY

AND

CONFIDENTIAL

CONTENTS

iii

SQR

FOR

PEOPLESOFT LANGUAGE REFERENCE

ALTER-REPORT ................................................................................................... 2-15

ARRAY-ADD, ARRAY-DIVIDE, ARRAY-MULTIPLY,

ARRAY-SUBTRACT............................................................................................. 2-16

ASK......................................................................................................................... 2-19

BEGIN-DOCUMENT............................................................................................. 2-20

BEGIN-EXECUTE ................................................................................................. 2-21

BEGIN-FOOTING.................................................................................................. 2-24

BEGIN-HEADING ................................................................................................. 2-25

BEGIN-PROCEDURE............................................................................................ 2-27

BEGIN-PROGRAM................................................................................................ 2-30

BEGIN-SELECT..................................................................................................... 2-30

BEGIN-SETUP ....................................................................................................... 2-34

BEGIN-SQL............................................................................................................ 2-35

BREAK ................................................................................................................... 2-40

CALL, CALL SYSTEM ........................................................................................ 2-40

CLEAR-ARRAY .................................................................................................... 2-46

CLOSE .................................................................................................................... 2-46

COLUMNS ............................................................................................................. 2-47

COMMIT ................................................................................................................ 2-48

CONCAT ................................................................................................................ 2-49

CONNECT .............................................................................................................. 2-50

CREATE-ARRAY .................................................................................................. 2-51

CREATE-COLOR-PALETTE................................................................................ 2-54

#DEBUG ................................................................................................................. 2-55

DECLARE-CHART................................................................................................ 2-56

DECLARE-COLOR-MAP...................................................................................... 2-65

DECLARE-CONNECTION ................................................................................... 2-66

DECLARE-IMAGE ................................................................................................ 2-68

DECLARE-LAYOUT............................................................................................. 2-69

DECLARE-PRINTER ............................................................................................ 2-76

DECLARE-PROCEDURE ..................................................................................... 2-83

DECLARE-REPORT.............................................................................................. 2-85

DECLARE-TOC ..................................................................................................... 2-87

DECLARE-VARIABLE......................................................................................... 2-89

#DEFINE................................................................................................................. 2-92

DISPLAY ................................................................................................................ 2-93

DIVIDE ................................................................................................................... 2-97

DO ........................................................................................................................... 2-98

#ELSE ..................................................................................................................... 2-99

ELSE ..................................................................................................................... 2-100

CONTENTS

iv

PEOPLESOFT PROPRIETARY

AND

CONFIDENTIAL

SQR

FOR

PEOPLESOFT LANGUAGE REFERENCE

ENCODE .............................................................................................................. 2-100

END-DECLARE, END-DOCUMENT, END-EVALUATE, END-FOOTING,

END-HEADING................................................................................................... 2-101

#END-IF, #ENDIF................................................................................................ 2-102

END-IF ................................................................................................................. 2-102

END-PROCEDURE, END-PROGRAM, END-SELECT, END-SETUP,

END-SQL, END-WHILE, END-EXECUTE ....................................................... 2-102

EVALUATE ......................................................................................................... 2-103

EXECUTE (SYBASE and MS-SQL Server)........................................................ 2-105

EXIT-SELECT...................................................................................................... 2-108

EXTRACT ............................................................................................................ 2-109

FIND ..................................................................................................................... 2-110

GET....................................................................................................................... 2-111

GET-COLOR ........................................................................................................ 2-113

GOTO ................................................................................................................... 2-115

GRAPHIC BOX, GRAPHIC HORZ-LINE, GRAPHIC VERT-LINE................. 2-115

#IF ......................................................................................................................... 2-118

IF ........................................................................................................................... 2-120

#IFDEF ................................................................................................................. 2-121

#IFNDEF............................................................................................................... 2-122

#INCLUDE ........................................................................................................... 2-122

INPUT................................................................................................................... 2-123

LAST-PAGE......................................................................................................... 2-126

LET ....................................................................................................................... 2-127

LOAD-LOOKUP .................................................................................................. 2-158

LOOKUP .............................................................................................................. 2-162

LOWERCASE ...................................................................................................... 2-163

MBTOSBS............................................................................................................ 2-164

MOVE................................................................................................................... 2-164

MULTIPLY .......................................................................................................... 2-168

NEW-PAGE.......................................................................................................... 2-169

NEW-REPORT..................................................................................................... 2-170

NEXT-COLUMN ................................................................................................. 2-171

NEXT-LISTING ................................................................................................... 2-172

OPEN .................................................................................................................... 2-174

PAGE-NUMBER.................................................................................................. 2-176

POSITION ............................................................................................................ 2-177

PRINT ................................................................................................................... 2-178

PRINT-BAR-CODE ............................................................................................. 2-197

PRINT-CHART .................................................................................................... 2-200

PRINT-DIRECT ................................................................................................... 2-208

PEOPLESOFT PROPRIETARY

AND

CONFIDENTIAL

CONTENTS

v

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download