From: arne@vajhoej.dk   
      
   On 7/6/2025 3:45 PM, Arne Vajhøj wrote:   
   > As we all know then the available options are currently very limited.   
   >   
   > But I just found a little trick to get one more.   
   >   
   > :-)   
   >   
   > $ write sys$output f$getsyi("VERSION")   
   > V9.2-3   
   >   
   > $ type TestPG.java   
   ...   
   > $ javac TestPG.java   
   > $ java -cp .:/javalib/postgresql-42_5_1.jar TestPG   
   > 1 A   
   > 2 BB   
   > 3 CCC   
   >   
   > $ type test.c   
   ...   
   > $ cc /include=libpq$root:[include] /name=as_is test   
   > $ link test + libpq$root:[lib]libpq/libr + libpq$root:[lib]libgpgtypes/   
   > libr + ssl111$lib:ssl111$libssl/libr + ssl111$lib:ssl111$libcrypto/libr   
   > $ run test   
   > 1 A   
   > 2 BB   
   > 3 CCC   
   >   
   > C:\IDEProjects\EclipsePHP\Test>type TestPDO.php   
   ...   
   > C:\IDEProjects\EclipsePHP\Test>php TestPDO.php   
   > 1 A   
   > 2 BB   
   > 3 CCC   
   >   
   > I cannot use PHP on VMS yet as I don't have a PHP with pgsql and   
   > pdo_pgsql. But given that libpq is ported, then those can probably   
   > be build.   
      
   About the same with Python. Trying to install psycopg2 with   
   pip fails, but given that VSI provide libpq, then I assume   
   that someone with Python+C+VMS skills could build it.   
      
   It is worse with embedded C.   
      
   VSI libpq port does include ecpg and it works and the   
   result can connect to H2 just fine.   
      
   But there are some incompatibilities between H2 in   
   PostgreSQL mode and real PostgreSQL.   
      
   And one of them is that H2 in PostgreSQL mode   
   does not support server side cursors.   
      
   And embedded SQL without "FETCH cursorname INTO ..."   
   is like a hotdog without a hotdog sausage!   
      
   Arne   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)