PeopleTools 8.4: SQR for PeopleSoft Language ... - 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