Kbase P104765: How to run the same program against another schema image under the Native4G
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/06/2005 |
|
Status: Unverified
GOAL:
How to run the same program against another schema image under the Native4G
GOAL:
Is -ld parameter supported in Native4GL client
FACT(s) (Environment):
IBM AS/400 (RISC)
Progress/400 DataServer
FIX:
The -ld parameter is not supported with the Native4GL client. Instead, the 'create alias' statement can be used to redirect the connection to another server schema image.
Let's assume we have two databases on the AS/400: DB1 and DB2. Each Dictionary Library contains a separate schema image. We have a program (program.r) compiled against DB1 that we want to run against DB2. In order to complete such a task we should create a new .p code including two alias statements:
/**********************************************/
CREATE ALIAS DB1 FOR DATABASE DB2
CREATE ALIAS DB1-SCHEMA FOR DATABASE DB2-SCHEMA
RUN program.r
/**********************************************/