SqlUtilGUIDTempTableName - cDbUpdateFunctionLibrary

Returns a temp table name that consists of the passed RootName plus an underscore and as much of a GUID that "fits" in the max allowed length for table names for the SQL back-end. A full GUID is 32-characters long.

Type: Function

Parameters: String sTableName String sFieldName

Parameter	Description
sRootName	The current table root name as specified in Filelist.cfg

Syntax

Function SqlUtilGUIDTempTableName String sRootName Returns String

Call:

Get SqlUtilGUIDTempTableName "OrdHea" to sTempNewTableName

Description

It uses the current piDbType to get the correct max length for the file name. SQL back-ends have different max table name sizes.

Max number of characters allowed for table names;

IBM DB2 = 128

MS-SQL = 128

Oracle = 128 (Version 12.2 and later. 30 characters for earlier versions) v 12.2 or later is assumed!

MySQL = 64

PostgreSQL = 64