View RSS Feed

Development Team Blog

  1. DataFlex and SQL Injection

    Are Visual DataFlex projects that use one of the Data Access CLI connectivity kits (DB2 Connectivity Kit, ODBC Connectivty Kit and Microsoft SQL Server Connectivty Kit) vulnerable for attacks described as SQL Injection?

    From time to time we get this question because people read about SQL injection and with the CLI drivers you talk via ODBC to an SQL based server. To answer this question correctly one first needs to understand what SQL injection really is. Let's look what Microsoft ...
  2. ESQL: Fetching from Batch Statements

    When using the database Connectivity Kits, developers may choose to use embedded SQL (ESQL) in their applications to take advantage of the database server capabilities and set processing. In ESQL you can execute many different statements either one by one or in batches. So, how can batch statements be used in Visual DataFlex?

    What are Batch Statements
    A batch of SQL statements is a group of two or more SQL statements or a single SQL statement that has the same effect as a group ...
  3. INT and CCH Files Explained

    When using the Connectivity Kits, we hear a lot about intermediate (INT) files and structure cache (CCH) files, but the role that those files play in the Connectivity Kit world seems to not be completely understood.

    What is an INT file?
    INT files are text files that contain the driver name to be used to open a table, the table's connection information (server, database, etc) and identification (table name, schema, etc), and some special information (e.g. whether the table is ...

    Updated 13-Apr-2022 at 10:17 AM by Marcia Booth

    Tags: cli, marcia booth, sql