View previous topic :: View next topic |
Author |
Message |
NASCAR9 Intermediate
Joined: 08 Oct 2004 Posts: 274 Topics: 52 Location: California
|
Posted: Fri Mar 11, 2016 12:49 pm Post subject: -IGNORE(WHEN)- |
|
|
I can't find an example how to -IGNORE(WHEN)- in my load job. I'm trying to bypass the first record if it's a title line. This is from IBM's site. No example on IBM's site
Code: | -IGNORE(WHEN)-
Specifies that records that do not satisfy the WHEN clause will be ignored. If discarding is specified, records that do not satisfy the when clause will not be loaded, and will not be written to the DISCARD data set. If discarding is not specified, records that do not satisfy the WHEN clause do not cause the LOAD to terminate.
Use the record count messages in the Utility output to determine the number of records ignored.
My load statements
LOAD DATA INDDN(INDD1)
RESUME YES
DISCARDDN DISCARD DISCARDS 0
IGNORE(WHEN) --- I need to bypass if SSNO IS NOT NUMERIC
FORMAT DELIMITED COLDEL X'05' CHARDEL '"' DECPT '.'
INTO TABLE MY.TABLE
(SSNO INTEGER ,
RET_TYPE CHAR(02) ,
)
LOG NO
|
_________________ Thanks,
NASCAR9 |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12357 Topics: 75 Location: San Jose
|
Posted: Fri Mar 11, 2016 3:57 pm Post subject: |
|
|
NASCAR9,
If you specify the FORMAT DELIMITED option, you cannot use any of the following options:
Code: |
CONTINUEIF
INCURSOR
Multiple INTO TABLE statements
WHEN
|
_________________ Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
NASCAR9 Intermediate
Joined: 08 Oct 2004 Posts: 274 Topics: 52 Location: California
|
Posted: Fri Mar 11, 2016 5:10 pm Post subject: |
|
|
That's too bad. Where did you find that information?
I added an OMIT to a sort to remove the record.
Thanks Kolusu. _________________ Thanks,
NASCAR9 |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12357 Topics: 75 Location: San Jose
|
|
Back to top |
|
|
|
|