|
Some samples of my work.
(Under construction - many more to
come!)
Links to My Previous Employers' Web pages Displaying My COBOL Samples |
These links below take you to COBOL programs I've created that
are still currently being used as customer training examples by my
former employers at Sybase and Viaserv. All of my published COBOL
sample programs emphasize structured coding methodology
and strong, readable internal documentation.
|
MODELRSP
Title:
VS COBOL RSP Sample
- How to code SQLDA for DB2 Output Pipe
Click above to be sent to a current Sybase web page
that shows a "whitepaper" display of a COBOL CICS program I designed
as a customer sample at Sybase. It is my best-known program sample.
The purpose of this program is to illustrate how to use IBM's SQLDA
in a CICS COBOL program to map non-relational data into a relational
format for easy conversion to desktop relational databases (e.g..
MS SQL Server, Sybase ASE, Oracle, Informix, - any database available
to ODBC) via Sybase's API commands.
This is the only one of my program samples available publicly that
still has my name coded in it. The programming style, however, will
be evident in all the other samples available below. Scott Jackson,
the author sharing credit in this program, tweaked the program to work
under VS COBOL, which predated COBOL II and required using the
"SERVICE RECALL" approach to CICS pointers. All other coding is mine. |
RSP3C
Whitepaper Title:
COBOL II OS Sample: RSP3C Written in Open Server/CICS
Click above to be sent to a current Sybase web page
that displays a frame version of the Sybase whitepaper featuring one of
my COBOL CICS programs designed as a working customer sample by sending
data blobs to send up to the mainframe from a LAN server.
All of the programs here are coded as COBOL II versions. The purpose of the RSP3C program is
to illustrate how to code Sybase's API in a CICS COBOL II program to
interface with Sybase's software. The programs are simple but like
MODELRSP there is an emphasis on structure and internal documentation.
|
RSP4C
Whitepaper Title:
COBOL II OS Sample: RSP4C Written in Open Server/CICS
Click above to be sent to a current Sybase web page
that displays a frame version of the Sybase whitepaper featuring one of
my COBOL CICS programs designed as a working customer sample.
All of the programs here are coded as COBOL II versions. The purpose of the RSP3C program is
to illustrate how to code Sybase's API in a CICS COBOL II program to
interface with Sybase's software by using keywords to send and receive
information between a mainframe and a LAN server.
The programs are simple but there is an emphasis on structure and internal documentation.
|
|
CLIENTC2, CSAINDX, CSARESCK
Title:
Viaserv sample CSAs
are distributed with the ViaSQL product.
Click above to be sent to a current Viaserv web page
that displays a customer documentation page featuring three more of
my COBOL CICS programs designed as customer samples. Almost all of the
coding examples used throughout the Viaserv coding manuals are from my programs.
Again, all of the programs here are coded as COBOL II versions.
These programs illustrate how to code Viaserv's API (which is virtually
identical to Sybase's API) in any CICS COBOL II program to interface
with Viaserv's software. These programs emphasize a function that
allows the mainframe to act as a client, connect to servers on the
LAN, send SQL commands, and transfer data to and from those LAN
servers. These same programs are actually also available from Sybase's
public web pages (see next box below). Viaserv, as well as Sybase,
publishes all of the programs mentioned here and above (MODELRSP,
RSP3C, and RSP4C) in their programming manuals as their best COBOL
coding examples. |
CLIENTC2, CSAINDX, CSARESCK
Manual Title:
Open ClientConnect Programmer's Reference
for Client Services Applications
Click above to be sent to a current Sybase web page
that displays the same three COBOL CICS programs mentioned directly above
at the Viaserv web site.
|
Documentation Contributions
Title:
How IXF format records are used by MDI Software
Click above to be sent to a current Sybase web page
that displays a "whitepaper" I wrote many years ago at MDI (the company
Sybase purchased to acquire all of software solutions and APIs mentioned in the examples
above). This information had been also added as an appendix to the programmer's
guides used at MDI and Sybase. Viaserv makes this same information available upon
request.
The purpose of the paper is to illustrate how to create IXF format
records. IXF is the methodology that IBM uses to move relational
data (e.g. DB2) in a flat file form to survive page code translations
from one platform to another. |
Documentation Contributions
Title:
Relationship between the SQLSDA and IXF header records
Click above to be sent to a current Sybase web page
that displays a "whitepaper" I also wrote many years ago at MDI. This
information had been also added as an appendix to the programmer's
guides used at MDI, Sybase, and Viaserv.
The purpose of the paper is to illustrate how IBM's SQLDA (the record format
for IXF records in coding form - in this case COBOL) relates visually to the
IXF format records created or received by the COBOL program.
|
Web Pages Created for Previous Employers |
For confidentiality reasons, I'll only be presenting GIF pictures of
selected internal Web pages that presently exist behind secured firewalls.
|
Click above for a picture of a web page that I designed for internal-only
use at Sybase. This web page was one of hundreds I created to help
Sybase employees navigate to hundreds of internal training recordings
and materials that I collected and made available. Notice I use a
Javascript list to help condense the selections available. I also
created the logo at the top of the page. |
Click above for a picture of a web page that I created for customer
use at Viaserv. This web page allows trusted customers (using a password)
to search and access hundreds of internal technical documents and
solved cases that I collected and made available. I did this by studying
and then modifying the sample search pages provided by Microsoft Index
Server. |
Click above for a picture of a web page that I created for internal
use at Viaserv. This web page, written in Perl, allows executive management
at Viaserv to run reports on the counts of web hits against the Viaserv
Knowledgebase that I created. I did this by studying the internals
of Microsoft Index Server and finding out how to scan the web server
logs. This is where I learned to code in CGI and Perl. |
PDF Samples of Documents for Previous Employers |
PDF - sample of student guide module
size=484Kb
Right-click above to download a PDF of the first 12 pages of a student guide I designed and created. PowerPoint was used to create the slides and student manual. The course was created from a curriculum design I devised.
|
PDF - sample of course description
size=114Kb
Right-click above to download a PDF of the course description for the course mentioned above. The course description has marketing and sales information about the course that I provided to boost the course's profitability.
|
On-Site Consulting: Short List of Satisfied Clients |
Metropolitan Life Insurance Company, Blue Cross of St. Louis, Marin County, Tulsa County, City of Oklahoma, City of Fort Lauderdale, City of Overland Park, City of Arlington, New York Employees Retirement Department, Massachusetts State Lottery, California Water Department, Colorado Department of Transportation, Swiss Union Bank, Redwing Shoes, and many others.
|
|