Remerciez-le!

Remerciez @Admin pour avoir partagé cet document gratuitement, de la manière la plus simple, en partageant sur les réseaux sociaux.

Sqr guide 2 PeopleTools SQR for PeopleSoft Developer's Guide CPeopleTools SQR for PeopleSoft Developer's Guide SKU Tr SQR-B PeopleBooks Contributors Teams from PeopleSoft Product Documentation and Development Copyright ? PeopleSoft Inc All rights reserved

PeopleTools SQR for PeopleSoft Developer's Guide CPeopleTools SQR for PeopleSoft Developer's Guide SKU Tr SQR-B PeopleBooks Contributors Teams from PeopleSoft Product Documentation and Development Copyright ? PeopleSoft Inc All rights reserved Printed in the United States All material contained in this documentation is proprietary and con ?dential 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 CContents SQR for PeopleSoft Developer ? s Guide Preface About This PeopleBook xi Before You Begin xi PeopleSoft Application Fundamentals xii Related Documentation xii Hard-copy Documentation xiii PeopleBooks Standard Field De ?nitions xiii Typographical Conventions and Visual Cues xv Page and Panel Introductory Table xvi Comments and Suggestions xvi Chapter Simple SQR Program Working with the SQR for PeopleSoft Developer ? s Guide - Audience - How to Use the SQR for PeopleSoft Developer ? s Guide - Related Documents - Syntax Conventions - Setting Up the Sample Database - Sample Program - Printing a Text String - Creating and Running an SQR Program - SQR Output - Understanding the SQR Commands - Chapter Headings and Footings Understanding the Page in SQR - Sample Program - Adding the Heading and Footing - Creating Page Headings and Footings - Page Heading - Page Footing - Order of Execution - PEOPLESOFT PROPRIETARY AND CONFIDENTIAL CONTENTS iii CSQR FOR PEOPLESOFT DEVELOPER'S GUIDE Chapter Selecting Data From the Database Sample Program - Listing and Printing Data - Understanding the SQR Program - SQR SELECT Statement - Syntax of the SELECT Statement - Positioning Data - Chapter Column Variables Using a Column Variable in a Condition - Changing the Column Variable Name - Chapter Using Break Logic Understanding Break Logic - Using ON- BREAK - Skipping Lines Between Groups - Arranging Multiple Break Columns - Using Break Processing Enhancements - Handling Page Breaks - Printing the Date - Obtaining Totals - Hyphens and Underscores - Setting Break Procedures With BEFORE and AFTER - Understanding the Order of