COPY_EBUS_INDEXFILE_TO_JDBC
|
Syntax: |
COPY_EBUS_INDEXFILE_TO_JDBC(<Name of Index
File>) <Name of Index File> = <INDEX
FILE> |
||||||||||||||
|
Meaning: |
Copies then content of an EBUS Index File to
a JDBC Index File. Ebus Index Files are stored in files whereas
JDBC Index Files are stored in SQL databases. COPY_EBUS_INDEXFILE_TO_JDBC copies all data
records of the Ebus Index File <Name of Index File> to an SQL database.
The necessary informations about the SQL database have to be defined by the
following instructions: JDBC_DRIVER specifies the JDBC driver. JDBC_DATABASE specifies the name of the database in which the Index File is
opened. JDBC_TABLE specifies the table name of the Index File in the database. JDBC_USERID specifies the userid. JDBC_PASSWORD specifies the password. COPY_EBUS_INDEXFILE_TO_JDBC returns the
number of records that have been copied or an error code:
|
||||||||||||||
|
Parameter: |
|
||||||||||||||
|
Sample: |
JDBC_DRIVER(CUSTOMER) =
"com.ibm.db2.jcc.DB2Driver" JDBC_DATABASE(CUSTOMER) =
"jdbc:db2://localhost:50000/sample" JDBC_TABLE(CUSTOMER) = "Customer" JDBC_PASSWORD(CUSTOMER) = "Xyz123" JDBC_USERID(CUSTOMER) = "Hugo" NUMBER% = COPY_EBUS_INDEXFILE_TO_JDBC(CUSTOMER) IF NUMBER% < 0 THEN ERRORMES
= "Error " + STR$(NUMBER%) ENDIF |
||||||||||||||
|
See also: |
|