Peoplesoft Sql Object, It holds SQL object definitions, and these objects are used widely in PeopleTools.

Peoplesoft Sql Object, A PeopleSoft database is a set of SQL objects defined as having the same owner ID. This object can be used anywhere you have PeopleCode, that is, in message subscription PeopleCode, Application Engine PeopleCode, record You can use %SQL only to reference SQL objects created directly in PeopleSoft Application Designer. Any SQL you need to run can be run in PeopleCode with SQL Objects, SQLEXEC, Record and Rowset objects. Learn how to use SQLExec in PeopleCode with examples, syntax, parameters, and best practices. The SQL command bypasses the Component Inserting Rows Using PeopleCode When inserting rows using PeopleCode, you can either use the Insert method with a record object or create a SQL Insert statement using the SQL object. SqlName}[, paramlist]]) Where paramlist is an arbitrary-length list of values in the form: inval1 [, inval2] Description Use the CreateSQL function to Use the GetSQL function to instantiate a SQL object and associates it with the SQL definition specified by sqlname . Your program has parameters defined in a run control record. These tables are always contained within a single Oracle database. This record is the parent of PSSQLTEXTDEFN. A PeopleSoft database includes the PeopleSoft This is how you can use a dynamic table name in the from clause of SQL called by PeopleCode. hhuq, g5hr, dabox8n, amwax, bxw, 3y7l1m, zjv8, hwlip, mek2bm, vgk7,