|
| |
 |
My name is Tony DeLia. I'm a technical
consultant with AnswerThink Consulting Group's PeopleSoft Solutions Practice (formerly
Delphi Partners). The purpose of this site is to provide SQR information and some pictures
I created which are mostly of undersea life (the theme of the site). Sign my Guestbook here. |
| Essential Guide to
PeopleSoft Development and Customization |
 |
By Tony DeLia,
Galina Landres,
Isidor Rivera and
Prakash Sankaran...
Manning Publications... More details to follow...
DOWNLOAD "PREVIEW" PDF Files - Click Here! |
| SQR in PeopleSoft and
Other Applications - a.k.a. the SQR "Bible" |
 |
SQR in Peoplesoft and Other Applications by
Galina and Vlad Landres - Manning Publications
Order a copy online at AMAZON.COM
Click on the book for my personal review |
| The SQR User's Group is an excellent site designed to
facilitate the open exchange of ideas amongst SQR Users. Membership is free. Questions and
solutions may be posted through a mailing list to the online bulletin board. A search
feature may be used to find information in the current or archived list. This is a great
site and the developers should be highly commended! http://www.sqrug.com |
| SQR Analyzer Use
this utility to analyze SQR source code. Several functions are performed which include the
creation of one stand-alone source file with nested includes expanded, a report listing
each procedure and called sub-routine, and finally an indented process flowchart of the
SQR execution path. |
 |
You may be wondering what some of these illustrations have to
do with SQR. Creating a web-site can be pretty boring. This makes it a little more
interesting for me. I drew this with my trusty crayola crayons on the flight back from our
honeymoon. At least there's sentimental value attached! |
| Application Engine
Analyzer This useful utility is similar to SQR Analyzer. The user is
prompted for the A/E program and the analysis begins. First a listing of the Cache record
is produced, then each step is printed with all of its' attributes. An indented process
flowchart is then generated illustrating the execution path of the process. |
| Custom SQR Function Library -
"NEW Feature" |
 |
I created a custom function library (TDFUNC.SQC) that contains various
routines for string handling, data manipulation, comparison and more... Visit often as
this library will be updated periodically... Suggestions for new functions are
encouraged... Click on the tiger head to check it out! |
| SQR Techniques (Here's some
samples) |
 |
Sorting Arrays - Click on the Killer Whale to view
several sort algorithms. Bubble, Insertion, Short and the recursive QuickSort are
demonstrated. |
 |
Searching Arrays - Click on the Shark to view array
search techniques. Two forms of binary searches are demonstrated along with the standard
linear search. |
 |
File I/O Validation Prompts - Click on the Sea Turtle for
a sample file validation routine. I use this for all programs requiring file input/output
prompts. |
 |
One of the SQR User Group members, Wayne Ivory, has created a
GUI Windows-Based version similar to my SQR Analyzer. It is written in Visual Basic and is
very nicely done. Click on my 'Tree' creation to the left for more information including
some previews and where to register. |
 |
Scattered about on this site you'll also find samples of my original
"Zoo Animals" collection... part of a 100 page sketchbook I'm creating for my
daughter... this is definitely a long term project! Already completed: Alligators, Lions,
Grizzlies, Pandas, Flamingos, Koalas, Tigers, Rhinos, Elephants, Giraffes, Anteaters,
Hippos, Sloths, Monkeys, Moose, Polar Bear, etc... there's even a Platypus! |
 |
I would appreciate any feedback you may have on this site.
Send mail to tdelia@erols.com or click on the
Octopus. |
| AnswerThink Consulting Group |
 |
If you're 'nosey' about AnswerThink Consulting just click on
the Toucan! We provide knowledge-based consulting and technology solutions and are
becoming recognized as a leader in the consulting industry. http://www.answerthink.com |
 |
Thanks to all who've sent feedback on this site... even just to say they
like my pictures! I appreciate it... special thanks to Robert Thomas for the animated
shark gifs... more at end of page... great stuff! |
| Latest Updates... Use Hyperlinks
for quick access... |
07/21/2001 - TDAUDIT.SQR - PSAUDIT Analyzer (Utilities)
02/08/2001 - SQR Send Mail for Windows (BLAT)
(Techniques/Functions)
12/29/2000 - Happy Holidays (Non-Technical) - Holiday Cutouts
& Mario...
12/15/2000 - COMP-3 handling (READ/WRITE/PACK) (Functions)
12/15/2000 - Revision SELECT/INSERT generator (improved
SubRecord)
12/07/2000 - BIT-Func (XOR/AND/OR) Simulate Bit Operations.
12/07/2000 - Non-Technical Stuff - "Stupid Magic Card
Trick" (About Me)
11/09/2000 - NL-Func - Numeric to Literal Translation (Pay Check
Printing)
10/05/2000 - PARSE-Func (Put/Get) - Sample creates XML output.
10/04/2000 - Please take a
moment to sign my Guestbook.
09/25/2000 - Our book was released! Thanks for your patience!
Click the link!
07/15/2000 - Preview of 'Essential Guide to PS...' - Download
PDF Files!
06/04/2000 - STRIP-Func - Strip Characters from String
(Functions)
06/03/2000 - REPL-Func - Replace String Characters (Functions)
06/03/2000 - INSTR-Func - Bi-Directional! More artwork!
(Functions)
04/11/2000 - Links page Update (New Art Links Section started)
04/11/2000 - TDFUNC.SQC Custom Function Library Update
(Functions)
04/11/2000 - More Powerful SQL*Engine Directives/Parameters
(Utilities)
03/10/2000 - INI-Func - INI Files / Windows Registry Access
(Functions)
03/05/2000 - LIKE-Func - Simulates Oracle LIKE Operator
(Functions)
03/03/2000 - NXT-Func - Increment Any String (Functions)
03/02/2000 - Custom SQR Function Library TDFUNC.SQC (Techniques)
02/27/2000 - Creating Oracle User-Defined Functions (Techniques)
02/12/2000 - Tree Node Re-Numbering Utility (Alternative to
PTUGAPTR)
02/12/2000 - Tree Node Listing Utility (Utilities)
02/08/2000 - PeopleSoft/SQR Books (including Essential Guide to
PS...)
02/02/2000 - Project Object Listing / Extract (Utilities)
01/02/2000 - Happy New Year! SQL*Engine @SET/@SCRIPT Sample
12/31/1999 - More SQL*Engine Directives (@SET/@SCRIPT)
12/18/1999 - SQL*Engine - Dynamic SQL Script Processor (Utilities)
10/31/1999 - Reading Comma-Delimited Files (Techniques)
10/31/1999 - SQR SELECT/INSERT Procedure Generator (Utilities)
09/16/1999 - Rounding Methods added to TDINCR.SQC (Up, Down,
Round).
08/19/1999 - Dinosaurs, Disassembler, & an SQR unpack routine
(Techniques)...
08/01/1999 - Supervisor Analyzer... and a "Forest Lake"
(Utilities)
07/22/1999 - More of Devon, TJ and Weenie (About Me)
07/22/1999 - More Routines... and another "Rain
Forest" (Techniques)
07/15/1999 - Simple SQR Routines... and a "Rain Forest"
(Techniques)
07/11/1999 - A/E Analyzer Update (DB2 support, A/E 6.0 support
also)
07/08/1999 - Pets Section added (About Me) See Devon, TJ and Weenie
07/07/1999 - Links Section Updated (About Me)
07/07/1999 - I finally updated my resume (About Me)
06/17/1999 - COBOL Analyzer added
06/02/1999 - Mainframe Signed Number Conversion (Techniques)
06/02/1999 - Duck Soup sketch (Utilities)
05/23/1999 - Incremental Rounding Technique (TDINCR.SQC)
05/21/1999 - COBOL Call Structure Analyzer added
05/15/1999 - Application Engine Analyzer added (downloadable) |
Tony DeLia - Updated July 21, 2001
Visitors Since August 1999:
|
