Results 1 to 1 of 1
  1. #1
    Join Date
    Jun 2004
    Location
    Bangalore
    Posts
    8

    Unanswered: My Unload on table is not working

    When I'm querying in QMF like SELECT COUNT(*) FROM TABLEA WHERE TB_FIELD='US' is fetching more than 100 rows but at the same time when I perform( Db2 Version 7 )Unload thru a job like UNLOAD TABLESPACE databasename.tablespacename FROM TABLEA WHEN TB_FIELD='US' its not fetching rows. Count in job log is zero.
    When I perform db2 v7 Unload on any other table with that TB_FIELD='US', they are working fine...
    Also when i give Unload like UNLOAD TABLESPACE databasename.tablespacename FROM TABLEA WHEN "some other condition" its pulling rows.

    what might be the problem? Can a table be set so that it cannot be unloaded?
    Please help
    Last edited by brainstorms; 06-11-04 at 02:11.

Posting Permissions

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