Oninit® Archive
Results for “DEFAULTESCCHAR”
Not enough room in ROOT DBspace
Reduce the size of your PHYSFILE. You probably moved it to another dbspace after setting up the first server. Start it smaller, then create the plog dbspace and move it there and resize. j. On 1/4/17 4:09 PM, STEVEN AB wrote: > Hi, > > I'm trying to setup a new server with the …
Re: Restores
On 24 Mar, 17:41, jrenaut <jpren...@yahoo.com> wrote: > On Mar 23, 5:50 pm, "Neil Truby" <neil.tr...@ardenta.com> wrote: > > > > > I note that there are different code streams now between IDS Workgroup and > > Enterprise Edition. > > > And I've just tried to restore an 11.5FC6 EE…
Automated Update Statistics and FORCE
Voted. Thanks for the SQL, Doug. ------------------------------ Davorin Kremenjas ------------------------------…
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 ------------------------------…
Empty `onstat -g his`
Hi Denis. I will raise that with AGS. Meanwhile: EXECUTE FUNCTION sysadmin:task("set sql tracing resume"); https://www.ibm.com/docs/en/informix-servers/14.10?topic=saaf-set-sql-tracing-argument-set-global-sql-tracing-sql-administration-api ------------------------------ Doug Lawr…
ESQL/C conversion error with CLVCHARPTRTYPE
Hi, Yeap, 57372 is 0xE01C which is the code for UTF-8 (You can find the whole list in the $INFORMIXDIR/gls/cm/registry file). Your oncheck output shows you have the correct value for the 'ö' (0xC3B6) so something else must be going on here. I will try to run it on a Linux box bu…
Informix client address sanitizer heap-buffer-overflow with 16 bytes in user name of CONNECT TO
The code is very simple: EXEC SQL BEGIN DECLARE SECTION; const char * un16 = "abcdefghijklmnop"; // 16 bytes => error const char * up = "password"; EXEC SQL END DECLARE SECTION; EXEC SQL CONNECT TO "testdb1" USER :un16 USING :up; ------------------------------ SEBASTIEN SF FLAESC…
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…
use of exists
Sorry for my mistake, I am SQL newbie :)…
SQL question
Hi, I am newbie about SQL and I would like to have 2 sql statements joined on same query. The second one only execute if table exists on database, I am using shell code for it but it takes some time to get results... My code: select x0.sid, x0.username, x0.hostname, x1.sqs_dbna…
SQL Plan Management in Informix
Are there any SQL plan management like SQL Baseline in Oracle for Informix?…
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.…
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)…
Identify SQL version from client
Hi Sergio, You can identify SQL version from the clients, like reported on onstat -g sql, querying the sysmaster:syssqlstat. sqs_sessionid integer, { session id } sqs_dbname char(128), { database name } sqs_iso smallint, { Isolation level } sqs_lockmode smallint, { lock mode…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
matches and like
I'm not sure exactly why you would expect those patterns to match... And to be honest I hate questions and issues around this topic... Simply because it usually comes down to ANSI standard compliance... And the ANSI standard is not freely distributable - although it may be found …
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.…
delimiter
In v12.10 you would just add the "ESCAPE ON" table option to the USING() clause in the external table definition. In 11.70 and earlier, "ESCAPE" takes an argument of a character to use as the escape character, so try "ESCAPE '\\\\'" Art Art S. Kagel Advanced DataTools (www.adva…
Rows having pipe symbols rejected when loading.
Any competent UNLOAD code should be escaping any pipe symbols in the unloaded data fields with a backslash, and also escaping any backslashes in the unloaded fields with a backslash. If the UNLOAD code is not doing that, it is inherently broken. The best fix is to ensure that UN…
External tables not reading all rows
I changed the DATAFILES section, doubling-up all entries except the first. DATAFILES ( "DISK:/soft/devdba/citizen/db/sql/xaa", "DISK:/soft/devdba/citizen/db/sql/xab", "DISK:/soft/devdba/citizen/db/sql/xab", "DISK:/soft/devdba/citizen/db/sql/xac", "DISK:/soft/devdba/citizen/db…
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,…
onstat & SMI
Good day. Is it possible to get information from SMI similar as "onstat -g sql <sid>" shows? Especially we need current sql and last parsed sql... Thank you in advance. P.S. IDS 11.50FC9 for AIX.…
SQL question
HI, in the batch job, I have below three SQL statement. they can run successful. 1) EXEC SQL INSERT INTO capfi0_temp SELECT cah0cmng, cah0dpno, cah0type, 0 dbcnt,COUNT(*) crcnt,0.00 dbbal,SUM(cah0bal*cah0pecnt) crbal, 0.00 dbcml,SUM(cah0bal*cah0pecnt) crcml,0.00 ovbal FROM c…
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…
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 …
Insert Text file in a Text field
I'M USING SQL IBM DATA STUDIO THIS IS THE SENTENCE OF SQL: INSERT INTO MY_TABLE VALUES (FILETOCLOB('URL','CLIENT')); I'M DOING IN SQL BECAUSE THE FILE IS IN MY PC AND NOT IN THE SERVER BECAUSE OF THAT I DONT USE THE FUNCTION LOAD. THANKS!…
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…
systabauth
Almost Dave. You can't filter for values in non-matched OUTER join rows using the older syntax, you have to use an ANSI style query. So, modify it to: output to grant_bill_cyc.sql select first 50 "grant select on "|| rtrim( tabname ) ||" to public as "||owner||";",created from s…
Re: Getting TEXT data in char.
is there a way to do it via SQL / SPL ?…
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.…
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…
Re: MSGPATH x syslog
I have more or less what you want... My "relatively complex script" can be setup for what you want. The configuration file must be setup with a pattern that matches every thing, and you can configure it to call a function that calls the logger. The main script already accepts ar…
Re: MSGPATH x syslog
I have more or less what you want... My "relatively complex script" can be setup for what you want. The configuration file must be setup with a pattern that matches every thing, and you can configure it to call a function that calls the logger. The main script already accepts ar…
How can I shrink the table's space
Thank you for all response, I see finally, use the SQL API. I knew the 11.5 have function for shrink table, so I find the sql syntax in the IBM reference book, but nothing in it. finally it in the SQL API, I learn it from all of you, and I'll learn the SQL API in the futhure, Tha…
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…
state of IDS in sysmaster tables
... is there a way of checking it in sysmaster tables or others (so somehow using SQL).…
finding rwo using key id
forgot to say worked out the sql to use…
SQL Tunning
Hello all again Im bothering you all just because im facing same issues while trying to do sql tunning. Thjis is the query: SELECT edithor.localidad_rango.co_mercado, edithor.mae_mercado.no_mercado, count(edithor.abonado.nu_inscripcion ) FROM edithor.abonado, edithor.am_p…
Dynamic SQL Informix 9.4
I never used: http://www.iiug.org/software/index_ORDBMS.html exec_sql_udr Bladelet that provides dynamic SQL functionality within an SPL procedure [C, ORDBMS, SPL, SQL]…
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…
Find Index & its dbspaces
If you wanna avoid the sql you can use oncheck -pt... MM…
data type for ip addresses
> From: carsten.haese@gmail.com > Subject: Re: data type for ip addresses > Date: Fri, 19 Jun 2009 17:05:00 -0400 > To: informix-list@iiug.org > > Ian Michael Gumby wrote: > > Actually I'd argue that it is. > > Gutsy, considering that we don't actually know the OP's requirements.…
How to Turn Off Automated Update Statistics in IDS 11.50
Is there a way, or are there ways (GUI + command line/SQL API) to turn off AUS?…
SQL question
IDS 9.40.FC3 on HPUX 11.11 When I run the following SQL (Informix Join), I get back almost every record and they don't meet the criteria; however, if I run the statement using SQL join, I get the correct results. Any idea of why the difference or did I create it incorrectly? s…
sql question
We have a datetime year to second field that contains start_time and an interval day to second field that contains elapsed_time. A representative value from those two fields is: start_time 2009-01-26 10:36:29 elapsed_time 0 00:01:25 Is there a way that I can add those 2 v…
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…
SQL statement
Just a comment. You should compare dates to date fields not strings. IDS will convert it for you but at a cost. This may also be causing it to use more temp dbspace and have difficulty with indexing. Change this to: select * from history where h_date between date('01/28/2009') a…
install info for ISQL 7.3?
Hi. The installation steps are in the SQL USER GUIDE under "Introducing INFORMIX-SQL".…
SPL SQL statments with variable define table names
Is there a way to prepare an sql for a stored procedure with a table name that is stored in a variable?…
FAQ - editing Informix unload files
Floyd Wellershaus wrote: > Hi, > This is on ids10.0 and aix5.3 > > We're trying to convert some data over to another database. When > unloading certain fields that have encrypted data inserted into them ( > not informix encryption ), we noticed that the data is getting converted …
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 developer tool
Hi friends, I am new person from Oracle. Does any developer tool for Informix SQL? example oracle developer tool as SQL developer, Oracel SQL, TOAD. It seems that informix is difficute to code SQL statement. Thanks for any help Webjimmy…
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…
Run SQL
Folks, If you run a SELECT with nonexisted column , it show the following 217 error, select item_int from order where order_int = 563; 217: Column (item_int) not found in any table in the query (or SLV is undefined). But, if you embed it as a subquery(below), the whole query …
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…
SQL-Editor
Is it possible to use Informix SSQL-Edirot with IDS 11.5. I am having trouble installing SQL-Edirot after installing IDS 11.5. It complains that I-Connect 2.3 or later is required. Allan…
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.…
SQL IF statements
IDS 10.00.UC4. Is there programming syntax available in straight SQL (eg: in dbaccess) such as the following? Just in SPL? if exist (select count(*) from tab1 where field2 = 0) then drop table tab2; Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@Spir…
DYnamic SQL
Hi guys: Could anyone have a good working example of a ESQL program that would dymamically execute a stored procedure using SQLDA with parameters known only at the run time. If you have could you please post it here. thanks Ryan…
SQL issue
Dear IIUG memebers, I am attempting what I believe to be a very basic operation. I am trying to do a conditional table update from another table using a subquery. For your information I am running: IBM Informix IDS 11.10 Developer Edition Red Hat Enterprise Linux 4 Before writi…
where can download I-SQL for linux?
see title : where can i download I-SQL for linux(X86)…
sql Help
I have a table like this in informix, User Contract ModifiedDate Person1 80545669 3/4/2008 6:41:08 PM Person2 80545669 3/4/2008 6:43:08 PM Person2 80545669 3/4/2008 6:43:08 PM Person3 80545669 3/4/2008 6:43:34 PM Person3 80545669 3/4/2008 6:43:34 PM Person4 80122222 3/11/2008 6:…
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…
Recursive SQL?
Hi, Can I do recursive SQL queries in IDS11, as each row in my table can reference a child row, and Im trying to build a tree to a flat file? (when searching I see that db2 can handle recursive sqls, hoping Informix does as well). If it is possible, what does the syntax look…
sql in informix
HI, I don't know if this is the right group, if not, please point me to the right one. I'm using SQL to query INformix, but I'm getting some weird errors. Below is my query, why is Informix bitching about syntax errors? Also, it doesn't tell me what's wrong, or even where, just …
determine server version via SQL
Hi, how can I determine the IDS server version from a SQL query? I'm looking for something similar to @@VERSION in SQL Server for example. Thanks, Jesse…
SQL question
Hi all, I want to upshift a certain field in my table. update table-name set field-name = upshift(field-name) how can I do this? Thanks any answers. Danny…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
SQL Server using Informix-4GL
Our application uses SQL Server as backend Database. Some times this error occurs when the background processes are running. [Microsoft][ODBC SQL Server Driver][SQL Server]Could not continue scan with NOLOCK due to data movement. Any one faced such problem. Please clarify.…
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…
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…
SQL Fun
I was thinking about this the other day and I created some "amusing" examples. Technically SQL has no reserved words so you can create some abdominal SQL. Of course in reality some of them don't work or don't work all of the time so here are some examples of some really bad thin…
RE: Senior Oracle DBA now Learning Informix byRequestofCompany:IThought Informix
> Speaking of Oracle ... PL/SQL is clunky. PL/SQL is actually pretty sublime as a language. I don't think the comparison to ACE is accurate. I think ACE was more like the SQL*PLus language extensions in Oracle (which are a little clunky).…
RE: Multilines with 7.2-Dinosaur
PDO is available in PHP 5. No chance if u run PHP 4. I think the replacement strategy is the only one I can think of (besides upgrading :-) ). > -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of tom > Sent:…
Multilines with 7.2-Dinosaur
Hi, thanks for your replys Jonathan and Art. Jonathan Leffler wrote: > Art S. Kagel wrote: > >> tom wrote: >> >>> I am just trying to insert text with multilines to a char-field. We >>> still use the very outdated version 7.2 of informix. > > > The first advice would be upgrade…
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…
Script dbspace-pages.sh posted to IIUG library; part of monitor_space
Hi, my distant family. :-( A few years ago, I posted monitor-space.shar, a shell archive whose ceterpiece was dbspace-pages.sh. (It got posted as monitor_space, with an underscore instead of the dash). Anyway, I recently ran the script against an OnLine 7 server where the the …
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…
SQL help
Greetings, I'm looking for some SQL help. I have two tables: Table 'h8_address' has approximately 370,000 rows; Table 'land_records' has approximately 5,400 rows; Both tables have an address column: Address column for table 'h8_address': stname Address column for table 'land…
informix 4gl Version 7.32.FC2 - "CASE" and "PIPE OPERATOR" cannot be used in the direct SQL conditional clause
ggk517@gmail.com said: > Thanks every Informix Guru, it works now. What worked, prepare and execute or SQL / END SQL? Or both? :o) -- Bye now, Obnoxio "... no bill is required as no value was provided." -- Christine Normile…
Performance SQL
Hi, Does anyone have some SQL that can provide basic average query response time data. Thank you. Tony…
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 …
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?…
Improving efficiency on char column searches
On 5/10/06, Dave Thacker <dthacker@omnicorporate.com> wrote: > > We have several text searches on name or company name fields that are > getting response time complaints. The typical query looks like this: > "SELECT * FROM my_table > WHERE first_name matches "*John*" AND > > last…
RE: Proper method of dropping 160K views
Thanks Keith and Carsten, that was exteremly helpful! I used a slighly modified version of your sql to only get the views I needed, and after viewing the .sql file, I dropped them successfully via dbaccess. Kudos!…
Linked tables in SQL
Is anyone using linked tables in SQL to connect to a ids9.4 db ken.shew@state.co.us…
RE: Splitting field
Dirk: I'm big in the isql side of the production db myself. I do most of the ad hoc queries and data modifications for data integrity purposes. If you only use ISQL, you can still try it as: Ex 1: Where st_name like "%sample%" Ex 2: Where st_name matches "%sample%" Of cours…
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/…
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!…
Re: SQL to search for column name
"They teach you this in SQL #1 don't they? " It's the one I remember!…
SQL question
Hi, all. Actually, I am working with Sybase AS IQ 12.6, but hope that your SQL experience would be helpful Situation - I have several tables, containing date fields: table1(start_date, end _date, id1, id2) table2(start_date, end _date, id1, id2) table3(start_date, end _date, i…
Hi
Hi , exist Informix Helper? same, SQL helper or ORACLE Helper?... thanks…
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.…
SQL Query
Hi, I have a insert query which has got select query inside. Eg: INSERT INTO table_1 (col_1, col_2, col_3, col_4) VALUES (13,'A',0,1 || ( SELECT SUBSTRING( NVL(MAX ( col_4 ), 10 ) FROM 2 ) FROM table_1 WHERE col_1 = 13 AND col_2 ='A' ) + 1 ) The select part in the query gives…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
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:…
SQL Tuning ...
Is there any document available on Informix SQL tuning for peoplesoft applications ... Bunch of thanks ...…
Fun with SQL
So, I have to tip my hat to the engineers who wrote the SQL parser for Informix. Believe it or not, the following SQL will run with no errors: create table from (select integer, where varchar(10), and varchar(10), or varchar(10)); select select from from where where = '=' and a…
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…
SQL for Itanium
Hello all I have a pair of procedasadores Itanium for R4440 hosts, but I have not been able them to install so that I have an application that has menus in SQL, Informix has not sent SQL for Itanium, if amount version SQL_7.32.FC2 worked tendre problems Thanks for its commentari…
SQL book
Hi, I find the Informix 7.3 manuals very poor for SQL examples. Any recommendations on an advanced book? Thank you, Tony…
Re: Cannot DROP database
kadu wrote: > I've found that we are using an Enterprise Replicatio (ER). So It's > reason why I can't drop it. All of you right said that anything is > using it... But Why I can't see it with onstat -g sql? onstat -g sql only shows connections that run sql.…
Re: Cannot DROP database
kadu wrote: > I've found that we are using an Enterprise Replicatio (ER). So It's > reason why I can't drop it. All of you right said that anything is > using it... But Why I can't see it with onstat -g sql? onstat -g sql only shows connections that run sql.…
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: sqlcode 37000 preparing statement with
Does matches with "*" has the same result? J. -----Original Message----- From: muqusun@gmail.com To: informix-list@iiug.org Date: 14 Feb 2005 15:07:34 -0800 Subject: sqlcode 37000 preparing statement with "like" Hi, I am coding with esql and try to feed informix with queries …
third edition of SQL FOR SMARTIES
I am working on the third edition of SQL FOR SMARTIES. If anyone has an SQL programming technique, trick or tip that they think should be in the book, drop me an email. You get a virtual beer and your name in the book. Even better, if you have an improvement on something in th…
Multiple like conditions
johnjohn-gg@triceratops.com wrote: > I can't seem to find the answer to this question in the SQL docs or the > group archives. I've even tried some experimentation without luck. > > I'm doing a select with multiple conditions AND'ed together. On one > field, I'm trying to use …
SQL problem
Hi. I have problem with update like this ex. UPDATE Table1 SET Check='Y' WHERE Table1.ID NOT IN (SELECT Table1ID FROM Table2) Problem is very long time of execution when Table2 has milions of records. Any idea how to solve this?…
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
SQL puzzle
Hi, I'm looking for some elegant SQL for the following scenario: 1-a very large table of data consisting of a key and code 2-there are approx. 100 codes 3-a case can consist of 1-n rows, where each row has a key and code 4-there are approx. 1 million cases I would like to coun…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
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…
convert stringfield to integerfield from an INFORMIX DATABASE
I would like to convert a numeric-field into a new "string"field. 1. what is the correct operator for this conversion in an sql-statement? 2. where can I find a good manual for sql on informix-databases ?…
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…
Re: A Question about (CONSTRUCT in I4GL and ISQL) Perform
Andrew Hamm wrote: > Jonathan Leffler wrote: >>There isn't any way to do this - it is a weakness of both ISQL Perform >>and I4GL CONSTRUCT statements. > > One of my cow-orkers asked about making CONSTRUCT yield a "NOT MATCHES" > clause, and there isn't syntax for it. > > I propos…
Re: DB2 Magazine
Sure -- Serge Rielau DB2 SQL Compiler Development IBM Toronto Lab…
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
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: dbaccess unload to a pipe
DL Redden wrote: > Here is my code. I should clarify that I don't close > the pipe. I close the file that I'm writing to. Thank > everyone for your input. > > #!/opt/perl5/bin/perl Add -w to that line - it warns you about some possible problems not covered by 'use strict;'. > …
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,…
SQL syntax
I'm trying to run the following query but get a syntax error shown below. Can you place a select within the From clause as below. Is there a work around? select y_BIRTH_LIVE. brth_regist_yr , LOCATION. dhc_cd , LOCATION. dhc_nm , y_BIRTH_LIVE. dhc_cd as dhc_cd2, LOCATION2. dhc_n…
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…
RE: IDS to DB2 conversion
Good post :-) -- Serge Rielau DB2 SQL Compiler Development IBM Toronto Lab…
Re: IDS to DB2 conversion
..., and Kone -- Serge Rielau DB2 SQL Compiler Development IBM Toronto Lab…
IDS to DB2 conversion
Is anyone aware of a migration tool for Informix DS 9.4 to DB2 UDB v8.1 conversions? The DB2 Migration toolkit works only for Oracle and SQL Server (and then only for an ageing version of DB2 and antediluvian ones of SQL Server). thanks Neil…
IDS to DB2 conversion
Is anyone aware of a migration tool for Informix DS 9.4 to DB2 UDB v8.1 conversions? The DB2 Migration toolkit works only for Oracle and SQL Server (and then only for an ageing version of DB2 and antediluvian ones of SQL Server). thanks Neil…
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…
Parametes in SQL-Statement ?
Hi there, is it possible with informix-sql creating an sql-statement with parameters like in ms-access? sample with access: SELECT ArtikelName FROM Artikel WHERE (((ArtikelNr)=[Artikel:])); <---[Artikel:] is the parameter!!! thank for all ansers.... Sandro Germany…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
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…
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?…
why total width of all index can't exceed 255?????
>This is a basic database design question. Nothing to do with >Informix. I am afraid by asking such basic question you are >only exposing your ignorance of a good design. Maybe it is a good and basic database design pattern. But There is no always good design pattern under every…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
Gupta SQL
A blast from the past. IHAC who has Gupta SQL talking to Online 5.1. They want to move to at least 7.31 ( did not want to push my luck too far and go for 9.40 ). Has anyone had the misfortune to attempt this, and if so, did it work? Is there anything that can assist in porting…
SQL Benchmarking
Hi, how can I ensure that data is being read from disk rather than from the buffer? I am moving data between 2 database instances (with insert/select)and would like to compare performance relative to differing configurations/settings. thanks! -Brian…
SQL Question
I have a table where the hierarchy is built by storing the parent_id in the same table.... id, parent_id .... other fields Can someone suggest an SQL statement that will list the entire hierarchy as follows id1 id1.1 id1.2 id1.2.1 id1.2.2 id1.2.…
Remote SQL
Hi , I never used a remote SQL before. Can somebody please help me here. My program is running on a machine A , I want to fetch the data from a machine B. If possible please tell me how I can do it both from the command prompt and programatically. Thanks in advance. Bharad.…
Re: my sql editor
sql explorer ? What are you using...? Chucho! Michael Sterling wrote: > i've lost my sql editor in sql explorer. does anyone know how i can get it back? > > -- Atte, Jes�s Antonio Santos Giraldo jeansagi@myrealbox.com jeansagi@netscape.net sending to informix-list…
my sql editor
i've lost my sql editor in sql explorer. does anyone know how i can get it back?…
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…
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…
SQL construct not supported in informix ?
"Art S. Kagel" <kagel@bloomberg.net> wrote in message news:<pan.2003.07.17.18.01.18.408954.15473@bloomberg.net>... > On Thu, 17 Jul 2003 11:40:27 -0400, vk02720 wrote: > > > The following SQL construct does not work in Informix 7.3 select a,b > > from > > (select col1 a, col2 b f…
SQL Editor
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_01C33B22.E7B15030 Content-Type: text/plain; charset="iso-8859-1" Hi We are using the SQL Editor from the old Informix E…
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
SQL question
Hi, Here's my scenario. I have two table in a one-to-many relationship in IDS 7.31. Is there a way in SQL to unload matching rows where a row is consolidated. What I mean by that is explained in the example below. Table1 has row: A|B|C|D Table2 (many) has rows: A|B|X|Y|Z|1 A|B|…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
How to hold an update cursor with ESQL/C
"Eduardo Bispo" <eabispo@attglobal.net> wrote in message news:91f3f8a2.0305291238.6f6c73eb@posting.google.com... > EXEC SQL declare cur_mis1 cursor for change it to EXEC SQL declare cur_mis1 WITH HOLD for…
SQL help
Is there another way to use a FROM clause in an UPDATE statement on IDS ? I found out that in a XPS this can be done but IDS don't support this option. ON XPS: UPDATE tab1 SET tab1.a = tab2.a FROM tab1,tab2,tab3 WHERE tab1.b = tab2.b and tab2.c = tab3.c Has somebody has done so…
SQL question
I am working with a db that has a datetime field (modified timestamp) in every table and would like to write a stored procedure that will loop through every table in a that db to determine what tables had new/modified records after a certain point in time. I am working with an ap…
Admin script has syntax errors...
This is a multi-part message in MIME format. ------=_NextPart_000_03CA_01C0759E.442DAAE0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hello Listers, I downloaded some DBA scripts from the Internet; however, I'm having difficulty with one that…
Informix error II
Suggestions? EDBEngineError General SQL error. Connection does not exist. 29231 ShiftZZ…
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…
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…
Any alternatives to DBAccess
Hi, I have worked with MS SQL Server and have recently started Informix. I HAAATTTTEEEE DBAccess. Don't they have any GUI tool like SQL Analyzer in SQL Server? Thank you.…
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…
Re: Universe and Windows 2000 Server.
From: "Matti Lamprhey" <matti@polka.bikini> > >"Obnoxio The Clown" <obnoxio@hotmail.com> wrote... > > From: "Matti Lamprhey" <matti@polka.bikini> > > > > > >I think the use of the word "legacy" is somewhat provocative in the > > >circumstances, though. > > > > Yeah, us dinosaurs …
Informix / UNIX
Is it possible to connect to an Informix DB and perform SQL queries directly from UNIX or must you use embedded SQL in a programming language such as C.…
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…
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…
SQL
Dear recipient: I have a table with next information : clave fecha hora valor L01 05/01/2000 00:17:33.1 67 L01 05/01/2000 00:47:36.99 56 L01 05/01/2000 00:55:35.23 45 For each clave there are…
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…
prepares in 9.2
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 procedure would be useless. …
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…
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…
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…
tracing of SQL-Statements
I am looking for a way to trace really each SQL statement an application sends to the database server. Because the source code of the application cannot be changed I have to use means of the DBMS. onstat -g sql sid -r seconds > file records sql statements. The minimum interval …
SQL -
Hi All, I've got table 1 with 4 articles A, B, C, D and i've got a second table 2 with articles B, D, E, F, and I want to create a third (temp)table 3 with the articles from table 1 & 2, from A throw F. How do I manage that? I've tried a lot with temp tables, joins and outer j…
ESQL/C : Syntax error
> main() > { > EXEC SQL connect to 'newdb'; > EXEC SQL BEGIN DECLARE SECTION; > struct stc > {...} > EXEC SQL END DECLARE SECTION; Hi Maria, I think you will have to DECLARE your stuff first, then CONNECT to your database. Hth, Chris…
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…
Select ... like (subselect) - Possible?
Hi Eugene, in the meantime I just came across a similar solution. It was much easier than I thought... (I hope I remember the query correctly, because I'm posting this from home...so I wasn't yet able to check your solution, but it looks like you got it.) Here's mine: select …
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…
Merge from PL/SQL and Transact SQL.
I need to quickly merge some PL/SQL statements from Oracle and Transact-SQL statement from SQL server. I guess the extension of SQL for Informix is called 4GL. Is this right? Can anyone recommend any books. I like the O'Reilly series. Sent via Deja.com http://www.deja.com/ Befor…
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…
Re: About Store Procedure
Ricky wrote: > > Can I dynamic generate a SQL(e.g. a string variable to > store a SQL), and execute it in a store procedure No. SPL does not support dynamic SQL. The best you can do is to generate a new stored procedure from the original one and execute it. Art S. Kagel…
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…
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…
Urgent: Q on loading table into memory
Hi, What is the Informix SQL command to load a table into memory ? TIA Vasudev…
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.…
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…
|| in 4GL and upshift in SQL
Jacob Salomon wrote: [.....] > > Now, as for the || operator: For some silly reason, Informix did not > see fit to endow 4GL with an understanding of the full SQL syntax > understood by the engine. Informix 4GL handles[embedded(direct)] syntax of SQL only upto 4.10 engines. The…
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…
Announce: IDSspaces Beta Disk Usage Tool For Linux IDS 7.30
I'd like to release this for testing, as I don't have a very complex system on Linux, and would like to see if it works correctly for a variety of systems. It's also been stripped down from another version I used on XPS. This one appears to work correctly but I'd like some feed…
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.…
INFORMIX-SQL 7.3 ???
Knows somebody if INFORMIX-SQL V 7.3 exists?…
INFORMIX-SQL 7.3 ???
Anyone knows if there is an Informix-SQL VERSION: 7.3 available?…
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…
SQL or SQL runtime
Hello, I have a question about informix products. When I order informix IDS 7.31, also order SQL and SDK (ESQL/C including in this CD ). After I install SQL, I found it is just SQL runtime. My question is: if I don't need to use isql tools, do I need SQL? what is the exactly mea…
What difference CLOSE cursor between FREE CURSOR?
What difference CLOSE cursor between FREE CURSOR? EXEC SQL close cursor; EXEC SQL free cursor; -- ------------------------------ e-mail to soph@doit.ajou.ac.kr…
RE: How Can I find the ascii value of a char in the stored procedure?
On Mon, 17 May 1999, Girish Kagrana wrote: >But how I will insert those characters whose ascii value is between 1 to 3= 2 >(that is my prime requirement) 1. Are you sure you don't want space ' ' ASCII(32) to be valid? 2. You won't; you'll insert only those from 33 ('!') through…
convert() function
Does Informix have any way to do datatype conversion within SQL? Such as MS SQL Servers convert function? Thanks…
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…
A 4GL Question
The 'Sql Power SniFFFer' product line for Informix was renamed the 'Zero Impact Sql Monitor' to more appropriately describe the product's non-intrusive, 24x7, zero impact -- SQL and service level monitoring facilities. Refer to www.sqlpower.com. Mary Owens Sql Power Tools www…
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…
Re: audit of sql-statements
> >Check out www.sqlpower.com > >The Sql Power SniFFFer is about to be released for Informix. > >It is a ZERO impact, 100% non-intrusive -- SQL service level monitor that >will capture all SQL statements with their associated performance. Ever heard of the Heisenberg principle :…
Web based SQL Tutorial w/ live Practice Database
Check out this new Web SQL Tutorial & SQL Interpreter: torresoft.netmegs.com This site provides SQL Instruction and allows you to submit your own SQL commands. You can create your own tables, perform inserts, updates, deletes, drops, selects, etc. --…
MS SQL and Informix SQL
Hello friends, I was wondering whether anybody out there knows of any mechanism for converting MS SQL scripts to Informix SQL scripts. Thanks in advance, Paul…
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…
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.…
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…
URGENT: HELP --- Select and Insert into the same table ?
Hi, In ESQL/C, is it possible to insert rows into the same table which is fetched within a cursor loop ? ie. can the following code work ?? --------------------------------------- EXEC SQL DECLARE curs WITH HOLD FOR "select n from toto"; while(1) { EXEC SQL FETCH cur…
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…
Dynamic SQL in SPL
Does anyone know of a way to use Dynamic SQL or Macro Expansion within Stored Procedure Language? I need to be able to pass all or part (say only the where clause) of a SQL Statement as a parameter of type varchar to a stored proc and have it parsed and executed as a SQL Stateme…
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…
Re: Select-Statement (TOP)
Informix SQL does not support the TOP statement.…
Q: How to break SQL file into single SQL statements?
have an SQL script file with a bunch of SQL statements separated by ';'. I have a problem of breaking this file info single SQL statements because ':' can be within SQL statement as well. Does anyone know a program that can break SQL file into single SQL statements? =Dmitry <ko…
seeking for remote job.
Programmer seeking for remote job. Skills MFC ODBC , Bilder, Delphy, SQL etc. Thanks.…
Re: Informix stock
Sorry, I was talking about SQL Server 7 (beta). Boris…
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…
[Request]the program for analyzing the SQL statements?
please help me. i want to obtain the program for analyzing the SQL statements.…
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: ? Trapping 'RAISE EXEPTION' in Informix stored procedures & Delphi 3 C/S
Ivan Lyakhovenko wrote in message <01bd94e8$36874480$59b1e2c2@van.xtech.ru>... >Hi Dennis! > >I have the same problem with D3 C/S& Informix 6.0. And this problem >is quite serious for me too. I found that in the first case when >exception occures, SQLCA.SqlCode has correct error …
|| in 4gl
Hi, Is it not possible to use the concatenation operator || in sql statements in 4GL ? TIA sathish…
Re: Informix-Online under Linux
Take a good advice: switch to NT and MS SQL Server. Boris…
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…
RE: Pipe Command
---------- From: Jim Mershon[SMTP:shenango@shenango.com] Sent: Thursday, April 09, 1998 9:11 AM I'm new at using ESQL/C and need some help. Can anyone explain how to use a pipe command to move data from a btrieve database to an informix database? What I do in c is move…
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…
New is SQL 4gl 7.20 for NT
Hi! What new in SQL 4gl 7.20 for NT?…
sql
Hello all, I know with informix SQL, there is a pow(x,y) function and an exp(y) function as well, but is there a logarithm/natural log function? I've tried log(x) and ln(x) but get syntaxs -Thanks, Felix…
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.…
Is there an Emacs SQL mode that is compatible with Informix SQL?
Has anyone ever written an SQL-mode for emacs that is compatible with Informix SQL? Is there interest in one? (other than myself?) The sql-mode that exist now with emacs seems to be Oracle-friendly. -- Thomas Tatum thomas@rtp.koz.com 919-489-5662 x2129 919-602-6521…
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
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…
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…
Re: Q:What is SQL buffer size
Manickam R Muthukumar wrote: > I am wondering what is the SQL buffer size for Online7.2 engine. > Actually I am writing dynamic SQL from C++ and sending the SQL to Online 4K is the default. There is a way to increase it but not to shrink it. You can affect the communication buf…
Re: calling stored procedures from 4GL
Ed Schaefer wrote: > > Greetings: > > Given: > Unix: SCO > Engine: 7.23 Online > 4GL: 6.04 > > I'm new to stored procedures and I'm trying to call a Stored Procedure > from > a 4GL program. I'm trying to call a stored procedure, sp_in_string, > which > checks if a substri…
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…
WTB -- Informix for Unix
Looking for Informix SE, 4gl, and SQL for SCO Unix. Steve sje2967@aol.com…
Re: Need basic ESQL/C help
Dan, Have you wrapped host variable declarations in begin and end declare section. EXEC SQL begin declare section; . variables used in sql statements . EXEC SQL end declare section; Drew…
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…
SQL Builder Tool
I'm looking for some information about SQL Builder. I think its made my Penta Tech. Inc., but I was not able to get any information from newsgroup. Is this case tool useful in development? Can this SQL Builder hander more than one databases? Any info will be greatful about SQL …
Adhoc interactive client side access for data warehouse?
We are working on a platform/database independant Adhoc SQL client side access environment. The target users are Adhoc SQL programmers, technical business analysts, and application programmers developing SQL for a data warehouse. This is not for SQL impaired users, it is a soph…
Adhoc interactive client side access for data warehouse
We are working on a platform/database independant Adhoc SQL client side access environment. The target users are Adhoc SQL programmers, technical business analysts, and application programmers developing SQL for a data warehouse. This is not for SQL impaired users, it is a soph…
HELP - Dynamic SQL Engine
Any help is greatly appreciated: Scenario: Input parameters in the form of a binary tree which contains all the necessary parameters for the WHERE clause. Goal: Need to parse this tree to build the SQL and execute the SQL and return results to the calling program. What's the b…
Text books on SQL processing
Hi Does anyone know of a textbook, or any other reference material, on handling of SQL. I'm thinking of the processing of SQL in terms of the compiler/translator technology and the techniques that have been developed for handling the semantics i.e. the design and implementation …
I wonder why!!!! ESQL/C unsigned char
I also noticed that an unsigned char is not recognized by the SQL compiler.. WHY????? Sham…
An SQL question
Hi everybody, can anyone help me with the attached question? Thanks in advance. begin 600 SQL question.doc MT,\\1X*&Q&N$`````````````````````/@`#`/[_"0`&```````````````! M````"@``````````$ ``$0````$```#^____``````L```#_____________ M______________________________________________…
Re: Set Explain
>David Williams wrote: > >Well I was going to get an sqexplain.out from work and write some C on >my Linux box at ome but plug away.....my idea was to have a version >that stripped out constants from the sql i.e. any 'word' in single >quotes and any numbers. This means two runs…
Re: Set Explain
My apologies if this has already come up in your mailbox, but my email system crashed, so I dont know if it was sent OK. :David Williams wrote: : :Well I was going to get an sqexplain.out from work and write some C on :my Linux box at ome but plug away.....my idea was to have a…
Re: Set Explain
:David Williams wrote: : :Well I was going to get an sqexplain.out from work and write some C on :my Linux box at ome but plug away.....my idea was to have a version :that stripped out constants from the sql i.e. any 'word' in single :quotes and any numbers. This means two runs…
Re: Informix 7.x and Fourgent
> We are using Online 5.05, with Fourgen Case tools 4.10. We would like to > upgrade to Online 7.x Is there anyone out there who has done somthing > similar, and if so are there any problems to look out for. > > leonj@zeta.org.au > Hi there, What version of Informix 7.x and Inf…
Re: C++ and informix
>From: Chengteh Lee <clee@acustaf.com> >Date: Thu, 23 Jan 1997 14:32:45 -0600 >X-Informix-List-Id: <news.32939> > >How to compile informix esql using C++ compiler? >A demo of Makefile and simple C++ code will be >very very helpful. This is a semi-frequently asked question. The …
Re: Exclusion list in a query-by-example
This is a multi-part message in MIME format. --------------3D8D6B675D79 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Jacob Salomon wrote: > > For the purpose of this question, I am assuming forms with the > instruction: > DELIMITERS "<>" > > A col…
Exclusion list in a query-by-example
Hi all. For the purpose of this question, I am assuming forms with the instruction: DELIMITERS "<>" A colleague asked me a kicker of a question today: When the user is entering a query (in either 4GL or ISQL) it is easy to put matching paterns between the brackets. For examp…
SQL Question
Can anyone tell me how to translate : LOCK MODE ROW (Informix) to Standard SQL ? Thanks in advance. Karel kadwilde@rug.ac.be…
SQL QUESTION
Can anyone tell me how to translate : LOCK MODE ROW (Informix) to Standard SQL ? Thanks in advance. Karel kadwilde@rug.ac.be…
SQL QUESTION
Can anyone tell me how to translate LOCK MODE ROW (Informix) to Standard SQL ? Thanks in advance. Karel kadwilde@rug.ac.be…
SQL question
If I have the following SQL select column1, count(*) from tablefoo group by column1 It returns 24 rows with various counts. Is there a way to return just the number of rows that would have been returned. (ie just the number 24) I know I could put it in a temp table and then co…
SQL question ...
Assume I have table A with composite key C1, C2 and table B with composite key C1, C2 . How do I delete from A where C1,C2 in(select C1,C2 from B where XXX) ; Assume C1,C2 may not be chars so no || deals ... also, no cascading deletes ... TIA, -Lin…
SQL lower/upper-case conversion function
Is there a function in INFORMIX SQL that does lower/upper-case conversion? Thanks. Yudong…
sql help
When I run a report using the following select statement, the data from at lest one customer id does not show up. select in_bname, il_desc, in_date, in_sales, il_unpr from customer, invhead, invline where cucat="BM" and in_bid=cuid and il_num=in_num and in_date >…
sql help
When I run a report using the following select statement, the data from at lest one customer id does not show up. select in_bname, il_desc, in_date, in_sales, il_unpr from customer, invhead, invline where cucat="BM" and in_bid=cuid and il_num=in_num and in_date >…
Ask the SQL Pro
Subject: Ask the SQL Pro Newsgroups: comp.databases Summary: Keywords: If you are new to Informix or SQL, you can ask questions at the Ask the SQL Pro home page at: <http://www.inquiry.com/> Or search our product database of nearly 100 combined web sites and our database of 1…
Datebase Modeling and SQL Code Generation
We're looking for a Database SQL generation and Reverse engineering tool that supports SQL generation for Delta Schema changes. (Not just recreate the entire database, just the changes)…
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: Surely - the *dumbest* Informix question ever asked.... (^|^)
If you don't have I/SQL or the sql runtimes how is we supposed to compile and run a 4GL program to create databases ;-) Terry Hillick…
Re: SQL Beautifier--sqlb
dyue@cs.umn.edu (Dongxiao Yue) writes: >Hello, SQL writer and readers, >I have written a program that beautify SQL statements, it is called >SQLB (SQL Beautifier). >It can be used to edit SQLs or format files that contain SQL/embedded >SQL (such as Pro*C). >For more informati…
Re: SQL Beautifier--sqlb
dyue@cs.umn.edu (Dongxiao Yue) writes: >Hello, SQL writer and readers, >I have written a program that beautify SQL statements, it is called >SQLB (SQL Beautifier). >It can be used to edit SQLs or format files that contain SQL/embedded >SQL (such as Pro*C). >For more informati…
SQL Beautifier--sqlb
Hello, SQL writer and readers, I have written a program that beautify SQL statements, it is called SQLB (SQL Beautifier). It can be used to edit SQLs or format files that contain SQL/embedded SQL (such as Pro*C). For more information, please visit http:/www.cs.umn.edu/~dyue/sq…
SQL Dilema
I am trying to write an SQL Statement to satisy the following situation, any help is appreciated. Table 1 - People - Teachers and Students Table 2 - Student names - exists for teachers only, linked to Table 1 by field X How do I produce output on a Teacher, his/her students, an…
SQL problem ?
Hi, I have two tables with the following data : table 1 : c1 table 2 : c2 --- --- 1 a 2 b How to formulate a query to get data as c1 c2 ?? ----- ----- 1 a 2 b…
SQL Anomaly?
Dear Informix or SQL Gurus, I ran into a problem with the following simple statement: delete from tmp_kontakt where s_doknr in (select unique(s_doknr) from kontakt) ^^^^^^^ Table "kontakt" has 1514 rows, while "tmp_kontakt" had ~6…
Re: sql
Try select whatever from a_table where weekday(a_date_column) not in ("6","0") or somesuch and a_date_column between "010196" and "012496" 0=Sunday HTH - John : > I am trying to write a SQL statement that will look at 2 dates and determine : > the number of work days there…
Re: sql
bayoff@izzy.net (bayoff) wrote: >I am trying to write a SQL statement that will look at 2 dates and determine >the number of work days there are between them. I need to issue the SQL >against many rows. If I can at least exclude the week-ends that would be >great. The holidays, …
sql (fwd)
> > I am trying to write a SQL statement that will look at 2 dates and determine > the number of work days there are between them. I need to issue the SQL > against many rows. If I can at least exclude the week-ends that would be > great. The holidays, a bonus.... Does anyone hav…
Re: sql
Hi, This isn't exactly what you want, but it should point you in the right direction. It is an ACE report that I wrote in response to a request that our database should be able to calculate the response time for samples received by our labs, and automatically determine the perce…
sql
I am trying to write a SQL statement that will look at 2 dates and determine the number of work days there are between them. I need to issue the SQL against many rows. If I can at least exclude the week-ends that would be great. The holidays, a bonus.... Does anyone have an answe…
sql error
I have compiled the following 4gl program successfully, but get a syntax error on line 37 (Error -201). I have tried everything to find out where the error is coming from, even commenting-out line 74, but without success. part.4gl: main define v_osadbname char(512), …
SQL Speedups
I have two questions on SQL access and tuning I can't answer for myself, from books or from the FAQ. Any help will be greatly appreciated... I'm using ESQL/C and I-SE 5.0. Q1: I need to select single data records "atomically" and stateless, and each SELECT has to return the sma…
Help on SQL
The result set we get for ... SELECT col1, col2, col3 FROM tbl1 ORDER BY col1, col2, col3 ... is as shown below : col1 col2 col3 ^^^^ ^^^^ ^^^^ Null Null A Null Null B Null A A Null A B Null B A A …
SQL TRAINING
HELLO EVERYONE! COULD SOMEONE HELP ME GET SQL TRAINING HERE IN THE PHILIPPINES? PLS ANSWER BY CALLING 8404048 TO 49 OR EMAIL prosoft@vasia.com thank you!!…
Re: Getting data to a file, and divide by zero (Running an SQL script from command line)
create a shell script with the following isql <database name> << ! > $0.out 2> $0.err <sql statement>; <sql statement>; <sql statement>; ! or isql - << ! > $0.out 2> $0.err database <database name>; <sql statement>; <sql statement>; <sql statement>; close dat…
Dynamic SQL
I'm knowlegeable with Oracle and will be diving into Informix soon. I have some Oracle PL/SQL scripts which may be useful to port (somehow). They use the dynamic SQL capabilities in Oracle v7.2. I can build an SQL statement programatically, then compile and run it from within …
Embedded SQL
Is there a way to use variables in embedded sql commands in C/UNIX environment? This is what I want to do select :var_column_name from :var_table_name; I know how to host variables but wanted to know if host variables canbe used for the table and column names. Thanks in…
SQL Question???
I am trying to do a SQL query on a numeric field. How do I query the last 2 numbers of a 5 digit field? Example: number field = 54387 - I want to search for all records that end in 87. Thanks…
sql question
How can we made a sql request on a huge table that will get out the last lines without using the rowid column? ex.: let's say that count(*) return 10000 on this table. If we want to get the last fifty lines, for now we are doing: select col1, col2 from table where ro…
Re: Redirecting input for PROMPT Statement
> > The statment in the example was: > > PROMPT "Are you done" FOR CHAR ans > > In this case, I believe the echo/pipe trick will always work. The "FOR > CHAR" will trigger on the typed character no matter what your accept > key is. If the statement is something else, then pe…
SQL Challenge
>THE ULTIMATE SQL CHALLENGE >-------------------------- > I need to be able to perform an aggregate function on two columns where the >value of one column may be NULL. I am aware that Informix's definition of >an > aggregate that includes a NULL is NULL, but does anyone know…
SQL Challenge
>THE ULTIMATE SQL CHALLENGE >-------------------------- > I need to be able to perform an aggregate function on two columns where the >value of one column may be NULL. I am aware that Informix's definition of >an > aggregate that includes a NULL is NULL, but does anyone know…
SQL Challenge
>THE ULTIMATE SQL CHALLENGE >-------------------------- > I need to be able to perform an aggregate function on two columns where the >value of one column may be NULL. I am aware that Informix's definition of >an > aggregate that includes a NULL is NULL, but does anyone know…
SQL Challenge
>THE ULTIMATE SQL CHALLENGE >-------------------------- > I need to be able to perform an aggregate function on two columns where the >value of one column may be NULL. I am aware that Informix's definition of >an > aggregate that includes a NULL is NULL, but does anyone know…
SQL Challenge
>THE ULTIMATE SQL CHALLENGE >-------------------------- > I need to be able to perform an aggregate function on two columns where the >value of one column may be NULL. I am aware that Informix's definition of >an > aggregate that includes a NULL is NULL, but does anyone know…
SQL CHALLENGE
S> I need to be able to perform an aggregate function on two columns where the > value of one column may be NULL. I am aware that Informix's definition of n > aggregate that includes a NULL is NULL, but does anyone know of a way to > represent NULL as ZERO so that the ag…
SQL Challenge
} } THE ULTIMATE SQL CHALLENGE } -------------------------- } } I need to be able to perform an aggregate function on two columns where the } value of one column may be NULL. I am aware that Informix's definition of an } aggregate that includes a NULL is NULL, but does anyo…
SQL Challenge
THE ULTIMATE SQL CHALLENGE -------------------------- I need to be able to perform an aggregate function on two columns where the value of one column may be NULL. I am aware that Informix's definition of an aggregate that includes a NULL is NULL, but does anyone know of a …
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?…
EDA SQL
Hello I have been trying to get a small deomstration working with EDA SQL via Informix and Ingres databases. Should be easily possible given what EDA is supposed to be able to do. I have not succeeded in part, I suspect, becuase the API header file and library that I have bee…
Re: INFORMIX -> Access Script
When you're creating a query in Acess an SQL button appears on the toolbar. If you click on it, a window opens to display the actual SQL code you're generating. I haven't tried, but could you just paste the Dbschema sql statement into the window? Hmm. Gives me ideas. I'll tr…
HELP NEED CROSSTABS WITH INFORMIX
> > If you select items with the group by clause, you get them back in > vertical order i.e. > > item1 amount1 > item2 amount2 > . > . > itemn amountn > > Does anybody know an utility to get it horizontal? i.e. > > item1 item2 ... itemn > amount1 amount2 ... amountn > > Is th…
Looking for PD-Preprocessor
I'm looking for a preprocessor (source-code) which is able to convert SQL-Statements to the dynamic-sql API for Informix Thanks D. Masak -- DMSS…
Re: Is there a faq for this group...
In article <9502201656.aa14220@condor.entel.cl>, Leo Lagos <LLAGOS@entel.cl> wrote: >Hi, i'm just entering the world of DB's, and i'm going to work >with Informix and Sybase. Before i begin, i'm asking for some >information that could be worthy, so i'm looking for the faqs of >bo…
Re: informix/perl scripts
In article <3g4jvq$sg3@news1.best.com> you wrote: : Hi,I am interested in sharing ideas with anyone who has used any perl scripts : to extract data to put in Informix. Hi, I found this posting in comp.lang.perl. Hope it helps. -- Bobby Sukumar Informix SDC. ----- Begin Includ…
Re: SQL Standards [Summary]
Eoin Woods (Eoin@copse.demon.co.uk) wrote: ... : 2. The SQL-89 and SQL-86 standards are obsolete. I beleive Informix is only up to SQL-89, correct? -- Martin Andrews andrewm@ccfadm.eeg.ccf.org Dept. of Neurology Phone (216)444-7485 Cleveland C…
Re: DBperl. anyone using it?
Andy Kent (akent@cix.compulink.co.uk) wrote: : > I don't know about DBperl, but isqlperl is marvelous. Use it all the : time for : > both quick hacks and largish systems. : So what does it (isqlperl) do then? ISQLPERL is an extention to PERL. Both are valuable tools. Below is t…
SQL support
Does anyone know of a SQL package for Paradox for Windows and Informix…
Re: Names matching
In article <32urqr$c7s@emory.mathcs.emory.edu> tilh@sin-co.sin-ro.DHL.COM (Ti Lian Hwang) writes: >We have a problem of matching names (esp. Company names) from one table >to another. Fun, isn't it? >One of the table is actually a consignee database. > >The other is keyed in pr…
Dynamic SQL
Hi ... I have this problem with dynamic SQL: If I need to insert into a table t1 with a single character field, one way to do it is as follows: sprintf (buffer, "insert into t1 values ('%s')", "Sample") and get buffer to be prepared and executed. In cases where the value is not s…
SQL interrupt
hi netters! I know a 4GL OPTION SQL INTERRUPT ON which allows you to interrupt a SQL instruction like open cursor, but Is there anything like this for ESQL/C ? Any workarounds ? thanks you all, ale. -- Maria Alejandra Perez Weiss alex@lucas.mrec.ar PNUD - Min. Rel…
QUES: Unix System Function call
Hi, Just a couple of questions fron informix gurus, Q1) Is there an informix SQL function (similar to USER) that will return the pid of the SQL turbo process running the query. Q2) Does anyone know when/if informix SQL products will confirm to SQL92 standards. --Raj --…
Re: Help: Slow Query
mstowski@seas.gwu.edu (Mike Mstowski) write: > I having a problem with slow queries using Online 5.0 and HP/UX G50. > We have a table with 10,000 rows and each row has 300 bytes, with > 18 columns per row. If I do a serial select on one column, I can fetch > all the rows in …
an SQL question
Informix netters: I have a question: Is there a way from within SQL to find: 1. the number of pages allocated to a particular table? 2. the number of extents that table uses? 3. the length of all the indexes for that table? Relevant info: Online 5.00.UC2 running on a Sequ…
sql question
netters, anyone have any idea why the following sql fails with a -457 error: SQL: New Run Modify Use-editor Output Choose Save Info Drop Exit Modify the current SQL statements using the SQL editor. ----------------------- quality ---------------- Press CTRL-W for He…
Spec char printing with esc
Status of special character printing problem and suggested use. Thanks to Jeff Cauhape, Alan Popiel, Stuart Kemp, and Todd Burkhardt and Charlie Hussey for their advise. The problem has evolved a bit as I have experimented and have worked with various suggestions. I have arriv…
4gl improvement thoughts
I was chatting with tech support a while back, and mentioned I had a "wish list" for enhancements to 4gl to turn it into a significantly more enjoyable language to program in... I was asked to mail it, but I thought since there are so many @informix.com's on here I'd also post i…
Re: change compiler name in 4gl?
>From: bud@mtek.com (Bud Hovell) >Subject: change compiler name in 4gl? >Date: Mon, 20 Dec 93 16:37:48 GMT >X-Informix-List-Id: <news.5131> > >Can one change the name of the C-compiler name sought by Informix 4GL from >"cc" to, say, "gcc"? Is there an environmental variable that …
Follow-up on proposed CONSTRUCT changes
Hi, Here are the revised proposals for the CONSTRUCT statement to support ANSI databases better, and in particular, the Informix-Gateway (DRDA) product. The only issue not formally covered below is the quote character generated by CONSTRUCT; the current proposal is to use singl…
SQL question
I am looking for the smallest value in a table of numeric values for which the next number is not contained in that table for any record. So if we have records with num_val values of 1 2 3 4 5 5 should be selected. For values 1 2 3 5 6 8 3 should be selected. I wrote th…
Text search engine
One of the challenges with textual data is the ability to perform fast contextual searches. Editors, such as vi, have the ability to quickly pattern match HUGE amounts of text. Grep is also prolific in the amount of text it can parse. I am looking for a methodology to tie to t…
sql question
netters, anyone able to explain the following output - explicitely, why the third column is always 1, but the diff column is correct? { get the count of number of columns for each table on host hermes1 } select tabid,count(*) cnt from system@hermes1:syscolumns group by tabid …
sql
What follows is a description of 2 tables and some selects we ran against them, we think the results are not what they should be. Environment Online 5.0 on a SUN SPARC with sun OS 4.1.3 DBaccess Description of the query : Give a list of all assignments (opdracht), with…
sql question
netters, can someone explain why the optimizer doesnt short circuit on the following query: QUERY: ------ select * from book_bill_back where 1=2 Estimated Cost: 370832 Estimated # of Rows Returned: 4330952 1) book_bill_back: SEQUENTIAL SCAN Filters: 1 = 2 r…
Re: perform syntax + semantic
bene@cs.tu-berlin.de (Benedikt Homann) writes: >Could someone tell me which manuals are covering the perform form builder >syntax? Any help would be fine. The manuals "Informix SQL Reference Manual" (part No 000-7042) and "Informix SQL User Guide" (Part No 000-7041) have detail…
sql and synonyms
netters, when i run the following agains a real table, it works fine. but when i run it against a synonym, i get an error stating that x is not a column: select pal_code[1,3] x, sum(net_units) from table1 group by 1; however, if i alter the group by to the following i…
Re: Storing non-printable chars in CHAR columns
In article <20tb3aINN2ur@charnel.ecst.csuchico.edu> tsaylor@ecst.csuchico.edu (Todd M. Saylor) writes: >Here at Bi-Tech Software, we also use COBOL and store binary (non-printable) >values in character fields. We have found that, if the first character >of a field is NULL (low v…
Re: Storing non-printable chars in CHAR columns
In article <11941@cimshop.UUCP>, vchow@HP-UX (Victor Chow) writes: > > I have questions about storing non-printable chars in CHAR columns. > > However, the Informix User's Guide and Reference manuals mention > that CHAR column should store only printable characters. Storing > no…
sql question
HI; I HAVE COME ACROSS ONE PROBLEM IN SQL. IF ANYBODY COULD HELP ME OUT, I WILL APPRECIATE YOUR EFFORT. HERE IS MY PROBLEM: I HAVE A DATABASE OF 50 PATIENTS. EACH PATIENT HAS UNIQUE ID NUMBER. I ALSO HAVE A BATCH NUMBER FOR EACH PATIENT, THERE ARE TWO BATCHES FOR ALL 50 PEO…
SQL Views
Hello Informix Net: I have been working with ISQL v. 2.10 for MS-DOS for some time. I have successfully created a view using the RDSQL language format, everything in the informix system says the view is ok. Question: How do I now use the view to display data on the screen, qu…
Informix SQL ?
Please respond via email. . .and thanks in advance. ============================================================================= We are trying to do some wildcarding using a MATCHES statement, however we are running into a problem. A sample table is created: TABLE NAME: tab…
SQL Forms
I am involved in writing forms for an inventory system, in INFORMIX SQL 4.10. I have shipping information (like, item_code, quantity_shipped, shipping_date) in "item" table, and stock information (like, item_code, quantity_on_hand) in "stock" table. My problem is to update stoc…
Re: Load Table in ESQL/C
>} >} Hi Netlanders, >} >} I've got following problem: >} With ISQL I can easily load a table with >} >} LOAD FROM "file_name" INSERT INTO table_name >} >} Now I want ESQL/C to do the same job and here is the problem. > For my applications I end up building a .sql > load file …
Repost: making isql output horizontal
The version of this program posted earlier had 1 and 1/2 bugs, which are fixed in the following. Also note that "nawk" as distributed by Sun is suitable for executing this. # # reform.isql.output.awk # # An awk program to reformat an Informix-ISQL output listing, # changing…
making isql output horizontal
Since I first posted this, at least two people have posted requests for solutions to the problem of "flattening" ISQL output. For a long time I couldn't find this file, but finally it turned up. So here it is, maybe Walt can stow it safely in his archive at Emory U? # # reform…
Online, SQL?
I am interested in trying to get the TPC benchmark suite to run under Informix on my 486 machine running DELL SysV R4 UNIX. I have been told that the ONLINE SQL product is all I need: 1. Will this product run on this platform? 2. Is the SQL product all I need? 3. An…
SQL Query
Can anyone offer an explanation on why this happens... Given the two tables with indexes shown below: This select runs real slow. I never let it finish because I got tired of waiting. select d1.md_lno, d1.md_data, d2.md_lno, d2.md_data from machdata d1, outer …
sql question
help, im having trouble doing a select. we have a table (trace) which has two trace_types, (WAF and ASM). what i want to know is the ASM source_lots which have more than one WAF source_lot. the trace table: create table trace ( source_lot char(16), test_lot char(16), …
awk script to flatten isql output
When you drive ISQL (or dbaccess?) from the command line, you can store its output in a redirected file. isql stores - >customer.list <<@ select * from customer; @ When the output width would exceed 79 chars, ISQL goes to vertical format, producing like: customer_num 118 f…
Re: ESCAPE key - black magic :-)
carsinfo!carsmax!bryan@uceng.uc.edu (Bryan Klopfenstein) writes: >How can all these other programs work so well under what appear to be >the same constraints you explain above? Most, rely on the timing. A sensible terminal handling package will, when when reading an <esc> in it…
Re: How can I assign the interrupt action to a function key in 4GL?
>From: uunet!felix.Sublink.Org!marco (Marco Penengo) >Message-Id: <843@felix.Sublink.Org> >Subject: How can I assign the interrupt action to a function key in 4GL? >Date: 1 Jul 92 11:26:48 GMT >X-Informix-List-Id: <news.1492> > >As the title states, I would like to bind the Contr…
SQL Count
I have come across what seems like a simple problem but I can't think of an easy solution to it. I have a table with the following columns: FIELD1 FIELD2 FIELD3 and an Ace report select of: SELECT UNIQUE FIELD1, FIELD2 from table; Before I execute this report I w…
SQL and RDA
Dear RDA Researchers; How are you?. I am doing my research on the RDA SQL Specialization. But, I feel difficulties in getting the necessary information. If you have any good information about the RDA SQL Specialization (except the ISO standards which were published last August),…
Problem with arrow and function key interpretation.
> We have been having a problem with arrow and function key interpretation. > Can anyone shed some light on the problem? > We are running on an AT&T 3B2 with PC users coming in via telnet. > (The folks on the PC are using PROCOMM). > The application running on the 3B2 is an Inf…
SQL
>>>To: informix-news-gate@rmy >>>Subject: informix sql report >>>Path: emory!wupost!cs.utexas.edu!uunet!infonode!ingr!nijmeg!swindon!sys2!susan >>>From: susan@sys2.uucp (Susan Court) >>>Organization: Intergraph >>> >>> >>>The select statement I use is as follows: >>> >>>select >>…
Error in sql
Ellen, I may be the only one listening today, and the what I'm saying you may have already researched. But here goes.... Have you changed the ulimit parameter? The ulimit parameter could be preventing you from accessing/writing a file larger then 15MB. See ulimit in your syst…
SQL Query
----- Begin Included Message ----- From: RUCHI@CFRVM.CFR.USF.EDU To: informix-list@rmy.emory.edu Subject: SQL Query X-Informix-List-Id: <list.655> Status: R I have two tables that joines them by project_no. Following are two tables with its values. TABLE A TABLE B -------…
SQL Query
I have two tables that joines them by project_no. Following are two tables with its values. TABLE A TABLE B ----------------------- project_no project_no ________________________ 1 1 2 - 3 3 When I user outer join then it says tha…
Problem with SQL
Hi, We are having a strange problem with INFORMIX-SQL version 2.10.00A. We have a simple application that serves as a user interface for creating 80-column card images on tape. In other words, users key in their data on a PERFORM screen one line at a time. The screen (and …
SQL question
Path: emory!att!linac!uwm.edu!cs.utexas.edu!uunet!europa.asd.contel.com!noc.sura.net!haven.umd.edu!mimsy!rlgvax!uupsi!jpradley!jlh From: jlh@jpradley.jpr.com (Jeff Henslin) Newsgroups: comp.databases.informix Message-ID: <1991Sep17.230325.10095@jpradley.jpr.com> Date: 17 Sep 91 2…
SQL <--> C
Path: emory!wuarchive!uunet!comp.vuw.ac.nz!am.dsir.govt.nz!marcamd!mercury!kcbbs!kc From: Martyn_Barry@kcbbs.gen.nz (Martyn Barry) Newsgroups: comp.databases Message-ID: <1991Jul13.064729.10662@kcbbs.gen.nz> Date: 13 Jul 91 06:47:29 GMT Organisation: Kappa Crucis Unix BBS, Auckla…
Re: double quotes in Informix fields
Path: emory!swrinde!zaphod.mps.ohio-state.edu!cis.ohio-state.edu!ucbvax!hplabs!pyramid!infmx!aland From: aland@informix.com (Colonel Panic) Newsgroups: comp.databases Keywords: Informix quoted strings Message-ID: <1991Jun29.032811.18364@informix.com> Date: 29 Jun 91 03:28:11 GMT …
INFORMIX SQL
Path: emory!att!pacbell.com!tandem!netcomsv!bobb From: bobb@netcom.COM (Bob Beaulieu) Newsgroups: comp.databases Keywords: New Book out. Great stuff!!! Message-ID: <1991Jun8.212352.10759@netcom.COM> Date: 8 Jun 91 21:23:52 GMT Organization: Netcom - Online Communication Services …