Kbase 18981: Deploying Apptivity Java Project To AS/400 Natively
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/02/2003 |
|
Status: Unverified
FACT(s) (Environment):
Apptivity 3.x
FIX:
Step by step details:
The deployed files of the project may be placed (copied) below a directory from where the Apptivity Component Manager is started for instance projects/AS400DB/
For that case the apptivity.qrypath property looks like:
apptivity.qrypath=projects/AS400DB/
The name of native JDBC driver to access the AS/400 Data Library is:
com.ibm.db2.jdbc.app.DB2Driver
If the name of the AS/400 Data Library is: APPSPORTS
and the name the AS/400 System: *LOCAL
than the database URL would be: jdbc:db2://*LOCAL/APPSPORTS
so the entries inside the project.qry file :
BEGIN CONNECT dcAS400Sports;
DRIVER com.ibm.db2.jdbc.app.DB2Driver;
CONNECT jdbc:db2://*LOCAL/APPSPORTS;
The CL command to get the AS/400 System name is:
wrkrdbdire
and the result of that command for the above example:
Relational Remote
Option Database Location Text
S44G8154 *LOCAL