Loading "packed" file with sqlloader

[jayjaybigs]

I was just wondering if anyone in da house has used sqlloader to load "packed records" from mainframe into Oracle database before.

"packed records" are the records that have been reduced in size from its original size to safe time. Hence, record lenght of 180 becomes 20.

The problem is that I cannot recognize the format of this recoords though they are in the format filename.dat

Please let me know if anyone has been through this b4.

Regards,
Jayjay.

 

[williey]

if you're refering loading packed decimals fields, here is a sample of my control file.

	Field1	POSITION (76:82)	CHAR,
	Field2 	POSITION (83:90)	DATE (8) "MMDDYYYY" NULLIF Field2 = '00000000',
	Field3	POSITION (91:93)	INTEGER EXTERNAL NULLIF Filed3 = '000',