LOAD DATA
INFILE 'c:\temp\test_data.txt'

INTO TABLE TEMP_X
APPEND
when (1) = '3'
(
XTIPT     POSITION (2:4)CHAR,
XORGD     POSITION (5:6)CHAR,
XIPTT     POSITION (7:11)CHAR,
XPART     POSITION (12:21)CHAR,
..
)
INTO TABLE TEMP_Y
APPEND
when (1) = '4'
(
YTIPT     POSITION (2:4)CHAR,
YORGD     POSITION (5:6)CHAR,
YIPTT     POSITION (7:11)CHAR,
YPART     POSITION (12:21)CHAR,
..,
..
)