Oninit® Archive
Results for “onstat -g prc”
IFX 14.10 FC14 License File
it seems FC13 license can work with FC14 package: onstat -V IBM Informix Dynamic Server Version 14.10.FC14 ------------------------------ ke chen ------------------------------…
How to restrict specific ODBC/JDBC users from accessing the source code of SPL routines and triggers
I need to grant access to Informix IDS 14.10 to some users but I don't want them to have access to the SPL and triggers sources codes. I try creating a new database with views that point to the production db. But I need to grant connect to the prod db to the users so they can acc…
How to restrict access for a user to Informix by IP?
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE AIX 7.1 We have several application servers and LDAP based authentication. How to prevent a user's connections from any but the application servers' IPs? ------------------------------ Sincerely, Dennis -------------------------…
Defragment sbspace
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, how to defragment (repack) a sbspace after plenty LOBs been deleted? ------------------------------ Sincerely, Dennis ------------------------------…
Changing DBSPACETEMP run-time
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, is there a way to change DBSPACETEMP for a session inside 4GL? ------------------------------ Sincerely, Dennis ------------------------------…
C-UDR reusage of prepared statement
I would agree with Art, C UDRs can be a lot quicker, but it depends on what you are doing. The more 'non SQL' work done in the UDR the more likely it will be faster, if your SPL calls a lot of SPLs then fastpath can speed things up significantly but at the…
INT to SERIAL in-place alter
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE My question is, why MODIFY INT to SERIAL does not use in-place alter? ------------------------------ Sincerely, Dennis ------------------------------…
Question on sysprocedures
Informix 14.10.FC7W1 on RHEL 8.6 I've got a couple of questions about the sysprocedures table. First, the isproc column. It looks like isproc is set to 'f' any time the routine has return values, regardless of whether it was created via CREATE PROCEDURE or CREATE FUNCTION. I g…
syntax error on EXECUTE statement
You cannot use "EXECUTE stmt_id" in an SPL routine, only in ESQL/C. In SPL you will have to EXECUTE IMMEDIATE p_sql_statement; but you will have to fill in the values instead of using the placeholder question marks. ------------------------------ Art S. Kagel, President and Princ…
SPL was called by another SPL
Antonio: I cannot think of any way for an SPL routine to know if it was called by another SPL, no. You could create a Global variable and set it before calling another routine then clear it after the routine returns. When the other routine checks the value of the global, if it wa…
IBM data studio and SPL debug
You can debug Informix SPL routines in: AGS's Server Studio IBM's Optim Development Studio MS Visual Studio with an IBM add-on I don't know about IBM Data Studio's capabilities for this. ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database …
dbschema output
Informix 12.10.FC14 Solaris 10 1/13 Folks, The following SPL exists in an Informix database: CREATE PROCEDURE informix.is_pattern_arg(str1 varchar(255), options char(4000)) RETURNING INTEGER RETURN 1; END PROCEDURE; -- Permissions for routine "is_pattern_arg" grant execute on fu…
DDL SPLs?
As shown in the document below, you can also get the text of spl with sql. https://www.ibm.com/docs/en/informix-servers/14.10?topic=routine-generate-text I think it is more convenient to modify the dbschema output using a script. ------------------------------ SangGyu Jeong Softw…
select next rows
Hi Amit, I prefer a small SPL routine in the case to go step by step through the result set - more flexible. Regards Henri ------------------------------ Henri Cujass leolo IT, CTO Germany ------------------------------…
How to know what edition is installed ?
I think that when there is no suffix on the version, that that is Enterprise Edition: IBM Informix Dynamic Server Version 12.10.FC6XC <-- custom build, but no suffix IBM Informix Dynamic Server Version 14.10.FC3 ------------------------------ Mike Walker ------------------------…
SELECT output to SETs and from SETs to Regular tables
According to the online documentation on the IBM site, creating a collection from a SELECT can only be done for a MULTISET. So we create a MULTISET and them cast to SET, since there is an Informix cast operator for such transformation. As for manipulating SET columns , it appears…
Are there hidden gotchas w.r.t. moving sysadmin tables?
Steps to move sysadmin https://www.ibm.com/support/pages/moving-resetting-sysadmin-database-new-dbspace-ibm-informix-dynamic-server-ids ------------------------------ Gaurav Kumar ------------------------------…
Fast Recovery after correct shutdown
When the engine is down –what is the last line in the online.log ? If it is not IBM Informix Dynamic Server Stopped then the engine was not shutdown properly Cheers Paul…
How do I determine which edition I m running?
John Miller used to have a web page on this but I'm pretty sure it disappeared. If you execute a onstat - or an oninit -Version and see: IBM Informix Dynamic Server Version 12.10.FC10AEE -- On-Line ...... this is Advanced Enterprise Edition IBM Informix Dynamic Server Vers…
ADO - activex data object
What do I require, to connect "ado activex data object" to Informix ? AIX 7.2 IBM Informix Dynamic Server Version 12.10.FC9W1 Regards Dirk…
"hits" reported by 'onstat -g prc'?
IDS 12.10.FC12 Solaris 10 1/13 I run 'onstat -g prc' and examine the output for a particular SPL. I observe a number (12) reported under the "hits" column. I believe this indicates that the particular SPL I am interested was accessed from the cache 12 times. Since when, though…
PC_POOLSIZE?
IDS 12.10.FC12 Solaris 10 1/13 How does PC_POOLSIZE get changed? In our ONCONFIG file, the PC_POOLSIZE parameter is entered as: PC_POOLSIZE 127 The first few lines of 'onstat -g prc' are as follows: informix@ifmx-prod-anc>onstat -g prc|more IBM Informix Dynamic Server Versio…
Re: Monitoring SPL Executions?
"I simply pull from "onstat -g prc" ... my watcher runs constantly and picks up any and all SPLs (seen before or new), tallying them so I always have a datetime|procname|executions_at_that_time record. This actually came in handy recently to find most used SPLs - never thought it…
Version 14.10 bug
Wow, it's really dangerous. I thought it was a useful feature, but when I use it, the SPL code disappears altogether. Thank you for informing us. <example> $ dbaccess stores_demo - Database selected. > create procedure myproc () > define a int; > end procedure; Routine created. >…
select over another database
You can't use INTO variable in "normal" Informix SQL. You either use an external program to collect the intermediary results and them build queries based on that information or you write a SPL routine. In an SPL routine you can build dynamic queries ( with some limitations ). Fo…
listener-thread@soc_be.c:3073: err = -25582:
Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
error initializing 11.70.FC9
How did this continue? What output would 'oninit -ivy' produce, would it also fail 'initializing dictionary and UDR caches'? Did you check INFORMIXDIR / DBLANG settings as suggested by error output? INFORMIXDIR exported? - I'd say so, but trying to make sure. If nothing else h…
Monitoring SPL Executions?
Solaris 10 Informix 12.10FC3 Today I was asked if we can monitor the execution of SPLs. Specifically, the requester wants a list of all SPLs executed in the preceding 24 hours, and the number of times each was executed. I didn't see any Server Studio reports that addressed thi…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
12.10.FC6 Mac port released
IBM Informix 12.10.FC6 release for Mac OS is officially available! John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS)…
Problem with sysdate in SPL
Servio: Looks like you've got your direct answer. If the suggested solution won't work for you because you need sub-second resolution, you will have to write a small "C" or Java language UDR that calls the gettimeofday() system call and returns the time to you in whatever format…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
open curser wth problem
Hey all. I am using IBM Informix Dynamic Server Version 11.50.FC9W2X2 but we are in the process of migrating to IBM Informix Dynamic Server Version 12.10.FC3 so the solution must work for both. I have a spl routine that builds a dynamic sql to run a name search. It works unless …
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
when use IfxDataReader.GetIfxDateTime to NULL valu
Hello, The version of Informix products in my environment is: Database server: AIX IBM Informix Dynamic Server Version 10.00.FC5 IBM Informix CSDK Version 2.90 IBM-ESQL Version 2.90.FC4 Client: PC Windows IBM Informix-ESQL 3.70.TC5DE.…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Error -556 on @ reference
In IDS_A have a stored procedure do_some that has a insert into a local table. In IDS_B have a stored procedure do_some that does: call base@IDS_A:do_some(); Calling this sp works ok. In IDS_C i try to run: call base@IDS_B:do_some(); Fails with error -556 Cannot create, drop,…
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
Mutex spotting
For a definitive answer, please open a PMR.... But apparently: PC_I hash is related to UDR cache... Make sure you have PC_* configured correctly (on big instances you can "over dimension it" because the memory consumption is relatively low). rrlist is more obscure... "resolved …
Re: COALESCE()
Depending on your needs and performance requirmentes there may be an easy solution. AFAIK the standard COALESCE function takes arguments that may have different types, an unknown number and returns accordingly. To the best of my knowledge this can't be done in a UDR, although I'd…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
Over 1,000 days of 24x7 database uptime!
On 29.07.2011 20:38 Lester Knutsen wrote: > From one of our customers, their Informix server hit 1,000 days today > .... congratulations;) > > IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up > 1000 days 00:31:45 -- They beat mine just bit ... IBM Informix D…
Connections to Database slow - for both shared mem
REPLY 1 - ONCONFIG FILE: cat onconfig.prod #************************************************************************** # # Licensed Material - Property Of IBM # # "Restricted Materials of IBM" # # IBM Informix Dynamic Server # (c) Copyright IBM Corporation 1996, 2006 All rights …
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
Query for database HDR mode?
I'm trying to determine from within an SPL routine what HDR mode the current database is in (standard, primary or secondary). Is there anything in systables that has this information? I've looked at sysopendb, but it doesn't seem to have that info. Even better, if I can detect…
Tool to estimate the size of an index
Sorry, I forgot to provide the version of the installation: IBM Informix Dynamic Server Version 11.50.FC4 Operative System: AIX Version 6.1…
Config
I am doing an intial tune for a new instance of 11.5 64bit. All of our previous instances have been 32bit so I am unsure about my current shared memory config... do I have too many buffers? I am also wondering whether I can safely add 1 or more CPU VP's. The stats seem pretty go…
Can't access sysindexes remotely
Hi, We are using IBM Informix Dynamic Server Version 11.50.FC6 using Platform: SunOS 5.10 Generic_125100-09 sun4v sparc SUNW,Sun-Fire-T200 Thanks…
optimum usage of resources
Hi, We are on IDS 9.4 TC9 on Windows 2003 EE OS. The server has two quadcore processors. In windows task manager it actually shows 16 processors (that's because of 8 cores x 2 because of Hyperthreading). We have 16 GB of RAM. We are using Informix as database for our Baan IV …
System Error on Windows 2003 x64 DB Server
After moving to a new DB server, I'm getting an error in the online.log when I attempt to call an executable on the DB server. System() command in SPL routine failed. Win32 Error :A required privilege is not held by the client. I realize that this is more of a Windows/permission…
Lcok iSsue on Sysproc plan catalog table
Hi, Did you run update statistics for procedure? This URL can help you: http://www-01.ibm.com/support/docview.wss?uid=swg21079720 If you are working on version 7 and the problem persists verify if your stored proceduer cache size is enough (onstat -g prc). Vagner On 23 jun, …
To IBM - DeveloperWorks - Articles
Hi, This message is to IBM . In the DeveloperWorks have a lot of nice Informix Articles , but most of them very very olds (2001-2006) what they treat only old IDS versions without consider news resources and updates.... Is time to review and update all this articles , isn't ??…
How to check informix DB bottlenecks
Hello, network latency might have quite an impact, if the application is reading a lot of rows one row after the other (without array fetch), or even worse, if it is reading a lot of rows through a lot of small select statements. But from the other performance indicators given …
Informix Dynamic Server Software Downloads
It appears IBM has cleverly hidden the IDS downloads again on the Passport Advantage Website, at least from my prying eyes. I can find the Solid DB and the DB2 links just fine. Does anyone out there in IIUG-land with a Passport Advantage account know where IBM has stashed the dow…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
Open SQL Statements
Hello, How can we identify that a particular session has how many open SPL routines or statements? I mean, how can we identify number of routines that are just open and doing noting? Whats the procedure to close these open statements appropriately? Do we need to check all sessio…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
To_Char Function
Hi, I am having some problems with this TO_CHAR function in my application. The reason i am using TO_CHAR is to get the date which is 2 months before today's date. I tried running my sql statement with TO_CHAR inside dbaccess and it runs well. But when I run my embedded sql st…
dbschema -f all versus onstat -g prc?
Hi everyone. If I want to get a definitive list of all of the UDR's (stored procedures) in an IDS 9.4 FXC21 database I would think dbschema -f all -d DB_NAME would show them. However when I execute: dbschema -f all -d DB_NAME it comes back with "No procedure" However when I exe…
Poor Performanc with Multiple DB's in one Instance
we are ussing SunOS CA-MCPDB2 5.10 Generic_125100-09 sun4v sparc SUNW,Sun-Fire-T200 with IDS Version 10.0.Total concurrent users are almost 200 per DB. We have updated the buffers to 80,000 but please see that we are using almost 20 instances in parallel. This particular instanc…
Re: Best Use of Free Memory
On 31 Oct, 00:49, "Kevin Cherkauer" <invalid_addr...@nowhere.com> wrote: > David, > > I see the confusion now. The English phrase, "Needs to acquire a buffer," is > too vague. There are really two major cases, but the manual is only > addressing one (the rarer one). The cases are…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
Re: Order by in SPL routines
Krishna wrote: > The section on 'Order by' in the 10.x documentation blankly mentions > that: > "The ORDER BY clause is not valid in queries within an SPL routine." > > (The last line in the page below > http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.s…
Re: Order by in SPL routines
Probably that's what clarified in v11 doc ... http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp?topic=/com.ibm.sqls.doc/sqls723.htm *The ORDER BY clause implies that the query returns more than one row. In SPL, the database server issues an error if you specify the…
RE: Order by in SPL routines
Submit a doc bug. j. Sane ego te vocavi. Forsitan capedictum tuum desit. -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]On Behalf Of Rich Sent: Friday, March 14, 2008 6:04 AM To: informix-list@iiug.org Subject: Re: Order …
Order by in SPL routines
The section on 'Order by' in the 10.x documentation blankly mentions that: "The ORDER BY clause is not valid in queries within an SPL routine." (The last line in the page below http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.sqls.doc/sqls684.htm) What…
onstat -g prc
How do you interpret the output of "onstat -g prc"? and/or how do you tune the PC_POOLSIZE (PC_HASHSIZE?) ? Any feedback is appreciated. onstat -g prc | more IBM Informix Dynamic Server Version 7.31.UD8 -- On-Line -- Up 2 days 08:36:59 -- 3711120 Kbytes Stored Procedure Cache: …
CURRENT time function inside SPL procedure
I did one of my first SPL procedures today with IDS 10.00.UC1 running on a SuSE Box. For timing reasons, I tried to get rough start and stop times between the different Update and Select routines, writing the times out to a logtable. Therefore I declared two Variables Starttime…
What is IPA abbreviation ?
Hi all IBM INFORMIX DYNAMIC SERVER 10.00 PRODUCT RELEASE bug_number 168928 description WITH NON-DEFAULT PAGE SIZE AND ACTIVE IPA'S, TABLE LEVEL RESTORES FAIL product_code ONUTILS component_code ARCHECKR What is IPA ? Thanks…
Re: Strange error when initialising (long)
"Logan, David (DBA - Adelaide)" <David.Logan@hp.com> wrote: Hi Folks, I am trying to install IIUG.IDS.10.00.FC5I1.HPIA64.tar and am receiving the following error after setting everything and running oninit -ivy. informix@i64aus01:(data)> oninit -ivy Checking group membership to…
Re: Calculate optimal value for DS_POOLSIZE
On Oct 16, 4:10 am, Colin Dawson <cjd_1...@hotmail.com> wrote: > For what it's worth, these are my settings > > # Dictionary Cache Size > DD_HASHSIZE 499 # Number of dictionary hash buckets > DD_HASHMAX 68 # Maximum number of dictionary entries p…
Re: Calculate optimal value for DS_POOLSIZE
On Oct 16, 4:10 am, Colin Dawson <cjd_1...@hotmail.com> wrote: > For what it's worth, these are my settings > > # Dictionary Cache Size > DD_HASHSIZE 499 # Number of dictionary hash buckets > DD_HASHMAX 68 # Maximum number of dictionary entries p…
Re: Calculate optimal value for DS_POOLSIZE
For what it's worth, these are my settings # Dictionary Cache Size DD_HASHSIZE 499 # Number of dictionary hash buckets DD_HASHMAX 68 # Maximum number of dictionary entries per hash bucket # Distribution Cache Size DS_HASHSIZE 503 …
Can't execute external command using SYSTEM
Hi guys. I'm trying to use SYSTEM from an SPL routine to execute an external command. It's not an OS command like date, ls, etc.. I can execute date and ls ok, but when I try to execute my compiled C executable, it just won't work either saying "No such file or direcotory" or "66…
need more TIME functions
Hi, I am using IDS 10.0 and i had been working on SPL routines which work with DATETIMEs and INTERVALs, and from my experience they are pretty inflexible and IDS should have provided more functions for these types. 1) When you subtract two DATETIMES you get back an INTERVAL typ…
Temp tables visible between sessions
Hey guys. We're executing an SPL routine from PHP using a persistent connection. We are getting this error unless I run UPDATE STATISTICS FOR FUNCTION before I run the SPL routine. This is the error we're getting: Warning: ifx_htmltbl_result() [function.ifx-htmltbl-result]: Can …
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
Re: Memory leak on AIX 5.3
Please look at the APAR's already supplied (All memory leak issue IBM provided me are listed below, some are fixed) as AIX has at least a few issues with memory access issues. Also if you notice the Service Pack was not completely installed. Other wise your server would return "…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
RE: UDR Cache
Hi , > > Number of lists : 1021 > > PC_POOLSIZE : 2048 ... > > Total number of udr entries: 352. > Number of entries in use : 137 > >This problem is not related whit bad configuration "PC_HASHSIZE" and >"PC_POOLSIZE" ? >I heard tha…
UDR Cache
I try: onstat -g prc OUTPUT: UDR Cache: Number of lists : 1021 PC_POOLSIZE : 2048 UDR Cache Entries: list# id ref_cnt dropped? heap_ptr udr name -------------------------------------------------------------- 444 48180 0…
Re: Mapping cpuvp's to IBM virtual processors on p
For soctcp use 1 or 2 NET VPs (a net VP should handle over 200 connections efficiently but I like to keep that below ~150 myself). #LRUs controls contention between users. In order to read new data into a buffer or to write/rewrite a buffer, the user much latch the LRU in which …
Mapping cpuvp's to IBM virtual processors on pSeri
We're currently running a read-only instance of IDS 10.0FC6 on AIX 5.3 TL-05. The logical partition (LPAR) hosting IDS has 2.4 physical CPU's, divided into 6 logical CPU's. Running nmon's cpu monitor shows CPU 0 at about 50% used, CPU1 used occasionally, and CPU 2-5 are idle. I'm…
Re: Time zone
select dbinfo('get_tz') from table(set{1}) > Krystian wrote: > > Hi, > > > > how to determine in SPL/SQL time zone the client has or the server is > > into? > > It doesn't matter to me which one, as they are both the same. > > I just don't want to create another spl routine just…
Time zone
Hi, how to determine in SPL/SQL time zone the client has or the server is into? It doesn't matter to me which one, as they are both the same. I just don't want to create another spl routine just to determine this /well i hope i won't have to/. Best regards, Krystian…
using a var in spl alter sequence
Bevis Kennedy wrote: > I have an application that requires a series of unique 12 digit integers. The left most 4 charaters are the year and the right most 8 are a sequence that gets reset to 1 every January 1. I have created a spl routine that uses a sequence and then a sql rest…
Checking for file existence in SPL
Informix 9.40.FC3 HPUX 11.11 I have an SPL routine that create entries in a set of tables for use by another program that inserts documents into an EDM system. I only want to create the records when I have ensured that the physical .tif file exists. This SPL is being called from…
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
Re: Possible Feature
Yes, I'm aware of the pitfalls of using this 'return' syntax, and if I choose to use it then I have the responsible for maintaining type consistency. But it would make life a lot easier :-) Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
IDS 9.4 - startup problem
Hi, I'm receiving this error when I try to startup an instance "Initializing Dictionary Cache and SPL Routine Cache...Cannot find message file. Check INFORMIXDIR and DBLANG.FAILED" AIX 5.3 IDS 9.40.FC8 INFORMIXTERM=terminfo INFORMIXDIR=/informix/product/9.40 INFORMIXSERVER=tso …
SPL Contention
Ben wrote: > -- Solaris 2.6 -- > -- IDS 9.4 UC4 -- > > I ran into an apparent contention problem today with a stored procedure. > > SPL 'X' > > process 1 executes SPL 'X' many times in serial > > process 2 executes SPL 'X' once every few minutes > > process 2 cannot execute SPL '…
Re: Dostats Segmentation Fault running Update Statistics for Procedure on 9.40.FC8
Colin Dawson wrote: > > I've just upgraded a server to 9.40.FC8 (from 7.31.FC7) and dostats > works fine when running on table but crashes when run against stored > procedures. Output below You shouldn't have to remove the SPECIFIC keyword anymore. That said, there seems to be …
More information on SQL error -9700
One of our perl developers handed me this a few minutes ago, and I'm not getting many returns when I GTFI. He's getting an raised SQL -9700 error, "more than one routine resolves to given signature", but he's not doing anything to invoke a trigger or SPL. His error is pasted belo…
Informix instances with large number of tables and databases
bozon wrote: > We are doing a proof of concept. In it we want to create a database for > each of our 2000+ customers. In each database we will have about 300 > tables and about 800 indexes. Does someone have experience with > informix servers running with this many databases and …
Performance issue after 732 to 94fc6 upgrade
Sorry, the previous posting of with the onstat output file did not have the sequence of onstat commands. They were in order: informix211 /tmp$ onstat -g cac >> retwa.stats.out informix212 /tmp$ onstat -p > retwa.statsdone.out informix213 /tmp$ onstat -d >> retwa.statsdone.out inf…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Re: Latch Waits
Interesting I'm running 7.31.FD7 - on Solaris 8 and constantly getting the global Cach lock as well. Here's truncated results from onstat -g prc and onstat -g dsc run when almost all users had 'S' in the first column with onstat -u onstat -g prc Informix Dynamic Server Version …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Illegal SPL Routine Entry
This concerns IDS 9.4 TC2 on Windows 2000. I have one database that recently stopped exporting views from dbexport and there are no error messages. It imports fine, but no views. Also, I notice that when I do dbschema -d database -f all Then dbschema aborts after the last store…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
Check INFORMIXDIR and DBLANG.FAILED
Hill, what could have caused it ? angel:/opt/informixids/msg/en_us/0333}oninit -v Checking group membership to determine server run modesucceeded Reading configuration file '/opt/informixids/etc/onconfig.angel'...succeeded Creating /INFORMIXTMP/.infxdirs ... succeeded Creating …
Re: Really Frustrating -9628 Errors
bug_number 130885 description 9628 TYPE NOT FOUND USING SPL WHEN ROUTINE/EXT TYPE CACHE IS HAMMERED ERROR IS STORED IN SYSPROCPLAN product_code ONLINE component_code CT dono have it checked; Superboer.…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
Re: oninit: Dictionary Cache and SPL Routine Cache error
RESOLUTION (sort of): There was some interaction with 4GL, possibly the media was bad, possibly the installation order. The db is now up and running as expected.…
Re: oninit: Dictionary Cache and SPL Routine Cache error
Hi Jef. Just a thought. I think truss -f -o file oninit -v is your help. -f option means -f Follows all children created by fork() or vfork() and includes their signals, faults, and system calls in the trace output. Normally, only the first-lev…
Re: oninit: Dictionary Cache and SPL Routine Cache error
I think that you are right about the message files getting overwritten if things are installed out of order. But, I installed in this order 4GL RT, 4GL Dev, IDS, Client SDK. This has worked for me in the past. I don't think that the missing message file is the problem. I thi…
Re: oninit: Dictionary Cache and SPL Routine Cache error
Looks like it is forking at the end and dying. ------- open64("/dbms/informix/etc/.infos.demo_on", O_RDWR) = 0 fcntl(0, F_SETLK64, 0xFFBD6D70) = 0 read(0, "\\007\\0\\0\\00201\\b\\0\\0\\0\\0".., 264) = 264 read(0, "\\001\\0\\0\\0\\0\\0\\0 R V H01".., 264) …
RE: oninit: Dictionary Cache and SPL Routine Cache error
Jef Have you installed any tools (4GL or ISQL) In the same directory? I have seen a similar error when the Tools were installed after the IDS and not before. Keith -> -----Original Message----- -> From: Jonathan Leffler [mailto:jleffler@earthlink.net] -> Sent: Monday, October …
oninit: Dictionary Cache and SPL Routine Cache error
I am having some trouble initializing shared memory on Solaris 9 with Informix IDS 9.4. --------------- $ oninit -ivy Checking group membership to determine server run modesucceeded Reading configuration file '/dbms/informix/etc/onconfig.site'...succeeded Creating /INFORMIXTMP/…
Re: Illegal SPL Routine Entry.
PTS Bug# 163050 ILLEGAL SPL ROUTINE ENTRY WHEN RUNNING DBSCHEMA You must be hitting this. Fix is available in 9.30.xC7 and later. Thanks and Regards, Gaurav tomcaml@gmail.com Sent by: owner-informix-li …
Illegal SPL Routine Entry.
we get this error (Illegal SPL Routine Entry) when running dbschema but server studio will generate all procedures to a script without a problem. is it possible for dbschema to be corrupt? just throwing ideas out there...we have dropped and recreated all proc's and ran update st…
-9600 error returning from an SPL
I've created a routine that returns a MUTLISET so we can encapsulate a rather complicated query in a SPL. However it keeps producing an exception -9600 at the end and this returning an empty set. -9600 isn't in my documentation so I don't really know where to go looking. We've…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
RE: Memory resident tables
Gustavo Tobares wrote: > This message is in MIME format. Since your mail reader does not understand PLEASE do not post MIME. It more than triples the bandwidth required to download and store your posting. > > Hi all, > > S.O: Solaris 8 > ENGINE: IDS 7.31.UD8 > > In the last…
SPL
Hi fellows, At our main development box when the daily dbexport is performed, the following error appears: "Illegal SPL Routine Entry" just after a few procedures got exported. I've tried droping a suspicious procedure but the error is still there. Can you give me a clue what…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
ER Classes at Conference
Yep - doing it on Sunday. I'm covering setup issues, trouble shooting, best practices, and unusual usages with replication. I'm also spending a bit of time with synchronization/resyncronization techniques and will be discussing an ER toolkit that I'm putting together. The tool…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
Work group edition - Unlimited edition??
Taken from IBM web site:- =========================================================================== The following Informix Dynamic Server Workgroup Unlimited editions have been added to the IBM Data Management Gold Transaction Processing Bundle for SMB Unlimited: IBM Informix…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
UDR Performance Question
Sean Baker wrote: > This is a multi-part message in MIME format. > > ------_=_NextPart_001_01C3FFA6.9A9C42E7 > Content-Type: text/plain; > charset="US-ASCII" > Content-Transfer-Encoding: quoted-printable Don't post frickin HTML :o( > We've been using SPL routines with some ver…
Re: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
Illegal SPL routine entry
Hello, Dbschema on database comes out with the above error. I tried doing dbschema on previous & next routines according to procid, they come out fine. Is there a way to find that illegal SPL routine? There are more than 500 routines. Thanks !!! Rakesh…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
JDBC returns error - 674
Has anyone come across a -674 error when using JDBC to access a StoredProc in 9.4. Our client works OK with IDS7.31 FD3, but we get this error in 9.4 FC2. The error seems to be -- You might also see this error message if you write an expression that calls an SPL routine (stored …
SPL routine.
--=_IS_MIME_Boundary Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all, We are running IDS 9.3 on Solaris 8. Does any one know how can I check when some SPL routine is created in database. I need a date of creation. thanks, ljiljana --=_IS_MIME…
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
Building SQL from parameters in SPL
On Mon, 04 Aug 2003 11:01:50 -0400, Ian Briscoe wrote: > This may be an easy one but I can't quite get my head around it - having > not used SPL before. Not easy actually. SPL does not permit dynamic queries so the database and table names must be static in the code. Only rep…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
db export issue with ids 9.3
Hi All, I am unable to dbexport (dbschema) the database because half way through it quits with the error "Illegal SPL Routine Entry". From what I have gathered this is cased by a illegal SPL name (I was told that this is a known bug in IDS 9.3) I have tried dropping and re-cre…
SPL routine error 721 during data import
Hi all, is there anybody who is able to give me some hints about this error? I have red the finderr output, but it won' help! ----------------------- update sch_save set (gwg) = (_gwg) where (and (and (= styc, _styc_typ), (= waeh, 0)), (= gwg, " ")); expression:(= TRIM ( BOTH '…
Re: undocumented parameters
----- Original Message ----- From: Ricardo Manzo <Ricardo.Manzo@cosan.com.br> At: 3/12 16:20 > Hi all , > > Does anybody know the meaning about the parameters below and how does it affect > performance ? Yes... > DD_HASHSIZE Not to forget: DD_HASHMAX The above control the siz…
problem with HPL
Hello! I have problem with executing HPL jobs from ISA (IDS 2000 on WIN2000) output of ISA window: Command Output onpladm run job robertw.state -p robwol -fu -l "/tmp/robertw.state.log" Cannot execute stored procedure start_onpload SQL ERROR -668 onstat -m: 12:54:27…
sequences
Artem Goncharuk wrote in message <949d61$20s9$1@nl.novosoft.ru>... > >Can you give me the routine code, please. The problem is that my >application works with several databases in unified way. So it is not >a porting from Oracle to Informix generally... Sigh* Database independen…
using text variables in spl routines
hi, I've got some problem when using text variable in SPl routines : example: create table_test ( txt1 text ) ; create procedure test ( test char(1) ) DEFINE my_text references text; ..... ..... LET my_text = ' test '; insert into table_test ( txt1 …
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
Translating SPL to Java
I am in the process of translating some SPL routines into Java. I am curious how others approached solving the following types of issues: * In SPL you are able to do DATE math similiar to the following: IF (((pMer_EndDate - pMer_StartDate)::INTERVAL DAY TO DAY)::VARCHAR(3))::I…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
ERROR IN DBEXPORT!
I made some PROCEDURES AND FUNCTIONS, they where accepted in IDS and they can be execute correctly. But, when I try to export my data base. All tables and constraints and RelationShips are exported, and finally when DBEXPORT exports SPL, DBEXPORT returns a error message which it…
Error -674
Hi all, is there anyone that knows how to fix this error -674( = Routine (xyz.) cannot be resolved ). I am using IIF 9.21 UC2 on SUSE Linux 6.4 . My Application uses the ESQL/C-interface with a system-descriptor-area to call spl's for updates,inserts,etc. On former Informix pro…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
function or procedure ?
Informix recommends to use CREATE FUNCTION for SPL routines which return value. We still use (7.30, 9.21) CREATE PROCEDURE for every SPL routine, returning value or not. Do you think it is dangerous or problematic? Should we put any effort into changing existing code? Thanks Ro…
Re: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
Tracing and datablades
I am a datablade developer trying to get tracing to work for debugging. I am running IDS 2000 on NT and Linux. My datablade uses the tracing code generated by the latest version of the DBDK. I have updated the systraceclasses table and created an spl routine to reference the t…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
Re: prepares in 9.2
Definatly no PREPARE. - otherwise we would never see "How can I write dynamic SQL in SPL" questions >>> <a_blonde@mindless.com> 05/11/00 03:14pm >>> ---- you wrote: > Also, do you know if there is a benefit from preparing sql used > repeatedly in a stored procedure? When sql a…
Re: prepares in 9.2
---- you wrote: > Also, do you know if there is a benefit from preparing sql used > repeatedly in a stored procedure? When sql appears in a stored > procedure, doesn't it automatically save the query plan for future > calls of the routine? If so, preparing sql in a stored proc…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
JVP hangs?
Hello, I'm running informix_dynamic_server_2000_v9_20_uc1_for_intel_linux_2_2_5.zip on FreeBSD 4.0-RELEASE with linux emulation (basically RedHat 6.0) with blackdown's jdk118_v1 (with green_threads). I'm trying to install a jar file both from dbaccess and from a java app (jdbc …
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
Creating C UDR
I am trying to write a C UDR but my routine is not resolving the UDR. Below is the C UDR, the compiler/linker statements, SPL routines, and the error message. The questions I would have are: Q: How do I verify the integrity of my .so? Q: Am I using the correct compiler/linker …
Procedure vs Function
In IDS.2000, I've noticed that Informix has added FUNCTIONS. According to the documentation, Informix recommends using PROCEDURES when your SPL routine does not return any values and use FUNCTIONS when your SPL routine returns one or more values. To me, this is a very thin line…
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
Re: 4GL from Stored Procedure?
Matthew wrote: > > Is it possible to run/call an Informix 4GL routine from a stored procedure? > I'm trying to get blobs into a database and have only been able to figure > out how to do it with 4GL, but i can execute SQL statements or stored > procedures via ODBC. So can i have …
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
SPL exception for success?
I have a SPL routine that is giving the following exception for success. The command is (with definition): DEFINE bXtractSuccess BOOLEAN; Let bXtractSuccess = 'T'::BOOLEAN; The trace output is: expression:"T"::boolean evaluates to t let bxtractsuccess = t exception : lookin…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
Question regarding Stored Procedures.....
Hi All, I am calling some Informix SPL from within a C+ program..is there a way that I can get a return code from the SPL to tell me if it was successful or not? The SPL routines do some deletions and insertions..nothing too radical. I am seeing problems where rows are locked …
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
Stored procedure best practices
Hi Red, If you are beginning to use stored procedures extensively, you would be interested to try SPL Workstation. This is the best visual development and debugging environment for stored procs and triggers. It features the only interactive SPL Debugger that allows to execute pr…
Are there any strings routines under SPL?
Hi all (from Paris) I am using Informix Universal Server v.9.14 TC1 under NT 4 Q1: I would like to split a string into parts separated by a specific token and I havent found any routines available to perform this task. Anyone knows a built-in routine and if not, what can I use …
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
Stored procedure pool in virtual memory
Does Informix 7.xx allocate memory dynamically to the stored procedure pool? How can I determine exactly how much memory the pool occupies? I know about PC_POOLSIZE and onstat -g prc, though not what all the output columns from latter represent. What does PC_HASHSIZE govern?…
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Re: Oracle with informix - please help
There are two hopes - Bob & No !! What GUI are you using ?? Delphi & VB should be able to execute a stored procedure based on the datasource you create within your app. As far as getting a pl/sql stored procedure from Oracle talking to an Informix database - I can't think of a d…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Re: What is a stored procedure?
In article <363730a1.1236249084@news.globalnet.co.uk>, cindewey@hotmail.com wrote: > A lot of queries seem to crop up about stored procedures but I have no > idea what they are. > Can someone please provide a brief explantion as to what it is and how > useful they are? Also, ho…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
execute SPL - function in MISQL - tag ?
Hi everybody ! Is there a way to execute SPL functions with parameters in MISQL - tags ? (It only worked with function without parameters. Every other function could not be revoked for any reason.) Does anyone know why it is not possible to execute an restricted Sql - Statement…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Re: Upper and lower functions in C for Informix 9.x
Rob wrote: > I few weeks ago, I searched this newsgroup for discussions on > string functions (such as upper() and lower()) for the Universal > Server (now marketed as the "Informix Dynamic Server with > Universal Data Option"). There were various pointers to SPL > string handlin…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
Re: Webexplode() and SPLs
Taras! Try with this URL parameter in I'm sure that after that it will works! MIqry2pass=on example in our house: http://sun1.icos.si/usr/shop/webdriver?MIval=/sishop/index.html&MIqry2pass=o n (index.html page executing SPL which UPDATE something) Problem is that webdriver ex…
Webexplode() and SPLs
Hi All. Configuration : Informix Universal Server 9.12TC3, WebBlade 3.30TC6 I've created a SPL routine with data modification statements (CREATE TEMP TABLE, INSERT, DROP,DELETE) . But I can't execute this routine from the <MISQL> tag because it raising ex…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
Re: Session memory grows a lot
We have also a memory 'problem' on solaris Online 7.23.UC1 with the same constellation ( a lot stored procedures, temp tables). I made some tests and came to following conclusion: Whenever a stored procedure is executed the first time the memory grows. Just execute onstat -g op…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
Re: "lazy"stored procedures
You can adjust the PC_POOLSIZE parameter to cache more stored procedures. This parameter is not in the onconfig file by default but can be added. The default setting is 50; with 1200 you may benefit by upping this. -Bill } } In article <0kM4lWAiPejzEwoV@smooth1.demon.co.uk>, Dav…
Re: "lazy"stored procedures
In article <0kM4lWAiPejzEwoV@smooth1.demon.co.uk>, David says... > >In article <5mkinu$8bv@cssun.mathcs.emory.edu>, Oscar Goldes ><ogolde@impsat1.com.ar> writes >> >>Oscar >> >>Sorry, misread your original posting. I agree it does not seem = >>reasonable based on the >>situation …
Re: "lazy"stored procedures
In article <5mkinu$8bv@cssun.mathcs.emory.edu>, Oscar Goldes <ogolde@impsat1.com.ar> writes > >Oscar > >Sorry, misread your original posting. I agree it does not seem = >reasonable based on the >situation you have described. > >I would see what informix have to say and in the mea…
Re: Stored Procedure cache size (PC_POOLSIZE)
In article <330d4ec1.23375420@news.gte.com>, cburton@gte.net writes >On Thu, 20 Feb 1997 18:32:10 GMT, Bashar Chalabi <bashar@ctl.com> >wrote: > >>Hi there. >> >>Anybody knows how the PC_POOLSIZE parameter affects the stored procedure cache? > >This parameter set the number of st…
Re: Fragmented Table
I wouldn't worry too much about this, expecially if this is DSA. In DSA, we maintain a cache of procedures which we use to contain the "compiled" version of the procedure. Since entries in this cache pool are aged by usage, the ones that are used a lot tend to remain in the poo…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
Re: Gupta SQL Windows performance
> Has anybody else experienced performance problems with > Gupta's SQL router for Informix, or is it just us? I've been on a site with an SQL-intensive Gupta application running on top of OnLine and the performance was a bit sluggish, though not really disastrous. In fact, no sl…
Re: Database tuning.. any hints?
>From: jockc@netcom.com (jockc) >Subject: Database tuning.. any hints? >Date: Sat, 3 Dec 1994 01:50:22 GMT >X-Informix-List-Id: <news.10099> >I'm very new to Informix and I'm trying to improve performance >for an Informix application we are running. The application is >Quintus …
Re: Dynamic SQL and speed
> > My systems admins at a development site just started using dynamic SQL. > This seems to have speeded the transactions (posting to the database) > tremendously. The Audit files and transaction log sizes were also reduced > considerably. Does anyone have experience with this? I…
Table names as variables?
Whadd'ya think? Will table names ever be able to be represented as variables? Something like this could make SPL incredibly powerful for maintenance and routine tasks. Or shall we just stick with requiring an additional language (ESQL, 4GL, Shell script) to do such *complex* a…
Flushing changes
Path: emory!wupost!darwin.sura.net!gatech!udel!rochester!cantaloupe.srv.cs.cmu.edu!crabapple.srv.cs.cmu.edu!andrew.cmu.edu!<UNAUTHENTICATED>+ From: Sean.Levy@cs.cmu.edu Newsgroups: comp.databases.informix Message-ID: <EdYNfaS00hMgQ7TYBn@cs.cmu.edu> Date: 6 Feb 92 20:30:30 GMT Org…