Laserfiche WebLink
INFORMIX-Net is responsible for establishing connections and transmitting relevant user validation <br />information to the database server machine(s). <br />For developers, what "include" files are necessary in source code, and what libraries need <br />? <br />to be linked when compiling? <br />Several header files are provided with INFORMIX-ESQL/C, all of which are located in the <br />$INFORMIXDIR/incl directory. An INFORMIX-ESQL/C program can include the following <br />header files: <br />sqlca.hContains the structure in which error status codes are stored. This file is <br />automatically included when a program is preprocessed, to allow checking the <br />success or failure of SQL statements. <br />sqlda.hContains the structures that contain value pointers and descriptions of <br />dynamically defined variables. <br />sqlstype.hContains integer constants corresponding to SQL statements. <br />sqltypes.hContains the definitions of strings corresponding to C language and SQL data <br />types. <br />varchar.hContains macros that be can used with VARCHAR data types. <br />locator.hContains the structure in which information about the locations of blobs (BYTE <br />and TEXT data types) is stored. <br />sqlxtype.hContains the definitions of strings corresponding to C language and SQL data <br />types that are used when in X/Open mode. <br />decimal.hContains the definition of the structure in which a DECIMAL data type is <br />stored. <br />datetime.hContains the definition of the structures in which DATETIME and INTERVAL <br />data types are stored. <br />Other ESQL/C files can be included in addition to header files. This is done by using the <br />preprocessor statement "$include" or "EXEC SQL include" (e.g., $include myprogram or EXEC <br />SQL include myprogram). <br />What reference documents are used to define ESQL syntax? <br />? <br />INFORMIX includes a programmer's manual as well as a SQL User's Guide and SQL reference <br />manuals as part of the ESQL/C development product. INFORMIX also offers a 3 to 4-day ESQL/C <br />training course that comes with additional supporting ESQL/C documentation. <br />Are there limitations to the size of data objects that can be accessed from the database? <br />Other than a 2-gigabyte limit on the size of a single blob (BYTE or TEXT data type) the <br />? <br />limitations are machine-dependent. <br />What are the security issues involved with using ESQL (can anyone write code to read the <br />? <br />database)? <br />Security for INFORMIX databases is always handled via the User's UNIX login and <br />specific SQL permission statements (e.g., GRANT CONNECT TO USER, GRANT <br />SELECT ON TABLE TO USER). <br />2 <br />A275 05.10.94 1.05-7 Malers, Rohlfs <br />