As Other Programming languages PeopleSoft SQR also contains date related functions, for example strtodate() – convert a string to date datetostr() – convert a date to a string dateadd() – add to a date datediff() – subtract dates datenow() – … Continue Reading
I was working on SQR code that will read CSV file with SQR Code and Insert data into Staging Table.This blog post will help you to understand How to do Read file with SQR.I hope you are aware of SQR … Continue Reading
Two-tier For two-tier connections Involves connecting directly to the database. A two-tier connection requires connectivity software to be installed and configured on the workstation. A two-tier connection is required for many upgrade and installation tasks. Example: PeopleSoft Data Mover runs … Continue Reading
Operator ID Operator ID also known as User ID. A PeopleSoft user ID is the ID you enter at the PeopleSoft sign-in dialog box and Operate PeopleSoft Online Portal. You assign each PeopleSoft user a user ID and password. The … Continue Reading
System Catalog Table System tables, also called system catalog tables, are analogous to a table of contents for a book or to file allocation tables on a hard drive. The structure and table names vary depending on which RDBMS you … Continue Reading