CA IDMS

Expand all | Collapse all

Schemaplus Fisrt time Load

Jump to Best Answer
  • 1.  Schemaplus Fisrt time Load

    Posted 06-01-2017 05:24 AM

    Hi,

    I need to install schema plus for DB view and DB draw -  In my project there are already more than 200 records exists. If I want to install Schema plus for both DB view and Draw, How I will load all the existing records in to the schema plus?
    By using IDMSRPTS, whether we will be able to do ? - If yes, Then what will be the procedure to do it?

     

    Thanks,
    Vaasu ( Chennai, India) 



  • 2.  Re: Schemaplus Fisrt time Load
    Best Answer

    Posted 06-01-2017 11:15 AM

    I am not positive what you are asking, but yes run a IDMSRPTS

     

    We use these options:

     

    //SYSLST   DD DISP=(NEW,CATLG),                          

    //           DSN=IDMS.SHPLUS.&SYSTEM..&VERSION..GLBLCHEM,

    //           RECFM=FB,LRECL=133,                        

    //           SPACE=(133,(30000,3000),RLSE)              

    //SYSIDMS DD *                                          

    LOCAL=ON                                                

    //SYSIPT   DD *                                          

      SCHEMA=(GLBLCHEM) VERSION=(2)                          

      RECDES SETDES                                          

    /*                                                      

     

    Then down load the file to your PC or a shared network drive as a .txt

     

    cd 'grps/shared/idms/Schema Plus/Help and Diagram Files'  
    dir                                                       
    put 'IDMS.SHPLUS.ECL.TEST.GLBLCHEM' 'ECL TEST GLBLCHEM.txt'

    quit

     

     

    Then you can select the file from DRAW.

     Ie

     

    Click on File, then Open Schema Report

     

    Select & Open the environment you want

     

    Click the green Plus button;

     

    Enter name you want to call this diagram

    Now you can drag and drop:

    Good Luck :D



  • 3.  Re: Schemaplus Fisrt time Load

    Posted 06-02-2017 01:33 AM

    Hi Mike

     

    Thanks a lot for a detailed explanation.

     

    Regards,

    Vaasu



  • 4.  Re: Schemaplus Fisrt time Load

    Posted 06-02-2017 10:26 AM

    I am not positive what you are asking, but yes run a IDMSRPTS and down load it your PC or a shared drive as a .txt

     

    We use these options:

     

    //SYSIPT   DD *

      SCHEMA=(GLBLCHEM) VERSION=(2)

      RECDES SETDES

    /*

     

    Then you can select the file from DRAW.

     

    Ie

     

    Or to create You can use x:\shared\idms\schemaplus double click on SHdbDraw.exe

     

     

    Click on File, then Open Schema Report

     

     

    Select & Open the environment you want:  ie CAS or ECL,  test, qual, or prod.

     

    Click the green Plus button;

     

    Enter name you want to call this diagram

    Now you can drag and drop:

    Good Luck