INFORMIX
Informix-ESQL/C Programmer's Manual
Appendix A: List of ESQL/C Library Functions
Home Contents Index Master Index New Book

List of ESQL/C Library Functions

All the library functions provided with INFORMIX-ESQL/C appear alphabetically in the following table.

(1 of 8)

Function Name Description Page

bycmpr()

Compares two groups of contiguous bytes

3-21

bycopy()

Copies bytes from one area to another

3-24

byfill()

Fills the specified area with a character

3-26

byleng()

Counts the number of bytes in a string

3-28

decadd()

Adds two decimal numbers

4-9

deccmp()

Compares two decimal numbers

4-11

deccopy()

Copies a decimal number

4-14

deccvasc ()

Converts a C char type to a decimal type

4-16

deccvdbl()

Converts a C double type to a decimal type

4-19

deccvint()

Converts a C int type to a decimal type

4-21

deccvlong()

Converts a C long type to a decimal type

4-23

decdiv()

Divides two decimal numbers

4-25

dececvt()

Converts a decimal value to an ASCII string

4-28

decfcvt()

Converts a decimal value to an ASCII string

4-28

decmul()

Multiplies two decimal numbers

4-35

decround()

Rounds a decimal number

4-37

decsub()

Subtracts two decimal numbers

4-40

dectoasc()

Converts a decimal type to an ASCII string

4-42

dectodbl()

Converts a decimal type to a C double type

4-45

dectoint()

Converts a decimal type to a C int type

4-47

dectolong()

Converts a decimal type to a C long type

4-50

dectrunc()

Truncates a decimal number

4-52

dtaddinv()

Adds an interval value to a datetime value

6-40

dtcurrent()

Gets current date and time

6-42

dtcvasc()

Converts an ANSI-compliant character string to datetime

6-44

dtcvfmtasc()

Converts a character string to a datetime value

6-47

dtextend()

Changes the qualifier of a datetime

6-51

dtsub()

Subtracts one datetime value from another

6-54

dtsubinv()

Subtracts an interval value from a datetime value

6-57

dttoasc()

Converts a datetime value to an ANSI-compliant character string

6-59

dttofmtasc()

Converts a datetime value to a character string

6-62

ifx_cl_card()

returns the cardinality of the specified collection type host variable

9-45

ifx_dececvt()

Converts a decimal value to an ASCII string (thread-safe version)

13-31

ifx_decfcvt()

Converts a decimal value to an ASCII string (thread-safe version)

13-31

ifx_getcur_conn_name()

Returns the name of the current connection

12-48

ifx_getserial8()

Returns an inserted SERIAL8 value

5-10

ifx_int8add()

Adds two int8 numbers

5-12

ifx_int8cmp()

Compares two int8 numbers

5-13

ifx_int8copy()

Copies a int8 number

5-14

ifx_int8cvasc()

Converts a C char type value to a int8 type value

5-15

ifx_int8cvdbl()

Converts a C double type value to a int8 type value

5-17

ifx_int8cvint()

Converts a C int type value to a int8 type value

5-19

ifx_int8cvlong()

Converts a C long type value to a int8 type value

5-20

ifx_int8div()

Divides two int8 numbers

5-21

ifx_int8mul()

Multiplies two int8 numbers

5-22

ifx_int8sub()

Subtracts two int8 numbers

5-23

ifx_int8toasc()

Converts a int8 type value to a text string

5-24

ifx_int8todbl()

Converts a int8 type value to a C double type value

5-26

ifx_int8toint()

Converts a int8 type value to a C int type value

5-28

ifx_int8tolong()

Converts a int8 type value to a C long type value

5-29

ifx_lo_alter()

Alters the storage characteristics of an existing smart large object

7-36

ifx_lo_close()

Closes an open smart large object

7-38

ifx_lo_col_info()

Obtains column-level storage characteristics into an LO-specification structure

7-39

ifx_lo_copy_to_file()

Copies a smart large object into an operating-system file

7-41

ifx_lo_copy_to_lo()

Copies an operating-system file into an open smart large object

7-44

ifx_lo_create()

Creates an LO descriptor for a smart large object

7-46

ifx_lo_def_create_spec()

Allocates an LO-specification structure and initializes its fields to null values

7-49

ifx_lo_filename()

Returns the generated file name, given an LO descriptor and a file specification

7-50

ifx_lo_from_buffer()

Copies bytes from a user-defined buffer into smart large object

7-52

ifx_lo_open()

Opens an existing smart large object

7-53

ifx_lo_read()

Reads a specified number of bytes from an open smart large object

7-55

ifx_lo_readwithseek()

Seeks to a specified position in an open smart large object and reads a specified number of bytes

7-57

ifx_lo_release()

Releases resources associated with a temporary smart large object

7-59

ifx_lo_seek()

Sets the seek position for the next read or write on an open smart large object

7-61

ifx_lo_spec_free()

Frees the resources allocated to an
LO-specification structure

7-63

ifx_lo_specget_estbytes()

Gets the estimated number of bytes from the LO-specification structure

7-64

ifx_lo_specget_extsz()

Gets the allocation extent size from the
LO-specification structure

7-66

ifx_lo_specget_flags()

Gets the create-time flags from the
LO-specification structure

7-67

ifx_lo_specget_maxbytes()

Gets the maximum number of bytes from the LO-specification structure

7-69

ifx_lo_specget_sbspace()

Gets the name of the sbspace from the
LO-specification structure

7-80

ifx_lo_specset_estbytes()

Sets the estimated number of bytes from the LO-specification structure

7-73

ifx_lo_specset_extsz()

Sets the allocation extent size in the
LO-specification structure

7-75

ifx_lo_specset_flags()

Sets the create-time flags in the
LO-specification structure

7-77

ifx_lo_specset_maxbytes()

Sets the maximum number of bytes in the LO-specification structure

7-79

ifx_lo_specset_sbspace()

Sets the name of the sbspace in the
LO-specification structure

7-80

ifx_lo_stat()

Returns status information about an open smart large object

7-81

ifx_lo_stat_atime()

Returns the last access time for a smart large object

7-83

ifx_lo_stat_cspec()

Returns the storage characteristics into the LO-specification structure for a specified smart large object

7-84

ifx_lo_stat_ctime()

Returns the last change-in-status time for the smart large object

7-86

ifx_lo_stat_free()

Frees the resources allocated to an LO-status structure

7-87

ifx_lo_stat_mtime_sec()

Returns the last modification time, in seconds, for the smart large object

7-88

ifx_lo_stat_refcnt()

Returns the reference count for the smart large object

7-89

ifx_lo_stat_size()

Returns the size of the smart large object

7-91

ifx_lo_tell()

Returns the current seek position of an open smart large object

7-92

ifx_lo_to_buffer

Copies bytes from smart large object into a user-defined buffer

7-93

ifx_lo_truncate()

Truncates a smart large object to a specific offset

7-95

ifx_lo_write()

Writes a specified number of bytes to an open smart large object

7-96

ifx_lo_writewithseek()

Seeks to a specified position in an open smart large object and writes a specified number of bytes

7-98

incvasc()

Converts an ANSI-compliant character string to an interval value

6-66

incvfmtasc()

Converts a character string to an interval value

6-69

intoasc()

Converts an interval value to an ANSI-compliant character string

6-72

intofmtasc()

Converts an interval value to a string

6-75

invdivdbl()

Divides an interval value by a numeric value

6-78

invdivinv()

Divides an interval value by an interval value

6-81

invextend()

Copies an interval value under a different qualifier

6-83

invmuldbl()

Multiplies an interval value by a numeric value

6-86

ldchar()

Copies a fixed-length string to a null-terminated string

3-30

rdatestr()

Converts an internal format to string

6-6

rdayofweek()

Returns the day of the week

6-8

rdefmtdate()

Converts a string to an internal format

6-10

rdownshift()

Converts all letters to lowercase

3-32

rfmtdate()

Converts an internal format to a string

6-14

rfmtdec()

Converts a decimal type to a formatted string

5-37

rfmtdouble()

Converts a double type to a string

5-41

rfmtlong()

Converts a long integer to a formatted string

5-44

rgetlmsg()

Retrieves the error message for a large error number

11-49

rgetmsg()

Retrieves the error message for an error number

11-52

risnull()

Checks whether a C variable is null

2-24

rjulmdy()

Returns month, day, and year from an internal format

6-17

rleapyear()

Determines whether a specified year is a leap year

6-19

rmdyjul()

Returns an internal format from month, day, and year

6-21

rsetnull()

Sets a C variable to null

2-27

rstod()

Converts a string to a double type

3-34

rstoi()

Converts a null-terminated string to a short integer

3-36

rstol()

Converts a string to a long integer

3-38

rstrdate()

Converts a string to an internal format

6-23

rtoday()

Returns a system date in internal format

6-26

rtypalign()

Aligns data on a proper type boundary

2-30

rtypmsize()

Gives byte size of SQL data types

2-33

rtypname()

Returns the name of a specified SQL type

2-36

rtypwidth()

Gives minimum conversion byte size

2-39

rupshift()

Converts all letters to uppercase

3-40

sqgetdbs()

Returns the names of the databases that a database server can access

12-49

sqlbreak()

Sends the database server a request to stop processing

12-52

sqlbreakcallback()

Provides a method of returning control to the application while it is waiting for the
database server to process an SQL request

12-54

sqldetach()

Detaches child process from parent process

12-57

sqldone()

Determines whether the database server is currently processing an SQL request

12-64

sqlexit()

Terminates a database server process

12-65

sqlsignal()

Performs signal handling and child-processes cleanup

12-66

sqlstart()

Starts a database server process

12-68

stcat()

Concatenates one string to another

3-42

stchar()

Copies a null-terminated string to a fixed-length string

3-44

stcmpr()

Compares two strings

3-46

stcopy()

Copies one string to another string

3-48

stleng()

Counts the number of bytes in a string

3-50




Informix-ESQL/C Programmer's Manual, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.