/*********************************************************************
* Copyright (C) 2000 by Progress Software Corporation ("PSC"),       *
* 14 Oak Park, Bedford, MA 01730, and other contributors as listed   *
* below.  All Rights Reserved.                                       *
*                                                                    *
* The Initial Developer of the Original Code is PSC.  The Original   *
* Code is Progress IDE code released to open source December 1, 2000.*
*                                                                    *
* The contents of this file are subject to the Possenet Public       *
* License Version 1.0 (the "License"); you may not use this file     *
* except in compliance with the License.  A copy of the License is   *
* available as of the date of this notice at                         *
* http://www.possenet.org/license.html                               *
*                                                                    *
* Software distributed under the License is distributed on an "AS IS"*
* basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. You*
* should refer to the License for the specific language governing    *
* rights and limitations under the License.                          *
*                                                                    *
* Contributors:                                                      *
*                                                                    *
*********************************************************************/

/*--------------------------------------------------------------------

file: prodict/ora/_ora_md0.p

Description:
    creates empty SI, creates SQL and ev. dumps the data from the
    PROGRESS source-db

Input:
    none

Output:
    nnoe

Changed/Used Shared Objects:
    s_xxx       ...

History:
    hutegger    94/05/12    stripped ".sql" from user_env[2], now
                            assigned in _wrktgen.p

    mcmann      97/12/29    Removed reference to oracle 6

--------------------------------------------------------------------*/
/*h-*/

{ prodict/dictvar.i NEW}
{ prodict/user/uservar.i }
{ prodict/ora/oravar.i }

/*----------------------- INTERNAL PROCEDURES ----------------------*/
/*---------------------------- TRIGGERS ----------------------------*/
/*------------------------- INITIALIZATIONS ------------------------*/
/*--------------------------- MAIN-BLOCK ---------------------------*/

FIND FIRST _DB
  WHERE _Db._Db-type = "ORACLE"
  NO-ERROR.
IF NOT AVAILABLE _Db
 THEN FIND FIRST _Db WHERE _Db-local.

ASSIGN
  drec_db      = RECID(_Db)
  ora_codepage = ( if   ora_codepage <> ""
                    then ora_codepage
                    else _Db._Db-xl-name
                 )
  user_env[11] = "varchar2"
  .
 
/*------------------------------------------------------------------*/

IF SESSION:BATCH-MODE and logfile_open
 THEN PUT STREAM logfile UNFORMATTED
        " " skip
        "-- ++ " skip
        "-- Creating SQL to create database objects " skip
        "-- -- " skip(2).

RUN "prodict/misc/_wrktgen.p".

IF SESSION:BATCH-MODE 
 and NOT logfile_open
 THEN DO:
  OUTPUT STREAM logfile TO VALUE(user_env[2] + ".log")
         APPEND UNBUFFERED NO-MAP NO-ECHO.
  logfile_open = true.
  END.

/*------------------------------------------------------------------*/

IF movedata
 THEN DO:  /* dump data */
  /* dump the data in Progress format */
  OUTPUT TO dump.tmp NO-ECHO NO-MAP.

  IF SESSION:BATCH-MODE and logfile_open
   THEN PUT STREAM logfile UNFORMATTED
          " " skip
          "-- ++ " skip
          "-- Dumping data " skip
          "-- -- " skip(2).


  RUN "prodict/dump_d.p" ("ALL","","").
  OUTPUT CLOSE.

  END.     /* dump data */


/*------------------------------------------------------------------*/