I'm importing data from SQL Server to DB2 on a Linux box using the IMPORT statement and using the DEL file format. It works beautifully.

When I issue the same IMPORT statement against DB2 on z/OS it gives me

SQL1325N The remote database environment does not support the command or one of the command options.

Is the DEL file format not supported on DB2 for z/OS? If not, how does one convert a ASC output from SQL Server to IXF format? Is there any other way to move data between SQL Server and DB2? I have tried ODBC / OLEDB connections but haven't been successful.

TIA.

AFAIK, DB2 for z/OS does support the DEL format in its LOAD utility. (There is no IMPORT utility.)
Did you check the syntax for LOAD? See http://publibz.boulder.ibm.com/cgi-b...20040209165609 (for DB2 v8) or http://publibz.boulder.ibm.com/cgi-b...20030507154051 (for DB2 v7).
Make sure to specify (at least) the options "FORMAT DELIMITED" and "ASCII".

your problem is that import over drda only supports ixf format and not del..
what peter says : bring the file to mvs and start the import locally and not over drda.

I'm using the following statement on the Linux box to import and it works like a charm, but when I execute it on z/OS it throws that error.

Import from D:\affiliations.csv of del MODIFIED BY COLDEL| insert_update into schema.table_name

Any ideas?

I will look into the LOAD utility.

TIA

Przytula Guy,

based on what you posted...the question I have is does the LOAD utility support the DEL file format to import over DRDA?

I need to move data from SQL Server to DB2-are there any other options that I can avail of to do this?
TIA

This is what I got on the LOAD utility...

The load utility does not fire triggers, and does not perform referential or table constraints checking. The data being loaded must be local to the server (unlike import and export, which support the passing of data from the client).

We will need to fire triggers after the data is imported.

That's right. Referential constraint checking is to performed with the CHECK DATA utility, so that's no problem, but the triggers cannot be run "automatically" afterwards.

The only other alternative that I see, apart from converting to IXF, is "converting" the data to SQL INSERT statements (which, btw, is essentially what IMPORT over DRDA is doing).

Is it possible (and simple) to convert the data in to the IXF format?

Is it possible to get data in a IXF format from SQL Server?