.ctl file containing variable and fixed-length records

.ctl file containing variable and fixed-length records

[ Follow Ups ] [ Post Followup ] [ Message Board ]

Posted by 'Yash' on June 08, 2001 at 04:43:21 EST:

I have data like:
2,45,234564
34,6,567893
235,456,567890
The first 2 fields are of variable length, The last field is 6 digits long. I want to break it into 2 fields, each of 3 digits
( field1,field2,field3,field4).
How do I specify this in the .ctl file?
Can I make SQL*Loader know somehow, that the last field isof fixed size(6 digits) and it has to pick 3 digits from it to load in field 3 and the next 3 digits in field4? I do not want to manually or programmatically separate the last 6 digits into 2 numbers.

Kindly help
Thanks

Follow Ups:

Post a Followup

Name:
E-Mail:
Subject:
Message: : I have data like: : 2,45,234564 : 34,6,567893 : 235,456,567890 : The first 2 fields are of variable length, The last field is 6 digits long. I want to break it into 2 fields, each of 3 digits : ( field1,field2,field3,field4). : How do I specify this in the .ctl file? : Can I make SQL*Loader know somehow, that the last field isof fixed size(6 digits) and it has to pick 3 digits from it to load in field 3 and the next 3 digits in field4? I do not want to manually or programmatically separate the last 6 digits into 2 numbers. : Kindly help : Thanks