Results 1 to 5 of 5

Thread: Load JCL

  1. #1
    Join Date
    Nov 2005
    Posts
    6

    Unanswered: Load JCL

    Hi

    I am trying to Load S99 cobol variable from a file into Db2 table with integer column.

    But my load JCL fails since i specify the position (1:2) Integer External for this varable.I cannot change these positions to (1:4).Is there any alternative?.

    Thanks
    Last edited by vikasa; 06-20-06 at 13:02.

  2. #2
    Join Date
    Apr 2005
    Location
    USA
    Posts
    130
    How that variable defined in table? Is it a smallint, int or decimal? The load card would be based on your table definitions. BTW, what error you receive during load?

  3. #3
    Join Date
    Nov 2005
    Posts
    6
    Hi ,

    in the table it is defined as Integer.

    the error i recieves is "INPUT FIELD 'Variable_Name' INVALID FOR "Table_Name"

    Thanks
    Vikas

  4. #4
    Join Date
    Apr 2005
    Location
    USA
    Posts
    130
    Verify the name of the column in load card and correct it.

  5. #5
    Join Date
    Nov 2005
    Posts
    6
    Hi ,

    I have verified the variable name in the load card and its fine. so there must be something else.Please help???.

    Thanks,
    vikas

Posting Permissions

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