The following rules apply for specifying the path of a filename in a function argument, depending on whether the file resides on the client or server computer:

The third argument specifies whether the target file is located on the client computer ('client') or server computer ('server'). The second argument specifies the name of the file into which data is to be copied. The first argument for LOTOFILE() specifies the name of the column from which data is to be exported. SELECT id_num, LOTOFILE(felony, 'felon_322.txt', 'client') The following SELECT statement uses the LOTOFILE () function to copy data from the felony column into the felon_322.txt file that is located on the client computer: Suppose you create the inmate and fbi_list tables, as Figure 4-2 shows. For examples of how to use the preceding functions in INSERT and UPDATE statements, see Chapter 6. You can use any of the functions that Figure 4-1 shows in SELECT, UPDATE, and INSERT statements. Query 4-1 counts and displays the total number of rows in the stock table.Ĭopies BLOB or CLOB data into another BLOB or CLOB column.įor detailed information and the syntax of smart-large-object functions, see the Expression segment in the Informix Guide to SQL : Syntax. When you apply an aggregate function to an entire table, the result contains a single row that summarizes all the selected rows. opaque data types (unless user creates aggregate functions)Īggregates are often used to summarize information about groups of rows in a table.You cannot use aggregate functions for expressions that contain the following data types: In the absence of a WHERE clause, the aggregate functions take on values that depend on all the rows that the FROM clause forms. The aggregate functions take on values that depend on the set of rows that the WHERE clause of the SELECT statement returns. This set of expressions contains the time function and the length function when they are used with a column name as an argument.Īll Informix database servers support the following aggregate functions:Īn aggregate function returns one value for a set of queried rows. All function expressions require arguments. You can use any basic type of expression (column, constant, function, aggregate function, and procedure), or combination thereof, in the select list.Ī function expression uses a function that is evaluated for each row in the query.

Informix dbschema function