| Sql loader question [message #137902] |
Sun, 18 September 2005 14:34 |
hpatel
Messages: 1
Registered: September 2005
Location: NY
|
Junior Member |
|
|
Hello,
We have one Sql loader file which needs to be loaded in temp table. Here how first three records looks like :
Period : 06/2005
Date : 03/07/05
Vendor : 10003456 Test vendor
Invoicenum invoicedate vendornum vendorname amount ponum date
12345 100.00
13445 200
122335 67.90
What i need is first three records needs to be inserted with lines information. To be clear what i want is, i want vendor number,name,date and period get inserted with lines.
Does anyone know how can i Do that ? is there any syntax for Sqlldr which helps me to achieve this ? i dont want to hard code any value in my control file for these fields so can you help me if you know how to do this ?
Thanks,
Hiral
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
