Home » Categories » Solutions by Business Process » SQL |
SQL In |
Article Number: 1722 | Rating: Unrated | Last Updated: Mon, Jun 12, 2023 at 2:44 PM
|
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. |
Attachments
There are no attachments for this article.
|
Installing the Datafile SQL Driver
Viewed 2622 times since Thu, Jul 5, 2012
Suspend SQL Mirroring During Night / Weekends
Viewed 1938 times since Fri, Oct 26, 2012
SQL Out
Viewed 2098 times since Thu, Jul 5, 2012
Configuring the Datafile System
Viewed 2079 times since Thu, Jul 5, 2012
Database Refresh - Empty Table and Re-Import Data
Viewed 2299 times since Mon, Jun 11, 2012
Datafile SQL Monitor
Viewed 2114 times since Thu, Jul 5, 2012
Running the SQL Manager
Viewed 2241 times since Thu, Jul 5, 2012
Additional SQLDET.DFD Maintenance Options
Viewed 9214 times since Mon, Jun 11, 2012
Datafile SQL Driver
Viewed 2271 times since Thu, Jul 5, 2012
Connection to SQL Server via ODBC and SQL Log Housekeeping
Viewed 4230 times since Fri, Jul 21, 2017
|