Have you ever had the need to update a sequence number, line number or schedule number based on a specific set of criteria? Well normally you would create a simple Do Select loop in your Application Engine program and then update each row by row. This does work but what if you have thousands of records to go through? There is a better way to allow the database to perform the update for you in just one step.
I have worked over many programs from other developers and even PeopleSoft itself where the row by row sequence number update was done. This is a tired and true method but we need to move to the next level. This document will teach you how you can easily learn and then use this set process to update a sequence number based on a set of criteria.
You use sequence numbers in all sort of places. Purchase orders, Cost Records, Bill of Materials, Invoice, Journals and lots more. This skill can be used in a multitude of places.
This document is designed for technical developers in how to code this specific process. The developer must be familiar with SQL statements and the use of sub selects and proper joins. This is not for the beginner in that they may not understand fully the ramifications. This document does not contain any information for non technical personnel.
Joseph Weessies originally joined PeopleSoft as the first Supply Chain consultant in the West Coast in 1995. He quickly earned many accolades and awards not only for his functional skills but his technical as well. Joe left PeopleSoft to become an independent consultant working at PeopleSoft and saw that many developers were struggling to learn PeopleTools. With his release of the only book for PeopleTools 8.1 Joe started on his career of writing books and aids for PeopleTools. Joe has released 3 books, 5 specialty chapters and 7 specialized cheat sheets that are being used all over the world.
This document is 7 pages long in 8.5 X 11 format. SQL is included and fully explained.