Hi,
I am trying to migrate a database from Sybase to db2. My DB2 version is 'v8.1.11.973' FixPack 11. I have unloaded the data into files and am trying to import it in my db2 database in a C++ program. The code looks like this:

sSQL.Format("import from 'f:/unload/%d.dat' of del modified by coldel^ commitcount 5000 messages 'f:/unload.txt' insert into SMART_GROUP.%s;",nTableID,(LPCSTR)tableName);
{
DBExt.GetCon().ExecuteSQL(sSQL);
}

That is of course in a loop. I am receiving the following errror - sql0007n - 'The character "^" following " del modified by coldel" is not valid'.I don't get this error when I execute the same command in the Command Editor. When I change the column delimiter to ',' I get the error - SQL0104N 'An unexpected token "import" was found following "BEGIN-OF-STATEMENT".' . I just read somewhere that it is impossible to import data through ODBC, I guess that is the problem. So my question is how can I do a mass storage import in DB2?

Thanks in advance,Emil

Why do you need to do the import command from a C++ program? It is easier to do it from a shell script on a machine with a DB2 client installed (or directly on the database server).

Well I don't really need it to be executed from a C++ program,it was simply the way I did it previously when I was migrating another database from Sybase to Postgre, I had no problems then. Can you give me any hints/links to what that shell script must look like?

You basically have the command in your code:

db2 "import from 'f:/unload/file.dat' of del modified by coldel^ commitcount 5000 messages 'f:/unload.txt' insert into schema.table-name"

You can use the Control Center to generate most commands (including IMPORT) and see the script without submitting it.

I know all of that, but I want to generate a script which will transfer the data of ALL my tables at once. I don't want to execute every single import by hand! ~1000 tables * ~50 servers = Nightmare! The code snippet which I have posted is executed in a loop for ALL the tables in the database, you can see the tableName parameter. Any ideas?

What you can do is generate the required scripts based on the tables in syscat.tables something likeselect the gerenated tekst and execute it.