optiload question - Database and Unix Discussions
This is a discussion on optiload question - Database and Unix Discussions ; Hi, Is there anyone who has worked with "optiload" product? I need help on handling varchar data in optiload. Iam trying to load data from a file to the table. The file has varchar data from positions 100-200. the length ...
![]() |
| | LinkBack | Thread Tools | Display Modes |
|
#1
| |||
| |||
| Is there anyone who has worked with "optiload" product? I need help on handling varchar data in optiload. Iam trying to load data from a file to the table. The file has varchar data from positions 100-200. the length of the file is 200. when the actual length of the data is say, 50 bytes, and the datatype in record definitioin is varchar(100), optiload is transferring 50 bytes of data tothe varchar field in table. then it uses data from 51st byte from the file as the data for the next row. but it should actually read the next record in the file. how can this be done? Thanks Last edited by maya2613; 10-17-2007 at 03:19 PM.. Reason: added explanation |
![]() |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| comp.lang.c Answers (Abridged) to Frequently Asked Questions (FAQ) | Database Administrator | Answers and FAQ | 0 | 10-15-2007 06:00 AM |
| Question about Item -- Respond Now | Database Administrator | mysql | 0 | 06-25-2007 02:57 PM |
| general question about how best to cache expensive query results | Database Administrator | databases | 4 | 05-07-2007 07:31 AM |
| Kerberos FAQ, v2.0 (last modified 8/18/2000) | Database Administrator | Answers and FAQ | 0 | 04-30-2005 12:25 AM |
| Re: Newbie question... | Database Administrator | mysql | 0 | 10-11-2003 03:19 AM |
All times are GMT -4. The time now is 07:31 PM.




Linear Mode
