Verifying the installation of spatial support

You can verify the installation of IBM® Spatial Support for Db2 for z/OS® by issuing two SQL SELECT statements.

To verify the installation of spatial support:

1. Submit the following SELECT statement:

   SELECT CAST(DB2GSE.ST_ASTEXT(DB2GSE.ST_POINT('POINT (1.0 1.0)', 1)) AS VARCHAR
   (32)) AS POINT_DATA FROM SYSIBM.SYSDUMMY1;

   The expected output is:

   POINT_DATA
   --------------------------------
   POINT (1.000000 1.000000)
   
   1 record(s) selected.

2. Then, submit the following SELECT statement:

   SELECT CAST(DB2GSE.ST_ASTEXT(DB2GSE.ST_POINT('POINT (Invalid SRS ID)', 99999))
   AS VARCHAR(32)) AS POINT_DATA FROM SYSIBM.SYSDUMMY1;

   The expected output is:

   POINT_DATA
   --------------------------------
   SQL0443N Routine "GSEGEOMFROMTEXT" (specific name "STCO00002GFT") has returned
   an error SQLSTATE with diagnostic text "GSE3001N Invalid SRS identifier 99999.".
   SQLSTATE=38SU1