Skip to main content

Actian X/Ingres - Working around the limitations of the GLOBAL TEMPORARY/SESSION TABLES

An attempt to work around the
Limitations of Database Procedures when used with Global Temporary Tables

Successfully tested on Ingres II 9.2.0 (int.lnx/118)NPTL

On Ingres II 10.0.1 (a64.lnx/100)NPTL returns error:
E_SC0206 An internal error prevents further processing of this query.
    Associated error messages which provide more detailed information about
    the problem can be found in the error log, II_CONFIG:errlog.log

 Code on GitgHub
Labels:

Comments

Post a Comment

Popular posts from this blog

Greenplum's Cloudberry Fork Enters Apache Incubator

  Cloudberry is the open source equivalent of Greenplum. Now it is fostered by the Apache Foundation as it acquires incubating status. It all began about six months ago. Greenplum's Github repositories was archived and went dark. This meant no more free new releases or security and bug fixes for its users. Why? Because in May 2024, Tanzu made the decision to close-source the project. https://www.i-programmer.info/news/84-database/17694-greenplums-cloudberry-fork-enters-apache-incubator-.html
Post a Comment
Read more

The Advent of SQL 2024 Has Commenced

  It's Advent - the time of year when we countdown the days to Christmas - and if your are a programmer complete daily coding challenges with the Advent of Code, the Advent of Perl, the Advent of Java, Javascriptmas, etc. Now we have the Advent of SQL too with 24 SQL challenges to complete before Christmas! https://www.i-programmer.info/news/204-challenges/17678-the-advent-of-sql-2024-has-commenced.html
Post a Comment
Read more