Hi Gurus,

We use below statement to load file records into the table. Now my question is, can I skip few records in the file.

load from /file_outbound/db2load_pipe of ASC METHOD L (1 2, 3 4, 5 15)
MESSAGES /file_outbound/db2load_pipe.MESG
REPLACE INTO SCHEMA_NAME.ERROR_MESSAGES(JOB_ID, ROW_ID, ERROR_MESSAGE)
NONRECOVERABLE

For eg:

If we have data in the file

10 1TRUEESCRIPTION
10 2FALSEESCRIPTION
10 3FALSEESCRIPTION
10 4TRUEESCRIPTION
10 5TRUEESCRIPTION

I'd like the table to have records with TRUE starting in position 5. Need to skip records with value FALSE.

Table should have
COL1 COL2 COL3
10 1 TRUEESCRIPTION
10 4 TRUEESCRIPTION
10 5 TRUEESCRIPTION

Is this possible?

Thnx
MMe

Any help would be helpful...

no with load/import this can not be done
you should use an application to insert the data

A couple of possible options:
- use an OS tool (sed, awk, and perl come to mind) to filter data prior to loading;
- load everything into a staging table, then define a cursor that selects only the data you need and use it to load the target table