:


                          || h4util 12--92|

DbcheckE       .
DdbloadE      ascii    INFORMIX
DdbexportE       ASCII .
DdbimportE      ASCII .
DdbschemaE     SQL  .
DdbupdateE    SQL 1.0    SQL 2.0
DmkmessageE    .
DsqlconvE   INFORMIX-  SQL- .
DupscolE         -
                   ,
           .
DdblogE {logfile}  Informix-SE  C-ISAM log .




        
 Informix-SE. (  .idx  .dat )

bcheck -ilnyqs cisamfiles ...
      -i      
      -l   list entries in b-trees
      D-nE   ,      No
      -y   ,      Yes
      -q   no program header
      -s   resize the index file node size



   ASCII     INFORMIX. 
     INFORMIX,    
( INFORMIX)    .

          :
         -
          
 .

      .

 n . ( -i)

    .

       NULL .

    ,      
.

      error log .

     ,    -
.   ,  . ( -e)

       ,  
     . ( -n)

dbload [-d dbname] [-c cfilname] [-l errlogfile] [-e errnum]
   [-n nnum] [-i inum] [-s] [-p] [-r]
        -d        
        -c        
        -l      log file   
        -e      -  . before abort
        -n      - of row(s) before commit
        -i         .
        -s         
        -p        : commit  
        -r         

          :

     .

    NewLine (^J=10   ASCII)

     .

   ,       -
- .

 :                     mm/dd/yyyy

 DATETIME  INTERVAL:     yyyy-mm-dd hh:mi:ss.fff

           dbload :

1.  FILE ,    
2.   INSERT  ,  ,   
     .


  DELIMETER,     f01, f02, ...
                                   
FILE  {"file-name"}     { DELIMITER "c"    nfields  |
                                       NULL 
       ( field1    start [ - end ] [: ...] [NULL="null-str1"] ,
         field2    start [ - end ] [: ...] [NULL="null-str2"] ,
                       .  .  .
         fieldN start [ - end ] [: ...] [NULL="null-strN"] ) }D;E
               []
INSERT INTO table-name [(column-list)] [VALUES (values-list)] D;E
                                       
[ . . . ]



      ASCII ,   
   .      database
name.exp.      database-name.sql  -
  .

dbexport database-name  [-c] [-q] [{-o  |
  -t  -b  -s  [-f ]}]
        -c      ,    
        -q         
        -o         
        -t          (./dev/rmt)
        -b         
        -s       
     -f           


    4.   DdbimportE       ASCII  INFORMIX


     ASCII ,  -
 dbexport.

dbimport  [-c] [-q]
  [-l [{ buffered |  }] [-ansi]]  [{ -i  |
   -t  [ -b  -s  ] [-f ]}]
     
        -c      ,    
        -q         
        -i         
        -t          (.  /dev/rmt)
        -b         
        -s       
        -f            .
        -d      (  OnLine)
        -l          logfile
           
      buffered  (  OnLine)
       -ansi        MODE ANSI


    5.   DdbschemaE     SQL    


    SQL,  ,    
   .

dbschema [-t tabname] [-s user] [-p user] -d dbname [filename]
      -t  ,     
    -t       
    -s      ,    user
    -p          user
    -d        
  filename   ,    SQL 


    6.   DmkmessageE      


   ,     4GL
.

mkmessage [-v] [-dMACRO] input_file output_file


    7.   DupscolE          


        
  ,     .  
       -
    ,       
.        
.

upscol


    8.   DdbupdateE     Upgrade  SQL 1  SQL 2


  ,   SQL  1   
SQL  2 (.     INFROMIX).

dbupdate [-bn] old-db-name new-db-name
    -n              NOT NULL
    -b               NULL, -
                ,   0  NULL
               NULL,
                ,   0  NULL


    9.   DsqlconvE          


   SQL  4GL,  -SQL  -
  INFORMIX-      SQL- 
   INFORMIX.

sqlconv [-4gl][-esql] databasename
     -4gl          4GL.
     -esql        ESQL/C.
   ,       SQL


    10.  DdblogE         SE  C-ISAM log 


 Informix-SE  C-ISAM log .

DdblogE {logfile}


Last-modified: Sun, 27 Jul 1997 20:01:08 GMT

  :