<<

Contents

Search

>>

 

COPY_JDBC _INDEXFILE_TO_ EBUS

 

 

Function

 

 

Syntax:

COPY_JDBC_INDEXFILE_TO_EBUS(<Name of Index File>)

 

<Name of Index File> = <INDEX FILE>

 

Meaning:

Copies then content of a JDBC Index File to an EBUS Index File.

 

Ebus Index Files are stored in files whereas JDBC Index Files are stored in SQL databases.

 

COPY_JDBC_INDEXFILE_TO_EBUS copies all data records of the JDBC Index File <Name of Index File> to an Ebus Index File. The path of the Ebus Index File has to be specified by the instruction PATH.

 

COPY_JDBC_INDEXFILE_TO_EBUS returns the number of records that have been copied or an error code:

 

Error code

Meaning

-1

Invalid file number

-2

<Name of Index File> is not an JDBC Index File but an Ebus Index File.

-3

<Name of Index File> contains no data records.

-4

Error opening the JDBC table. OK, OK2 and ERRORTEXT$ contain the error information.

-5

Error reading the JDBC Index File. OK, OK2 and ERRORTEXT$ contain the error information.

-6

Error writing the Ebus Index File. OK, OK2 and ERRORTEXT$ contain the error information.

 

Parameter:

Name of Index File

Name of Index File

 

Sample:

PATH(CUSTOMER) = "C:\Data"

 

NUMBER% = COPY_JDBC_INDEXFILE_TO_EBUS(CUSTOMER)

 

IF NUMBER% < 0

THEN ERRORMES = "Error " + STR$(NUMBER%)

ENDIF

 

See also:

COPY_EBUS_INDEXFILE_TO_JDBC

CHANGE_FILETYPE

PATH