Suppose i have data like 2009/12/31 555555534 ' ' Generally

Suppose i have data like
2009/12/31
555555534
' '
Generally last 2 records are wrong format it is going to
error table but i don't want load error table if any wrong
format in Date column Pass "NULL" how can we do it fast load

Question Posted / aniltd1980

4 Answers
8019 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Suppose i have data like 2009/12/31 555555534 ' ' Generally last 2 records are w..

Answer / yuvaevergreen

In FLOAD, record command can be used to select records.
.RECORD 1 THRU 998;

In MLOAD, option in import command can be used to select records.
.IMPORT INFILE FILE1
FORMAT TEXT
FROM 1 THRU 998
LAYOUT FILEIN
APPLY INSERTS;

Is This Answer Correct ?

1 Yes

0 No

Suppose i have data like 2009/12/31 555555534 ' ' Generally last 2 records are w..

Answer / yogi

If those invalid records are the same everytime, then NULLIF
option in DEFINE command can be used(below). But, this would
not work, if the invalid values are different every time.

.DEFINE EMPLOYEE_NAME(CHAR(10),NULLIF='555555534'),
EMPLOYEE_ADD(CHAR(10),NULLIF=' ')
FILE=inputfile;

Is This Answer Correct ?

1 Yes

0 No

Suppose i have data like 2009/12/31 555555534 ' ' Generally last 2 records are w..

Answer / guest

INDICATORS is a keyword related to how FastLoad
handlesnulls in the input file. It identifies columns with
nulls and uses abitmap at the beginning of each row to show
which fields containa null instead of data. When the
INDICATORS option is on,FastLoad looks at each bit to
identify the null column. TheINDICATORS option does not
work with VARTEXT

Is This Answer Correct ?

0 Yes

0 No

Suppose i have data like 2009/12/31 555555534 ' ' Generally last 2 records are w..

Answer / tdguy

IF it is always the last two records, then use RECORD
option. Assuming 1000 records are present, use the below
option to avoid the last two records
RECORD THRU 998;

Is This Answer Correct ?

2 Yes

2 No

Post New Answer