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
How popular Informix SPL are ?
8 posts
• Page 1 of 1
- off-topic
- windows ce
- Windows XP
- OS2
- informix
- Windows XP
- delphi
- Axapta
- Layout&presentation
Jump to:
Sponsored Links
- 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
Next
How popular Informix SPL are ?
by Gil Lapid » Sat, 28 Oct 2006 04:20:03 GMT
RE: How popular Informix SPL are ?
by 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 ?
by 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 ?
by 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 ?
by 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 ?
by 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 ?
by 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
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 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 33 guest