Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Odbc Import – Local Append

forums › forums › SQLyog › Using SQLyog › Odbc Import – Local Append

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • September 14, 2005 at 9:56 pm #19188
      peterlaursen
      Participant
      Quote:
      I want to be able to add this one column with a default value to the table that is being imported.

      The solution is the have two jobs

      1) An ODBC-importjob

      2) A Notifications Service-Job executing the appropriate ALTER TABLE statement.

      You can then build a job.bat file like

      Quote:
      SJA importjob.xml

      SJA notifyjob.xml

      and the job.bat can be executed or scheduled.

      As of now there is no way to execute more job type from one jobfile and you can't either add additional data to the MySQL database with an ODBC-import-job.

    • September 15, 2005 at 8:44 pm #19189
      shawn_h
      Member

      I see!

      So if we're talking about say 10 tables, then we're talking about 10 import jobs and 10 notification jobs, executed serially, one after the other. Is that right?

      Do you have an example I can use?

    • September 15, 2005 at 9:05 pm #19190
      peterlaursen
      Participant

      You have a Personal Message with a download link.

      Peter

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.