Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665

    Unanswered: Export command on OS 390

    I am running the following command on an OS 390 DB2 8.1.0 system.

    Code:
    db2 -q "export to /export/home/mldwh/bi_addhoc/load_files/RKSATACT.txt OF DEL 
    		select * 
    		FROM RKSA.RKSATACT 
    		WHERE CREATE_TIME between '2007-11-01-00.00.00.000000' and '2007-11-30-00.00.00.000000' WITH UR"
    I am getting the following error:

    Code:
    SQL1325N  The remote database environment does not support the command or one
    of the command options.
    I have reviewed the sytax online and I cannot see what I am doing wrong. Can anyone point out what I am doing wrong?
    ------------
    And back to SQL Server....I always find my way home
    View my Linkedin profile

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    The only time I exported a DB2 z/OS table from a DB2 LUW client I used IXF format and it worked ok. I don't know if that is your problem. I would also try it without the UR.

    The other issue is to make sure you do a remote bind from the DB2 LUW client of the utilities to the DB2 z/OS server (you will need bind add authority on DB2 z/OS).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665
    Can an IXF file be imported into a SQL Server environment? That is why I was using the DEL file type
    ------------
    And back to SQL Server....I always find my way home
    View my Linkedin profile

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Probably not. But you could load it into a DB2 LUW table and then export to DEL.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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