empsldv

EMPSLDV(1)                                                          EMPSLDV(1)



NAME
       empsldv - loads data from a dumpfile into an Empress table

SYNOPSIS
       empsldv [ -c | -d [count] | -l | -r reject_file]
                       dump_file database table ["where_clause"]

DESCRIPTION
       Empsldv  is a general purpose utility for loading fixed length or vari-
       able length data from a dumpfile into an Empress table. It accepts  the
       data in the Empress dump format and allows the user to:

       1)    Load all the data from the dumpfile into the table, or only those
            qualified the optional where clause.

       2)   Load the data into any Empress data  types,  with  automatic  data
            type conversion.

       3)    Generate a reject file for those records that could not be loaded
            due to datatype error, for example.

       4)   Examine the input file for invalid data.




       -c             To check the dumpfile for valid data. This  option  sup-
                      presses  the  actual  loading  of the data.  This option
                      only detects the errors in the format and the  datatypes
                      such  as  loading  a  character  field  into  a  decimal
                      attribute; not the errors in the table constraints  such
                      as loading duplicate values into a unique indexed key.

       -d  [count]     To  display  each  attribute  name along with the field
                      value to be loaded into the attribute  to  the  standard
                      output.   Only the first 30 characters of field value is
                      printed.  If the count (an integer) is given then  count
                      records  will be displayed. If the count is omitted then
                      all the records will be displayed.

       -l             To lock the table at table level  during  loading.   You
                      should  use  this  option if the number of records to be
                      loaded is greater than the value of the Empress variable
                      MSFILESLOCKNLOCKS. In addition, locking the table at ta-
                      ble level speeds up the loading process.

       -r reject_file To generate the reject_file containing the records  that
                      failed to be loaded. The reject_file must not exist.








       Notes



            1.    The  user  must  have  "insert" privilege on the table to be
                 loaded.

            2.   The datafile must be in the Empress  dump  format.  For  more
                 information  on  the  dumpfile,  please  refer to the Empress
                 select statement in the SQL reference manual.  You  may  also
                 want  to  refer  to  the  two  Empress  environment variables
                 MSVALSEP and MSLINECONT.

            3.   Since empsldv was designed for efficient selective loading of
                 variable  length (text, bulk) data, the where_clause must not
                 reference any variable length attribute.

            4.   Upon completion, empsldv prints  a  count  of  records  read,
                 qualified,  inserted and rejected to the standard output.  If
                 the where_clause was specified then  the  number  of  records
                 qualified   is   the  number  of  records  that  qualify  the
                 where_clause. If the where_clause was omitted, then the  num-
                 ber of records qualified is the number of records read.



FILES
       EMPRESS database files

SEE ALSO
       empmkdb(1), empcmd(1), empsdump(1)


DIAGNOSTICS
       Error  diagnostics  are  printed  if no database is specified or if the
       database is not in the EMPRESS format.

HISTORY
       Written by Empress Software Inc..   All  material  is  copyrighted  and
       licensed.  Use on non-licensed CPUs is prohibited.




Empress 8.62                 Empress Software Inc.                  EMPSLDV(1)