How popular Informix SPL are ?

informix

    Sponsored Links

    Next

  • 1. Specifying location of .4gi files
    Which environment variable tells fglgo where to look for pcode files? TVM -- Andy Kent Bristol, UK Shiny new genuine reply address.
  • 2. ONBAR, IXBAR, & Point in Time Recovery
    The system crashed hard on Monday (SAN Failure). My last good full database and file system backups (which includes the IXBAR file) are from Friday morning. I have all the logs sent to tape since the last db backup. My problem is can I recover to a point in time beyond the IXBAR file? I have been doing some searching and I don't really see anything and I am wondering if anyone has tried this? If the IXBAR file needs to have all the log files info is there away to get that information in the IXBAR file? Any help will be appreciated. Thanks in advance. T.E.Mammoser DBA Nicor Gas
  • 3. C-ISAM Runtime Environment
    Greetings, Does C-ISAM need to have an associated runtime environment if the executable has been statically linked? Can I move an executable to another environment and provide it only the target C-ISAM data files (and INFORMIXDIR for GLS support) and expect it to function properly? I sifted through the C-ISAM programmers guide and the CDI archive looking for a clue with no luck. Thanks in advance,
  • 4. Now I've seen it all
    Today we were investigating why our database engine would not restart following a relocation. The system is IDS 9.30.UC5 running on SUSE Linux SLES 8. Here's the good bit. We couldn't start the engine using oninit so we used oninit -v. The engine did not succeed in starting the ADM VP. There were no messages in the message log, the shared memory had been created, but there were no oninit processes running. We tried various things such as starting oninit as root, rebooting the wholde machine, and even resorted to praying to the Informix Handbook, but nothing worked. Then we tried starting up using onmonitor and .... it worked? Now I'm really baffled. What can I possibly have missed? We've checked raw-device permissions, we've checked /etc/hosts and everything looks OK. Does anybody have any ideas of what we might have missed? regards Malcolm sending to informix-list
  • 5. RESIDENT -1
    IDS 9.30 on Linux SLES 8 ISA always sets RESIDENT to -1 for us on this platform. What does this mean? I've checked the archives and can find conflicting explanations of what RESIDENT -1 means. regards Malcolm

How popular Informix SPL are ?

Postby Gil Lapid » Sat, 28 Oct 2006 04:20:03 GMT

Does anyone know how popular Informix SPL are ? I mean, if I  sample
1000 Informix databases, how many of them, on average, will make
(extensive) use of  SPL ?

Thanks,

Gil


RE: How popular Informix SPL are ?

Postby Dale Gilbert » Sat, 28 Oct 2006 04:30:45 GMT

We have on average 150-200 SPLs in each database

-----Original Message-----
From:  XXXX@XXXXX.COM  [mailto: XXXX@XXXXX.COM ]
On Behalf Of Gil Lapid
Sent: Thursday, October 26, 2006 12:20 PM
To:  XXXX@XXXXX.COM 
Subject: How popular Informix SPL are ?

Does anyone know how popular Informix SPL are ? I mean, if I  sample
1000 Informix databases, how many of them, on average, will make
(extensive) use of  SPL ?

Thanks,

Gil

_______________________________________________
Informix-list mailing list
 XXXX@XXXXX.COM 
 http://www.**--****.com/ 


RE: How popular Informix SPL are ?

Postby Adam Tauno Williams » Sat, 28 Oct 2006 04:33:07 GMT



Same.


RE: How popular Informix SPL are ?

Postby Konikoff, Rob » Sat, 28 Oct 2006 04:59:07 GMT

I have about four SPLs used on a custom requirement, and another 8 on a
standardized platform across about 10 servers.  I love SPLs.  I love SPLs almost
as much as Nulls.  (Hey, OTC, you out there?!)

Rob 



-----Original Message-----
From:  XXXX@XXXXX.COM  [mailto: XXXX@XXXXX.COM ] On
Behalf Of Adam Tauno Williams
Sent: Thursday, October 26, 2006 2:33 PM
To:  XXXX@XXXXX.COM 
Subject: RE: How popular Informix SPL are ?




Same.

_______________________________________________
Informix-list mailing list
 XXXX@XXXXX.COM 
 http://www.**--****.com/ 

RE: How popular Informix SPL are ?

Postby Obnoxio The Clown » Sat, 28 Oct 2006 06:09:37 GMT

Konikoff, Rob said:

I think SPL is great. :o)

-- 
Bye now,
Obnoxio

"... no bill is required as no value was provided."
-- Christine Normile

-- 
This message has been scanned for viruses and
dangerous content by OpenProtect( http://www.**--****.com/ ), and is
believed to be clean.


Re: How popular Informix SPL are ?

Postby Paul Watson » Sat, 28 Oct 2006 06:12:18 GMT

In the systems we look after all use SPL in some shape or form 

Paul Watson
Tel: +44 1414161772
Mob: +44 7818003457
Web: www.oninit.com

GO FURTHER with DB2
GET THERE FASTER with Informix.
Attend IDUG 2007 San Jose, North America
May 6-10, 2006
Visit  http://www.**--****.com/ 

 
 



RE: How popular Informix SPL are ?

Postby informix » Sun, 29 Oct 2006 09:20:33 GMT

You just can't develop a really efficient application without using any kind
of server logic, and SPL is a powerful tool in that way (despite of some
awful limitations, at least at 7.31). And maybe the easiest option. In my
last project nearly the 80% of the hardest logic of the system was developed
using SPL and it works really good (of course you also need a hard work
designing optimized algorithms, nothing can be done without these).

ole for the stored procedures! sometimes SQL becomes art !!!



-----Original Message-----
From:  XXXX@XXXXX.COM  [mailto: XXXX@XXXXX.COM ]
On Behalf Of Paul Watson
Sent: jueves, 26 de octubre de 2006 23:12
To:  XXXX@XXXXX.COM 
Subject: Re: How popular Informix SPL are ?

In the systems we look after all use SPL in some shape or form 

Paul Watson
Tel: +44 1414161772
Mob: +44 7818003457
Web: www.oninit.com

GO FURTHER with DB2
GET THERE FASTER with Informix.
Attend IDUG 2007 San Jose, North America
May 6-10, 2006
Visit  http://www.**--****.com/ 

 
 


_______________________________________________
Informix-list mailing list
 XXXX@XXXXX.COM 
 http://www.**--****.com/ 


Re: How popular Informix SPL are ?

Postby spinning.spanners » Sun, 05 Nov 2006 00:57:23 GMT




Gil

My guess about 50% will have "some" SPL. 25% loads of SPL, and <5%
running just about all their businees logic via SPL.

cheers

Spanners


Similar Threads:

1.Problem on SPL syntax in Informix 7.31

Hi,

I've got a syntax problem on a Stored Procedure undert IDS 7.31. Is it
possible to concatenate integers and put them into a varchar variable
maintaining them as a uniqeu item? How? Are they canverted
automatically to chars within thgelist? My code looks like something
like this:

DEFINE varList varchar(250);
DEFINE varFirst smallint;

LET  varList = '';
LET  varFirst = 0;

CREATE PROCEDURE TEST()

FOREACH
     SELECT var      INTO varAux     FROM table1

      IF (varFirst = 0) THEN
        LET varList = varAux;
        LET varFirst = 1;
     ELSE
        LET varList = varList || ',' || TRIM(varAux);
     END IF;

END FOREACH;

FOREACH

SELECT value
               INTO valueAux
        FROM table2  WHERE   value NOT IN (varList)
        order by 1 desc

END FOREACH

END PROCEDURE;


My problem is that when I execute the sentence:

SELECT value
               INTO valueAux
        FROM table2  WHERE   value NOT IN (varList)

varList is trated as a unique parameter (char) and not as a group of
integers and this sentence returns always all the values. Any idea?

Thank you for your help.

2.Perl DBD::Informix and IDS9.40 SPL display labels

Hi,All

I'm using: 9.40.UC1E1 on RedHat 7.3, perl5.8.0, DBD::Informix 2003.04.
 SPL function:
create function test1(a integer) 
    returning integer as test1_res;
  return 1;
end function

In perl script:
my $sth = $dbh->prepare('EXECUTE FUNCTION test1(1)');
$sth->execute;
statement "$sth->fetchrow_hashref" returns { 'test1_res' => 1 }.

But, if calling via 'EXECUTE FUNCTION test1(?)', and $sth->execute(2);
statement "$sth->fetchrow_hashref" returns { '(expression)' => 1 }.

It's possible to receive labels in 2nd variant? (with placeholders).

-- 
Best regards,
Sergey

3.Functions in Informix SPL

Hi, 
  Where can I find information (syntax) about functions that I can use in SPL?
  Like, SUBSTR, COALESCE, CURRENTDATE, ROUND, ...

Thanks a lot

4.FYI:Informix Chat with the Lab - Wednesday, August 16th 11 AM Eastern

5.Need NT executables of popular IIUG software packages

6. Ingres must be becoming more popular!

7. pgsql-server: Due to popular domand, backport fix for a typo in the

8. using a var in spl alter sequence



Return to informix

 

Who is online

Users browsing this forum: No registered users and 33 guest