


         III  CRT
        --------------

      III  冷 ਬ ⨫ CRT  -
। ࠪ⨪ ᯫ ନ,  ᯮ㥬  ஬
࠭ த⮢  ORACLE.    ⨫ CRT  
⠪ ந ன ࠭ ᯫ  ⮡ࠦ  ண-
ࠬ 㭪樨   ନ.
     ᠭ ᭮ ਭ樯 ࠡ  ⥩ -
 CRT,   8 ᬠਢ ᫥騥 :
    * த, ᯮ騥 । CRT
    * ନ, ন ⨫⮩ CRT
    * ⠡ , ᯮ㥬 ⨫⮩
    * 冷   ८। ࠪ⨪ ନ
    *  ⨫ CRT


     8      CRT
    

    ⨫ CRT ᮧ  ८। ᠭ ࠪ⨪
ନ, ᯮ㥬 ࠧ묨 த⠬ ORACLE. ࠪ-
⨪ ନ ᯮ  襭 ᫥ :
    *   ᮢ㯭  ணࠬ  㭪権  
      ନ, ᯮ  㭪樨. , ਬ, 㭪樨
      "३   ᫥饬  "  " ᯨ᮪ ⨬
      祭"  믮   㭪樮  F1  F2.
    * । ࠧ⥫ ⥩ ନ  (-
       ࠦ, 뤥 梥⮬  મ, ન-
      ), ᯮ㥬 ࠭묨 த⠬ ORACLE.
    * ன ࠦ  ࠧ ࠭ த.

    ᯮ짮 । ࠪ⨪ ன ⮡ࠦ
ଠ樨, । ࠧ묨 ⠢騪,   -
⠬ ௮樨 ORACLE  ⭮⥫쭮 ᨬ묨   -
. 㣨 ᫮,  த   ன⢠ ⮡-
 ଠ樨 㭪樮 .

      樮 । 㭪樮஢  ORACLE -
⠥  ନ, ⠭ ( 㬮砭) । -
ࠪ⨪  ଫ   CRT-䠩.     
८।  ࠪ⨪    ⨫ CRT.
    ௮ Oracle ⠢ ⢮ ⠭  ।-
 ࠪ⨪  ࠧ ନ     ਤ
  ⠢.  ,  ਬ,   ⠢ CRT-䠩 室
IBM3270.CRT, VT220.CRT  D410.CRT.    䠩 ᮤঠ -
  ନ ⨯ 3270, VT220  D410, ᮮ⢥⢥. -
祭 ନ,     ⠭ । -
ࠪ⨪, ।⠢  ਫ E.
    ᫨  祭  㤮⢮, 饭  ⨫ CRT
 ॡ.
    , ᫨    ᮧ । ࠪ⨪ 
 ନ  ८। 騥 ࠪ⨪,  
   ⨫ CRT     ᮮ⢥-
 ଠ, ࠭  ,  ᮧ  CRT-䠩.




                                    -- 87 --



      䠩 CRT
    -------------------
    । ࠪ⨪  ନ  ࠭   ORACLE 
⠡ CRT ਡ⥫쭮  ᫥饬 ଠ:

ணࠬ ORACLE    ନ       ணࠬ 㭪

SQL*Forms IAP      VT100           7 (᫮)  饥 
SQL*Forms IAP      IBM3270         ENTER      饥 

    ࢠ ப ।⠢ ᪮ ⠡  
⮬,  ᫨  ࠡ⠥  ⨫⮩ IAP, 室饩  ⠢ -
 SQL*Forms,  ନ DEC VT100,   室  ᫥-
饬   ࠭   ᯮ짮 ,   ।-
祭     ᫠ 7.  筠 㭪  ନ IBM
3270 믮    ENTER.
    ଠ, ।⠢  ࢮ ப,   -
  䠩   VT100.CRT.  ᫨ ⨯  ନ  ᮢ  
 CRT-䠩,     砥,     䠩 ᮤন
ᠭ ନ.

    । ନ ࠭  ᫮  ORACLE ( ⠡-
 CRT),  ⮬ CRT-䠩,  ᯮ짮  
ࠡ ࠧ ணࠬ த⮢ ORACLE,     
᪮  㪠 ⠡.
    ⨫ CRT ন ᪮쪮 ⠡  (ਬ,  ⠡-
 FUNCTIONS  CRT_PRODUCTS),  ࠭ ଠ,  
ନ. 짮⥫  ४஢  ଠ, -
⨢   ⠡栬  騬 ࠧ.     ⠡
⨫ CRT  CRT-䠩.

    த ORACLE, ᯮ騥 । CRT
    ---------------------------------------------
     CRT-䠩      ᢮  ࠡ  ᫥騥
࠭ ணࠬ த ORACLE  ।⢠ :
    * SQL*Forms
    * SQL*Calc
    * SQL*Menu
    * SQL*QMX
    * SQL*DBA
    ਬ砭: ᬮ  ,  த Easy*SQL ⮦ 頥
 ⨫ CRT,    ᯮ   । 㭪権 .

    ନ, ন ⨫⮩ CRT
    --------------------------------------
⨫ CRT ন  ᫥ ⨯ ன ⮡ࠦ ଠ樨:

    ஭ ନ

    ஭ ன⢠ (⠪  IBM 3270) ।  -
  ࠭.   ⠪   ன⢠, ࠡ-
騥  筮 ०.  ᫥⢨ ⮣ ᨭ஭  ନ  
㦤   ।⢠ ᨬ쭮 ࠡ⪨,  ᬠਢ 
᫥饬 ࠧ.

    ᨭ஭ ନ



                                    -- 88 --



    ᨭ஭ ன⢠ (⠪  DEC VT100) ।  -
  ᨬ쭮.
    ᨭ஭ ନ    ﭨ 믮  ᫥-
騥 :
    * ।    ᨬ       
    * ᯮ짮  ᨬ, "த"   樮-
       ⥬ (ASCII  EBCDIC)
    * ६       ࠭ ᨬ
    * ६     ࠢ  ࠭  ᨬ
    * 樮஢   㦭 ப  ⮫
    * ࠡ뢠   ⥬  ᪮  祭  -
       (  ⮪ ࠢ ⮪ ⨯ X-ON/X-OFF)
    *     ࠭   ⠭   
      孥 㣫
    ࠪ⨪ ନ  ⠭ ⠪, ⮡:
    * ᫨ ࠪ⨪ ⠭,  ன⢮ ⮡ࠦ  
      室    ᯮ짮 ⮩ ࠪ⨪  
      ,  ࠪ⨪  㤥 ⠭  襭
    * ⠭   ࠪ⨪    﫨   
    * ⠭   ࠪ⨪  ࠦ   ᮤ-
       樨 뢮  ࠭ 

    祭 ࠪ⨪  㬮砭
    -----------------------------------

     ਡ⨢  ORACLE   樮  ।
砥  ᥡ ᮮ⢥騥 । 祭 ࠪ⨪ -
  㬮砭.   祭,  筮 ᮤঠ騥   䠩
DEFAULT.CRT, । 㭪樨  ନ,  ᯮ-
 樮 ।.
    ਬ,   ਡ⨢   । IBM VM/SP ᮤ-
 䠩 DEFAULT.CRT ᮢ  ᮤন 䠩 IBM3270.CRT,
   ਡ⨢      ।  DEC VMS ᮤন 䠩
DEFAULT.CRT ᮢ  ᮤন 䠩 VT100.CRT.
     設⢥  ணࠬ  ORACLE  । ᯮ짮
祭 ࠪ⨪  㬮砭.  ᫨   ᯮ짮
㣨 祭,  ⫨  祭  㬮砭,   ᪥
ணࠬ  ਤ 㪠뢠 ⨯ ନ ᯮᮡ, ᠭ
 ணࠬ 㬥樨.

     ⠡, ᯮ㥬 ⨫⮩ CRT
    ------------------------------------------
      ORACLE,  騩  SYSTEM,    -
楬 ᪮쪨 ⠡ , ᯮ㥬 ⨫⮩ CRT. ᫨ 
ᯮ짮 ⨫ CRT  室,     ⠡
   㦥  ஬.      ⪮
ࠪਧ, ஡       ᫥-
 ࠧ.

CRT             , 뢠 ᪮쪮   ࠪ-
                ⨪ ନ.

CRTBOX          , 뢠 ᪨ ᨬ, ᯮ-
                㥬 ନ  ନ஢ ࠬ  ࠭.

CRT_PRODUCTS    ,  ᮤঠ   ணࠬ த⮢,
                ᯮ । CRT.


                                    -- 89 --



CRT_TYPE        ,  ᮤঠ    ன ⮡ࠦ
                ଠ樨  ⨯ ன (ᨭ஭    ᨭ஭).

ESC             , ।祭   樨 ।-
                 ࠪ⨪ ନ  ᫥饬 ଠ:
                -  ணࠬ த,
                -  ନ,
                -  ନ,
                - ணࠬ 㭪 ORACLE.
                   ᭮ ⠡ ⨫ CRT.

FUNCTIONS       ,  ᮤঠ    ࠭ 㭪権 -
                ࠬ த⮢.

GOTO_LC         , ॢ   ଠ  "ப-⮫" 
                न   ᫥  न  
                । ன ⮡ࠦ ଠ樨,  
                न    ᫥.

     CRT 筮 ᮧ   ᫥  蠣  ⠫樨
 ORACLE.       樮  ⥬  䠩  
CRTINS.SQL ᯮ  室  ⥬      SYSTEM,
ᮧ   㧪  ⠡.   ஡  ⠫樨 㪠
⠡ .   㪮⢥ "Installation and User's Guide"  -
襩 樮 ⥬.
       ,  䠩 CRTINS ।⠢ 
⠡栬 CRT  ⮫쪮 짮⥫   SYSTEM.  ᫨  
⠡栬 CRT ॡ 㣨 짮⥫   ORACLE  (-
,   ⠢  ४஢ ப  樨 ࠨ-
 । ନ), ࠢ ⠪ 㯠   -
⠢ ⮫쪮 짮⥫ SYSTEM    ଥ.

    襭  祭

     ᫥  ࠧ   ᬮ७ ⤥  
㤥 짮 ᫥騬 祭ﬨ:
          祭

\nnn            쬨筮 ᫮
\e              ᨬ 砫 ࠢ饩 ᫥⥫쭮  (ESC)
\x              न ப
\y              न ⮫
\t              न 孥 ப
\b              न  ப


     CRT

     ப  ⠡  SYSTEM.CRT  뢠  ࠪ⨪
ନ쭮 ன⢠ । ⨯.  ப -
뢠 冷 ᯮ짮 ࠭묨 த⠬ ⠪  -
ࠪ⨪ ନ,  뤥 梥⮬  મ  -
 ࠦ.
    ଠ, 砥     ⠡,  筮 롨ࠥ 
㪮⢠ ணࠬ  㬥樨,  뢠饩  ਭ
 ନ esc-᫥⥫쭮.
    ਬ砭:   SYSTEM.CRT   ᨬ      த⮢
Oracle. 㣨 ᫮,    ⮫, 易 -

                                    -- 90 --



ࠧ  த⮬, ⮬ ࠪ⨪  騩  
 ନ ।.
    ३  ᬮ७ ⮫殢 ⠡. ।, 
          esc-᫥-
⥫쭮⥩   ⥪饣  .

NAME         ⨯ ன⢠, ࠪ㥬  ⢥  室
            㧫   CRT-䠩.     ᮮ⢥⢮
            ॡ, ।塞    䠩  襩 樮
            ⥬.

TYPE          ⠡ CRT_TYPE, 騩 ⨯ ன⢠:
            CHAR  = ᨭ஭ ன⢠
            BLOCK = ᨭ஭ ன⢠, ஬ ⨯ 3270
            3270  = ᨭ஭ ன⢠ ⨯ 3270

OFFSET      , ᯮ㥬  祭 न , 筮 ᫮
            祭, 塞    ப  ⮫  楫
            ८ࠧ ᫥   ᨬ.   祭 筮 ࠢ
            31 ( 筮 ⥬)   \037. 㫥 - 祭  
            ⮬,  न   ।⠢ ப ᨬ.

BASE         ࢮ ப ନ, 筮 1  0.

LC_TABLE    , ᢮ ନ  ⠡ GOTO_LC. -
               ⠡  GOTO_LC ᮮ⢥ ப -
            , 祭 ⮫  㤥 ।.

LINES       ⢮ ப  ࠭ ନ.
COLUMNS     ⢮ ᨬ   ப ନ.
MSGL         ப ᮮ饭.
MODL         ப ﭨ.

CLEARSCREEN , ᯮ㥬  ⪨ ࠭ ନ-
               宦      孥 㣫 ࠭.

BACKSPACE   , ᯮ㥬  ६饭     
            .  祭   ࠢ騩 ᨬ  
            㤠.     設⢠ ᨭ஭ ன - \008.

FORESPACE   , ᯮ㥬  ६饭     
            ࠢ. 祭   ࠢ- 騩 ᨬ  த
            ।   㤠.  ஡  ᪠.

GOTO_LC     ,  ᯮ㥬   ६饭   㪠 
            ଠ "ப/⮫" . ࠢ ᫥⥫쭮
            "\y"   ᯮ   न ப,
            "\x" -  㪠 न ⮫.
            (᫥⥫쭮 "\y"  "\x"  ᯮ짮 ⮫쪮  ⮬
            ;  㣨      ᫠.)
            , ਬ, ᫨  ⠥ :
            "esc", 窠  ⮩,  न ப, -
            , न ⮫, "H",
            뢠  ᫥騬 ࠧ:
            \e;\y,\xH

CLEARLINE   ,  ᯮ㥬    ⪨ ᥩ ⥪饩 ப,
            ᨬ  ⮣,   樨 ப 室 .

                                    -- 91 --



TSET        , ।祭  樠樨 ନ ।
            ᯮ짮.  ࢮ  , 뫠  ⨫⠬
            ,  ᯮ騬 ࠪ⨪ CRT.  , ਬ, ⨫
            SQL*Forms   ⠭ ࠪ⨪ ନ (
            ⠭  祭  TRSET).

TRSET       ,  ।祭   ⠭ ࠪ⨪
            ନ ᫥ ᯮ짮.   ᫥  ,
            뫠  ⨫⠬ , ᯮ騬 ࠪ⨪ CRT. ,
            ਬ, ⨫  SQL*Forms    ⠭
            ࢮ砫 祭 ⠭ ࠪ⨪ ନ
            (  TSET).

ATT1        ,  ਡ ࠦ 1 (筮 
            ࠦ). ᯮ ⨫⮩ SQL* Forms  ࠡ  ﬨ,
            㯭묨  .  ⨫⮩ SQL*Calc  ᯮ.

ATT2        ,  ਡ ࠦ 2 (筮 ન).
            ᯮ  ⨫⮩  SQL*Forms  ࠡ  祭ﬨ,
            ⮡ࠦ묨  ࠭ ᪠. ⨫⮩ SQL*Calc 
            ᯮ.

ATT1_2      ,    ਡ ࠦ 1  2.  ᯮ
            ⨫⮩ SQL*Forms  ப  ᮮ饭.
            ⨫⮩ SQL*Calc  ᯮ.

ATTOFF      Esc - ᫥⥫쭮,  ਤ ࠦ  ࠭ , 
            ᫥ ⪨ ࠭.

WINDOW      , ᮧ  ⢠ ப  ࠭  ᬮ
             (஫).  न 孥   ப  
             ᫥⥫쭮ﬨ "\t"  "\b".  (᫥⥫쭮 "\t"
             "\b"  ᯮ짮 ⮫쪮  ⮬ ;   㣨  
               ᫠.) , ਬ, ᫨  ⠥
            :  "esc",  ७,  孥 ப, , 
             ப, 뢠  ᫥騬 ࠧ:  \e-\t,\b

SCRUP        ப⪨ (६饭) ࠦ   ࠭  
            ப .

SCRDN        ப⪨ (६饭) ࠦ   ࠭  
            ப .

GRAPHON     ,  ⠢ ன⢮ ⮡ࠦ ଠ樨
            ஢  ᨬ      ⮪ 
            ᪨.  ᫨  ன⢮  ࠡ뢠 ᪨
            ࠦ,   ᮤন ⮥ 祭.

GRAPHOFF    ,  ⠢ ன⢮ ⮡ࠦ ଠ樨
            ஢  ᪨     ⮪ 
            ᨬ. ᫨ ன⢮  ࠡ뢠 ᪨
            ࠦ,     ᮤন ⮥ 祭.

PROTON      ,   ࠭.

PROTOFF     , 몫  ࠭.



                                    -- 92 --



CLEAREOL    ,    ப  ⥪饩 -
            樨     ப.

CURSORUP     ६饭     .

CURSORDOWN   ६饭     .

TOP2X       ,  ⭮襭  ⥪饩 ப  㢥稢 ࠧ
            ᨬ  ⨢ ,   ਧ⠫, ⠪  
            ⨪.   ⮩  ᨬ  ࠦ ਮ
            㤢 ਭ      㤢 .
             TOP2X  ᯮ짮    BOTTOM2X.

BOTTOM2X    ,    ⭮襭    ⥪饩 ப  㢥稢
            ࠧ ᨬ  ⨢ ,   ਧ⠫,  ⠪  
            ⨪.   ⮩  ᨬ  ࠦ ਮ
            㤢 ਭ       㤢
            .   BOTTOM2X   ᯮ짮  
             TOP2X.

ATT3        ,  ⥫ ࠪ⨪ ࠦ,
            ਬ, 㦨   뤥-  મ    梥⮬.
            ᯮ ⨫⮩ SQL*Forms  饭 . ⨫⮩
            SQL*Calc  ᯮ.

ATT1_3      ,  ⥫ ࠪ⨪ ࠦ,
            ਬ, 㦨   뤥 મ    梥⮬.
            ᯮ ⨫⮩ SQL*Forms  ,   襤 ஢.
            ⨫⮩ SQL*Calc  ᯮ.

ATT2_3      ,  ⥫ ࠪ⨪ ࠦ,
            ਬ, 㦨   뤥 મ    梥⮬.
            ᯮ ⨫⮩ SQL*Forms   ⥪饣   ६
            ஥ . ⨫⮩ SQL*Calc  ᯮ.

ATT1_2_3    ,  ⥫ ࠪ⨪ ࠦ,
            ਬ, 㦨   뤥 મ    梥⮬.
            ᯮ ⨫⮩ SQL*Forms  ६ ஥    
            롮 ⮢  襩  <Select>.   ⨫⮩ SQL*Calc 
            ᯮ.

ATT_BOLD    ,   㦨   뤥 
            મ (梥⮬). ᯮ ⨫⠬ SQL*Calc  SQL*Menu,
            ⨫⮩ SQL*Forms  ᯮ.

ATT_FLASH   ࠢ ᫥⥫쭮,  栨 ࠦ.
            ᯮ ⨫⮩ SQL*Calc, ⨫⮩ SQL*Forms  ᯮ.

ATT_REVRS   ࠢ ᫥⥫쭮,   ࠦ.
            ᯮ ⨫⮩ SQL*Calc, ⨫⮩ SQL*Forms  ᯮ.

ATT_UNDER   ࠢ  ᫥⥫쭮,   ન.
            ᯮ ⨫⮩ SQL*Calc,  ⨫⮩ SQL*Forms 
            ᯮ.

     浪    祭   ਡ⮢ (⠪  ATT1
 ATT2_3) । ᫥騥 ॡ:
    1. । 뫪  ନ 祭  ,  -

                                    -- 93 --



       ண 稭  ATT...  ( ᪫祭 ATTOFF), 뫠-
        esc-᫥⥫쭮  ATTOFF.    ࠧ,  
       뫪 ࠢ饩 ᫥⥫쭮,  饩 ਡ
       ନ,   ⮫쪮  ᨬ,   ॡ
         ᠬ ਡ,  ᫮,   ਡ
       㦥 ।⥫쭮  뫨 ⠭.  (몫 ਡ
        易⥫쭮,    ॡ ⮫쪮 祭  -
       ਡ⮢,   .)

    2.    ᫥⥫쭮   ਡ⮢  "-
       ᨨ", "栭",   "ન"  "㦨୮ "
        뫠  ନ , ।⢥ ᫥
       esc-᫥⥫쭮 ATTOFF.   ᫥묨 -
       ⠬   ⭮襭 設⢠ ,     ⮣,
          痢.    ⠭ ⨯ ATTx
       䠪᪨ ᯮ  祭   ࠪ-
       ⨪ ࠦ,  - ७ 裡  㣨
       ࠪ⨪.

       , ਬ,   ATT2_3   樥  
        ATT2   ATT3.   த ORACLE,  ࠡ騩 
       ࠪ⨪ CRT,   ᯮ     ਡ⮢
       ᢮ ࠢ騥 ᫥⥫쭮. ⨫ SQL*Forms -
        ⮫쪮   , 稢騬 ன
       (ਬ, ATT_1),     ६    ⨫  SQL*Calc  
       SQL*Menu ᯮ  ⮫쪮         
       (ਬ, ATT_BOLD).

    ਬ砭:   㪮⢥   冷  
ਡ⮢, ண  ⨫  ORACLE  ਤন   饥
६,   ६,  ⭮,  冷 . -
⥫     㦡  ᮯ஢  த⮢
௮樨 Oracle.

     CRTBOX
    ---------------
     ப ⮩ ⠡ 뢠     ন
⨯ ନ.     ⮫ 뢠 ᨬ,  ᯮ㥬
 ନ  ⮡ࠦ । ᪮ .
     ⮫ ।   ᨬ,     ᪫祭
⮫ CRTNAME. ३   ᬮ७:

CRTNAME           ନ쭮 ன⢠,  ।⠢  ⠡ CRT.

CMODE           ਧ ᪮ ०. ᫨ ᮤন 祭 "Y" (),
                ⨫ SQL*Forms ᯮ ਢ ᨬ 
                뢮    ࠭     䠩.

 뢮  ࠭ ன⢠ ⮡ࠦ ଠ樨:

BOX_BV          ⨪쭠  אַ㣮쭮 ࠬ.
BOX_BH          ਧ⠫쭠  אַ㣮쭮 ࠬ.
BOX_CUL          孨 㣮 אַ㣮쭮 ࠬ.
BOX_CUR         ࠢ 孨 㣮 אַ㣮쭮 ࠬ.
BOX_CBL           㣮 אַ㣮쭮 ࠬ.
BOX_CBR         ࠢ  㣮 אַ㣮쭮 ࠬ.
BOX_TL          ஭  (㯥४).
BOX_TR          ࠢ஭  (㯥४).

                                    -- 94 --



BOX_TU          ⨪쭮-饥 㯥४.
BOX_TB          ஢ 㯥४ (ॢ⮥ ).
BOX_X           ४ אַ㣮쭮 ࠬ.

 뢮  䠩, ।祭  :

PRT_BV          ⨪쭠  אַ㣮쭮 ࠬ.
PRT_BH          ਧ⠫쭠  אַ㣮쭮 ࠬ.
PRT_CUL          孨 㣮 אַ㣮쭮 ࠬ.
PRT_CUR         ࠢ 孨 㣮 אַ㣮쭮 ࠬ.
PRT_CBL           㣮 אַ㣮쭮 ࠬ.
PRT_CBR         ࠢ  㣮 אַ㣮쭮 ࠬ.
PRT_TL          ஭  (㯥४).
PRT_TR          ࠢ஭  (㯥४).
PRT_TU          ⨪쭮-饥 㯥४.
PRT_TB          ஢ 㯥४ (ॢ⮥ ).
PRT_X           ४ אַ㣮쭮 ࠬ.

     CRT_PRODUCTS

     ⮩ ⠡ ᮤঠ  ணࠬ த⮢, ᯮ-
 । CRT. ⮫ ⠡:

PROD_CODE        த ( 6 ᨬ). ᯮ  ⠡ ESC 
                FUNCTIONS.

PROD_NAME        த,  ᯮ饣 । CRT. 
                ᮤন ப, 뢠騥 ⨫ SQL*Forms,  SQL*Calc,
                SQL*Menu  SQL*QMX. ᬮ  ,   த Easy*SQL  ⮦
                頥   ⨫ CRT,    ᯮ   ।
                㭪権   ⨬   ⢨ ப 
                ⮬ த  ⠡ CRT_PRODUCTS.

     CRT_TYPE

     ⮩   ⠡  뢠  ⨯  ନ쭮  ன⢠ (ᨭ஭,
ᨭ஭). 室  ४஢ ᮤন ⮩  ⠡  筮
 ;  ᯮ ⮫쪮  ஫ ࠢ쭮 ,
ᮤঠ    ⠡  CRT.  ⮫ ⠡:

NUM             ᫥ ,  ਭ騩  ᫥騥 祭:
                1 = ᨭ஭ ன⢠
                2 = ᨭ஭ ன⢠, ஬ ⨯ 3270
                3 = ᨭ஭ ன⢠ ⨯ 3270

TYPE            , ᯮ㥬  䨪樨 ⨯  (० ࠡ)
                ன⢠.

DESCRIPTION     ⮢ ᠭ ⨯ ன⢠.

     ESC

     ⮩ ⠡   ନ ⢮ ᪮쪮  ப,
      ⠭ ᮮ⢥⢨   
த⮢ ORACLE,    ஭,   ନ, 襩 
ணࠬ 㭪樥,  㣮. ⮫ ⠡:



                                    -- 95 --



PROD_CODE  ,  ᢮ த ORACLE,  ᯮ饬 ।
           CRT (ᮮ⢥ , 㪠  ⠡ CRT_PRODUCTS).

NAME        ନ, ᮮ⢥騩 , 㪠  ⠡ CRT.

FUNC        㭪樨 ନ, ᮮ⢥騩 , 㪠  ⠡
           FUNCTIONS.

ESCSEQ     ᫥⥫쭮 ᨬ,  㥬 ନ  ⨨
           㪠 㭪樮쭮 .  ᫥⥫쭮  
           "\nnn",   nnn - 쬨筮 ᫮   .  ⮡ 
           ⠭  筮 ଠ樮 ,  ᫥⥫쭮
            稭  ᨬ,  㥬    .
            ,  ᨬ   ।⠢,
           ⮡ࠦ  ࠭,     饬 ன⢥. ,
           ਬ,  ନ VT100 ᨬ "control-Z" ।⠢
           ᫥⥫쭮 "\032",  ᨬ "escape"  - ᫥⥫쭮
           "\e". 砢 ᫥⥫쭮 ᨬ "*",    ᤥ  
           ⢨⥫쭮    ॣ .

COMMENTS   ᠭ  㭪樮쭮  , ⮡ࠦ  ࠭ .

     FUNCTIONS

     ⠡ ᮤন 祭 ࠭ த⮢ ORACLE,
⠪  SQL*Forms  SQL*Menu,   ⠭  ࠭묨 㭪-
, 室묨   ࠡ.
    ਬ砭:    ⮩ ⠡ ந  ᫥,
  㪠 த⮢ ⠭ ।᪠㥬.
    ⮫ ⠡:

PROD_CODE       3 ᨬ, ᮮ⢥騩 ࠭
              ணࠬ த,  ᯮ饬 ࠪ-
              ⨪ CRT.    ᯮ஢  -
                ⠡ CRT_PRODUCTS.

FUNCN         , ᢮ 樨 "㭪-த".

FUNC           㭪樨 (2 ᨬ).    ᯮ  ⠡ ESC.

FNAME         ᠭ 㭪樨, ਬ:  "६饭  ࠢ".
              祭  㭪権      ᠭ  த⮢ SQL*Calc,
              SQL*Forms  SQL*Menu .   ਫ F.

     GOTO_LC

    ⤥ ନ ᯮ ⠡ GOTO_LC    ॢ
ᮢ ப  ⮫  न .  ᥬ ନ
室   ⮩ ⠡ - ⮫쪮 ⥬,    -
 ப   ⮫殢  ࠧ 뢭  ᫮-
 ᫥⥫쭮 ( ⮬       ᫥  
㬬  ப  ⮫,   ᬥ饭).
    ᫨   ᫥ न  ப,     ⠡
GOTO_LC ᫥    ,  ॢ騥  ப  
न. ᫨   ᫥ न ⮫, -
 㯨  ࠧ    ⠡ , -
ॢ騥  ⮫殢   न. ᫨ ⭠  ,
 㣠 न,  ⠡ GOTO_LC  ᮤঠ ᢥ,

                                    -- 96 --



騥  ।.    ஡ ଠ樥 -
  ࠧ "ᠭ न ".
    ⮫ ⠡:

NAME             ନ,  ᮮ⢥饥 祭
                 NAME  ⠡ CRT.

TYPE             न, 뢠   . -
                ⨬ 祭:
                L = न ப
                C = न ⮫

VALUE            ப  ⮫, न ண -
                    .

ESCSEQ          ᫥⥫쭮 ᨬ,  㯠 न-
                ⮩   㪠 ப  ⮫.

      । ନ ࠪ⨪
    -------------------------------------------------------------
     ()  । ନ ࠪ-
⨪ ந   ᫥ ᯮᮡ:
    *   室  ଠ樥 ᮮ⢥ ࠭  CRT
    * ⠢ ப  ⠡ CRT   ⨫ SQL*Plus.

    ᯮ짮  CRT

       ।   ⨫ SQL*Forms  -
饣 CRT-䠩 砥  ᥡ ᫥騥 蠣:
    1. ᫨ 䠩 CRT.FRM ,  :
       RUNFORM CRT
       ᫨ ᮮ⢥騩 䠩    ᮧ,  ᮧ  :
       IAG CRT -TO
        ᣥ    ⨫ SQL*Forms.   ⥬,
       ᯮ  RUNFORM,     CRT. ଠ CRT
       ⮨   ,       ࠧ頥  
       ࢮ ࠭,   ⠫ -  ன,    
       㭪 8-1  8-2.
    2.         ଥ CRT ᠭﬨ ਡ⮢
       ନ  , ॠ  ਡ.
    3. ࠭    , 멤    ᣥ-
        CRT-䠩,  ⨢ ணࠬ CRT. ⠪ -
        ணࠬ:
       CRT _䠩_CRT [_짮⥫/஫] [-d?]
        䠩      ப  ᮢ  ,
       㪠   ࢮ ࠭  CRT.
         ஡ ଠ樥 ᫥   ࠧ-
        " ணࠬ CRT".

    㭮 8-1        ࢠ ࠭  CRT
Ŀ
                                                                
        Crt Name:             Type: CHAR      
                                                                
Columns: 80  Lines: 24  Mode Line: 24  Message Line: 24  Base: 1
                                                                
Terminal Setup:       Term Reset:         
   Graphics On:     Graphics Off:         

                                    -- 97 --



    Protect On:      Protect Off:         
        2X Top:        2X Bottom:         
                                                                
Clearscreen:   Clear Line:   Clear to EOL: 
Create Window:   Scroll Up:    Scroll Down: 
 C-L Offset:          Goto C-L:        C-L Map: 
                                                                
Cursor Left: \10 Right:     Up:   Down: 
                                                                
Video Bold:  Flash:  Revrs:  Under: 
Attribs Off:     1:      2:      3: 
     1+2+3:    1+2:    2+3:    1+3: 
                                                                
 


    㭮 8-2         ࠭  CRT
Ŀ
          Graphics (Y/N):                    Screen  Printer   
                               Vertical line:                 
                             Horizontal line:                 
  Crt Name                 Upper left corner:                 
             Upper right corner:                 
                           Lower left corner:                 
                          Lower right corner:                 
                                 Left-side T:                 
                                Right-side T:                 
                                   Upright T:                 
                                  Inverted T:                 
                                   Cross (+):                 
                                                                
   Prod  Fn                                                     
   Code  Cd  Function Description    Escape Sequence  Comments  
            
            
            
                                                                
  


    ᯮ짮 ⨫ SQL*Plus

      ।   ⨫ SQL*Plus -
  ᥡ ᫥騥 蠣:
    1. 祭 㯠  ᮢ㯭 ⠡ CRT, ਭ饩
       짮⥫   SYSTEM.
    2. ⠢   ⠡ CRT ப,  뢠饩 騥 ࠪ-
       ⨪ ன⢠.
    3. ⠢  ⠡ ESC ப,  ⠭ ᮮ⢥⢨
        ன ନ  ணࠬ묨 㭪ﬨ  -
       ⮢ ORACLE.
    4. ⠢ ப  ⠡ GOTO_LC, ᫨  樮-
          ன⢠   न,  
       騬 ᫥.
    5.  ணࠬ CRT  ᮧ CRT-䠩,  뢠饣
       ࠪ⨪ ன⢠.

    ᠭ न 

                                    -- 98 --



     , 室  祭 ன ப 
ண ⮫,   ப ᨬ   ᨬ-
,   ண ࠢ 㬬 祭 न  -
ன ⠭. ᫨ न     ࠦ
  㬬  ப (⮫)   ⠭,  ८ࠧ-
 ஢  ப  ⮫殢  ᮮ⢥騥 न ᫥-
 ᯮ짮 묨 ⠡ GOTO_LC.

    ⨥ "न  "    ⠡ GOTO_LC ⭮ 
, ஥ 室 ᮮ ன    樮-
஢    㪠  ப/⮫.   ᫮
    ப ᨬ   ASCII, ⠪  
 (  ࠧ饭   ),    ࠢ⢮ ᮡ⢥
 ப (⮫)    㬬 ⮣    ன
⠭ ᮢᥬ  易⥫쭮.

     '\x'  '\y'  esc-᫥⥫쭮 "goto" (३)
 ᨬ   '\t'    '\b'    esc-᫥⥫쭮  "scrolling
region" ( ᬮ)    ᪮쪨 ᨬ-
, 뢠騬    ப/⮫.   ᠭ 樨
ப/⮫ 稭 ᫥騬 ࠢ:
    1. ᫨  祭 ࠢ 0,  ப  ⮫ 㬥-
       , 稭  0,  ᫨  祭 ࠢ 1, 㬥
       ப   ⮫殢  稭   1.  ᪫祭 ⠢
       砩,  ᭠ ⠡  㪠;  ⮣  㬥
       ᥣ 㤥 稭  1.  祭, ⫨ 
       0  1,  ᪠.

    2. ᫨ ᭠ ⠡ ।,    ⮩  -
       ,  ᮮ⢥ 樨 ப (⮫).  -
       樨 ப  ⮫殢  ⮬ 砥 ᥣ 㬥 -
       ⥫쭮 1  ( 1   ப   ⮫-
       ),   祭  BASE  ⠡ CRT. -
        ᮢ  ப    ⮫殢   筮 ⠪ 
       ࠧ,   ࠧ 뢠  ࠭.  ⠪-
        ,    ᭠  ⠡  ⢥
       ।⢮ 祭 ᮢ ப  ⮫殢,   न
          ଠ쭮 ᠭ.

    3. ᫨ 祭 ᬥ饭 ।, ப ᨬ, -
         ப (⮫),  ⮨  ⢥
       ᨬ,   ண  ।⠢  ᮡ  㬬
        ப (⮫)   祭 ᬥ饭.  , -
       , ᫨  祭 ࠢ 0,  ᨬ,   뢠騩
        ப    ᠬ   ⮫,   
       , ᮢ騩  祭 ᬥ饭.  祭 ᬥ饭
          ⥫. ஬ ⮣, ᫨  -
       祭 ࠢ 0, 祭 ᬥ饭  ⫨  0.

    4. ᫨  ᭠ ⠡,   祭 ᬥ饭  ।-
       , 뢠  ᫥⥫쭮 ᨬ -
        筮 ।⠢. , ਬ,  ப
       뢠 ᨬ '0', ᫨  祭 ࠢ 0, 
       ᨬ '1', ᫨  祭 ࠢ 1.

    ८।  ࠪ⨪ ନ
    -------------------------------------------------------------


                                    -- 99 --



    ८। ࠪ⨪ ନ    ᫥-
  ᯮᮡ:
    * ᯮ ⨫ SQL*Forms  ᥭ    㭪-
      樨   ணࠬ த⮢ ( ଥ CRT)
    * ᯮ ⨫ SQL*Plus  ४஢   ᥩ
       ⠡ ESC.

     ணࠬ CRT
    --------------------
    ᫥ ᥭ ,  । ନ
ࠪ⨪,  ⠡   ணࠬ CRT,  ᣥ-
  CRT-䠩  ନ.  ⠪ 맮 ணࠬ:

    CRT _䠩_CRT [_짮⥫/஫] [-d?]

        짮⥫  ஫,  뢠騥 -
  ᥬ ⠡栬 CRT.   CRT-䠩,  㪠   
ப,   ᮢ  ,  ᮤঠ騬  ⠡ CRT,
ESC  CRTBOX.  ᫨ ࠬ d  ᯮ, 室 䠩 -
砥 ,  㪠    ப,   ७ .CRT; 
砥 ᯮ짮 ࠬ d 㤥 ᮧ      䠩  
 DEFAULT.CRT.
    ଠ   ࠭  ᮧ CRT-䠩 .  
㪮⢥ "ORACLE Installation and User's Guide"  襩 -
樮 ⥬.

    ⠫/樠 ⨫ CRT (ଠ    -
     )
    -------------------------------------------------------------

     ⭮襭 ⨫ CRT  ।  ନ  ࠪ-
⨪    ⢥⢥ :
    *  䠩 CRTINS,  ᮧ饣  㦠饣 ⠡ CRT  
      (樨 .  㪮⢥ "ORACLE Installation and User's Guide")
    * 롮  ନ,   ࠪ⨪ ண  ਭ 
      ⢥ ࠪ⨪  㬮砭 (⢫   
      ⢥   ,   騩    믮 䠩
      CRTINS,  ⥬ २ ᮮ⢥饣 CRT-䠩
       䠩 DEFAULT.CRT)
    * 뤠 ਪ ࠧࠡ稪,  騬  
       ।  ନ  ࠪ⨪,   ࠧ襭 
        ᮢ㯭 ⠡ CRT
    * ᯥ祭 짮⥫ ଠ樥  㭪  
      ࠡ  ਪ묨 ணࠬ, ᯮ騬  ORACLE















                                   -- 100 --



         IV  

         A       
                      EXPORT/IMPORT
        

    饥 ਫ  ᮤন  ᯨ᮪  ᮮ饭  訡,
  ६ 믮 ணࠬ Export/Import.   -
ਢ ।  稭   訡 
। ⢨   ࠭.
     楫  祭 ᪠  ࠭ 訡   ᮮ-
饭   ꥪ⮢,  , ⢥ ࠪ-
騥 訡,   ᯮ⥫ ⥪.   ᮮ饭
   "name" (), "num" (᫮)  "str" (⥪),
ᮮ⢥⢥. ,  ਬ, ᮮ饭  訡, 饥 -
:
    EXP-00011: <name.name> does not exist
    (EXP-00011: 䠩   "."  )
 ਭ  :
    EXP-00011: SCOTT.ACCTS does not exist
       ᮮ饭ﬨ  ᠬ  ணࠬ Export  Import  
믮   ᮮ饭,  뤠   ORACLE.
 ᮮ饭, 㥬 ᮮ饭ﬨ  訡  ORACLE, -
  㪮⢥ "ORACLE Error Messages and Codes Manual".

    饭  㦡 ᮯ஢ த⮢ ௮樨 Oracle
    -------------------------------------------------------------

       ᮮ饭 ४   饭
 稢襩 訡  㦡 ᮯ஢ த⮢  ௮樨
Oracle.   ⮢ 饭 室   ᥡ  -
 ᫥ ଠ:
1. ⭠  樮 ।,  ᨨ 樮
   ⥬,  ࠢ ன 㭪樮  ORACLE.
2.  ᨨ  ORACLE (筮 V6.0, V5.1  V5.0).
3. ணࠬ த ORACLE ( ࠬ  ᨩ),   -
     ⨫ 訡 (ਬ, Import V6.0).
4.   訡 ( 訡,  ᫨  ᪮쪮)    
   () ⥪ ( 浪 ).
5. 쥧 訡  ᮮ⢥⢨  ᫥饩 ஢:
   1 = ணࠬ  짮. 訡 ᪨ -
       ࠧ ࠦ  㭪 ணࠬ.
   2 = ணࠬ 짮 ,     㭪樨 -
        ࠭祭.
   3 = ணࠬ  짮       ࠤ訬
       㭪ﬨ. ﭨ  ⠫ 㭪樨 ᪮.
   4 = ஡ ࠭ 짮⥫.  㭪樨 ணࠬ
       ﭨ 쭮.
6. ᠭ ஡, 饥  祭  -
   ⥫⢠.

஬ ⮣, ⥫쭮 ᮮ  ᥡ ᫥饥:
* 
*  ,   ࠡ⠥
* 짮⥫᪨  襩 ,     -
  ॣ஢   㦡 ᮯ஢ த⮢ ௮樨
  Oracle (᫨ )
*  ⥫䮭

                                   -- 101 --




        饭  訡 ணࠬ Export
        -------------------------------------

EXP-00000: Export terminated with error
           (⨫ ᯮ 訫 ᢮ ࠡ  訡)
稭:   ⨫ 㦨 訡  ORACLE.
⢨:    ᠭ 訡,  㪠  ᮯ饬 ᮮ饭
           ,  믮 ᮮ⢥- 饥 ⢨.

EXP-00001: data field truncation -  column  length  =  <num>,
           buffer size = <num> fetched = <num>
           (ଠ樮   १:     ⮫ =
           ᫮, ࠧ  = ᫮,  ࠭  = ᫮)

稭:   ⨫   㬥 祭 ⮫   .
⢨:   ࠧ 㪠  ࠬ஢     ᮯ騥
           ᮮ饭, ᮮ    ७ 訡 ⨫.
           ( ᯮ஢ 筮; ⨫ 室 
           ᯮ஢ ᫥饩 ⠡.)


EXP-00002: error in writing to export file
           (訡 뢮   ᯮ-䠩)
稭:   ⨫   ந   ᯮ-䠩,
           , - ⭮ 訡.  ᮮ饭
           筮 ᮯ஢  ᮮ饭     ⭮
           訡, 祭  樮 ⥬.
⢨:  ⠭ ࠡᯮᮡ ன⢠.


EXP-00003: no storage definition found for segment (name,num)
           ( ᠭ ࠬ஢ ࠭ ᥣ (,᫮))
稭:   ⨫     ᠭ ࠬ஢ ࠭-
            ,   ⠡.
⢨:   ᮯ騥 ᮮ饭  ᮮ  -
            ७ 訡 ⨫.


EXP-00004: invalid username or password
           (  짮⥫  ஫)
稭:    㪠 ୮ 祭 ࠬ஢  ॣ-
           樨 (_짮⥫/஫).
⢨:   , 㪠 ࠢ쭮 祭.


EXP-00005: all allowable logon attempts failed
           ( ࠧ襭  ⪨  ॣ樨  稫
           㤠祩)

稭:    ᭮ ⠫  ॣ஢  
           祭 ࠬ஢ ॣ樨.
⢨:   , 㪠 ࠢ쭮 祭.






                                   -- 102 --



EXP-00006: internal inconsistency error (襭 ७ ᮣᮢ)
稭:   ० ଠ樮  ⨫.
⢨:   ᮯ騥 ᮮ饭  ᮮ  -
            ७ 訡 ⨫.


EXP-00007: dictionary shows no columns for <name.name>
           (⮫  ꥪ .  ᫮  ᠭ)
稭:   ⪠ ⨫ ᯮ   ᫮  -
           ଠ  ⮫ ꥪ (⠡)  稫
           㤠祩. ⭮, ⠡ 뫠 㤠.
⢨:     ᯮ஢   砥 -
           ७ 訡 ᮮ   ७
           訡 ⨫.


EXP-00008: ORACLE error <num> encountered
           ( 訡   ORACLE  ஬ "᫮")
稭:    訡    ६  ᯮ஢.
⢨:    ᠭ 訡,  㪠  ᮯ饬 ᮮ饭
           ,   믮 ᮮ⢥饥 ⢨.

EXP-00009: no priviledge to export <name>'s table <name>
           ( ᯮ஢ ⠡ "",  ਭ饩
            "",  짮⥫  稩)
稭:     ।ਭ ⪠ ᯮ஢ ⠡,
           ਭ饩 㣮 짮⥫. ࠢ ᯮ-
           ஢ 㦨 ⠡  ⮫쪮  .
⢨:    ࠧ襭  .

EXP-00010: <name> is not a valid username ( 짮⥫ 㪠 ୮)
稭:    짮⥫  㪠 ୮.
⢨:   , 㪠 ࠢ쭮 .


EXP-00011: <name.name> does not exist
           (⠡   "."  )
稭:   ⨫    㪠 ⠡.
⢨:   ,  㪠  饩 ⠡.

EXP-00012: <num> is not a valid export mode
           ("᫮"   ⨬ 祭 ࠬ-
            "० ᯮ஢")
稭:     㪠 ⨬ 祭 ࠬ "-
            ᯮ஢".
⢨:    ,   㪠  ࠢ쭮  祭 ࠬ.

EXP-00013: respond with either 'Y',  'N',  RETURN or  '.'  to quit
           ( ⢥ ᯮ    <Y>, <N>, <RETURN>  <.>)
稭:   ⨬ ⢥.
⢨:  ⢥ ⨥    㪠   ᮮ饭 .

EXP-00014: error on row <num> of table <name>
           (訡  ப  ஬ "᫮",  ਭ饩 ⠡ 
           㪠 )
稭:    롮થ ப  訡  ORACLE.
⢨:    ᠭ 訡,  㪠  ᮯ饬 ᮮ饭
           ,   믮 ᮮ⢥饥 ⢨.

                                   -- 103 --



EXP-00015: error on row <num> of table <name>, column <name>,
           datatype <num>
           (訡  㪠 ⮫ 㪠 ⨯,  -
           饬 㪠 ப ⠡)

稭:     訡   ORACLE  롮થ 
            祭 ⮫.
⢨:    ᠭ 訡,  㪠  ᮯ-
           饬 ᮮ饭 ,   믮 ᮮ⢥饥 ⢨.

EXP-00016: ORACLE error  encountered  while  reading  default
           auditing options
           ( ⥭ ࠬ஢  ୠ   㬮-
             訡  ORACLE)
稭:     ⥭ ࠬ஢  ୠ ॣ樨
           (, 㤠  ..)   訡   ORACLE.
⢨:    ᠭ 訡,  㪠  ᮯ-
           饬 ᮮ饭 ,   믮 ᮮ⢥饥 ⢨.

EXP-00017: ORACLE  error  encountered  while  reading  system
           auditing options
           ( ⥭  ࠬ஢  ⥬ ୠ
            訡  ORACLE)

稭:     ⥭ ࠬ஢   ⥬ ୠ
           (ॣ 짮⥫,  ࠢ 㯠  ..)
            訡  ORACLE.
⢨:    ᠭ 訡,  㪠  ᮯ-
           饬 ᮮ饭 ,   믮 ᮮ⢥饥 ⢨.

EXP-00018: datatype (num) for column <name>, table <name.name> is not supported
           (㪠  祭 ⮫ ⨯   ন)
稭:    ⨯  ⨫⮩  ন.
⢨:   , 㪠  ⨬  ⨯  
           (CHAR, NUMBER, DATE, LONG  RAW).

EXP-00019: failed to process parameters,  type  'EXP  HELP=Y' for help
           (⪠ ࠡ ࠬ  稫  㤠-
           祩,   祭  ᪠  ப 'EXP HELP=Y')
稭:   訡   ࠬ஢  ப.
⢨:  ᬮ  ᯨ᮪ ⨬ ଠ⮢,  ⨢-
               ⨫,   .

EXP-00020: failed to allocate memory of size <num>
           (⪠ 뤥  ࠭⢮   㪠
           ࠧ 稫 㤠祩)
稭:   訡  뤥 ࠭⢠ .
⢨:   ࠧ   ᯮ஢ (᮪⨢
           ⥬ ᠬ ॡ  )  㢥 ࠧ-
            ᪮ , 뤥塞 ⨫.

EXP-00021: can only perform incremental export in Full Database mode
           (蠣 ᯮ஢ 믮 ⮫쪮  ०  )
稭:   ⪠ 믮 蠣 ᯮ஢   -
            짮⥫  ⠡.
⢨:    ,  㪠  ०       (FULL=Y).



                                   -- 104 --



EXP-00022: must be SYS or SYSTEM to do incremental export
           (믮 蠣  ᯮ஢  ࠧ襭
           ⮫쪮 짮⥫ SYS  SYSTEM)
稭:    ࠡ  ० 蠣  ᯮ஢  
             室 稩.  蠣 ᯮ-
           ஢   ந  ⮫쪮  짮⥫ SYS  SYSTEM.
⢨:    ࠧ襭  蠣 ᯮ஢ -
              .

EXP-00023: must be a DBA to do Full Database export
           (ࠡ   ०   ࠧ襭 ⮫쪮 )
稭:    ࠡ  ०       室 稩.
           ᯮ஢  ⮬ ०  ந ⮫쪮 짮⥫
           SYS    SYSTEM.
⢨:   ࠧ襭  ᯮ஢  ०  
               .

EXP-00024: Export views not installed, please notify your DBA
           (奬 ᯮ  ⠫஢,  ⠢  ⭮
            )
稭:   奬 () ⨫  ⠫஢.
⢨:      室 ⠫-
           樨 奬 ⨫.

EXP-00025: dictionary   shows   no   column   for  constraint <name.num>
           (⮫  㪠 ࠭祭   ᫮   ᠭ)
稭:   ⪠ ⨫ ᯮ   ᫮  -
           ଠ  㪠 ࠭祭 稫 -
           祩. ⭮,   ࠭祭 ࣫ .
⢨:     ᯮ஢   砥 -
           ७ 訡 ᮮ   ७
           訡 ⨫.

EXP-00026: only one parameter (TABLES, OWNER, or FULL) can be specified
           (᪠ 㪠 ⮫쪮   ࠬ  
           ᯨ᪠: TABLES, OWNER  FULL)
稭:    ० ᯮ஢ ⨢  .
⢨:    , 㪠 ⮫쪮   ࠬ஢.

EXP-00027: failed to calculate ORACLE block size
           (ࠧ     ᫥)
稭:   ⨫   ﭨ । ࠧ   .
⢨:     ७ 訡  ⨫.

EXP-00028: failed to open <name> for write
           (訡   ᯮ-䠩  㪠   )
稭:   ⪠ ⨫  ᯮ-䠩     稫
           㤠祩.   ᮮ饭 筮 ᮯ஢ ᮮ饭 
           ⭮ 訡, 祭  樮 ⥬.
⢨:  ⠭ ࠡᯮᮡ ன⢠.


饭  訡   訡 ணࠬ Import
-------------------------------------------------------------





                                   -- 105 --



IMP-00000: Import terminated with error
           (⨫  訫 ᢮ ࠡ  訡)
稭:   ⨫ 㦨 訡  ORACLE.
⢨:    ᠭ 訡,  㪠  ᮯ饬 ᮮ饭
           ,  믮 ᮮ⢥- 饥 ⢨.

IMP-00001: respond with either 'Y',  'N',  RETURN or  '.'  to  quit
           ( ⢥ ᯮ    <Y>, <N>, <RETURN>  <.>)
稭:   ⨬ ⢥.
⢨:  ⢥ ⨥    㪠   ᮮ饭 .

IMP-00002: failed to open <name> for read
           (訡  ᯮ-䠩  㪠   ⥭)
稭:   ⪠ ⨫   ᯮ-䠩    ⥭
           稫 㤠祩.   ᮮ饭 筮 ᮯ-
           ஢ ᮮ饭  ⭮ 訡, -
           祭  樮 ⥬.
⢨:  ⠭ ࠡᯮᮡ ன⢠.

IMP-00003: ORACLE error <num> encountered
           ( 訡  ORACLE  㪠  ஬)
稭:    訡   ६ ࠡ ⨫.
⢨:    ᠭ 訡,  㪠  ᮯ-
           饬 ᮮ饭 ,   믮 ᮮ⢥饥 ⢨.

IMP-00004: invalid username or password (  짮⥫  ஫)
稭:    㪠 ୮ 祭 ࠬ஢  ॣ-
           樨 (_짮⥫/஫).
⢨:   , 㪠 ࠢ쭮 祭.

IMP-00005: all allowable logon attempts failed
           ( ࠧ襭  ⪨  ॣ樨  稫 㤠祩)
稭:    ᭮ ⠫  ॣ஢  
           祭 ࠬ஢ ॣ樨.
⢨:   , 㪠 ࠢ쭮 祭.

IMP-00006: failed to allocate memory of size <num>
           (⪠ 뤥  ࠭⢮   㪠
           ࠧ 稫 㤠祩)

稭:   訡  뤥 ࠭⢠ .
⢨:   ࠧ   ஢  (᮪⨢
           ⥬ ᠬ ॡ  )  㢥 ࠧ-
            ᪮ , 뤥塞 ⨫.

IMP-00007: must be a DBA to import objects to another  user's account
           (ࠢ ஢ ꥪ⮢ 㣮  짮-
           ⥫ ᯮ ⮫쪮  )
稭:       ﬨ ந -
           ஢ ꥪ⮢    㣮  짮⥫.
            ࠢ ।⠢ ⮫쪮  .
⢨:    㣠 .

IMP-00008: unrecognized statement in the export file: <str>
           (ᯮ   ⠢  ᯮ-䠩-
           , ᫥ ⥪ )
稭:   ⨫     ᯮ    ᯮ-
           䠩.     ⮣,   ᯮ-

                                   -- 106 --



           䠩 祭,  ⮣,   ७-
            訡 ⨫.
⢨:  ᫨  ᯮ-䠩  祭,    ,
           㪠 㣮 ᯮ-䠩.  ⨢ 砥 -
               ७ 訡 ஢.

IMP-00009: abnormal end of export file (਩ 砭 ᯮ-䠩)

稭:    ᪫祭,  ᥠ ᯮ஢, १-
           ⮬ ண   ᯮ-䠩, 訫 ਩.
⢨:  ᫨  ⠪,   ᯮ   ᭠砫.  
           ⨢ 砥 ᮮ  訡 ⨫ 
            ਫ ᯮ-䠩, 맢襣 訡.

IMP-00010: not a valid export file, header failed verification
           (ᯮ-䠩 㪠 ୮,  訡 ⥭ )
稭:    ᯮ-䠩   ᣥ஢ ⨫⮩ -
           ᯮ,   ⨫.
⢨:  ᫨  䠩 -⠪ ᣥ஢ ⨫⮩ ᯮ,
           ᮮ  訡 ⨫      ਫ
           ᯮ-䠩, 맢襣 訡.

IMP-00011: formatted table data not currently supported
           (८ࠧ ⠡   ন)
稭:    ।ਭ ⪠ 㧨 ᮤন -
           -䠩, 饥   ८ࠧ ⠡筮
           ଠ樨. ⨫ ন ⮫쪮  ᯮ
           -䠩, ⠡       ᮤঠ  筮 .
⢨:   , 㪠 ᯮ-䠩, ᮤঠ騩
           ⮫쪮  ⠡ .

IMP-00012: invalid export mode (num) in header
           (  ᯮ-䠩 㪠  ० ᯮ஢)
稭:    ᯮ஢,  㪠   -
           -䠩, ७.
⢨:  ஢,  祭  ᯮ-䠩.  ᫨ ,
           ᮮ  訡 ⨫      ਫ
           ᯮ-䠩, 맢襣 訡.

IMP-00013: only  a  DBA can import a file exported by another DBA
           (⮫쪮     ࠢ 㦠 -
           -䠩, ਭ騩 㣮 )
稭:    㧪 ᯮ-䠩, ᮧ -
           ஬ ,    室 稩. 쪮
           , ᠬ 饥 ஬ ,    ࠢ.
⢨:    㣠 .

IMP-00014: insufficient ORACLE priviledges to do import
           ( 믮 楤 ஢  짮-
           ⥫  墠⠥ 稩)
稭:     믮 楤 ஢   -
           ⠥ 稩.  ࠡ  ⨫⮩  -
              ਢ ⨯ CONNECT.
⢨:     뤠    室 .

IMP-00015: following  statement  failed  because  the  object
           already exists: <str>
           (᫥騩   믮 -  ⮣,   

                                   -- 107 --



           ꥪ 㦥 , ᫥ ⥪ )
稭:   ⪠  ⨫  ᮧ ꥪ 稫
           㤠祩, .. ꥪ 㦥 .
⢨:  ᫨  ,  ⮡ ⨫ ஢ -
            訡  㦠 ப   砥,  -
            ࠬ 'IGNORE=Y'.

IMP-00016: required  character  set conversion (type <num> to
           <num>) not supported
           (㪠 ८ࠧ ⨯  ন)

稭:   ⨫  ࠡ⠥  ᯮ-䠩,  ଠ -
            ⫨祭  ᨬ ଠ⮢, ন .
⢨:    ,  㪠 ᯮ-䠩,  騩
           ଠ ASCII  EBCDIC.

IMP-00017: following  statement  failed  with  ORACLE  error <num>: <str>
           ( ࠡ⪥    㦥  訡 
           ORACLE, ᫥ ⥪ )
稭:   ⪠ ⨫  ࠡ    稫
           㤠祩 - 㦥 訡  ORACLE.
⢨:    ᠭ 訡,  㪠  ᮯ-
           饬 ᮮ饭 ,   믮 ᮮ⢥饥 ⢨.

IMP-00018: partial import of previous table complete:   <num>
           rows imported
           (। ⠡ 㦥 筮: -
            㪠 ᫮ ப)

稭:    㦥 ⮫쪮 筮  裡   -
           㦥 訡  ORACLE.
⢨:    ᠭ 訡,  㪠  ᮯ-
           饬 ᮮ饭 ,   믮 ᮮ⢥饥 ⢨.

IMP-00019: row rejected due to ORACLE error <num>
           (ப ⢥࣭ - 訡  ORACLE, c  訡)

稭:     ⪥  㧨  ப  㦥 訡  ORACLE.
⢨:    ᠭ 訡,  㪠  ᮯ-
           饬 ᮮ饭 ,   믮 ᮮ⢥饥 ⢨.

IMP-00020: column  (size <num>)  in export file too large for
           column buffer (size <num>)
           (ࠧ ⮫  ᯮ-䠩 ॢ蠥 ࠧ 뤥 )
稭:     ⮫ ᫨誮 .
⢨:    訡 ⨫      ਫ
           ᯮ-䠩, 맢襣 訡.

IMP-00021: operating  system  error  - error code (dec <num>, hex 0x<num>)
           (訡 樮 ⥬, ᫥  
           ⭠  訡)
稭:    訡 樮 ⥬.
⢨:    ᠭ 訡  㪮⢥   -
           襩 樮 ⥬  믮 ᮮ⢥饥 ⢨.

IMP-00022: failed to process parameters,  type  'IMP  HELP=Y' for help
           (⪠ ࠡ ࠬ  稫  㤠祩,
             祭  ᪠  ப 'IMP HELP=Y')

                                   -- 108 --



稭:   訡   ࠬ஢  ப.
⢨:  ᬮ  ᯨ᮪ ⨬ ଠ⮢,  ⨢-
               ⨫,   .

IMP-00023: Import views not installed, please notify your DBA
           (奬    ⠫஢,  ⠢ 
           ⭮  )
稭:   奬 () ⨫  ⠫஢.
⢨:      室 ⠫-
           樨 奬 ⨫.

IMP-00024: full import mode, cannot specify FROMUSER or TABLE parameter
           ( ०  㧪   ࠬ FROMUSER
            TABLE  )
稭:    㪠 ࠬ, 䫨騥  ࠬ஬  FULL=Y.
⢨:     㪠 ࠬ FULL=Y.

IMP-00025: for DBA export files,  FROMUSER must be  specified  with TOUSER
           ( 㧪 ᯮ-䠩,  ᮧ -
           ஬, ࠬ   TOUSER  㪠    ࠬ FROMUSER)
稭:    㧪 ᯮ-䠩, ᮧ ஬,
             㪠 ࠬ TOUSER,    㪠 ࠬ FROMUSER.
⢨:   ࠬ FROMUSER, ⮡ ⨫ ⠫ -
           ⭮,  ਭ 㦠 ꥪ.

IMP-00027: failed  to  roll  back  partial import of previous table
           (⪠ ⬥     㧪  ।饩
           ⠡ 稫 㤠筮)
稭:    ⪥ ⬥  㧪 ⠡  -
            訡  ORACLE.
⢨:    ᠭ 訡,  㪠  ᮯ-
           饬 ᮮ饭 ,   믮 ᮮ⢥-
           饥 ⢨.  ⥬   ⥬  㡥
            ⮬,  १  㧪 ⬥.

IMP-00028: partial  import  of  previous  table  rolled back:
           <num> rows rolled back
           (१  㧪  ।饩  ⠡
           ⬥, ᫥ ᫮ ⬥ ப)
稭:    ⪥ 㧨 ⠡  訡   ORACLE.
⢨:    ᠭ 訡,  㪠  ᮯ-
           饬 ᮮ饭 ,   믮 ᮮ⢥-
           饥 ⢨.   ⥬,  ᫨ 㦭,  १㧨 ⠡.

IMP-00029: cannot qualify table <name> by owner  (name.name),
           use FROMUSER parameter
           (㪠       ⠡  -
           ᪠, ᯮ ࠬ FROMUSER)

稭:     ⠡  㪠   , 
            ࠧ蠥:
           IMP SYSTEM/MANAGER TABLES=(SCOTT.EMP,SCOTT.DEPT)
⢨:    㪠    ⠡ ᯮ
           ࠬ FROMUSER:
           IMP SYSTEM/MANAGER FROMUSER=SCOTT TABLES=(EMP,DEPT)




                                   -- 109 --



         A       SQL*LOADER
        

    饥 ਫ  ᮤন  ᯨ᮪  ᮮ饭  訡,
  ६ 믮 ணࠬ SQL*Loader. 饭
 訡 SQL*Loader  ᫥ :
    SQL*Loader-: ⥪_ᮮ饭
     楫  祭 ᪠  ࠭ 訡   ᮮ-
饭   ꥪ⮢,  , ⢥ ࠪ-
騥 訡,   ᯮ⥫ ⥪.   ᮮ饭
   "name" (), "num" (᫮)  "str" (⥪),
ᮮ⢥⢥. ,  ਬ, ᮮ饭  訡, 饥 ଠ:
    SQL*Loader-501: Unable to read control file (name)
    (SQL*Loader-501: ⨫   ﭨ  ࠢ騩 䠩 ())
 ਭ  :
    SQL*Loader-501: Unable to read control file (LOAD5.CTL)

      ᮮ饭ﬨ ᠬ ⨫ SQL*Loader     
ࠡ   ᮮ饭,  뤠  ORACLE.  
ᮮ饭, 㥬 ᮮ饭ﬨ  訡  ORACLE, 뢠-
  㪮⢥ "ORACLE Error Messages and Codes Manual".

     100-199: 訡  ப
    -------------------------------------

SQL*Loader-100: Syntax error on command line
                (ᨭ⠪᪠ 訡   ப)  稭
                ⮩ 訡: 㪠 樮 㬥 ᫥ 祢
                㬥⮢, 䮣᪠ 訡  ᠭ  祢
                ᫮, ᡠ஢ 㣫  ᪮  祪,
                稥 ஡   ஬   ࠢ⢠,  ⠪
                 ᫥  㬥⮬.  ஢ ᨭ⠪   -
                䮣  ப,   ⥬  .

SQL*Loader-101: Invalid argument for username/password
                (୮ 祭 㬥 "_짮⥫/஫")

SQL*Loader-102: Invalid control file <name> on command line
                (୮   ࠢ饣 䠩   ப)

SQL*Loader-103: Invalid log file <name> on command line
                (୮   ॣ樮  䠩    ப)

SQL*Loader-104: Invalid bad file <name> on command line
                (୮   䠩  ᥩ   ப)

SQL*Loader-105: Invalid data file <name> on command line
                (୮   䠩    ப)

SQL*Loader-106: Invalid discard file <name> on command line
                (୮  䠩 ﭭ ᥩ   ப)

SQL*Loader-107: Invalid maximum number of discards
                (࠭祭  ⢮ ﭭ ᥩ  ୮)

SQL*Loader-108: Invalid number of logical records to load
                (⢮ 㦠 ᥩ  ୮)


                                   -- 110 --



SQL*Loader-109: Invalid number of logical records to skip
                (⢮ ய᪠  ᥩ   ୮)

SQL*Loader-110: Invalid maximum number of errors
                (ᨬ쭮 ⢮ 訡  ୮)

SQL*Loader-111: Invalid number of rows for bind array
                (⢮ ᥩ  易 ᨢ  ୮)

SQL*Loader-112: Invalid maximum bind array size
                (ᨬ ࠧ 易 ᨢ  ୮)

SQL*Loader-113: Invalid silent mode option (ॡ  樨 "०")

SQL*Loader-114: Error in OPTIONS statement (訡  । OPTIONS)


         200-299: ⠪᪨ 訡 DB2
        ---------------------------------------
SQL*Loader-200: FORMAT  clause  should  not be present - flat
                data files only SQL/DS format  not  supported here
                (ࠧ FORMAT    ⢮  - 䠩
                  ଠ SQL/DS    ন)

SQL*Loader-250: Work data sets are not used by SQL*Loader
                (ࠡ稥   ⨫⮩ SQL*Loader  ᯮ)

SQL*Loader-251: Sort devices are not used by SQL*Loader
                (।⢠ ஢ ⨫⮩  SQL*Loader   ᯮ)

SQL*Loader-252: Sort data sets are not used by SQL*Loader
                (㥬   ⨫⮩ SQL*Loader  ᯮ)

SQL*Loader-253: DB2  partition  number  has no significance - ignored
                ( ࠧ DB2   祭  ⮬ )

 300-399: ⠪᪨ 訡  ࠢ饬 䠩
-------------------------------------------------------------

SQL*Loader-300: Control file line too long
                (ப ࠢ饣  䠩      ᫨誮  )

SQL*Loader-301: Token too long (祭  ᫨誮  )

SQL*Loader-302: Non-terminated quoted string constant found
                (㦥 祭 ப ⠭)

SQL*Loader-350: Syntax error at line <num>
                (ᨭ⠪᪠ 訡  ப    㪠 ஬)
                num -  ப  ࠢ饬 䠩,  㦥 訡.
                 ⨬ ᮮ饭 ᫥   ᮮ饭, 饥 :
                Expecting <str1>, found <str2>
                ( ப 1 㦥 ப 2)
                 str1 - ᠭ ப,   ࠢ饬 䠩 
                ᯮ     ப str2.  ⥬ SQL*Loader 뢮
                 ࠭ ப, 訢  ࠢ饣 䠩, 
                ன    ᯮ 訡 ⬥砥 ᨬ '^' 
                '*'.   ਬ:

                                   -- 111 --



                SQL*Loader-350: Syntax error at line 28
                Expecting column name, found keyword CHAR
                col3 ENCLOSED BY '"', CHAR ENCLOSED "'",
                                      ^

 400-499: ᪨ 訡 ( ࠢ쭮 ᨭ⠪)
-------------------------------------------------------------

SQL*Loader-400: Record  format  only  for data and control in same file
                (  䠩   ⮫쪮 ଠ-
                  ࠢ騩 ଠ)

SQL*Loader-401: End field position must be  greater  than  or equal to start
                (᫥       ,
                訩  ࠢ   砫쭮 樨)

SQL*Loader-402: Unable  to  determine  length from column  specification
                ( ᯥ䨪樨 ⮫ ᭠  )

SQL*Loader-403: Referenced column <name> not present in table  <name>
                (⮫   㪠        ⠡)

SQL*Loader-404: Column <name> present more than once in table  <name>
                (७   ⮫    ⮩   ⠡)

         500-599: 訡  ⨨  ⥭ 䠩
        -------------------------------------------------------------

SQL*Loader-500: Unable to open control file (name)
                (   ࠢ騩 䠩  㪠 )

SQL*Loader-501: Unable to read control file (name)
                (   ࠢ騩 䠩  㪠 )

SQL*Loader-502: Unable to open log file for write (name)
                (   ॣ樮 䠩   㪠-
                   )

SQL*Loader-503: Unable to open data file (name)
                (   䠩   㪠 )

SQL*Loader-504: Unable to read data file (name)
                (   䠩      㪠 )

SQL*Loader-505: Actual  physical  record  length greater than
                specified maximum
                (䠪᪠  䨧᪮  ॢ-
                  ᨬ)
                 ⨯   VARIABLE  ࠢ饬 䠩
                  ᨬ ࠧ ,  -
                  ॢ襭 ⥪饩 .

SQL*Loader-506: Unable to open bad file (name)
                (   䠩  ᥩ    㪠 )

SQL*Loader-507: Unable to open discard file (name)
                (    䠩  ﭭ  ᥩ   㪠 )


                                   -- 112 --



         600-699: 訡, 訥   㧪
        -------------------------------------------------------------

SQL*Loader-600: Specified maximum bind size too small  for  a
                single row
                (ᨬ ࠧ 易 ᨢ  ࠧ 
                ப)  ࠧ ࠭⢠, ⢮  易
                ᨢ, ᯮ ࠧ BINDSIZE   ப 
                । OPTIONS   ࠢ饬 䠩.

SQL*Loader-601: For INSERT option, table must be empty. Error on <name>
                (᫨ ᯮ  INSERT, ⠡   )
                ᫨  㦭  ,  ᮤঠ騥  ⠡,
                묨, ᯮ 祢 ᫮ REPLACE; ᫨    
                    ⠡, ᯮ ᫮ APPEND.

SQL*Loader-602: Maximum error count exceeded
                (ॢ襭 ᨬ쭮-⨬  ⢮ 訡)

     620-639: 訡 ଠ
    -------------------------------------------------------------

      㯯 室 訡, 㦥  , ଠ  
ࠢ饬 䠩  ᠭ    ᢮  (TERMINATED, ENCLOSED).  ଠ
訡     ,    室  ᠭ ଠ
 㧪  ਢ  襭 ⮢୮ ᮤন .  
砥   訡 ⪠ 㧨  ਧ
㤠筮    砥  䠩  ᥩ.

SQL*Loader-620: Initial enclosing character not found
                ( 㦥 砫 騩 ᨬ)

SQL*Loader-621: Field in data file exceeds maximum  specified length
                (ࠧ   䠩  ॢ蠥  -
                쭮-⨬ )

SQL*Loader-622: Logical record ended - no terminator  character found
                (᪠   稫,    ਧ
                (ᨬ)   㦥)

SQL*Loader-623: Logical  record  ended  -  second   enclosing
                character not present
                (᪠   稫,     ன
                騩 ᨬ  㦥)

SQL*Loader-624: No  terminator  found  after TERMINATED and  ENCLOSED field
                (᫥ ,   ᠭ    TERMINATED  
                ENCLOSED, ᨬ-࠭⥫  㦥)

     640-699: ࠢ 訡  ORACLE
    -------------------------------------------------------------
      㯯 室 訡,  騥  饭   
騥  쭥 ࠡ ⨫ SQL*Loader.   -
⢥ ਬ   ࠢ 室  ⥬, -
  ⠡   ⮫  ୮ .
     砥   ࠢ 訡 뢮 ᮮ-
, ᮤঠ饥  訡  ⥪, 㪠뢠騩, ⪠ ࠡ-


                                   -- 113 --



    稫 㤠祩.   ᮮ饭 ⠪ 
㪠뢠  ⠡  ⮫,   ࠡ⪥  -
㦥 訡.

SQL*Loader-640: Non-recoverable ORACLE error occurred
                ( ࠢ 訡 )

SQL*Loader-641: Error  occurred  on  SQL insert statement for
                table <name>.   Your  use of column <name> is
                possibly in error
                (訡       SQL-  ⠢
                ப  ⠡  㪠 .  -
                , 訡 맢 ࠢ ᯮ짮-
                 㪠 ⮫)

SQL*Loader-642: Error occurred while verifying  emptiness  of table <name>
                (訡   ६ ஢ન  㪠
                ⠡  ⢨ ᥩ)

SQL*Loader-643: Error  occurred  while  trying to delete from table <name>
                (訡    ⪥ 㤠 
                 㪠 ⠡)
                ᫨   ᯮ  祢 ᫮ REPLACE,
                । 砫 㧪  ᮤন ⠡
                㤥 㤠.    ⮬ 砥  室
                  㤠   ⠡.


SQL*Loader-644: Error occurred on an attempt to commit
                (訡    ⪥ ॣ樨   )

SQL*Loader-645: Error occurred while querying  the  count in table <name>
                (訡   ࠡ⪥ ,  -
                  ⮬ ᥩ  ⠡)

SQL*Loader-646: Error  occurred  while  querying  maximum of <name.name>
                (訡   ࠡ⪥ ,  -
                  ᫥ ᨬ쭮  祭
                 ꥪ  㪠 )

         700-799: ⠫ 訡
        ------------------------------

SQL*Loader-700: Out  of  memory  while  performing  essential allocations
                (墠⪠    । ᮢ)

SQL*Loader-701: Out of memory while allocating bind array
                (墠⪠     뤥   易 ᨢ)

SQL*Loader-702: Internal error - call customer support
                (७ 訡 -   㦡 ᮯ஢)








                                   -- 114 --



     C      DB2
    

     ਫ  뢠  ࠧ   ᨭ⠪ ࠢ
䠩 ⨫ SQL*Loader  DB2.  ᬠਢ ᫥騥 :
    * ⥫  ⨫ SQL*Loader   ࠢ
       ⨫⮩ DB2
    *  RESUME  DB2
    * 樨, ᯥ稢騥 ᮢ⨬ ⨫
    * , 騥  SQL*Loader

    ⥫   ⨫ SQL*Loader  ࠢ 
    ⨫⮩ DB2
    -------------------------------------------------------------

     ⮣,  ⨫ SQL*Loader  짮 ࠢ-
騬 䠩  ⨫ DB2,   ᯮ ᫥묨 -
ﬨ, 騬  㭪権 稪 DB2,   । :
    * প  ⨯ DATE
    * ⮬᪠  㭨 ᫥⥫ 祢 祭
    *     
    * 㧪   ᪮쪨 䠩  ࠧ筮 ⨯
    * প ᥩ 䨪஢ ଠ,  ६ 
       ᥩ, ᯮ ࠭⥫ 祭 
    *  ࠪ⮢  䨧᪮      -
      쪨 ᪨
    *  ꥤ ᪮쪨 䨧᪨ ᥩ  -
          ࠧ CONCATENATE,  CONTINUEIF NEXT,
      CONTINUEIF THIS
    *  ஢ 訡  ᮮ饭
    * প 䠩  ᥩ (DB2  ⠭  ࠡ
       ࢮ 訡)
    * ࠢ  ⢮ ய᪠  㦠 ᥩ,
       ⠪ ⨬ ⢮ 訡
    * প । WHEN  ࠧ AND
    * প । FIELDS  ᠭ ࠪ⨪ -
        㬮砭

     RESUME  DB2
    ------------------
     ᮧ ࠢ饣 䠩  ᯮ짮    ᨭ-
⠪ 樨 RESUME ⨫ DB2, ⠪   ࠧ ⨫-
 SQL*Loader.  ஡   ࠧ  㧭  ࠧ-
  7 "㧪 ⠡   ०   -
  ".

樨 DB2         樨 SQL*Loader      

RESUME NO         INSERT                 㦠 ⮫쪮
 ⢨                           ⮬ 砥, ᫨ ⠡-
ࠧ RESUME                              ;     ⨢
                                        砥 뤠 ᮮ饭
                                         訡.
RESUME YES        APPEND                   
                                         騬  ⠡.
RESUME NO         REPLACE                  -
REPLACE                                 騥.


                                   -- 115 --



    ⠪ ࠧ  DB2 ᫥騩:
    ᫨ ⠡,    㧪 , 㦥 ᮤঠ
- ଠ,   㯨   ᮤন -
   ᯮᮡ.    ᯮᮡ । ᯮ짮
ࠧ RESUME. 㬥 ࠧ RESUME   祭  㣫 ᪮.
    RESUME { YES  NO [ REPLACE ] }
:

YES               ப  㦥 騬   ⠡-
                .

NO                ।  㧪    ⮩.  
                ⨢ 砥 㤥 뤠 ᮮ饭  訡
                 ࠡ  ⨫  .     㬥 
                㬮砭.

NO REPLACE       ᮤন ⠡ । 㧪  -
                 . 㣨 ᫮,   -
                 .  짮⥫,  㪠뢠騩  -
                ,     ࠢ  ()  㤠
                  ⠡. ⠭ ஥ ᮤন
                ⠡  ᬮ ⮫쪮 ⥬  ᯮ஢-
                  㣨 묨 ।⢠.

     ࠡ  ⨫⮩ SQL*Loader  ࠧ RESUME   
ᯮ짮   ᠭ  ० 㧪   ⠡ ࠧ,
᫨ 㪠  । ᠬ ࢮ ࠧ INTO TABLE.     ⠪
 㪠뢠       ⤥쭮 ⠡,  ⮣ ࠧ
RESUME ᯮ ᫥ ࠧ INTO TABLE.   ࠧ RESUME,
 ன ᫥  ⠡, ⬥ ⢨ ।饩 -
; ᫨   ⠡ ࠧ RESUME  㪠,    ⠡-
 㤥  ࠭ ⢨ ᫥  ।
ࠧ  ⨯.

    樨, ᯥ稢騥 ᮢ⨬ ⨫
    -------------------------------------------------------------

    稪 DB2 砥  ᥡ ⤥ ,   ᯮ-
㥬 ⨫⮩ SQL*Loader. DB2  ࠡ  ஢묨
㪠⥫ﬨ, ᮧ묨   譨 䠩,  ᠭ -
 (䠩)  砥   㧪.  楫 ᯥ祭
ᮢ⨬   稪  DB2  ⨫ SQL*Loader 
 ᠭ,    ,  ᫨  窨 ७  ORACLE
   祭. 騥 ᨭ⠪᪨  DB2 -
 SQL*Loader ࠧ蠥 ᯮ짮,  .

     LOG
       ন  ᯥ祭 ᮢ⨬ 
⨫⮩ DB2.    ⨫⮩ SQL*Loader,  -
. (         ᮧ ⨫⮩
ॣ樮 䠩.)  稪 DB2 ᯮ  ॣ樮
䠩  ⠭  訡,  ⮬   ⢮-
.
    SQL*Loader । ⮬᪨ 室  ⥬,  -
   ॠ   ᪠ ⥬  .
    [ LOG { YES  NO } ]



                                   -- 116 --



     WORKDDN
       ন  ᯥ祭 ᮢ⨬ 
⨫⮩ DB2.    ⨫⮩ SQL*Loader,  -
. 稪 DB2 ᯮ   ஢ ६ (-
祣) 䠩.
    [ WORKDDN _䠩 ]

     SORTDEVT  SORTNUM
       ন  ᯥ祭 ᮢ⨬ 
⨫⮩ DB2.   ⨫⮩ SQL*Loader,  -
. 稪  DB2 ᯮ   㪠 ⢠  ⨯
ࠡ ஢ ,    ஢.
    [ SORTDEVT ⨯_ன⢠ ]
    [ SORTNUM n ]

    ࠧ DISCARD
    ᫨   ࠡ⪥    ᪮쪮  䠩,   ࠧ ⨯
DISCARD (DISCARDDN  DISCARDS)  ᯮ  ࠢ饬 䠩
  ᢮ 筮 ,   ᫥ ᠭ 䠩 . -
, ᫨ ᯮ ,  ᮢ⨬  DB2,  䠩,   ࠧ
  ०  -  ࠧ RESUME  RECLEN.  -
   ,  ᫨ ᯮ 稪 DB2, 㫥
祭 ࠬ  DISCARDS  砥  ⢨ ࠭祭 
⢮ ⢥࣠  ᥩ,          祭   ⨫⮩
SQL*Loader    室 ४饭 ࠡ
 ࢮ  ⢥࣠ .

    , 騥  SQL*Loader
    ---------------------------------------

     ᯥ 㭪樮஢ 稪 DB2  㡫-
 ⨫⮩ SQL*Loader. , ਬ, SQL*Loader  ந
㧪       䠩  ଠ SQL/DS,    䠩 
ଠ DB2 UNLOAD.   㦥 ᫥   稪
DB2 ⨫ SQL*Loader 뤠 ᮮ饭  訡:

     FORMAT
     DB2 FORMAT  ࠢ饬 䠩,  ࠡ뢠 -
⮩ SQL*Loader,   ⢮. 稪 DB2 ᯮ
    ଠ 㧮筮 䠩 (DB2  UNLOAD
 SQL/DS),  ᫨  ⫨砥  ७ ଠ -
.  ଠ ⨫⮩ SQL*Loader  ন.  ᫨ 㪠-
     䠩,  SQL*Loader ४-
 ࠡ  뤠 ᮮ饭  訡.  (ଠ IBM  ᠫ
ଠ 㪠 䠩, ⮬ SQL*Loader    .)
    FORMAT { UNLOAD  SQL/DS }

     PART
     PART  ন  ᯥ祭 ᮢ⨬ 
⨫⮩ DB2.    ORACLE  ⨥, ᮮ⢥饥
 "⠡  ࠧ",  ஥   DB2. -
 SQL*Loader 뢠 ⠡ 楫;   㦥  㪠-
   㤥  뤠  ᮮ饭  ⮬,   ⠡ 
ࠧ  ন,   ⠡ 㤥 㦥  楫-
.
    [ PART n ]



                                   -- 117 --



     SQL/DS
     । WHEN  SQL/DS=_⠡   ᯮ-
. SQL*Loader  ন  ७  ଠ  SQL/DS,
⮬   㦥  㪠  樨  SQL*Loader ४頥
᢮ ࠡ  뤠 ᮮ饭  訡.

    ᪨ ப
    ᪮     ORACLE ப ᨬ,    
  ,   ন, ᯮ짮 ᪨
  ଥ G'**'  ᪠.

















































                                   -- 118 --



     D     SQL*LOADER
    

    ᢮  ⠡栬  ⮫栬, ࠡ뢠   ⨫ 
SQL*Loader,   稭 饯ਭ ॡ.   ⠡  
⮫    ᮢ     १ࢨ஢ ᫮ - 
᫮,  ᮡ 祭  ⨫ SQL*Loader  ᫥  
᫥饩 ࠭.  ᫨   㦭 -⠪ ᯮ짮 १ࢨ஢ 
᫮  ⢥  ⠡  ⮫,  ᫥    
窨.
    AND                 EXTERNAL            RECLEN
    APPEND              FIELDS              RECNUM
    BADDN               FIXED               RECORD
    BADFILE             FLOAT               REPLACE
    BEGINDATA           FORMAT              RESUME
    BLOCKSIZE           GRAPHIC             SEQUENCE
    BY                  INDDN               SMALLINT
    CHAR                INFILE              SORTDEVT
    CONCATENATE         INSERT              SORTNUM
    CONSTANT            INTEGER             SQL/DS
    CONTINUEIF          INTO                STREAM
    COUNT               LAST                TABLE
    DATA                LOAD                TERMINATED
    DATE                LOG                 THIS
    DECIMAL             MAX                 UNLOAD
    DEFAULTIF           NEXT                VARCHAR
    DISCARDDN           NO                  VARGRAPHIC
    DISCARDFILE         NULLIF              VARIABLE
    DISCARDMAX          OPTIONALLY          WHEN
    DISCARDS            OPTIONS             WHITESPACE
    DOUBLE              PART                WORKDDN
    ENCLOSED            POSITION            YES



























                                   -- 119 --



         E     
        

           ᯮ㥬 ⨯ ନ,   -
    ন ௮樥 Oracle:
        D200             VI3x0
        D410             VK100
        D605x            VT52
        GG               VT100
        GIGI             VT102
        IBM3270          VT200
        OWL              VT220
        PC

         ᫥ ⨯ ᮢ      ᮮ-
     CRT-䠩.     ࠧ  樮  ⥬  ⠢
    CRT-䠩, ᮤঠ  ਡ⨢ ,   ࠧ-
    ,    ⮬   ⥬   䠩 ࠭ ।
      । ࠪ⨪ ᮢ  (㯮ॡ)
    ⨯ ନ.







































                                   -- 120 --



         F     
        

     饬 ਫ ᮤন ᯨ᮪ 㭪樮 
 ନ, ᯮ㥬 ⨫⠬ SQL*Forms IAP  IAD,
SQL*Calc  SQL*Menu.       ஢ ࠭
 ⠡ SYSTEM.FUNCTIONS.

    , ᯮ㥬 ⨫⮩ SQL*Forms IAP
    -------------------------------------------------------------

    BM     SELECT BLOCK BY MENU       (   )
    CA     CLEAR ALL                  ( )
    CB     CLEAR BLOCK                ( )
    CF     CLEAR FIELD                ( )
    CM     INSERT/REPLACE             (/)
    CQ     COUNT QUERY HITS           (  , 
                                        )
    CR     CREATE RECORD              ( )
    CT     COMMIT TRANSACTION         ( )
    D      DELETE RECORD              ( )
    DB     DELETE BACKWARD            (   )
    DC     DELETE CHARACTER           ( )
    DE     DISPLAY LAST ERROR         (  )
    DF     DUPLICATE FIELD            ( )
    DK     DISPLAY FUNCTION KEYS      (   )
    DR     DUPLICATE RECORD           ( )

    EQ     ENTER A QUERY              ( )
    H      HELP FIELD                 (  )
    IL     ILLEGAL KEY                ( )

    K0     USER DEFINED KEY 0         
    K1     USER DEFINED KEY 1         
    K2     USER DEFINED KEY 2         
    K3     USER DEFINED KEY 3         
                                         ,
    K4     USER DEFINED KEY 4         
                                       >  
    K5     USER DEFINED KEY 5         
                                         
    K6     USER DEFINED KEY 6         
    K7     USER DEFINED KEY 7         
    K8     USER DEFINED KEY 8         
    K9     USER DEFINED KEY 9         

    LV     LIST FIELD VALUES          (  )
    MD     MOVE CURSOR DOWN           (  )
    ML     MOVE CURSOR LEFT           (  )
    MR     MOVE CURSOR RIGHT          (  )
    MU     MOVE CURSOR UP             (  )

    NB     NEXT BLOCK                 ( )
    NF     NEXT FIELD                 ( )
    NK     NEXT PRIMARY KEY FIELD     (   )
    NR     NEXT RECORD                ( )
    NS     NEXT RECORD SET            (  )


                                   -- 121 --



    P      PRINT FUNCTION             ()
    PB     PREVIOUS BLOCK             ( )
    PF     PREVIOUS FIELD             ( )
    PR     PREVIOUS RECORD            ( )
    Q      EXECUTE QUERY FUNCTION     ( )

    R      REDISPLAY SCREEN           ( )
    RR     RELEASE RECORD             ( )
    SL     SCROLL LEFT                (  )
    SR     SCROLL RIGHT               (  )
    TM     TRANSMIT                   ( )
    X      EXIT/CANCEL                (/)


    , ᯮ㥬 ⨫⮩ SQL*Forms IAD
    -------------------------------------------------------------

    A      ACCEPT                     ()
    BL     DRAW BOX/LINE              ( /)
    CF     CLEAR FIELD                ( )
    CM     INSERT/REPLACE             (/)
    CR     CREATE FIELD               ( )
    CU     CUT                        (  )
    D      DEFINE                     ()
    DB     DELETE BACKWARD            (   )
    DC     DELETE CHARACTER           ( )
    DK     DISPLAY FUNCTION KEYS      (   )
    IL     ILLEGAL KEY                ( )
    MD     MOVE CURSOR DOWN           (  )
    ML     MOVE CURSOR LEFT           (  )
    MR     MOVE CURSOR RIGHT          (  )
    MU     MOVE CURSOR UP             (  )
    NF     NEXT FIELD                 ( )

    P      PRINT                      ()
    PA     PASTE                      (   )
    PF     PREVIOUS FIELD             ( )

    R      REDISPLAY SCREEN           ( )
    RF     RESIZE FIELD               (  )
    RO     RUN-OPTIONS WINDOW         (  )

    S      SELECT                     ()
    SB     SELECT BLOCK               ( )
    UN     UNDO                       ()
    X      EXIT/CANCEL                (/)

    , ᯮ㥬 ⨫⮩ SQL*Calc
    -------------------------------------------------------------
    AD     MOVE CURSOR DOWN           (  )
    AL     MOVE CURSOR LEFT           (  )
    AR     MOVE CURSOR RIGHT          (  )
    AU     MOVE CURSOR UP             (  )
    BS     BACKSPACE                  (   )

    CN     ESCAPE                     ()
    DL     DELETE                     ()
    EN     ENTER                      ()

                                   -- 122 --



    F0     "COPIED"                   ("")
    F1     HELP                       ()
    F2     EDIT                       ()
    F3     NAME                       ()
    F4     ABS                        ( )
    F5     GOTO                       ()
    F6     WINDOW                     ()
    F7     QUERY                      ()
    F8     TABLE                      ()
    F9     CALC                       ()

    IC     INSERT/REPLACE             (/)
    IL     UNDEFINED                  ( )
    LF     LINEFEED                   ( )
    ME     END                        ()
    MH     HOME                       ( )
    PD     PAGE DOWN                  ( )
    PL     PAGE LEFT                  ( )
    PR     PAGE RIGHT                 ( )
    PU     PAGE UP                    ( )
    R      REDISPLAY SCREEN           ( )
    RT     RETURN                     ()
    RU     RUB OUT (DELETE)           ()

    , ᯮ㥬 ⨫⮩ SQL*Menu
    -------------------------------------------------------------
    AM     GOTO APPLICATION MENU      (   )
    B0     BACKGROUND MENU OPTION # 1 
    B1     BACKGROUND MENU OPTION # 2 
    B2     BACKGROUND MENU OPTION # 3 
    B3     BACKGROUND MENU OPTION # 4 
                                          
    B4     BACKGROUND MENU OPTION # 5 
                                       >   
    B5     BACKGROUND MENU OPTION # 6 
                                          
    B6     BACKGROUND MENU OPTION # 7 
    B7     BACKGROUND MENU OPTION # 8 
    B8     BACKGROUND MENU OPTION # 9 
    B9     BACKGROUND MENU OPTION # 10

    CD     CHANGE DEBUG MODE          (  )
    CF     CLEAR FIELD                ( )
    CM     INSERT/REPLACE             (/)
    CS     CHANGE SPECIAL WINDOW      (  )

    DC     DELETE CHARACTER           ( )
    DF     DISPLAY FUNCTION KEYS      (   )

    E1     ENTER/EXECUTE O/S COMMAND  (/  )
    EA     ENTER APPLICATION          (  )
           PARAMETERS
    EM     ENTER MENU PARAMETERS      (  )
    EO     INTERACTIVE O/S COMMAND    (  )

    H      HELP                       ()
    IL     UNDEFINED                  ( )
    MD     MOVE CURSOR DOWN           (  )

                                   -- 123 --



    ML     MOVE CURSOR LEFT           (  )
    MM     GO TO MAIN MENU            (   )
    MR     MOVE CURSOR RIGHT          (  )

    MU     MOVE CURSOR UP             (  )
    NF     NEXT FIELD                 ( )
    PF     PREVIOUS FIELD             ( )

    PM     PREVIOUS MENU              ( )

    RS     REDISPLAY SCREEN           ( )
    RU     REDEFINE                   ( _-
           USERNAME/PASSWORD           /)

    SB     SHOW BACKGROUND MENU       (  )
    TM     TERMINATE INPUT ON FORM    (   )
    X      EXIT                       ()










































                                   -- 124 --
