SQL In

The SQL In parameters ask:

Optimise Records – this asks the number of entries processed in one loop.

IP Address – enter the IP Address of the SQL server

Database – enter the database name on the SQL server

Username – enter the user name for the database on the SQL server

Password – enter the password for the database on the SQL server

Server Type – enter the server type i.e. mysql for Jshop webserver

SHP-XMO path – enter the database file (including path) that is to be updated

The SQLMGR.INI contains additional entries which define the tables that are accessed within the database

key=orderID

from=FROM `df_orders_lines` INNER JOIN `df_orders_headers`

where=ON `df_orders_lines`.orderID = `df_orders_headers`.orderID

orderby=ORDER BY `df_orders_lines`.lineID ASC

tables=df_orders_headers,df_orders_lines

This defines the primary table being read as the df_order_lines but then links it to the header table.