Editing the Contains.sql unit test file

Although you are not setting breakpoints and debugging this DataBlade module, using the DBDK Visual C++ Add-In and the unit test files is the easiest way to run SQL statements for your DataBlade module.

To edit the Contains.sql file:

  1. In Visual C++, open the Contains.sql file under the Test Files node in the File view.
  2. Find and select the following SQL statement:
    execute function Contains( '98234.22 98234.22  98234.22 '::Circ,  
             '98234.22 98234.22 '::Pnt);
  3. Replace it with the SQL statements in the circle.txt file.
  4. Save the changes to Contains.sql.

Copyright© 2019 HCL Technologies Limited