optiload question

This is a discussion on optiload question within the Database and Unix Discussions forums in category; 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 ...

Go Back   Database Forum > Database and Unix Discussions

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 10-17-2007, 03:47 PM
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 04:19 PM. Reason: added explanation
Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 05:44 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.