C / C++
|
| Category |
Topic |
Subject |
| Description
|
|
| Code Samples
|
access MySQL with C
|
sample C programs accessing MySQL
|
| MySQL sample programs to demonstrate connecting, selecting, inserting, and listing(tables) from within C programs.
|
|
|
| Code Samples
|
File I/O and params
|
example of file I/O and input parms
|
| simple example of file I/O, buffering, and input parameters. The pgm breaks a file into diskette (or any) size pieces. if the parameters are not correct, instructions are written to the screen.
|
|
|
| Code Samples
|
pgm in C & Pascal
|
screen I/O pgm in C & Pascal (&rpg)
|
| the program I wrote, in C and Pascal & rpg, has a 4 level nested search-repeat parse through a list.
|
JavaScript
|
| Category |
Topic |
Subject |
| Description
|
|
|
| Code Samples
|
DHTML
|
commonly used functions (11)
|
| commonly used Java-Script aka DHTML functions such as scrolling; fading; blinking; and oscillating; text (4). Browser feature sensing, drop down navigation bar, image buttons, Alt function for text, and more.
|
|
|
| Code Samples
|
separate HTML file
|
common HTML in a separate file
|
| example of how to put HTML such as headings and navigation bars, used in many pages across a web site, in a separate file
|
|
|
| Code Samples
|
set tblrow color on
|
set table row color onclick & hover
|
| very simple, very short, java script and CSS code to set a table row color (etc.); to "highlight" a row when the cursor passes over and, stay highlighted if clicked.
|
RPG - AS400
|
| Category |
Topic |
Subject |
| Description
|
|
|
| CLP - OS/400
|
CLP intro
|
CLP introductory tutorial
|
| CLP intro tutorial with code - COMMAND LANGUAGE (SYSTEM) programming
|
|
|
| code - full programs
|
RPG Sub Files
|
sample subfile program
|
| sample subfile program: ile-rpg, dspf, pf, lf, and a small data set
|
|
|
| Miscellaneous
|
QSECOFR notes 1994
|
notes taken while QSECOFR
|
| notes taken while QSECOFR on a network of 3 AS/400\'s on subjects including object authority, job logs, WRKSYSVAL, terminals, inactivity, outq\'s & printers, profiles, routing tables, etc. . .
|
|
|
| Miscellaneous
|
QSYS Commands List
|
QSYS (AS/400) Commands List
|
| All the AS/400 QSYS commands, with short descriptions, including PWRDWNSYS etc. which you may not have authority to see or use.
|
|
|
| Miscellaneous
|
RPG-ILE ref. code
|
RPG-ILE reference file for code
|
| Reference file for code syntax used seldom enough to be forgotten; array overlays, SORTA, date formats, tables, multi-occur-DS\'s, SDS, plus.
|
|
|
| tests & quizes
|
Certification
|
IBM sample RPG Cert. test
|
| IBM had/has an on-line sample sertifiication test for RPG (ILE +) sr. programmer analysts along with a general list of things an RPG - AS/400 programmer should know.
|
|
|
| tests & quizes
|
ILE-RPG; RPG-IV (4)
|
39 question quiz of RPG
|
| quiz offered in 2007 to co's and agencies for technical testing of their RPG programmer job applicants and etc.
|
|
|
| utility
|
Display File Format
|
Display Format of PF and all LFs
|
| it combines the information of several as400 file description comands and displays it all in a more compact, readable, manner.
|
|
|
| utility
|
LDA Local Data Area
|
LDA - Edit your Local Data Area
|
| a simple CLP and DSPF to edit your Local Data Area - you can expand or contract it for how much you need
|
|
|
| utility
|
object listing
|
object listing sorted by a date
|
| object listing sorted by last used date and restricted by object size and or a date range
|
|
|
| utility
|
printouts to files
|
copy multiple printouts to a file
|
| a CMD, CLP, and RPG for copying multiple printouts to a file with the option of having the printouts deleted (y/n) afterward
|
|
|
| utility
|
RPG ILE indented
|
indented source code listing
|
| source code utility to print indented columnized RPG (III and ILE) source
|
SQL
|
| Category |
Topic |
Subject |
| Description
|
|
|
| Code Samples
|
from my experiences
|
from my web site databases
|
| sample code and tips from my experiences designing SQL databases for my customer\'s web sites
|
|
|
| Commercial Programs
|
Crystal Reports
|
selects in Solomon accounting pkg
|
| The Microsoft accounting pkg SOLOMON, uses Crystal Reports to generate its printouts. which, in turn, uses SQL Select statments that a programmer can modify. Here are some of the selects used and
modified.
|
|
|
| Commercial Programs
|
Solomon
|
Ordering, main tables, fields
|
| Tables written step by step in order processing - (coming from an outside CRM-Sales data base - Siebel)
|
|
|
| Databases
|
NORTHwind
|
MS SQL Server sample database
|
| Table definitions to export the sample database NorthWind from MS SQL Server 2000 and Import it to MySQL in either Unix(Linux) running Apache or in Windows running IIS. --- See demo at page NorthWind-db-1
|
|
|
| Databases
|
NorthWind order data
|
data for NorthWind order table
|
| The create and insert statements with the data to build the NorthWind Orders table.
|
|
|
| Miscellaneous
|
SQL Functions
|
Functions in SQL Server & MS Access
|
| list of Aggregate functions in MS Access and SQL Server and Useful Scalar Functions in MS Access
|
|
|
| tests & quizes
|
2 MySQL quizes
|
MySQL application and admin quizes
|
| A 12 question MySQL application quiz and, a 50 question MySQL administration quiz
|
