wb_import_file

PHP Interface

Information about Cursors

wb_data_transport

Parameters

connection

Identifier of the open connection returned by the wb_connect or wb_pconnect functions.

move_descr_obj_name

Name of the object defining the data transfer or NULL.

src_conn

Connection to the data transfer source.

trg_conn

Connection to the data transfer target.

src_schema

Scheme in the data transfer source.

trg_schema

Scheme in the data transfer target.

src_name

Table, query or file containing the source data.

trg_name

Table or file to write data.

src_format

Format of the data transfer source.

trg_format

Format of the data transfer target.

src_code

Source file coding.

trg_code

Target file coding.

flags

Flags affecting the function.

Description

This function provides data transfer between 602SQL Servers, ODBC data sources and files in various formats.

The transfer description is in the move_descr_obj_name object. If the move_descr_obj_name is set (not NULL), then the function will read this description from the database connected with the connection identifier to the connection database. The entries set in the transfer description are then modified according to the function parameters beginning with the src_schema parameter. If some parameter equals NULL or -1, it will be ignored and the entry from the transfer description will be used.

The src_conn and trg_conn parameters represent connection to the data source and target. They may equal NULL only if the source/target is a text or DBF file.

If the move_descr_obj_name is NULL, then the function will create a default transfer design based on the function parameters in the same way as the interactive designer. The connection parameter value is ignored.

If the flags parameter is set to 1, then indexes will not be rebuilt in real time when transferring data into a 602SQL table. The index will be discarded and rebuilt from scratch after the transfer is done. This may affect the operation time depending on the amount of data in the table before the transfer and the amount of transferred data.

Type and format of the target and source of the data transfer are further described by the src_format and trg_format parameters according to the following table:

Based on the parameter values, the data source and target are described in one of these ways:

Table or Query in 602SQL

A table can be both a target or a source of the data transfer. A query may only be the source. The connection identifier to 602SQL (the result of the wb_connect or wb_pconnect function) is then the src_conn or trg_conn parameter. The scheme on this server is then the src_schema or trg_schema and the table name or the query in this scheme is then the src_name or trg_name parameter. The src_code or trg_code parameter values are ignored.

The specified scheme and source table or query must exist. If the data transfer target is a database table, that does not exist yet, it will be created according to the transfer design.

Table or Query Accessed via ODBC

A table can be both the source and target of data transfer; a query can be only the source. The src_conn or trg_conn parameter then describes connection to the ODBC data source:

• by an array where the "dsn" element contains the ODBC data source name, the "uid" element contains user name for login to the ODBC data source and the "pwd" element contains password for login to the ODBC data source. Elements "uid" and "pwd" are optional;
• by means of wb_odbc_connect function value - this is a recommended alternative.

If the array is passed, then wb_data_transport function opens connection to the ODBC data source, it executes the transfer and closes the connection. When transferring the open connection to the ODBC data source, this function does not close the connection (it is closed by means of wb_odbc_disconnect).

The src_schema or trg_schema parameter is an eventual schema or another qualifier of the object names in this ODBC data source and the src_name or trg_name is table name or query name. As long as the ODBC data source does not use schemas or other qualifiers, then an empty string could be a parameter determining this schema. Value of the src_code or trg_code parameter is ignored.

Both the source and target must exist.

File in a supported format

The src_name or trg_name parameter contains the file name (usually with the full path). The src_conn and src_schema or trg_conn and trg_schema parameter values are ignored. The src_code or trg_code parameter value describes the file coding as follows:

This function has the same restrictions as the Data_transport function.

Returns

TRUE if successful, otherwise it is FALSE.

Example

Data transfer from an ODBC data source to a 602SQL table (1. method - I have created an object of the transfer type (in this case called MySQLODBC_602tab) - it is better in the possibility to verify the transfer in the 602SQL Client in advance):

  $conn=wb_connect($cfg_dbconn_database,$cfg_dbconn_application,$cfg_dbconn_username,$cfg_dbconn_password) or die;
  $odbc_resource=wb_odbc_connect("MySQL test","user","password") or die("MySQL odbc connect failed");

  $result = wb_data_transport(
    $conn,
    "MySQLODBC_602tab",
    $odbc_resource,
    $conn,
    "",
    "",
    "",
    "",
    NULL,
    NULL,
    -1,
    -1,
    -1);
  if( $result==FALSE ) { /* handle the error */ }
  else { echo "transfer succesful\n"; };
  wb_odbc_disconnect($odbc_resource);
 

Data transfer from the ODBC data source to the table in 602SQL (2. method - I need not have created an object of the transfer type, however, if the transfer fails, it is very complicated to find an error):

  $conn=wb_connect($cfg_dbconn_database,$cfg_dbconn_application,$cfg_dbconn_username,$cfg_dbconn_password) or die;

  $result = wb_data_transport(
    $conn,
    NULL,
    array("dsn" => "odbc_data_source_name","uid" => "user","pwd" => "password"),
    $conn,
    "odbc_schema",
    "scheme",
    "odbc_table",
    "table",
    IMPEXP_FORMAT_ODBC,
    IMPEXP_FORMAT_TABLE,
    -1,
    -1,
    1); 
  if( $result==FALSE ) { /* handle the error */ }
  else { echo "transfer succesful\n"; }		

wb_import_file

PHP Interface

Information about Cursors