Results 1 to 2 of 2

Thread: item count when input file has zero records

  1. #1
    Join Date
    Mar 2008
    Posts
    15

    Default item count when input file has zero records

    Hi all,
    I have a single step in my batch job which reads data from a flat file and stores them to database. After the job finishes I am looking at the number of items processed using the below sql.

    PHP Code:
    SELECT ITEM_COUNT FROM BATCH_STEP_EXECUTION where JOB_EXECUTION_ID 
    I assume item count should reflect the number of records processed right?.
    So if 10 records were processed item count should be 10 right?. but the item count is 11.

    If I have no data in the input file then the item count should be 0 right? but I am seeing the item count=1.

  2. #2
    Join Date
    Jun 2005
    Posts
    4,230

Posting Permissions

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