|
-
Yes, you can load multiple tables using one control file.
Example:
LOAD DATA
INFILE 'example1.dat'
BADFILE 'example1.bad'
DISCARDFILE 'example1.dsc'
APPEND/REPLACE
INTO TABLE table1
(p1 POSITION(1:4) INTEGER EXTERNAL,
p2 POSITION(6:15) CHAR,
....)
INTO TABLE table2
WHEN p5 != ' '
(p5 POSITION(25:27) INTERGER EXTERNAL,
p6 POSITION(28:30) CHAR,
......)
i hope this helps.
vidhya
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|