Select Page
Posted by Steven Alexander | Apr 26, 2009 | Peoplesoft Specific, Practices |
The term “log file” implies that this file serves as a log; a diary; a record of significant events in the program. It’s a place for unofficial information or information about this instance of this program,...
Read MorePosted by Steven Alexander | Apr 19, 2009 | Algorithms, Commands |
Numbers are probably the most important scalar objects of business applications, but dates may be a close second. Dates Are Harder Than Numbers Numbers are simple; they line up. Commands manipulate them without units. Dates...
Read MorePosted by Steven Alexander | Apr 12, 2009 | Commands |
Even the best programmer in my one-person cubicle makes mistakes. I’ve worked in several different languages, and made the same mistakes in many of them; out of bounds array index, dividing by zero, messing with Texas....
Read MorePosted by Steven Alexander | Apr 5, 2009 | Algorithms, Peoplesoft Specific |
Peoplesoft allows the user to give direction to an SQR program by entering parameters on a webpage before the Process Scheduler runs PSSQR. Here is a new way to get those parameters to the SQR program. SQR Command Line...
Read MorePosted by Steven Alexander | Mar 29, 2009 | Commands |
SQR programs can execute SQL “select” statements with a “begin-select … end-select” block. They can execute any other SQL statements with a “begin-sql … end-sql” block. SQR has three ways to modify the literal text of those SQL...
Read More
Recent Comments