Row type must have its values surrounded by parentheses and a field delimiter separating each element. You can use a different currency notation if you indicate this notation with the DBMONEY environment variable.įor more information on this environment variable, see the Informix Guide to GLS Functionality. Value that can include currency notation: a leading currency symbol ($), a comma (,) as the thousands separator, and a period (.) as the decimal separator. You can use a different date format if you indicate this format with the GL_DATE or DBDATE environment variable.įor more information about these environment variables, see the Informix Guide to GLS Functionality. (You can specify another century algorithm with the DBCENTURY environment variable.) The value must be an actual date for example, February 30 is illegal. You can use a two-digit number for the year if the year is in the 20th century. You must state the month as a two-digit number. You can include leading blanks in fields that do not correspond to character columns.Ī 't ' or ' T ' indicates a TRUE value, and an ' f ' or ' F ' indicates a FALSE value.Ĭollection must have its values surrounded by braces () and a field delimiter separating each element.įor more information, see Loading Complex Types.Ĭharacter string in the following format: mm/dd/year. One or more blank characters between delimiters. The following table indicates how the database server expects you to represent the data types in the LOAD FROM file (when you use the default locale, U.S. Specify only values that can convert to the data type of the corresponding column. You must define field lengths that are less than or equal to the length that is specified for the corresponding column. If you do not include a list of columns in the INSERT INTO clause, the fields in the file must match the columns that are specified for the table in number, order, and data type.Įach line of the file must have the same number of fields. You can use the file that the UNLOAD statement creates as the LOAD FROM file. The LOAD FROM file contains the data to add to a table. For information on database-level and table-level privileges, see the GRANT statement. To use the LOAD statement, you must have Insert privileges for the table where you want to insert data. You cannot add a row that has the same key as an existing row.
The LOAD statement appends new rows to the table. Name of the view in which you want to insert data Name of the table in which you want to insert data The synonym and the table to which the synonym points must exist. Name of the synonym for the table in which you want to insert data Pathname and filename must conform to the naming conventions of your operating system. The default pathname for the load file is the current directory. The load file contains the data to be loaded into the specified table or view. Quoted string that identifies the pathname and filename of the load file You cannot use any of the following characters as a delimiter: backslash (\), newline character (= CTRL- J), and hexadecimal numbers (0-9, a-f, A- F). If DBDELIMITER has not been set, the default delimiter is the pipe (|). The default delimiter is the character set in the DBDELIMITER environment variable. Quoted string that identifies the character to use to separate the data values in each line of the load file You must also specify columns if the order of the fields in the load file does not match the default order of the columns in the table (the order established when the table was created). You must specify the columns that receive data if you are not loading data into all columns. Name of a column or columns that receive data values from the load file during the load operation
0 kommentar(er)
