dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

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 ...



Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 10-17-2007, 02:47 PM
Database Newbie
 
Join Date: Oct 2007
Posts: 2
maya2613 is on a distinguished road
Default optiload question

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 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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads

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.