Results 1 to 8 of 8

Thread: DB2 Import

  1. #1
    Join Date
    Feb 2002
    Posts
    8

    Unanswered: DB2 Import

    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.

  2. #2
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    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".
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11

    import

    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.
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  4. #4
    Join Date
    Feb 2002
    Posts
    8

    DB2 Import

    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

  5. #5
    Join Date
    Feb 2002
    Posts
    8
    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

  6. #6
    Join Date
    Feb 2002
    Posts
    8

    DB2 Import

    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.

  7. #7
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    Quote Originally Posted by sackerdj
    The load utility does not fire triggers
    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).
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

  8. #8
    Join Date
    Feb 2002
    Posts
    8

    DB2 Import

    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •