std::wstring qry2 = L"INSERT IGNORE INTO abcattbl VALUES( ?, ?, (SELECT CASE WHEN t.engine = 'InnoDB' THEN (SELECT st.table_id FROM information_schema.INNODB_TABLES st WHERE name = CONCAT(?,'/', ?) ) ELSE (SELECT 0) END AS id FROM information_schema.tables t WHERE t.table_name = ? AND t.table_schema = ?), \'\', 8, 400, \'N\', \'N\', 0, 34, 0, \'Serif\', 8, 400, \'N\', \'N\', 0, 34, 0, \'Serif\', 8, 400, \'N\', \'N\', 0, 34, 0, \'Serif\', \'\' );";

    SQLWCHAR *qry = new SQLWCHAR[qry2.length() + 2];
    memset( qry, '\0', qry2.length() + 2 );
    uc_to_str_cpy( qry, qry2 );

    auto qry1 = new SQLWCHAR[30];
    memset( qry1, '\0', 30 );
    uc_to_str_cpy( qry1, L"BEGIN" );
    ret = SQLExecDirect( m_hstmt, qry1, SQL_NTS );
    delete[] qry1;
    qry1 = nullptr;
    ret = SQLPrepare( m_hstmt, qry, SQL_NTS );
    ret = SQLBindParameter( m_hstmt, 1, SQL_PARAM_INPUT, SQL_C_TINYINT, SQL_TINYINT, 0, 0, &osid, 0, &cbParam[2] );
    for( auto it = pimpl.m_tableDefinitions[cat].begin(); it < pimpl.m_tableDefinitions[cat].end(); ++it )
    {
        schemaName = new SQLWCHAR[(*it).schemaName.length() + 2];
        tableName = new SQLWCHAR[(*it).tableName.length() + 2];
        memset( schemaName, '\0', (*it).schemaName.length() + 2 );
        memset( tableName, '\0', (*it).tableName.length() + 2 );
        uc_to_str_cpy( schemaName, (*it).schemaName );
        uc_to_str_cpy( tableName, (*it).tableName );
        ret = SQLBindParameter( m_hstmt, 2, SQL_PARAM_INPUT, SQL_C_WCHAR, SQL_WCHAR, (*it).tableName.length(), 0, tableName, 0, &cbParam[1] );
        ret = SQLBindParameter( m_hstmt, 3, SQL_PARAM_INPUT, SQL_C_WCHAR, SQL_WCHAR, (*it).schemaName.length(), 0, schemaName, 0, &cbParam[2] );
        ret = SQLBindParameter( m_hstmt, 4, SQL_PARAM_INPUT, SQL_C_WCHAR, SQL_WCHAR, (*it).tableName.length(), 0, tableName, 0, &cbParam[3] );
        ret = SQLBindParameter( m_hstmt, 5, SQL_PARAM_INPUT, SQL_C_WCHAR, SQL_WCHAR, (*it).tableName.length(), 0, tableName, 0, &cbParam[3] );
        ret = SQLBindParameter( m_hstmt, 6, SQL_PARAM_INPUT, SQL_C_WCHAR, SQL_WCHAR, (*it).schemaName.length(), 0, schemaName, 0, &cbParam[2] );
        ret = SQLExecute( m_hstmt );
        delete[] schemaName;
        delete[] tableName;
        schemaName = nullptr;
        tableName = nullptr;
    }
    ret = SQLEndTran( SQL_HANDLE_DBC, m_hdbc, SQL_COMMIT );

CREATE TABLE IF NOT EXISTS abcattbl(abt_os tinyint, abt_tnam char(129) NOT NULL, abt_tid integer, abt_ownr char(129) NOT NULL, abd_fhgt smallint, abd_fwgt smallint, abd_fitl char(1), abd_funl integer, abd_fstr integer, abd_fchr smallint, abd_fptc smallint, abd_ffce char(18), abh_fhgt smallint, abh_fwgt smallint, abh_fitl char(1), abh_funl integer, abh_fstr integer, abh_fchr smallint, abh_fptc smallint, abh_ffce char(18), abl_fhgt smallint, abl_fwgt smallint, abl_fitl char(1), abl_funl integer, abl_fstr integer, abl_fchr smallint, abl_fptc smallint, abl_ffce char(18), abt_cmnt char(254), PRIMARY KEY( abt_tnam, abt_ownr ));
CREATE UNIQUE INDEX abcatt_x ON abcattbl(abt_os ASC, abt_tnam ASC, abt_ownr ASC)\"));

void ODBCDatabase::uc_to_str_cpy(SQLWCHAR *dest, const std::wstring &src)
{
    const wchar_t *temp = src.c_str();
    while( *dest )
    {
        dest++;
    }
    while( *temp )
    {
        *dest = *temp;
        dest++;
        temp++;
    }
    *dest++ = '\0';
    *dest = '\0';
}