2009 年 1月 9 日随笔档案 - Kevin's Blogy

All About Oracle Hints

摘要： 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... 阅读全文

posted @ 2009-01-09 14:57 Kevin's Blogy 阅读(253) 评论(0) 推荐(0)

Read Env Variables from an SQR

摘要： 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... 阅读全文

posted @ 2009-01-09 14:49 Kevin's Blogy 阅读(329) 评论(0) 推荐(0)

Calling a Batch File/EXE from an SQR

摘要： Use the following code to call a batch file or executable from an SQR. Put the complete path of the batch or executable in the variable $command_line. If $message is not 0 then you have an error from ... 阅读全文

posted @ 2009-01-09 14:48 Kevin's Blogy 阅读(214) 评论(0) 推荐(0)

Strip out additional chars from Phone Numbers

摘要： Below is a good SQR tip for stripping out special characters from those nasty Phone Number formats stored in HRMS. begin-procedure main . . do parse_phone($phone_number, $phone_number) . . end-proc... 阅读全文

posted @ 2009-01-09 14:47 Kevin's Blogy 阅读(183) 评论(0) 推荐(0)

Use an SQR to call DataMover to Export then call a

摘要： Below is a sample piece of SQR code which you can use to call Datamover to export data perform some processing, and call another SQR within that SQR to posibly load the data. It's a good sample! !**... 阅读全文

posted @ 2009-01-09 14:46 Kevin's Blogy 阅读(326) 评论(0) 推荐(0)

Skip a Search Record Prompt When You Know the Keys

摘要： Here is a worthy tip to take note of. If you are going into a new page and using a search view, yet you already know the keys of that search view, you can use the PeopleCode function SetSearchDialogBe... 阅读全文

posted @ 2009-01-09 14:43 Kevin's Blogy 阅读(444) 评论(0) 推荐(0)

Quick way to send emails from PeopleCode

摘要： Here's a quick way to send an email message from within peoplecode. You can also send attachments along with your email message. Simply use the PeopleCode command SendMail to send an email message fro... 阅读全文

posted @ 2009-01-09 14:39 Kevin's Blogy 阅读(548) 评论(0) 推荐(0)

Tracing App Engine Programs

摘要： Tracing an application engine program can be easily done without modifying the trace settings in your application server. Here are some simple guidelines to follow to trace an app engine program. Go... 阅读全文

posted @ 2009-01-09 14:38 Kevin's Blogy 阅读(223) 评论(0) 推荐(0)

Dynamic DropDown Lists

摘要： If you have a drop down list on a page and want to place items into the drop down list dynamically, here is a bit of insight on how to do it. This tip is taken from our discussion forum thread How t... 阅读全文

posted @ 2009-01-09 14:36 Kevin's Blogy 阅读(346) 评论(0) 推荐(0)

Difference Between 2 Dates or 2 Times

摘要： There are many occassions where you might want to find the difference in time or days between two dates. Use the PeopleCode function known as DateDiff. The %DateDiff meta-SQL function returns an int... 阅读全文

posted @ 2009-01-09 14:35 Kevin's Blogy 阅读(483) 评论(0) 推荐(0)

Record Level Auditing

摘要： I'm sure you are aware that PeopleSoft has built in Field Level Auditing that allows you to track any adds, changes, or deletes to a specific field in a record. This is good to use at times when you... 阅读全文

posted @ 2009-01-09 14:17 Kevin's Blogy 阅读(229) 评论(0) 推荐(0)

Calling App Engine from PeopleCode

摘要： There have been many requests from PeopleSoft Pros wanting to call an appengine program from PeopleCode. Some refer to this as "Real-Time Application Engine Processing." For example, when a user save'... 阅读全文

posted @ 2009-01-09 14:09 Kevin's Blogy 阅读(289) 评论(0) 推荐(0)

Left Pad Zero Fill

摘要： If you have any specific fields that are lengthy and are left padded with zeroes, you can save your users a lot of time by alowing them to type ONLY the right most numbers. For example, lets say you... 阅读全文

posted @ 2009-01-09 14:06 Kevin's Blogy 阅读(403) 评论(0) 推荐(0)

2009年1月9日