Hi All,

I have a file with each row is terminated by 2 new line charaters and fields are delimited by 1 new line character.

If i do a load data in file for this file i am able to insert only one record into the table.

File looks like.

MSH|^~\&|SiemensRx||Omnicell||200804071429||RDE|20 080407142906|P|2.3
PID|1||152419200216||CORDERO^CHRISTOPHER||19681107 0001|M|||850 BRYANT ST^^CA^CA^941030000^||^^^|||||1524192|000-00-0000|
PV1|1|I|5A^15^01||||010389^KAHN ,JAMES^^|||MED||||||||||||||||||||||||||||||||||20 0803241131||||||
AL1|1|DA|DI^NO KNOWN ALLERGIES^99USR|||20080404|
ORC|NW|31|||IP||||200804071429|LXC|LXC|010389^KAHN ,JAMES^|||200804061428|||
RXE|^D&0900^D^200804061428^200804102200^R^|1901222 ^TEMOZOLOMIDE|250||250 MG = 1 CAP|CAP|^DAILY X5 DAYS |||1|CAP|||LXC|||||||||||250|MG
RXR|PO||||

MSH|^~\&|SiemensRx||Omnicell||200804071425||ADT|20 080407142906|P|2.3
EVN|A02|200804071425|200804071425||
PID|1||152419200216||CORDERO^CHRISTOPHER||19681107 0001|M|||850 BRYANT ST^^CA^CA^941030000^||^^^|||||1524192|000-00-0000|
PV1|1|I|7D^02^01||||010389^KAHN ,JAMES^^|||MED||||||||||||||||||||||||||||||||||20 0803241131||||||
PV2||||||||||||1|


Please let me know if there is any limitation

Thanks in advance for any help
Venkat