Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    36

    Unanswered: Load problem (BMC- mainframe)

    HI All,
    I m trying to load records to a table AAA.
    First I unloaded all the records to a flat file, after the successful unload I deleted all the rows from the table AAA and again trying to load the records back to the empty table AAA.

    I m using BMC to do this....All the records are getting into discard dataset.....
    I m specifying RESUME NO REPLACE YES options in JCL
    the error message that I m getting is as follows:

    RECORD (1) WILL BE DISCARDED DUE TO INVALID 'COUNT_CODE' COLUMN SPECIFICATION.

    the RC is 4

    the above is the case for all the records........... Do I need to alter the mainframe BMC settings for this .........to load enormous records .............

    Help me in case u know to tackle this issue.......

    bye,
    Sahana .....
    Last edited by sahana; 10-30-03 at 05:20.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    We need to see the table DDL, the load control cards, and the an example of the data file being loaded.

Posting Permissions

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