Sqr Language Reference

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 toPeopleSoft,
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 writtenpermission 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 licenseagreement 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 andproduct
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 YouBegin.............................................................................................................. ix
PeopleSoft Application Fundamentals ............................................................................... x
Related Documentation ...................................................................................................... x
Hard-copyDocumentation.......................................................................................... xi
PeopleBooks Standard Field Definitions........................................................................... xi
Typographical Conventions and Visual Cues.................................................................. xiii
Page and Panel Introductory Table.................................................................................. xiv
Comments andSuggestions...............................................................................................xv

Chapter 1
Understanding SQR for PeopleSoft
Understanding SQR for PeopleSoft Tools....................................................................... 1-1
Understanding SQR......................................................................................................... 1-1
SQR ProgramStructure ............................................................................................ 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...