Home » RDBMS Server » Server Utilities » CONTROL FILE
CONTROL FILE [message #179223] Mon, 26 June 2006 07:33 Go to next message
sharmila_roy
Messages: 1
Registered: June 2006
Junior Member
MY .DAT FILE IS
!DATA
DRSFTDFGD;EE;EE
DF;DEED;ED;WD
!DATA1
HH;3;4;4;
WE;4;5;5
BASED ON THE HEADERS MY DATA SHOULD GO TO RES TABLES..I.E FOR DATA THE DATA UNDERLYIN IT SHOULD POPULATE TABLE T1,FOR DATA1,IT SHOULD POPULATE TABLE T2 ETC..
HOW TO DO USING CONTROL FILE IN SQL LOADER
Re: CONTROL FILE [message #188654 is a reply to message #179223] Mon, 21 August 2006 02:30 Go to previous message
aorehek
Messages: 52
Registered: August 2006
Member

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,
..,
..
)

[Updated on: Mon, 21 August 2006 02:31]

Report message to a moderator

Previous Topic: Pound symbols in external table definition
Next Topic: Some jobs stop running after some time
Goto Forum:
  


Current Time: Sun Dec 08 18:47:37 CST 2024