I have one file with name locator_TestID.txt which contains data with fixed length which has to be loaded into table.
I have one table with two columns
create table TestLoad
( Locate VARCHAR(50),
Say i have text File " HYD_NAT1204.TXT". HYD should be inserted into Locate column and NAT1204 should be inserted into TestID column of table TestLoad.
Thanks in advance.