MY_SQL_DATA_WRITER: cannot read fix-length data??

achan

• April 13, 2009 00:00

• Answered

Follow

Hi,

Looks like MY_SQL_DATA_WRITER only read data in delimited format. If I have a fix-length data file, I have to transform it to a delimited-format, right? So, the graph can look something like:

FIXLEN_DATA_READER -> SIMPLE_COPY -> MY_SQL_DATA_WRITER

Does Clover load the data record by record, or is there an option to "batch load" the records (say load every 100 records)?

Thanks so much,
albert

• 

  avackova

  • April 14, 2009 07:29

  0

  Comment actions Permalink

  Hello,
  if MySqlDataWriter reads data from input port, it doesn't matter if it is delimited or fix length - it formats data to temporary file or named pipe and load data to MySql database. You can pass any parameter, that mysql utility or LOAD DATA INFILE statement accept, but seems that there is not anything like batch mode for data loading.
• 

  achan

  • April 14, 2009 16:20

  0

  Comment actions Permalink

  Thanks, Agata :-)
  
  al

Please sign in to leave a comment.