摘要:
The OPRID (USER) that has "locked" this run control from continuing on should take the followings steps: 1. Go to the Details link for the process that has No Successed, if the process is a sub proces... 阅读全文
摘要:
You could E-Mail the Query results by embedding the paramters in a nVision Layout. Create a Tabular nVision Layout. Add the Query parameters to the Tab. Then, when you execute the nVision Report on... 阅读全文
摘要:
Same way as a delivered record (or you can add audits to a delivered record if it doesn't already have them). You can either turn audit on for individual fields or build a custom audit record. To au... 阅读全文
摘要:
All PeopleCode objects can be passed as function parameters. You can pass complex data structures between PeopleCode functions (as opposed to passing long lists of fields). If a function is passed an ... 阅读全文
摘要:
Local File &File; Local string &FILE_NAME, &CHARSET, &COMPANY_NAME, &COMPANY_PADDED, &LINES_PADDED, &AMOUNT_PADDED; Local number &LINES, &AMOUNT; Local Record &HEADER_REC, &TRANSACTION_REC; Local SQL ... 阅读全文
摘要:
To set up alternate character functionality in PeopleSoft HRMS: Link the alternate character sets with language codes on the Installation Table - Alternate Character page (ALT_CHAR_TBL). ... 阅读全文
摘要:
If you are an Oracle DB customer, you should learn about Oracle hints. Oracle hints influence the Oracle optimizer to your advantage. Here is an example of a hint. Example: select /*+ ALL_ROWS */ em... 阅读全文
摘要:
Get the O/S environment variables from within SQR programs There is a function called GetEnv(). This gets the TEMP environment variable on the machine where SQR is run. Returns the value of the spec... 阅读全文