If you cannot find the answer to your question here look in our Frequently Asked Questions page.
You may also contact us by e-mail
Class Detail Options and Class Library List:
These screens are used to to identify, and confirm the various options for a
Class Library generation.
The user must select the following options:
Program name prefix: (required)
It is recommended that this be less than 5 characters long depending on how many programs you want to generate
in the class library. The total length of the program name is seven characters total. If the prefix is four characters
you will be able to generate 999 programs under that prefix. (xxxx001 thru xxxx999). If the prefix is three
characters you will be able to generate 9999 programs under that prefix. (xxx0001 thru xxx9999).
The prefix can be any combination of letters and numbers that meet your naming standards.
Program Index: (required)
This value indicates to DB2Factory where to begin the numbering of the next generated program for a given
class library. For example if you do a new hundred table class library generation today you be assigned
program names xxxx001 thru xxxx100 (where xxxx is your program prefix literal). If you add ten tables to
this class library you would want to start with an index value of 101. You would then generate programs
xxxx101 thru xxxx110.
SQL Operations: (at least one is required)
Check one or more of the SQL options based on your requirements for this particular class library.
All programs generated will be generated with only the SQL options selected. If you select all SQL
functions you will have a class library of programs (one per table selected) that will allow you to perform
basic table maintenance. The first three programs in the DB2Factory Demo were generated with all
SQL functions and the DB2JS template.
Tables: (at least one is required)
Select one or more tables to be included in a particular class library generation request. Tables can
belong to many class libraries. Hold the CTRL or Shift key to select multiple tables.
Program Template: (one is required)
This indicates to DB2Factory.com the template of your choice. A list of
available templates and their functionality can be found here.
Class Library List Confirmation:
After entering the required information on the class library generation detail form, click the 'Continue' button.
This will take you to a confirmation screen for the class library you are about to generate. This
screen will list all of the program names to be generated as well as the corresponding table
for that program. If the list meets with your approval, click on the 'Accept' button
to begin the generation process. After the generation is complete, you will be taken to the Program Download screen where you will be able to
download the generated source code.
Class Library:
A Class Library can be described as a group of COBOL/DB2 programs that have similar
characteristics and assumptions.
These characteristics and assumptions include:
Program naming convention - All generated programs will have the same prefix and a numerically
incremented suffix
Generated SQL functions - The SQL functionality will be the
same throughout a given Class Library
Generation template -
The same generation template will be used through out a given class library
The use of Prime Keys in the generated 'Where Clause' -
The default 'Where Clause' attributes will be based on the use of prime keys
for a given table. In lieu of prime keys, the first column will be used as the
selection criteria. Any 'Where Clause' once generated can be updated as needed for
your specific needs by using the Generation Detail screen.
Help Index
Generation Detail
This screen allows the user to select the basic options for generating the DB2/COBOL source code. The fields on this
screen are:
Program name:Help Index
A seven byte alphanumeric identifier for this particular program.Description:
A thirty byte alphanumeric description for this particular program. This will default to the DB2Table name if the program was generated in a class library generation request.SQL Operations:
Select, via the check box, which SQL operations you want to generate into the program.
The options are:Fetch - Will allow the calling program to request a multiple row result set.
Select - Will return a single row to the calling program
Insert - Allows the calling program to perform DB2 Inserts
Update - Allows the calling program to perform DB2 Updates
Delete - Allows the calling program to perform DB2 Deletes
Selecting Insert, Update, or Delete implies a single table operation. Fetch and Select can include multiple tables.
Get Columns:
Individual columns may be selected for all SQL operations. To get a list of columns available for the tables selected, click on the 'Get Columns' button. This will populate the Columns list box with a list of tablename.columnname pairs for all tables selected in the 'Tables' list box. To select multiple columns hold the CTRL, or Shift key while selecting the required attributes. It is the users responsibility to know about their individual requirements with respect to the inclusion or exclusion of columns for a given table definition. In other words, if you declare a column as non-nullable it is up to you to make sure that it is included in an Insert operation. Where Clause: If you need to include a custom DB2 where clause, click on the 'Where Clause' button. You will be presented with a second browser session that will include the screen for a custom where clause.Continue: When all of your selections are complete for this screen (including the Where Clause), and you want to continue, click the 'Continue' button.
Template Selection
Select the generation template for the program you are about to generate. Only one may be selected at a time. It is possible
to regenerate the program using a different template if need be. It is also possible to use the same table under multiple program name, in
conjunction with a variety of templates.
To get detailed information regarding a particular template, select the template and click on the 'Detailed Description'
button. When you have made your selection, click on the 'Continue' button to proceed to the generation confirmation screen.
Entrance / Logon help
If you forget your user id or password, notify us by e-mail. We cannot give
it to you over the phone. We will notify you via the e-mail
id for the project or account in question.
Project Menu
From this menu you can select one of five links. They are:
Upload Data Definitions (DDL) |
|---|
Use this option to send us your Data Definition Language. The DDL is the basis for all COBOL/DB2 source code generation. Think of this as sending us the 'blue prints' for the system you are going to build. |
Generate Program |
This option allows you to generate a single program at a time. You can use this link to generate a new program, or, use it to maintain an existing program. This option will allow you to generate single or multi-table COBOL/DB2 programs. Additionally, you can specify your own join, selection, and sequencing criteria. |
Generate Program Class Library |
This option allows you to generate many programs at once. You specify a range of tables, a naming standard, and a template, and we do the rest. You can generate a class library for your entire data model in minutes or seconds using this option. |
Download Generated Program(s) |
This option allow you to download all generated source code. Additionally, you can download the results of your last DDL submission from this page. |
Log Out |
The error messages presented are from DB2 UDB DDL processor. Consult your DB2 UDB documentation for more information, or use the following links for more detail:
Online
Documentation
DB2 Product and
Service Technical Library
Free DB2 for
educational purposes
DB2 general information
Program Download:
There are two ways to download generated source code:
Upon completion of any generation you will be presented with a screen that allows you to download three different files of zipped source code. They are:
1.) ALL.ZIP - Every line of source code you ever generated.
2.) CURRENT.ZIP - Everything you just generated. This could be either a single program or a class library of programs. Note: CURRENT.ZIP and ALL.ZIP are both a zip of individual zip files.
3.) XXXXXXX.ZIP - Where "XXXXXXX" represents an individual generated program name. Each of these zip files contains the source for one program.
From the Project Menu, you may select the "Download Generated Programs" link to get to a slightly different version of the source download screen. This screen contains ALL.ZIP, CURRENT.ZIP, XXXXXXX.ZIP as well as the file size, ZIP file timestamp, and program description.Help Index
Additionally this screen contains download links for your last DDL submission.
Depending on your browser options and the length of time it takes to process any sizable request (such as a large class library generation request) you run the risk of having your browser "time-out" while waiting for a response from DB2Factory. Should that happen, or, should you just decide to 'logoff and go to lunch', you can download all completed work using this option.
Program Selection List
This screen presents the user with a list of programs already generated, and at the top of the list, the option
to generate a 'NEW' program. You can select only one item from this list. After doing so click on Continue.
Program Review
This is a confirmation screen. If you want to continue with the generation click on
Accept, if not click on Cancel, or
use your browsers back button to return to the previous screen.
Template Selection:
Select the generation template for the program you are about to generate. Only one may be selected at a time. It is possible
to regenerate the program using a different template if need be. It is also possible to use the same table under multiple program name, in
conjunction with a variety of templates.
To get detailed information regarding a particular template, select the template and click on the
'Detailed Description'
button. When you have made your selection, click on the 'Continue' button to proceed to the generation confirmation screen.
Upload DDL
This screen is used to transmit your Data Definition Language (DDL) to DB2Factory.com.
You will use this screen initially to set up your data model with us, and, you will use it whenever your data model changes.
We use your DDL as a 'blueprint' in the generation of source-code.
It is important, therefore, that we have the most current version of your DDL.
Where Clause Detail
This screen is used to develop custom 'where' and 'order by' clauses for a particular
program.
Here are the functions of the various controls:
Save updates the data base with the contents of the Where Clause: - whatever the content - and ends the all Where Clause Detail processing.
Cancel ends the Where Clause Detail processing without doing a 'Save'.>> (add) control adds selected columns from the candidate list on the left to the detail on the right
<< (remove) control removes selected columns from the detail list'Create Where Clause' populates the Where Clause: list box with the SQL Where Clause Columns: and Order By Columns: as selected with the >> and << controls above. The contents of the Where Clause: list box can be edited as needed.
'Reset to Default' creates the default 'where' clause (prime key join criteria and prime key selection criteria) with no 'order by' clause. 'Reset to Default' and 'Create Where Clause' are mutually exclusive. Mouse selection with the shift key results in multiple selections. Mouse selection with Ctrl key results in individual selections.
The contents of the Where Clause: list box will be used exactly 'as is' in the generated program.
Note: User modifications to the contents of the Where Clause: list box are not validated in any way.
Joining Columns:
Use the mouse and Ctrl keys to select two columns from the left and the >> control to move them to 'Where Clause Columns: on the right. 'Create Where Clause' moves the join to the Where Clause: list boxHost-Variable Selection:
This is the same as Joining Columns except that the columns are selected one at a time from the left and moved one at time to the right into 'Where Clause Columns:.Host-Variable Sequencing (Order-By):
This is the same as Joining Columns except that the columns are selected one at a time from the left and moved one at time to the right into 'Order By Columns' either Ascend or Descend.
Rolodex Application:
This sample Name and Address application consists of three tables:
rolodex,
and two reference tables:
state_codes,
and, country_codes.
In this sample application we generated a class library of maintenance screens
using the Java Script / COBOL CGI / COBOL SQL model. This
model provides Inter/Intranet access to your mainframe DB2 tables. Also for this
example we generated a view by doing a three table join. Last, we selected
the DB2 to Excel model for each table as well as the three table join.
Java Script / COBOL CGI / COBOL SQL
API declarations
Architectural tenets for this model include:
Java Script HTML forms processing that provides basic grid based table
maintenance.
COBOL / CGI form processing.
Queuing logic for result sets greater than 32k
COBOL / DB2 data access routine that can run in a Batch or CICS environment.
Automatic update of create and revised user-id's and timestamps
Concurrency validation logic
Numeric validations
Batch
API declarations
Architectural tenets for this model include:
COBOL / DB2 data access routine that can run in any batch environment on any supported DB2 platform
Automatic update of create and revised timestamps
Concurrency validation logic
Numeric validations
32K result set limit
CICS API declarations
Architectural tenets for this model include:
COBOL / DB2 data access routine that can run in a CICS environment on any supported DB2/CICS platform
Automatic update of create and revised timestamps
Concurrency validation logic
Numeric validations
Queuing logic using CICS Temp Storage for result sets greater than 32k
Java Script MS Excel 2000 / COBOL CGI / COBOL SQL
API declarations
Architectural tenets for this model include:
COBOL / DB2 data access routine that can run in a Batch or CICS environment.
COBOL / CGI screen processing for basic grid data
JavaScript / HTML basic grid maintenance Queuing logic for result sets greater than 32k
This template supports 'Fetch' (Read) only processing. Although this
template uses Fetch only processing, it is still possible to generate Insert,
Update, and Delete functions into the COBOL/SQL component of the generated
source code. (These functions may be used by programs other than the generated
CGI program. e.g. a batch update process)
This template interfaces the DB2 result set directly into an Excel spreadsheet
via the Excel HTML 'plug in'. This plug in come with Microsoft Office 2000. If
your company has a site license to Office 2000, you can download the necessary components
from your corporate LAN. See your LAN administrator for more details.
The DB2 column names are displayed in row one of the HTML spreadsheet.
While it is possible to manipulate, cut and paste, and otherwise process the
data contained in the spreadsheet, the end user cannot save any changes made to
the spreadsheet. To save the data, you must cut and paste it into another
application, or, invoke an instance of MS-Excel from the HTML Plug in toolbar.
This will transfer your data from the browser spreadsheet to one that can be
saved locally.
This model has only been tested using Microsoft Internet Explorer version 5.0.
Copyright (c) 2000 The Object
Group, Inc. All Rights Reserved