SQL statements that are generated by a template or by a template wizard will use commas (,) as required for the syntax of the statement – for example, to separate items in a list or to separate arguments of a function. These statements can be generated by:
selecting the Create SPC standards when necessary check box on step 6 of the File Import Wizard or the Database Integration Wizard
selecting the Create DMS standards when necessary check box on step 6 of the File Import Wizard or the Database Integration Wizard
using the DB_STD_SQL, DB_DATA_SQL, DB_DATA_AUX_SQL, or DB_NOTE_SQL command to return a partial or complete SQL statement
If your database does not use commas to separate field values in an SQL statement, you must use the CONCAT command to build an SQL statement that is appropriate to your database.