Groups | Search | Server Info | Login | Register


Groups > comp.databases.ingres > #3869

Re: Call 3GL from DP ?

From Roy Hann <specially@processed.almost.meat>
Newsgroups comp.databases.ingres
Subject Re: Call 3GL from DP ?
Date 2023-04-10 18:07 +0000
Organization A noiseless patient Spider
Message-ID <u11j8t$28und$1@dont-email.me> (permalink)
References <dfe21a24-340c-4797-9484-aad36ffe07b2n@googlegroups.com>

Show all headers | View raw


nikosv wrote:

> Is is possible for a DP or a UDF/OEM to access a shell or call an external command, like Perl?
> By that I mean the dbms server actually accessing the OS.
> Ingres 10.2

Nope.

When I've wanted to do something like that I've been able to set up
something to listen for database events. You can attach a small
payload/message of up to 256 bytes when you raise them, which might be
enough to send some argument. You need the listener to register for the
event then react to any message.

I rather doubt you can have a UDF even in 11.2+ that could run
externals, but I would run screaming from the idea anyway.

Roy

Back to comp.databases.ingres | Previous | NextPrevious in thread | Next in thread | Find similar


Thread

Call 3GL from DP ? nikosv <nikos.vaggalis@gmail.com> - 2023-04-10 09:47 -0700
  Re: Call 3GL from DP ? Roy Hann <specially@processed.almost.meat> - 2023-04-10 18:07 +0000
    Re: Call 3GL from DP ? nksvg <nksvg1@gmail.com> - 2023-04-11 01:55 -0700
      Re: Call 3GL from DP ? Roy Hann <specially@processed.almost.meat> - 2023-04-12 09:36 +0000
        Re: Call 3GL from DP ? nksvg <nksvg1@gmail.com> - 2023-04-12 02:44 -0700

csiph-web