Good bosses,

I ask, I now have an OA system (SQL) database is to sign the nuclear data written to the ERP in the DB2 database, save artificial key data in ERP system, how to implement, the operation can
What to write on the SQL to perform a task, how to configure ODBC to connect to the DB2 SQL, please experienced teacher give guidance, thank you very much,

CodePudding user response:

Methods method are many, I CSV, I guess the DB2 should support the CSV file, if not calculate I didn't say
First in SQL replace text in the column of text with $$$(replace bean, [and] with $$$, avoid conflict), and remitted into *. CSV
DB2 import after the CSV file, and then the column number in $$$for bean

CodePudding user response:

Through CSV format into DB2 requires manual, I wanted to write a program interface, SQL database through the ODBC DB2 writes in a table,

CodePudding user response:

To build a model SQL Insert
String SQLinsert="INSERT INTO XX1 (Column1, Column2) values (' {0} ', '{1});"

SQL data read
String SQLread="Select * from Table1"//read MS SQL data
The DataTable dt=FunDataTableCreate (SQLread);

String SQLrun="";
Do a loop, produce the INSERT SQL
Foreach (DataRow Dr In dt. Rows)
{
SQLrun=SQLrun + string Format (SQLinsert, Dr [Column1]. ToString (), Dr [Column2]. ToString ());
{

In DB2 threads execute the SQLrun

CodePudding user response:

Hello, can you tell me the SQL and DB2 connection, using IBM I Access for Windows configuration ODB hello, excuse me SQL and DB2 connection, using IBM I Access for Windows to configure ODBC played well C

CodePudding user response:

Haven't played with DB2, so not clear IBM I Access for Windows usage