1
0
-1

Someone can help with this situation:

I need to make a "Load definition" from Oracle to my Uniface repository.

The connection to ORACLE in the .asn file is: $ORA ORA:DBORACLE|USER|PASS

Donde: Base de Datos -> DBORACLE, User -> USER, Password -> PASS

The ORACLE Database has 2 Schemas with entities in each of them:

Schema_1

    Entity_a_schema_1

    Entity_a_schema_2

    Entity_a_schema_3

    Entity_a_schema_4

Schema_2

    Entity_b_schema_1

    Entity_b_schema_2

    Entity_b_schema_3

    Entity_b_schema_4

At the time of running the "Load Definition" does not present any entities.

What should I do in Uniface o Oracle to see al the entities?

Like this:

Entity_a_schema_1

Entity_a_schema_2

Entity_a_schema_3

Entity_a_schema_4

Entity_b_schema_1

Entity_b_schema_2

Entity_b_schema_3

Entity_b_schema_4


IN SPANISH:


Alguien podrá ayudar con esta situación:

Necesito hacer un “Load definition” desde Oracle a mi repositorio en Uniface.

La conexión a ORACLE en el archivo .asn  es:  $ORA     ORA:DBORACLE|USER|PASS

Donde: Base de Datos -> DBORACLE, User -> USER, Password -> PASS

La Base de Datos de ORACLE tiene 2 Schemas con entidades en cada una de ellas:

Schema_1

    Entidad_a_schema_1

    Entidad_a_schema_2

    Entidad_a_schema_3

    Entidad_a_schema_4

Schema_2

    Entidad_b_schema_1

    Entidad_b_schema_2

    Entidad_b_schema_3

    Entidad_b_schema_4

Al momento de ejecutar el “Load Definition” no presenta ninguna entidad.

Que debo hacer en Uniface u ORACLE para que presente todas las entidades?

Así:

    Entidad_a_schema_1

    Entidad_a_schema_2

    Entidad_a_schema_3

    Entidad_a_schema_4

    Entidad_b_schema_1

    Entidad_b_schema_2

    Entidad_b_schema_3

    Entidad_b_schema_4


Thanks

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      Hi Pedro,

      you have to connect UNIFACE to the owner schema of the tables .

      A first time with :

      $ORA ORA:DBORACLE|USER_SCHEMA1|PASS

      A second time with :

      $ORA ORA:DBORACLE|USER_SCHEMA2|PASS

      Ok work with differents asn files.

      Regards,

      Gilles

        CommentAdd your comment...
      1.  
        1
        0
        -1

        In Uniface Nine for load definitions you must use the connector option u4_compatibility because Oracle system tables still use LONG datatype. 

        Also you need

        [ENTITIES]
        USER_TABLES.ORA6 = UNIFACE_TABLES.*

        You can load in a separate environment  for example with SEQ for repository,

        correct definitions where needed export the result to the real development.


        For example a load.asn like this

        [SETTINGS]
        $enhanced_edit all
        $putmess_logfile load.log

        [FILES]
        usys:idf.aps usysuniface:components\idf.aps

        usys:uu*.frm usysuniface:components\uu*.frm
        usys:uu*.svc usysuniface:components\uu*.svc

        common:uu*.frm usys:..\components\uu*.frm
        common:uu*.svc usys:..\components\uu*.svc
        common:ur*.svc usys:..\components\ur*.svc


        usys:*.xml usysuniface:misc\*.xml

        [PATHS]
        $SEQ SEQ
        $ORA ORA:?|?|?
        $REP $SEQ
        $SYS $REP
        $UUU $REP
        $IDF $REP
        $DEF $ORA

        [DRIVER_SETTINGS]
        SEQ=U1.0
        ORA=U7.2
        usys$ora_params u4_compatibility , dpa

        [ENTITIES]
        *.dict .\repos\*.*
        *.sysenv .\repos\*.*
        *.printer .\repos\*.*
        *.state .\repos\*.*
        *.u .\repos\*.*
        USER_TABLES.ORA6 = UNIFACE_TABLES.*


          CommentAdd your comment...