Ansicht
Dokumentation
03311 - New Tables - Is Primary Key Constraint added immediately or i n 2nd step on table creates
PERFORM Short Reference rdisp/max_wprun_time - Maximum work process run timeThis documentation is copyright by SAP AG.
New Tables - Is Primary Key Constraint added immediately or i n 2nd step on table creates
I'm retracting my comment about the Primary Key Constraint not being supported
by Lakeview MIMIX product
The product is just running so efficiently on our AS/400's that it is grabbing a
new table creates too quickly before the constraint is applied
Just thought I would inform the group
Thanks
Doreen
> -----Original Message-----
> From: Anderson, Doreen
> Sent: Friday, September 28, 2001 12:50 PM
> To: 'SAP AS/400 Discussion Group'
> Subject: New Tables - Is Primary Key Constraint added immediately or in 2nd
step on table creates
>
>
>
> Does anyone know what happens under the covers (at the iSeries Operating
System) when transporting a change request which creates a new table?
>
> Does the table get built with its PRIMARY KEY CONSTRAINT all in ONE step?
>
> We are running Lakeview MIMIX HA & every NEW table (eg A718; A719; B556 etc.)
> gets created on the replicated system BUT WITHOUT IT's PRIMARY KEY CONSTRAINT
& therefore my 2 DB's get out of sync! (every few days)
>
> According to Lakeview Support; if the PRIMARY KEY CONSTRAINT is built in a
second step; THEY DON'T SUPPORT IT
>
> Running V4R5 with 4.6C
>
> Frustrated
> Doreen
>
>
Durban Tours - Südafrika Safari
SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up BAL_S_LOG - Application Log: Log header data
This documentation is copyright by SAP AG.
Length: 1817 Date: 20240427 Time: 071858 sap01-206 ( 3 ms )
