Databases Reference
In-Depth Information
// pa_col1 is an array of character strings
break;
case 2: rc = SQLBindParameter (hstmt, counter,
SQL_PARAM_INPUT, SQL_C_CHAR, (SWORD) ptype,
(UDWORD) prec, (SWORD) scale,
pa_col2, sizeof(pa_col2[0]), cbValue2);
// pa_col2 is an array of character strings
break;
case 3: rc = SQLBindParameter (hstmt, counter,
SQL_PARAM_INPUT, SQL_C_CHAR, (SWORD) ptype,
(UDWORD) prec, (SWORD) scale,
pa_col3, sizeof(pa_col3[0]), cbValue3);
// pa_col3 is an array of character strings
break;
...
default: break;
}
Environment Details
The environment details are as follows:
•
Order management is done using a legacy AS/400 application. Every night, a
batch job exports the AS/400 data into an XML document that is then trans-
ferred to a Linux machine using FTP. As part of a nightly consolidation
process, an ODBC application reads in the contents of the XML document
and bulk loads the data into an Oracle database.
•
Auto-commit is turned off in the application.
•
The application is reading the data in as character strings and binding the
data on the server as the appropriate numeric type, such as int or floating
point.
•
The bulk load application is on a Linux machine.
•
The Oracle database is on a Windows machine.
The Issue
The performance (response time) of the bulk load operation is too slow. Is there
any way to speed up the bulk load operation?