Home » Categories » Solutions by Business Process » SQL

SQL In

Datafile Software

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.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Datafile SQL Monitor
Viewed 2991 times since Thu, Jul 5, 2012
SQLDET Database Structure
Viewed 5218 times since Mon, Jun 11, 2012
Installing the Datafile SQL Driver
Viewed 3642 times since Thu, Jul 5, 2012
Datafile SQL Configuration
Viewed 2705 times since Thu, Jul 5, 2012
Connection to SQL Server via ODBC and SQL Log Housekeeping
Viewed 5664 times since Fri, Jul 21, 2017
Datafile SQL Driver
Viewed 3158 times since Thu, Jul 5, 2012
Update Individual Records to SQL on Nominal Update
Viewed 3490 times since Fri, Oct 26, 2012
Additional SQLDET.DFD Maintenance Options
Viewed 11910 times since Mon, Jun 11, 2012
Configuring the Datafile System
Viewed 3080 times since Thu, Jul 5, 2012
SQL Out
Viewed 2953 times since Thu, Jul 5, 2012