Oninit® Archive
Results for “EILSEQ_COMPAT_MODE”
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 …
Upgrade from 10.00.FC6 - 11.70.FC1
We are trying to upgrade our IDS engine in HP-UX B.11.11 from version 10.00.FC6 to version 11.70.FC1. We encountered error during the conversion. Please take a look at the error. Do we need to drop the sysmaster table from the old version before the conversion? Do we need a full …
App: no NLS-Support
Going from 7.1x to 7.2x Informix dumped the older proprietary NLS system for generic GLS support. See if you can configure for GLS, RTM. Art S. Kagel Wolfgang Buerger wrote: > > Hello, > \…
Upgrade from IDS 15.0.0.2 to 15.0.1.0 errors for IPA's
Hello, I had similar problems when trying upgrade from 15.0.0.2 to 15.0.1.0 (besides others during conversion from 12/14.x to 15.x on AIX) - see TS020674987 Milan Rafaj Senior Lead, Infrastructure/Cloud Architecture Kyndryl Consult +420 737 264 248 www.kyndryl.cz Planned absence/…
bson_update with special characters crashes session
Hello Andreas, That are interesting news and obvouisly really bad news! Because I haven't found any information in Informix documents and I've read all bson/json information I've found there. Yes, it's documented that the bson functions expect valid BSON/JSON data but nothing abo…
future support of UTF-8 character handling
Hello Informix community, the fact that the current implementation of UTF-8 in the Informix database is not optimal and difficult to handle is probably known to everyone who has ever dealt with this topic. Before I submit an RFE, I would like to know the opinions of other members…
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 ------------------------------…
ESQL/C conversion error with CLVCHARPTRTYPE
Add more than one character to the c1 row, like "aaöaa". Had not chance to look at the code yet, but I think the value used to calculate the string length for the conversion is wrong, it is not properly taken in count that the UTF8 'ö' (C3B6) will convert to just a single byte (F…
ESQL/C: Fetching LVARCHAR with ifx_var_getdata() when DB and client locale do not match
Hi Shesh, thanks for your quick answer. The usage context is with our Genero runtime system (www.4js.com), using our Informix driver/interface, written in ESQL/C. The code is quite complex and I would need some time to write a simplified ESQL/C sample. However, I have tested diff…
Automatic conversion of ifx_loc_t (TEXT/BYTE) to/from ifx_lo_t (CLOB/BLOB)
Hello, We have legacy ESQL/C code using ifx_loc_t to handle TEXT/BYTE columns. Customers want now to replace TEXT/BYTE by CLOB/BLOB columns... and we would avoid to touch our ESQL/C code. Informix can support simple type conversion. For example, when binding an (int) C sqlvar to …
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…
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…
GLS Help
Can someone provide some advice please? I have an Informix database defined with en_US.819. I want to accept JDBC client connections that use UTF-8 but translate special characters on the way through. For example if the client connection sends an endash character I am quite happ…
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)…
Informix 12 Unicode
Related RFEs are: Character length semantics instead of byte length semantics: http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=47787 New National Language Support data type with variable size greater then 255 bytes: http://www.ibm.com/developerworks/rfe/exe…
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?…
Cannot insert the utf8 data into database
Hi, before trying to give a possible explanation, I've to state, that I'm not an expert for this. Most likely, some of the character code that got generated randomly (because the Big5 chinese character cannot be converted) are codes that are not valid UTF-8 code points. Not ev…
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…
esql pam module - undefined symbol: sqlca
On 21/06/13 00:58, Justin Killen wrote: > Now that it's all built and loading within the engine, I attempted to run a > select query and I'm getting an error with SQL code -23111. This turns out to > be: > > -23111 Internal error. Illegal argument for locale initialization. > > A…
unload data from informix
Are you sure they don't want a 'PSV' file like CSV or comma-separated values, but with pipes instead of commas as the field separators and with a quote at the start of the first field and at the end of the last field? It seems odd to want "|" separating fields without a double …
How to install ISL?
Hi, How to install ISL(IBM INFORMIX INTERNATIONAL LANGUAGE SUPPLEMENT) in informix 11.70 TC1IE? How to add Marathi language(Indian Language) in GLS?…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
dbimport error 23103
Thanx for replays. Unfortunately, I have a little knowledge in the administration of Informix. I didn't do any conversation, just standard export and import database. I will try to apply these tips and find GLS User's Guide. The last solution is to create another Informix instan…
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,…
ILS utf8
Hi, I have to play around with GLS/ILS (never needed so far), esp. with utf8. First, is there any way to determine which codes are support by GLS, for example de_de.utf8. Second, if I have to install ILS where may I find the download site. (Solaris10 and RHEL 5.8, Informix 11…
Config Help
Your biggest performance problem is that you are running your server on a VM. IO performance under VMWare is VERY VERY POOR and, as I've said several times already this month, databases live and die on IO performance. Art Art S. Kagel Advanced DataTools (www.advancedatatools.co…
What are best onconfig parameters for a DSS app
Frank.... first question: Is your database installation being made for a production system???? Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional …
problem about unload text data
In the current engines (11.50 & 11.70) there are ways to handle this using LOAD, in 9.40 there is none. You will have to write your own loader and unloader that understands the file format you want to use in Perl, Java, ESQL/C, or some other host language. You will either have t…
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 …
Over 1,000 days of 24x7 database uptime!
On 29.07.2011 20:38 Lester Knutsen wrote: > From one of our customers, their Informix server hit 1,000 days today > .... congratulations;) > > IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up > 1000 days 00:31:45 -- They beat mine just bit ... IBM Informix D…
Connections to Database slow - for both shared mem
REPLY 1 - ONCONFIG FILE: cat onconfig.prod #************************************************************************** # # Licensed Material - Property Of IBM # # "Restricted Materials of IBM" # # IBM Informix Dynamic Server # (c) Copyright IBM Corporation 1996, 2006 All rights …
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
IDS 11.7 ,Inplace Upgrade Failed
Yes you' re right.Error 2 mean -2 No such file or directory. An operating-system error code with the meaning shown was unexpectedly returned to the database server. Look for other operating-system error messages that might give more information. Ok I've fix the path/links and F…
Re: JOIN databases of different charsets
I believe Ian is missing the point. The issue is not unloading data and load it into a different locale. Apparently the issue is that the applications require distributed queries between two (or more) databases with different locales. I believe this could be achieved with an und…
RE: JOIN databases of different charsets
Aleksander, When you unload the data, regardless of the character sets, your data is going to be a CSV file. That is, the character set strings are going to be in either a comma or pipe delimited format. If you want to do this in Java, you open the file and read each line in, s…
RE: JOIN databases of different charsets
> From: Ian Michael Gumby [mailto:im_gumby@hotmail.com] > It looks like you already know the answer to your question. > Different character sets will order/compare differently. Its not like > you're writing your own comparable operator which would allow you to > handle different…
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…
rootdbs size
The problem, as someone already mentioned, is that you cannot position the physical log in a different dbspace during server initialization since only the rootdbs will exist at that time. Change PHYSFILE to something rather small (less than 300MB) and remove the no longer support…
Purpose and effect of $DBNLS env
Hi folks I'm trying to get up to speed with GLS, and I can't seem to do anything which triggers an error contrary to what the GLS manual claims is the purpose of the DBNLS setting: <quote> The DBNLS environment variable specifies whether automatic data type conversion is suppor…
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…
newline character in text field
Hi Dbload can handle newline character ('0x0D') in a text field. However, if your data contains multibyte characters and delimiter "|" happen to be a valid part of valid multibyte character for that locale. Then dbload maybe confused. I need more information to reproduce it. A …
Random Server Slowdown "Redone"
There are some usual things you could do for now: 1) calc your database ratios, I think there are several NETTYPE, BUFFERS and even BTSCANNER options that could be optimized, you could download Mr. Art script to automatically know these important numbers!!! It´s on the download …
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…
unload truncates decimal values
> OK - let's try to get this straight. Is the problem in ISQL and I4GL, or is > the problem in IDS and DB-Access? The problem is in ISQL and I4GL only, DB-Access works fine. As far as I know ISQL is written in I4GL but DB-Acces is not (maybe in C). > then we need to know which …
Performance impact of LVARCHAR
What version of IDS are you running? COBOL is handling the column as a CHAR column and the engine is doing the type conversion. A 5000 character column will be causing the row to taking up at least 3 data pages on disk. And since it is being inserted using a CHARACTER type host…
RE: finding non ascii characters in the database
Floyd, That's not right. Arrgh! Now I have to think back about internationalization... I'm going from memory and you may want to ping this off Mark Townsend ... You should be able to set up the correct character set. As I said internally Oracle should be supporting UTF-8 so a …
authenticating informix users using winbind
found this that seems to be what I need: http://www.ibm.com/developerworks/data/library/techarticle/dm-0809govindarajan/index.html still not sure if it will require modifications to any 4gls running locally on the IDS ... server. Remote clients will need to include "s=7, csm = …
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…
Insert into an indexed table is really SLOW!
MIKE DUNHAM-WILKIE wrote: > I am running into performance problems inserting into an indexed table, using > Informix 11.50. The following timings for loading into > compressed/uncompressed, indexed/non-indexed tables using dbload/HPL-Deluxe > more illustrate the problem. The numb…
data type for ip addresses
> From: carsten.haese@gmail.com > However, the question is, beyond the mere storage and retrieval of such > animals, do you have any needs that you haven't mentioned? For example, > do you expect the field to reject invalid values? Do you expect to be > able to order results in …
RE: Can't connect to database - Unknown error message 84
Jonathan Leffler <jleffler.iiug@gmail.com> schrieb: >/usr/include/bits/errno.h:# define EILSEQ 84 /* Illegal byte sequence. */ Correct, same on my system (SLES 10 SP1) >What is your locale set to? Which one? Client or server? The problem happens no matter what locale I set …
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…
RE: SSJE & locale
> Do you have right gls files for lv_lv? Yes, sure. Another programs works fine. > consider trying IBM Data driver Can you be a little more specific, please? I didn't find such phrase in Google...…
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…
Loading a data file containing character fields with different encodings
gerrit.schutte@gmail.com wrote: > Given a DB created on IDS 11.50 running on XP with > > DB_LOCALE=en_us.utf8 > > and given a table t > > create table t( > s1 TEXT in blobdbs, > s2 VARCHAR(254,100) > ) > > and given an import file containing the hexadecimal sequence > > C…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
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…
Warning - Cannot retrieve ... ???
Hello, I'm using SSIS (SQL Server Integration Services) via Native Informix OLE DB provider to extract (ETL) data from Informix 7.3 to SQL Server 2005. I have following problem, when I try to connect to the Informix database I'm getting : Warning - Cannot retrieve the column …
IDS 11 sds problem
Hi: I installed IDS sds in SUN OS 5.9, I initialize the primary and SDS server successful. I could execute some query from SDS server, But after I ran some applicaton in the primary server, The sds server disconnect from the primary server. In the online.log , IDS report the fol…
error 21005 with odbc connection
hi, i'm trying to retrieve rows that contains accidentely characters (\\0207 in octal) in a column char. my odbc application fails with error -21005. could it be possible to add this character in the gls files ? i have try several connect version without sucess. thanks…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
Karen Qualley/Lenexa/IBM is in training Thurs and
I will be out of the office starting 03/29/2007 and will not return until 03/30/2007. Please contact Jena for technical questions regarding Common Libs, GLS or Install for IDS. t/l 337-8682 (pjena@us.ibm.com).…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
RE: Unusual GLS online.log error
Sorry, should have anticipated that question. These errors have appears, always together, several times in the last few days. Also, the vast majority of our connections are tcp (maybe 8 or 10 shm). NETTYPE ipcshm,1,50,CPU # Configure poll thread(s) for nettype NETTYPE …
Unusual GLS online.log error
I have a problem with IDS 9.40.FC5 on AIX 5.2. Has anyone ever seen this before: 10:40:29 gls function initgls failed, error -1212 10:40:29 (35552) connection rejected - too many users, or invalid user name There are about 50 user sessions at the time this occurred, and we'v…
C UDR : Text to Char or reverse
On Thu, 2006-12-21 at 15:11 +0100, news.hansenet.de wrote: > Hi all, > > > > i implented some c-udr's in ids 10 successfully. > > The new request is to cast text-fields (simple large objetcs) and/or > reverse. > > Main-problem is to cast TEXT-Field to the lvarchar-type. > > > IBM…
function write to tape failed code -1 errno 16
16 should mean tape is busy, you can check in errno.h in case it is something else. Have you only got a single tape device and running continous logging ? Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THERE FASTER with Informix…
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
Re: 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…
Re: ^M character
On 8/4/06, Dirk Moolman <DirkM@digicare.co.za> wrote: > > My own problem is not removing these characters [^M] from the unload file, > but removing them from the table before I do the unload. > > Any ideas ? First, consider whether the question is well phrased - I debated wheth…
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…
Re: ODBC 2.9 TC5 DSN questions
Gary Quiring wrote: > I am trying to setup a DSN for MS Access using ODBC 2.9-TC5 on a IDS > 9.4 engine. I have never used a DSN before. After setting up the DSN > all I get are -7778 errors. I can connect to the DB if I do not use a > DSN. > > My main interest in using a DSN …
Informix 7.25 UC4 German Locales ODBC Driver
Hi, I know that the GLS doesn´t translate words. I also know what de_de.CP1252 means. When I connect with Access to the Database I see the characters like [,],{,},\\,| instead of ä,Ä,Ü,ü,ß,ö,Ö. Thanks Akbaba > Hi, > > Please let us know what you're expecting to happen and what…
Informix Dynamic server - how to se Croatian language characters
Hi, Im Informix noob, who needs to enable Croatian language to work fine inside Informix (yeey). I got DS 9.40v T1, everything works fine. I figured that I need to download language pack. I dowloaded International Language suplement, version 340 ( newest). I run setup.exe, run GL…
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?…
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/…
Re: ODBC Driver Problems
Did you try to replace old GLS directory to new one? And is there any regional difference between old OS and new OS? Deniz…
Informix 7.31 UD8 GLS error 23115 Code sets of the locale categories
This probably means you've had some non-standard gls setup added on your UC6 and didn't have it on UD8. When you copied gls dir from older setup to the new one you effectively added the feature that was missing in UD8. If you haven't erased anything from UC6's gls dir before copy…
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…
Informix SQL help
> -----Original Message----- > From: Curtis Crowson [mailto:curtis.crowson@employease.com] > Posted At: Monday, February 06, 2006 9:18 AM > Posted To: comp.databases.informix > Conversation: Informix SQL help > Subject: Re: Informix SQL help > > > Because these are essentially Hi…
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: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
Re: -266 Error When Logging Is Enabled
The fix for PTS 172334 changed the error message from -266 to -255 (Not in transaction) because -266 is misleading. So using a newer version won't solve your problem :-( insert/update/delete within a hold cursor must be always started in a transaction. Adam Tauno Williams wrote:…
-266 Error When Logging Is Enabled
I have some 4GL applications that where written with a database with logging disabled and I would like to enable logging on that database. However when I do so the 4GLs still work so long as you don't attempt to modify data; as soon as you attempt to modify data you get an "-266…
Re: ACE Reports Copyright question
In legal terms, Any code written is only a text file, the Copyright belongs to who ever wrote it. A compiler reads the text file and converts it to a Binary or P-Code which can be run by the microprocessor. In the process of conversion the compiler calls other programs and inc…
Re: cyrillic sort order, ru_ru problem
nekoj wrote: > How to compile my own locales? is glfiles somehow related? > > Version: IDS 9.30 UC2 on Linux. > > meanwhile I may try the 10 version but it may be only for wducational > and developement porposes, no upgrade of the production servers in plan > so far. > > thank yo…
cyrillic sort order, ru_ru problem
which IBM version? IDS 10 has the Unicode support from DB2! Very few people seem to use GLS stuff First read the GLS manuals then I would raise a support call with IBM.…
Re: EGL support for ESQL/C?
<malc_p@btinternet.com> wrote: > Ahem. Back to the subject.... > I had a reply from IBM (good quick response, very satisfying) as > follows: > > "The limitation you seen in the conversion guide are relating to the > conversion tool itself, EGL can support esql/c functions with s…
Re: EGL support for ESQL/C?
malc_p@btinternet.com wrote > In between watching England rubbing the Aussie noses in the dirt > [...] get the 4GL/EGL > conversion utility [...] > So far, so hoopy. I've even converted succesfully a cursor-based form > program, so progress has been made. > However - reading the …
Building a custom runner to log all accesses to the 4gi/4go
Hi, We are reengineering our existing informix 4gl environment and to determine which code is actually being run we would like to audit code being run by our users. Is it possible to build a custom runner to perform this task? And if so what function do I need to put our audit …
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: Migrate from Informix to Mysql
Use Aubit4GL - http://www.aubit.com I've updated the SQL conversion routines so it better supports mysql (which you can access via ODBC) - so make sure you get v0.50.2 MYSQL doesn't support all the commands/datatypes/functions etc that informix supports, some are emulated by th…
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:…
Re: failed to install IDS 9.40.UC5 for Linux 32-bit
thanks to all of you. the procedure is really simple, ( Igot confused with an instruction I foun in the Informix installation guide that said rpm .. relocate - do not do that) 1.- Downloaded the file 2.- Login as root. 3.- cpio -icmv < IDS_file It extracted 3 rpm files ( gls, m…
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…
My GoD, ASCII 0 is NULL in my Informix Online Dynamic Server 7.24
ETHERMI wrote: > My God, my God Deities, especially undefined ones, are not usually invoked in this news group. Regrettably, the producers of IDS are all too human, as are the other denizens of this news group. > I have always read that an empty chain is not the same > thing t…
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…
error occurred while extracting the package
When i tried to extract the Informix package by using the command rpm -iv *.rpm it generates the errors. The errors are attached in log file. Installing directory . Installing directory aaodir Installing directory bin Incorrectly built binary which accesses errno, h_errno or _…
GLS Implementation with Chinese:
We have a customer that wants to be able to store a few of their text data fields (like a part description) in Traditional Chinese. The application will use Four J's BDL (or Genero) windows client, and the Informix SE database (IDS-Workgroup could be substituted if necessary). …
Re: Running Informix on 2 different Servers in parrallel
wcottishpoet wrote: > Neil, > > other than the holiday, how about all the following which are available > in 9.40 .... > > > Improved Performance 8-15%better in internal benchmarks;Fuzzy > Checkpoints;Shared Statement Cache;New Buffer Management System;B-Tree > Scanner;Improved R…
Re: Informix version
Vadim.Loevski@sro.vic.gov.au wrote: > I am getting "-23101 Unable to load locale categories" when attempting > to use dbaccess That usually means $INFORMIXDIR (or %INFORMIXDIR%) is pointing to somewhere without a valid gls sub-directory -- as opposed to being unset. (Or, INFOR…
Handling Special Characters
This is a multipart mime message --Next_1099376231---0-202.54.124.151-2553 Content-type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline <P>=0ADear All,<BR>=0A<BR>=0AI have created a UTF-8 database to store multi= -lingual …
=?ISO-8859-1?Q?Can_not_Search_for_Accent_chara?= =?ISO-8859-1?Q?cters_like_-_Caf=E8_/caf=E9_Informix?=
Hi, formerly I did some tests with DB_LOCALE=en_us.utf8. Here are my experiences: 1. Your application must be able to handle Unicode characters. If you are using Java this is the default. 2. To see special characters on the display you have to set your OS environment to an ap…
Re: how to change Informix database character set
Alex Soares wrote on 2004-09-15: > I'm running a Informix 7.31 database server on windows 2000. > This database has the single purpose of holding all of our ERP data > (built by a brazilian company) and is accessed only by this > application that handles data interaction via ODBC…
Different locales (2nd attempt)
God day community! Task description. Source DB is created with locale en_us.819 (default), target DB is created with locale lv_lv.1257, Win32 ESQL/C application must connect to both DB at the same time and move some data from the source to the target. Question. So, is it possib…
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'?…
how to change Informix database character set
Hey there folks, I'm running a Informix 7.31 database server on windows 2000. This database has the single purpose of holding all of our ERP data (built by a brazilian company) and is accessed only by this application that handles data interaction via ODBC, clients don't access …
International character set
Rajesh Rajasekaran <RRajasekaran@forestpharm.com> wrote on 08/31/2004 09:50:34 AM: > Your database must support Unicode technology that is used for multi-lingual > applications. > > Terrence Mullins <terrence@wagerworks.com> wrote: >> My company is in the process of international…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Unexpected backslashes \\ in dbaccess unload output
rkusenet wrote: > "Michael Ben-David" <mikebd@iname.com> wrote: >>Is there a known issue with dbaccess unload commands rendering empty >>or null text fields with a backslash and a space? >> >>The output I am seeing is like this: >>field 1|\\ |field3| > > > it means the data has b…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Re: C-ISAM Runtime Environment
Omegamon wrote: > Does C-ISAM need to have an associated runtime environment if the > executable has been statically linked? Can I move an executable to > another environment and provide it only the target C-ISAM data files > (and INFORMIXDIR for GLS support) and expect it to fu…
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…
Bitwise operators in SQLs/4GLs
Hi, just wanted to confirm my impression that 4gl won't let you use logical ands in select on bit fields under SE. What we want to do is select ... where amendFlag & 0x6, that is, when the second and third bits of amendFlag are set. I suspect we are going to be redu…
Re: database market share 2003
I was going to try to come up with some poetry of my own, but I'm not as good at it as you are. The point is Nano-Nano that DB2 runs the same code base across all platforms, as well as SQL-Server, and I believe even Informix. I thought we covered this. What is very strange is…
Re: Possible poplong bug in 4GL 7.32.FC2 on True64 V5.1 2650 alpha
On Mon, 03 May 2004 02:13:22 -0400, J?rg Spilker wrote: > i changed all the long definitions to int and replaced poplong by popint and > everything is working again (at least on the new platform). But what i don���t > understand is, that poplong doesn���t do the necessary conver…
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: 4J's
brett wrote: > Hi all > > Has anyone used 4J's and converted their 4gl code across ? > > Was the conversion painless ? > > Was the final outcome worth it ? I concur with June. Quite painless, very useful and even "fun". The new Genero is even more modern in the interface, but w…
4J's
Hi all Has anyone used 4J's and converted their 4gl code across ? Was the conversion painless ? Was the final outcome worth it ? thanks in advance.…
GLS variables
hi... I get the following error when I try to connect my application (from win2k pro english) with the informix database: Server does not support GLS variables DB_LOCALE, CLIENT_LOCALE or GL_DATE. Theinformix database is on sco. Thank you _____________________________________…
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,…
Re: Whatcha' wanta have?????
How could i forget this one? case insensitive comparisons and collating order! I don't want that applied to CHAR and VARCHAR types, since they are fast'n'mean byte-wise datatypes. However, since NCHAR and NVARCHAR fields can have a GLS locales applied, they are ideal for this l…
Whatcha' wanta have?????
As a mild diversion from the IDS-DB2 conversion thread, its time for one of my more favorite exercises. ;-) We are nearing the end of the coding cycle for IDS 9.5. We've got a whole bunch of really cool stuff in place and - well - its time to get input from you guys as to what…
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…
Informix GLS Queries...
Dear All, I have created my database setting both DB & CLIENT Locales to utf8. I have a few queries on it - 1. Does the actual data in japanese/chinese language get inserted in the database, how can i view them through dbaccess 2. Will the current width be enough to hold the da…
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…
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…
Informix Multi-language support (GLS)
Dear All, I have IDS 9.4 on win, 2000. I want to have multi-language support for my database. I have set my DB_LOCALE variable to en_us.utf8, I also created a new database and a table but cannot proceed further. Now how do i insert multi-language data in it. How do i insert data…
Reusing same Cursor name help (errors 710 and 4371)
I have code that works in Informix 4GL 6.05 and fails spottily in 7.24 (we are doing a conversion). If a table is dropped and recreated, the foreach below fails intermittently with error 710. Error 710 says to reprepare and redeclare. But if I place another prepare and declare af…
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?…
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.…
JDBC and Informix V7.12
Hello! I can't connect to a Informix DB V7.12 over JDBC from a IBM AIX, but it works from a WinNT-PC and a linux-maschine. On every maschine is the same JDBC-driver, but on aix i get following error: SQLException: Server does not support GLS variables DB_LOCALE, CLIENT_LOCALE …
Can utf-8 chars be stored safely in char variables?
Thus asketh the developers: What datatypes can we safely store utf-8 data in? Version: IDS 9.3 Backround: We are going to write applications in perl that take data entry and output data in French. I think the database was created in en_us, but I'm not sure how to verify that f…
Host vars and code page conversion question
Hello, Does anybody know what is the documented and known behavior of inserting/updating binary columns using host variables from a client to a server which have different code pages? Will any code page / character set conversion take place? I am particulary interested in insert/…
7.1 version and JDBC: how to?
Environment: Informix SE 7.1 on AIX, JDBC 2.2 connection. When I try to execute a simple select, the server returns this error: "java.sql.SQLException: Server does not support GLS variables DB_LOCALE, CLIENT_LOCALE or GL_DATE." I found this note on http://www-3.ibm.com/software/d…
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…
Informix Client SDK 2.81UC1 install errors
I'm running an instance of IDS 9.2 on a Solaris 7 machine along with an older version of the SDK (2.2). Went to upgrade the SDK to a newer version - downloaded 2.81 from the IBM site to my PC and then ftp'd it to our solaris server. During the install, I received the following …
Re: blade api and datetime
Tsutomu Ogiwara wrote: > Hi Eyalk. > > How about using JL's script. > http://www.iiug.org/software/archive/unixtimespl > > It is a conversion from YYYY-MM-DD HH:MM:DD to second. Or the interval to decimal code (eg iv_seconds()) in: http://iiug.org/software/archive/intvl_conv >…
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???…
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…
byte editor
Devin Gibson wrote: > Warning informix novice... > I have a letter head that needs to be updated. The .unl file contains > a byte field that needs to be updated. (I need to add a person's name) > Does any one know what type of editor to use to edit a byte field in a > .unl file?…
Re: Recommended Lock Mode for heavy JDBC usage?
On 27 May 2003 13:32:07 -0700, anthony@zoraptera.com (Anthony Presley) wrote: >Sorry for the cross-post, but it applies in both places :-( > >I'm writing several database conversion utilities for a client, under >Informix 7.31.UD2, which run fairly well. > >However, during the c…
NCHAR and NVARCHAR for Foreign letters in English application
HP-UX 11 IDS 7.23 Hi Family, this is the prodigal Jake asking for help. We have an application that deals in book titles in char columns and commentary text (like book reviews) in blob columns. Usually these are all in English. My users now want to include Spanish and Italian …
Re: GLS clearout
Hi Malc. Sorry if the question of meaning is a different. $INFORMIXDIR/bin/glfiles [-lc] [-cv] [-cm] See the Guide to GLS functionality. If you want to remove unused code set, see Appendix A. Regards. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: "Malc" <malc_…
GLS clearout?
Can anyone recall where I can find the script to clear out all the unnecessary language support files etc? Ta Malc…
GLS clearout
Can anyone recall where I can find the script to clear out all the unnecessary language support files etc? Ta Malc…
Unable to change locale to Japanese in IDS 9.3
Hi Sumanto, You might want to look at this book, http://www-3.ibm.com/software/data/informix/pubs/library/interim/8332-pdf.html For the purpose of this test, unset DB_LOCALE, SERVER_LOCALE, CLIENT_LOCALE, DBLANG and DBNLS, (Do not set these to empty string, be sure they are not…
Resolution on dbexport is wrong
I use Informix Online 7.22 UC3 on SCO OS 5.0.4. After transfer from NLS to GLS an dbexport ´dbname´ -ss bring on statistics update a resolution 050000. But it must be 0.50000. What is wrong? Can anyone help me, Please ? Thanks, jush…
GLS, GLS (Global Language Support) support question.
Dear Friends, This question (on GLS Language support)is one those odd balls which is pretty tough. Any answer would be of great assistance. Also share any experience's that you had in this matter. I am curently running IDS 7.31.UC6 on US English default locale. But recently i w…
RE: Need code help-4GL to Linux Conversion
Mike Wrote> > Here is the code that fails immediately on executing > by .4ge . .. > SQL Statement error number -481 >Invalid statement name of statement was not PREPAREd If you check the SQLCA.SQLCODE status after the prepare statement you'll probably find it failed. It follows…
Need code help-4GL to Linux Conversion
I am presently trying to determine how much work its going to be to convert a massive amount of 4gl code to Linux. Linux is RedHat 6.1, I have checked for the correct version of GLIB, etc. Thousands of lines of code have compiled succesfully into .a file. I have compiled and lin…
GLS Problem
I recently did a level-0 ontape backup of instance_1 on server_1 and restored it to server_2. All seems to be well until I try and perform a query against a database table on the new instance. I get: -23197 Database locale information mismatch. There is no such problem on t…
Version 5 migration question
Greetings! I want to confirm that there are no conversion issues with a move from v5.08 to v5.1. I dimly remember that migration only poses such issues when moving from one code-base to another (e.g. v5 to v7), but I can't seen to remember clearly. Can anyone help me out? Tha…
Re: Fwd: Identifying numeric string in a 4gl program
Colin McGrath wrote in message <92026u$5g0$1@news.xmission.com>... > >To avoid writes to the error log file when the conversion of a string >to a numeric fails, you have to pepper your code with a new startlog() >call in those sections where you don't wish to see the error report…
Upper(datafield) in Informix 5.0
This was always a problem in 5.0 and earlier. That is the MAIN reason we forced CHARACTER fields to only have UPPER CASE values. If I can find the appropriate code snip I will forward to you. Check the code vault at www.iiug.org - lot's of good stuff there - maybe what you are…
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…
GLS
All, I am looking for any insight into Global Language Support (GLS) with Informix. In particular, pitfalls/limitations in implementation. Any documents/case studies/comments would be appreciated ( besides "read Informix GLS manual" ). Example of questions I need answered. H…
Changing the locale of a DB
hi there, Database: Informix dynamic server 7.31 UC2, running on SCO Unix 5.0.5 I am investigating the possibility of changing the locale of a database from "english_uk.8859" (NLS) to "en_gb.819" (GLS). The reason for doing this is so that we can use the native ODBC driver of i…
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…
GLS problem
hi all, I have some GLS problems, please can any one send me how are his environment variables are positionned. LANG DBLANG DBNLS NLSPATH CLIENT_LOCAL ... thinks for any request _________________________________________________________________________ Get Your Private, Free E-ma…
SQL Error 1213
hi Guys, SELECT SPL.bulk_option FROM sys_params_link SPL, sys_var SYV WHERE SPL.value = SYV.value AND SYV.name = �DEFAULT_SYS_PARAM_OPTION�; When I run the above statement, it returns SQL error code -1213 If you do a finderr 1213 -1213 A character to numeric conversion proc…
Re: asterisk as data
--- "Richard E. Hassler" <Hassler.1@osu.edu> > wrote: >Evidently I'm doing something wrong since I don't get any responces to >my questions. Am I using bad tone, incomplete information, stupid >questions? Maybe it's the way you're spelling responses..... There is no such thing…
Database Setup
On Fri, 18 Aug 2000 00:57:15 GMT, jrw3319@gis.net (John Welch) wrote: >Hello all, > Here are a few more questions to all Informix gurus from an Informix >newbie. >... First, I want to thank everyone who responded to my question. Now for a couple of follow up questions/comments…
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…
Re: SQL Syntax error in DBI::Informix
In article <396CDD85.8D0C4384@conxsysinc.com>, paul@conxsysinc.com <paul@conxsysinc.com> wrote: >My script connects with the Informix DB server, but it doesn't like my >INSERT >statement (below). This code below is supposed to store a new user into >a database. > >print "DEBUG: …
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…
GLS and dictionary collation order
Hello, With the default GLS locale setting of en_us.8859-1, sorting of an "nchar" column is always done in the "code-set order". What if I want the column values to be sorted in the "dictionary order"? How do I set the locale? I see that with other English locales (uk, au, etc…
ODBC GLS UTF8
Hi, we have a problem while connecting to informix server via odbc The database-server has 8859-1 codeset The client application uses UTF8 In an older version, our client application made informix connections via isql... (native) we had: DB_LOCALE=en_us.8859-1 CLIENT_LOCALE=en_u…
SQL question
Tom wrote: > I have sql statement: SELECT UPPER(FieldX).... > but this not working with special national characters DB_LOCALE, CLIENT_LOCALE? > What I have to do?? If GLS can't help write You own "upper".…
Re: GLS
We are using en_us.CP1252@dict with NCHAR, NVARCHAR and we dont have problem, whats the difference with es_es.8859 ? Atte. On 5 Jun 2000, at 11:08, Isidre PONS ROCA wrote: > En Martin A. Marques va escriure el dia 4 Jun 2000, a les 10:27: > > > I need help with GLS support. I…
Re: GLS
En Martin A. Marques va escriure el dia 4 Jun 2000, a les 10:27: > I need help with GLS support. I have to build a few DBthat will contain > strings with spanish characters like the acute vocals and n-tilde. > How does GLS work, and how do I set it up? > > Thanks > > > -- > "An…
GLS
I need help with GLS support. I have to build a few DBthat will contain strings with spanish characters like the acute vocals and n-tilde. How does GLS work, and how do I set it up? Thanks -- "And I'm happy, because you make me feel good, about me." - Melvin Udall -------------…
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…
Informix iconnect 7.2 and gls
Dies ist eine mehrteilige Nachricht im MIME-Format. --------------FE86CC4699B27ACE8358F2F6 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello, i try to connect to a database via the program sqleditor301.exe of the iconnect-CD . My setnet is 9.20 2.…
Re: Advice on Informix/Oracle switch
Willis >>1. What are the Oracle equivalents of the following Informix products which we use? Informix SE -> Oracle 7 (both use cooked filesystems to store data, AFAIK). Informix 4GL -> no equivalent, AFAIK Informix SQL -> sql*plus and pl/sql for stored proc…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
GLS memory pool growing
I'm using 7.31 UC4 on HP-UX 10.20. I observed a constantly growing amount of shared memory on my IDS server When I look at the memory pools (onstat -g mem) I see that the GLS memory pool is constantly growing and consumes about 80 % of the whole shared memory. Did anybody else …
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…
display int as words
Informix news groups wrote: > > I want to display integers a words (eg: display 4 as four). How do i do > this. pl help. Version, platform, and front-end tool? Using IDS 7.31 you can use the CASE statement to replace simple numbers (like 4) with words if all of the possible val…
Memory problems? Please help.
Monitor the exe using ps and see if the memory is increasing, if it is then review the code and start releasing or re-using the memory Vincent Kennedy wrote: > > I'm running data conversion routines on SCO UNIX 5.05 using Informix v7. > > They used to be executed during a shell …
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…
Re: 4GL and C
From: "Ken_in_Manila" <kmossman@hotmail.com> > >This is a multi-part message in MIME format. Yech! Do you have to? >We have to convert nearly 100 'screens' of 4GL stuff to C Why? >Does anyone know of any libraries/tool-kits/utilities/etc to help ? The 4GL C precompiler? :-) …
4GL and C
We have to convert nearly 100 'screens' of 4GL stuff to C Does anyone know of any libraries/tool-kits/utilities/etc to help ? We documented the 4GL code already, but I loathe the conversion effort. Please CC me directly when responding.…
How I perform dbload with decimal ???
fabioantunes@my-deja.com wrote: > > > >command > >dbload -d dbpplay -c inf -l erro -e 1 -n 1 > >----------------------------------------- > >FILE teste.txt (a 1-10, b 11-30, c 31-50, d 51-59) > >INSERT INTO teste VALUES (a,b,c,d) > > file teste.txt > 12121212121212121212121211…
Statically-linked 4GLs
We've been having problems with our Warehousing system (Exceed, formerly known as Dallas) When we upgraded from v5 -> v7.24 the time for critical processes doubled. By use of v7.31, a special gls-neutered version of 4GL and some oher changes we have benchmarked performance down …
GLS Problems
I get an error message when I try to conect to my db form IECC Console: Unable to locate the locale or conversion file "en_us.1252" I haven't found muck help on the topic and i have tried to change my regional settings but nothing have helped so far. Anyone know what i shall do?…
GLS: collating problems
'Hola' everybody. I'm having trouble with GLS databases: 1- Some characters in the codeset are not included in the collating sequence (eg. 0x20 and 0xAA in ISO8859-1). They are simply ignored, thus distorting the ordering and confusing my users. 2- The collating sequence …
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…
DATABASE statement in 4GLs
--------------80A826922C424D17385512CE Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I've just been advised that use of the DATABASE statement, in 7+ engines (SE in my case) may/does cause a performance hit. I've seen no official mention of this. R…
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…
BLOB Help
Hi I am just starting to use BLOBS for a correspondence system at our site. Previously Blobs were handled via C functions but I want to do it via 4GL without calling those. How do I get data into the Blob without using INPUT ? I basically want to do this CALL push_field_data("…
Re: 4gl run time error "has already been defined -1351"
Possibly two of your 4GLs have MAIN defined. As the message says , either a report or function. Only your main 4GL should have : MAIN blah blah some code END MAIN HTH.…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
which ISQL handle GLS ?
Hi, we upgraded our DB to IDS 7.30UC9 and ISQL to 7.20UD6. But ISQL can not handle nchar type clipping nor subscripting (xxx[1,2]). It seems ISQL does not know the n-types (char+varchar) at all - when I get info about table, nchar type is shown as char... So what is the correct …
Unable to locate the locale or coversion file"en_us.1252". Check the file system to ensure that this file resides in the appropiate gls subdirecrory
Hello everybody! I have a problem while trying to start SQL Editor 3.0 on a Windows NT workstation. Following error is displayed on the screen: Unable to locate the locale or coversion file"en_us.1252". Check the file system to ensure that this file resides in the appropiate gls…
Re: 9.2 - extracting BLOB data - not handle
Our front end is the webblade. In an app page, we get the BLOB handle back when we select blobcol from foo. The only way to get the data is to do something like select blobcol::lvarchar::clob from foo which presents other problems since you are representing binary data in a c…
Re: Multi-language data in a database
No way. IDS 7.30UC2. The error message is: "Unable to load locale categories". Sorry doesn't work. What Informix server version do you have ? Does it really work ? Best Regards, Octav On Fri, Sep 17, 1999 at 11:23:27AM -0700, Heiko Giesselmann wrote: > Octav, > > starting with…
conversion to binary coded decimal in Informix 4GL
Hi everybody, Any body can help me on this. We don't have ESQLC . We have only 4GL. I need this very urgently because one of our bank asking some of the fields from database need to convert to BCD and generate a ascii file. I can convert the whole file to BCD format but not the …
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
Re: GLS initialization failed
>>> Paul Storm <pstorm@pinbot.nit.AirTouch.COM> 08/18/99 06:53PM >>> [cutting] >Paul, > >I agree with you that paths should be declared with a separate variable. The >call then can be with a concatenation with other fields(i.e. devices, file >names, etc.). That would be good pr…
Re: GLS initialization failed
[cutting] > >Also, all paths should be explicitly stated for any calls made within your > >program. > > Disagree, all paths should be based on a variable so if the box changes I only one thing to alter. > > [cutting] > > > > Paul Watson Paul, I agree with you that paths should …
Re: GLS initialization failed
>>> Paul Storm <pstorm@pinbot.nit.AirTouch.COM> 08/17/99 05:25PM >>> >Your cron job is run independent of your account login scripts. You should >include a source of your login scripts within your job(i.e. source .cshrc). or .profile etc. Personally, I like to source a differe…
Re: GLS initialization failed
Have you set all environment variables in your cron script (including INFORMIXDIR, DB_LOCALE, CLIENT_LOCALE, DBNLS, INFORMIXSERVER, ONCONFIG ...)? Check it. Best Regards, Octav On Tue, Aug 17, 1999 at 07:34:25AM +0000, Andreas Lommel wrote: > Hi > I have a cronjob, which produ…
Re: GLS initialization failed
En Andreas Lommel va escriure el dia 17 Aug 99, a les 7:34: > Hi > I have a cronjob, which produces this mail: > > ----------------------------------------------------------------------- > Subject: Output from "cron" command Content-Length: 163 > > > Your "cron" job on bi…
GLS initialization failed
Hi I have a cronjob, which produces this mail: ----------------------------------------------------------------------- Subject: Output from "cron" command Content-Length: 163 Your "cron" job on bisun1 /export/home/informix/lims/savelogs produced the following output: GLS init…
blob (text) to character conversion
drewmoo wrote: > > Does anyone know a better way to convert a text data type field to a > character string besides: > locate text field in "filename" > create temp table (string char(500)); > load from "filename" insert into temp table > select from temp ta…
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.…
Re: GLS initialization failed,
Andreas Lommel wrote: > > Hi, Anybody here who can help me with this error - message? What does > it mean ? > > Your "cron" job on goofy1 > /home/informix/logbook > > produced the following output: > > GLS initialization failed, error -23101 Type in: finderr 23101 and it'll t…
GLS initialization failed,
Hi, Anybody here who can help me with this error - message? What does it mean ? Your "cron" job on goofy1 /home/informix/logbook produced the following output: GLS initialization failed, error -23101 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…
GLS sorting wrong
We are having problems getting GLS to sort our NCHAR values properly. Using dbaccess, here is the simple test I'm running: create database test; create table tab1 (col1 nchar(1)); insert into tab1 values("A"); insert into tab1 values("�"); insert into tab1 values(…
Unix makefile for ESQLC with GLS
We just moved to 7.20 from something older and simpler. I have couple of programs I maintain with make, for eslqc is just a part of the program. I fashioned a makefile that included the ESQL includes as needed and the ESQL librarie as needed. My make command creates oodles (a …
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
GLS support: How can complile a .lc extension file ?
Hi all, I need to change a local value source file: $INFORMIXDIR/gls/lc11/es_es/0333.lc Next step is to update the objet file: $INFORMIXDIR/gls/lc11/es_es/0333.lco How can create the new .lco file from the modified .lc file…
select first x
Hi we are running version 3.70.TC1 of the DBDK and when I went to generate the datablade I got the following errors: 1) When generatiing the C files : - Code Generation ERror. Unable to locate template ("CDriverMain.Main") The file cdriver.tpl is located under c:\\informix\\db…
example of GLS implementation
Greetings all, I'm trying to setup some GLS variables. If anyone could share there's (DB_LOCALE, etc.) I'd appreciate it a great deal. Thanks! Max Pyziur pyz@panix.com…
How compile a .lc extension file ?
Hi all, I need to change a local value source file: $INFORMIXDIR/gls/lc11/es_es/0333.lc Next step is to update the objet file: $INFORMIXDIR/gls/lc11/es_es/0333.lco How can create the new .lco file from the modified .lc file…
Re: Please help on a question about Informix varchars
I agree with almost everything Keaton said, except for one point. > > > If I have a table that has 2 fields defined: > > > > table foo > > problem varchar(1024) nulls allowed > > > > First of all, the maximum length for a varchar is 255 characters (unless > this is an I-U…
Please help on a question about Informix varchars
> If I have a table that has 2 fields defined: > > table foo > problem varchar(1024) nulls allowed > First of all, the maximum length for a varchar is 255 characters (unless this is an I-Universal Server thing, which I don't have experience with yet). > 1. If problem i…
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.…
The format of GLS
I am using mutlibytes language.Could anyone tell me the format of GLS file such as ${INFORMIXDIR}/gls/lc11/en_us/0333.lc? Can I write my GLS files? Thank you. Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.…
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…
GLS-Problem
I am running informix SE 7.23 UC 1 under Unixware 2.1. While using a terminalprogramm it is necessary to create a 7-bit database. So I used DB_LOCALE=de_de.1011 and CLIENT_LOCALE=de_de.1011 when I created my database. On the other side it…
JDBC question
Hi, I have table TabA in database DbA on server ServerA with GLS (DB_LOCALE=cs_cz.8859-2) and table TabB in database DbB on server ServerB with GLS (DB_LOCALE=sh_hr.CP1250). Is there any way to join this two tables in Java? e.g. select * from DbA@ServerA:TabA, DbB@ServerB:TabB …
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…
GLS connectivity question
I recently recieved 7.31.UC2 with the GLS int'l language supplement and setup my instance. I can easily connect to it from a remote server running version 5.04 by adding an entry to the sqlhosts file. If I try to connect from a remote server running 7.24 I get error: 23101: U…
Informix 7.2x GLS
Hi, I want to change the code-set, from en_us.8859-1 to zh_tw.big5, of a existing database in Online DSA 7.2x. What should I do?? ----------------------------------------------------------- Brad, Huan-Ming Kao (Institute for Information Industry) Email: proton@iii.org.tw Mobi…
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…
Re: Text Data File
Try TEXTools, (see description at end). Following is an example: ============================================================================== Converting a comma/quote delimited file into a fixed length one using TEXTools =======================================================…
Problem with aggregate functions in sql
Hi, I have a problem in a 4gl program compiled with v4.13 running on a SE 7.1 DB. When I do queries such as: select count(*) into f_count_translog from translog where doc_num = "2019909" and doc_typ = 'QUO' and tr_status = "WS4" -OR- select max(translog.date) into f_current…
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…
Informix on SuSE Linux problem
HZ wrote: > When I try to start onmonitor error occurs: > Unable to load locale categories. > Any suggestions? Set $INFORMIXDIR. Or you've got an interesting locale set via LC_COLLATE, LANG, etc, which the GLS system doesn't recognize. Or your GLS file in $INFORMIXDIR/gls all w…
GLS Informix !
Does anyone knows how to make Informix 7.22 OWS work with international chars ? I have a NT40 with portuguese (standard) instaled but I can't make the Informix OWS accept portuguese chars ! I've tried several configuration options without results... Thanks for all the help tha…
Datetime and Interval
Massimiliano Panella wrote: > This the second time that i ask about this argument: > I've a problem with a store procedure that work with Datetime: > If I've this situation: > CREATE PROCEDURE PROC_NAME(Data DATETIME YEAR TO FRACTION) > DEFINE pippo INTEGER; > .... > …
Case insensitive locale for IDS
Hi Informix specialists! We're using IDS 7.30. For a porting activity we must have a case insensitive locale, i.e. a locale which does not distinguish between lower und upper case letters. In Informix GLS guide I've found the following passage: The localized order can include e…
4GL Question
I am working on a Year 2000 problem. I have many .per and many .4gl to work with. I am trying not to have to modify the 4gls if possible. The question is how can I force the user to enter a 4 digit year in a type date field, while also giving them the ability to enter or chang…
Re: converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
On Mon, 8 Feb 1999, nitric wrote: > converting Informix Online 5.1 esql/c to Dynamic Server esql/c? > What is the easiest way to do this? Recompile. > Is there a parser that could do this? There are no compulsory source code changes that I can think of, unless you've gone delv…
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…
ESQL/C + gls problem
Hi, I'm using ESQL/C 7.20 and I'm working on one dll file. Everything is OK except I can't set CLIENT_LOCALE through InetLogin structure. I have 2 static char arrays static char DB_Loc[128]; static char Client_Loc[128]; and I copy two strings into these arays. Next, I put these p…
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…
how to convert DATETIME hh:mm to integer
io wrote: > > Hi, > are there any good ways of conversion of DATETIME (or better INTERVAL) > hours:minutes to integer? Check the library of date/datetime functions I posted to the IIUG Software Repository called datefuncs.shar. If what you want is not there there certainly is e…
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?…
GLS problem
We have IDS 7.3 on AIX 4.1. When I create database with locale pl_pl.CP1250, I have problem with collate order. In file 04e2.cm not corresponding with LatinII ASCII Table. How I can change it? How compile *.cm to *.cmo or *.lc to *.lco? I'll be appreciate for help... Thanks. Jar…
GLS DB and non GLS clients
Hi, we will have our DB in ISO-Latin2, using GLS. It will be converted from PC-Latin2 codepage. We have a lot of 4ge non-GLS programs, they all will be recompiled to "GLSable" binaries, but I do not believe in miracles and I suppose problems with some of them. Can I connect to G…
Re: creating databases with GLS ??
Hi, Code-set en_us.819 is that same as en_us.8859-1. Enviroment variable SERVER_LOCALE has not effect for code-set database. Pavel Hampl On Mon, 4 Jan 1999 bjarne.wilken.jensen@almbrand.dk wrote: > > It seems as if you have forgotten this environment variable > SERVER_LOCALE=e…
Re: creating databases with GLS ??
It seems as if you have forgotten this environment variable SERVER_LOCALE=en_us.8859-1 Set this environment variables and recyckle the server. Bjarne Alm. Brand Denmark Jerry A. Van Zant wrote: > > First off the system > > Online 7.24.UC6 > HP/UX 10.10 > > When I create a datab…
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.…
Re: creating databases with GLS ??
Jerry A. Van Zant wrote: > When I create a database either with dbaccess or dbimport, it looks > like the system is ignoring the environment variables. I have the > following set: > DB_LOCALE=en_us.8859-1 > CLIENT_LOCALE=en_us.8859-1 > But the database is created with en_us.8…
Re: creating databases with GLS ??
On Wed, 23 Dec 1998 20:24:28 +0100, Dragi Raos <draos@4mate.hr> wrote: >Jerry A. Van Zant wrote: Yep > >Well, it works for me (AIX and IDS 7.23). Stupid question: have you >exported your variables? > >Dragi "Bonzi" Raos…
Re: creating databases with GLS ??
Well, I'll not claim to be any GLS expert, but what you did should be all you need to do. I played around with it a bit and discovered the following, on solaris anyway (on 7.24 and 7.30). Like you when I used the en_us.8859-1 setting for DB_LOCALE and CLIENT_LOCALE in the syste…
Re: creating databases with GLS ??
Jerry A. Van Zant wrote: > > First off the system > > Online 7.24.UC6 > HP/UX 10.10 > > When I create a database either with dbaccess or dbimport, it looks > like the system is ignoring the environment variables. I have the > following set: > > DB_LOCALE=en_us.8859-1 > CLIENT_LO…
creating databases with GLS ??
First off the system Online 7.24.UC6 HP/UX 10.10 When I create a database either with dbaccess or dbimport, it looks like the system is ignoring the environment variables. I have the following set: DB_LOCALE=en_us.8859-1 CLIENT_LOCALE=en_us.8859-1 But the database is created…
GLS question
Hi, I have two databases running on separate database servers: - database1 under ISO-8859-1 locale - database2 under ISO-8859-2 locale Is it possible to exchange data between them in one single session? For example: insert into database2@dbserver2:table (col1,col2) \\ select…
4gl RDS 7,2 on hp-ux 10.20 -- string handling errors
A warning to others and a plea for ideas or help. Just upgrading to 4gl RDS 7,2 UD4 running on hp-ux 10.20 and I'm having problems with simple string handling causing errors. Is anybody else having similar problems and have they managed to determine what is happening ? Example …
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…
Re: DBI, blobs, and strings longer than 256 chars
On Wed, 2 Dec 1998, Stephen Roach wrote: > On Mon, 30 Nov 1998 16:58:16 -0500, "Art S. Kagel" <kagel@bloomberg.net> wrote: > > Steven Primrose-Smith wrote: > > > After struggling for an afternoon trying to get blobs into an > > > Informix database via perl and DBI, without any In…
How make *.cvo file?
Dear Sirs! How make (or where get) *.cvo files for GLS? -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own…
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: Informix 4.1 inquiry
FGAnderson wrote: > > I know I am behind but does someone have information on > what makes Informix 4.1 Y2K non-compliant. We are > currently using Informix/4gl, Informix/sql, Informix/SE > We have modified the code to use a 4 digit year with > no problems. Any info would be ap…
Session to database access
Nicole Try the following select statement I find it more useful than the onstat command select sysdatabases.name database, syssessions.username, syssessions.hostname, syslocks.owner sid from syslocks, sysdatabases, outer syssessions where syslocks.tabname = "sysdatabases" and s…
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.…
Coredumps and 4GL
4GL: 7.20.UD2 Engine: 7.23.UC11 OS: HPUX 10.20 I've just about had it -- hopefully someone out there can pull me back from the brink. 8-) I have a 4gl program that has been running since the 4.1 days. It declares a cursor for an outer loop, then it processes each row. It …
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…
GLS converting Inf 7.2
Hi! Could anyone please help me to convert my database with a default locale of US english to Swedish? I have read the GLS guide and the Migration guide (which states that you can change locales on a database but doesn't give any examples). I have a 7.22 server running on Solari…
Problems with GLS
I use INFORMIX Online 7.22 on SCO UNIX. I need to store in a table data containing Polish national letters in several different standards. If I create a database using one GLS standard I cannot insert rows containing characters > 128 not included in this standard because I receiv…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: GLS Databases
Vincent Birlouez wrote: > > The document I was talking about is "Guide to GLS functionality", page 3-23. > I understood from that document that the "IN('feron')" comparisons should > return feron and f+AfI-on (is e and +AaA-are considered are equivalent). > Any other clues ? The…
Re: GLS Databases
The document I was talking about is "Guide to GLS functionality", page 3-23. I understood from that document that the "IN('feron')" comparisons should return feron and f�ron (is e and � are considered are equivalent). Any other clues ? June Tong wrote in message <36071C14.58BBE4…
Re: GLS Databases
Vincent Birlouez wrote: > I set up my database to support french sorting order (using DB_LOCALE and > CLIENT_LOCALE, I set them to fr_be.8859-1). I'm using informix 7.24 > > It work fine for sorting order (F�ron is coming right after Feron). > > But, when I execute the following…
Re: onunload/onload usable for migration frm NLS to GLS ?
Helmut Leininger wrote: > Hi, > > Can onunload/onload to be used to transfer a database (or tables) from > an NLS database to a GLS database? > I would like to use this for migrating an existing database from NLS to > GLS. Up to now I used dbexport/dbimport, but sometimes had tr…
GLS Databases
Hello all, I set up my database to support french sorting order (using DB_LOCALE and CLIENT_LOCALE, I set them to fr_be.8859-1). I'm using informix 7.24 It work fine for sorting order (F�ron is coming right after Feron). But, when I execute the following query : select * fr…
HELP! GLS
I have a 3rd party application (Documentum) that uses an Informix database to store data. When I insert extended ASCII characters into the database by telneting to the server and use Informix DBACCESS the data is inserted just fine. For example (note the special characters): i…
Re: Unable to load locale categories - Please help
Though I'm not much of an NT expert, on the unix side, that message refers to the setting of your GLS variables(DB_LOCALE, CLIENT_LOCALE, SERVER_LOCALE) Check to see if these are being set and if they are if the gls files exist if they are. Good luck, Jacque Graham Cebulskie w…
GLS support for Replication
Hello, Has anyone been able to set up Replication with GLS in the following environment: - HP-UX 10.20 - Informix 7.24.UC5 Olli…
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 …
Other RDBMS databases (Re: Informix SE 7.x: Does it support data types 'text', 'varchar'??)
I am also using the following RDBMS databases (porting exercise) on Linux - Solid Server from Finland ( very good) http://www.solidtech.com/ Adabas D (from germany) http://www.adabas.com/ YardSQL (from germany) http://www.yard.de/ MySQL (from Sweden) http://www.tc…
Re: Informix SE 7.x: Does it support data types 'text', 'varchar'??
Al, Linux-SE engine does *not* support types: Byte Character Varying Text Varchar This is a major bummer. I just got my server up and running for an Image database and I didn't see this coming. I am now looking for a database that can handle the Byte datatype …
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…
Re: trying to use nls
On Mon, 27 Jul 1998 17:40:30 +0300, Mati Link <mati@www.tallinn.ee> wrote: >hi >i have a problem with natlive language support. > >i need to input some special characters. so i set dbnls variable to 1 or >2 and >i encouter errors when trying to set the lang variable. i would li…
Re: Spanish local characters + Informix
It sounds like you have not set up GLS (or NLS if it's an older server). On servers prior to some version I don't know (7.2 something I believe) you had to set up GLS support even though the default locale is supposed to use the 8 bit 8859-character set. There was a bug that mad…
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…
Posting from the Informix-list
I'm moving some databases from Intel, XENIX boxes with Informix 2.0 to a Hewlett Packard HPUX, Informix 5.0 system. I just hit a wall, in that I have lost some source code. The code was a c program, it was used in place of acego, or a modification of acego to run Informix repor…
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: problem with characters in dynamic ESQL
On Tue, 7 Jul 1998 apatnaik@aircom.com wrote: > I am using dynamic ESQL select statements to > fetch an unsigned char(1) into my host variables. So, you are remembering to use either a fixchar data type or at least char(2) -- sorry...char value[2] -- aren't you? > Now with dyn …
Re: Accessing CHAR columns in java
On Tue, 7 Jul 1998 13:02:43 -0500, "Candy McCall" <candym@olcinc.com> wrote: >As I understand it, when a CHAR(n) field is retrieved from the >database in Java (using JDBC), the driver will convert the >field to a Java String object of length n, padding spaces at >the end if nece…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: dbaccess output formatting
ccremid wrote: > On Wed, 17 Jun 1998, Mike Morris wrote: > > As a new user to Informix, I wonder if there are any tools for > > formatting the output > > of dbaccess selects to make rows easier to read > > Informix offers a Relational Object Manager (ROM) tool. > It is free and …
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: SQL query
On Tue, 9 Jun 1998 11:32:17 -0700 (PDT), Jonathan Leffler <jleffler@informix.com> wrote: > >On Tue, 9 Jun 1998, Richard Caldera wrote: >> From what you've described and your sample data, it looks like you just >> want the unique values in ascending order. >> >> Here's one method…
Re: What's new in Informix 7.3?
Also sprach "Jay D. Sullivan" <jnelaine@erols.com> : :We had two problems with 7.2 which I'm hoping (but not expecting) were :resolved in 7.3. The first is Informix's lack of case-independent :indexes. There was no way to do a case-insensitive search and still be :able to use a…
Data Conversion Test
<html><div>Hello Everyone,</div> <div><x-tab> </x-tab>I am currently in the process of converting a database from DataFlexx using 4GL application into an Informix 7.24 database.</div> <div>The end user application is in character mode.</div> <br> <div>Old e…
Pros and Cons of 4GL's
I'm preparing a presentation and I would like get some input. I need to present the pros and cons of a 4gl paradigmic approach. I also would need to be able to say how the market views 4gls now (whether they are on the demise or not). I need online and printed references and a…
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 Openings
Hit the ground running for a mid-sized company located in North Scottsdale, Arizona. Working directly for the IT Manager you will be working on a large conversion project employing state-of-the-art technology. Your primary responsibility will be running reports as part of a con…
Re: Unset NLS ?
If you - for obvious reasons - you don't wish to use NLS/GLS you should set DB_LOCALE, SERVER_LOCALE and CLIENT_LOCALE to en_US.819@dict. SERVER_LOCALE has to be set in advance of oninit -i !…
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…
Informix SPL Foreach Problem
I am having a problem with an Informix SPL FOREACH loop. I am reading character data that needs to be converted to money. I am getting a -1213 which specifies that I have character data that can not be converted. This is true. There are a few bad rows. To handle this, I am using …
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…
Re: 10 GB from 5.02 to 7.20 in "real time" ??
Michal Hajek wrote: > > Hi, > > we use OnLine 5.02 on HP-UX 10.20 (K260) and planning upgrade > to 7.xx (DSA, which version ?). > Our database has now 10 GB (and will have cca 12 GB next year, > when we will do the upgrade). > We are a hospital, so we really can not stop work for…
Re: GLS
High, as far as I know the collating order can be modified by setting the LOCALE to ...@dict or some other but only for NCHAR od NVARCHAR-columns!. But this doesn't have anny affect on your SELECT. You have to say for example: select ... where column matches "[aA]*". Best Regar…
GLS
I would like to change the collation order so that there is no difference between capitals and non-capitals. I would like to be able to ask SQL questions like: select name from t where name matches "a*" and get all names starting with a or A. Does anyone know how this can be don…
4GL to GUI conversion
I was wondering if someone out there could possibly assist me with the following scenario. We have a large number of customers with applications developed with Informix 4GL. The size and extent of the applications varies considerably. We would like to find some sort of conversio…
Webkit & 4gl advice
I have a client that has a large legacy program (>200,000 lines of code) with more than 250 input and output screens all character based. They need to upgrade their product to a graphic user interface. We are looking at the feasibility of using web browser and rewriting i/o scr…
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
Re: Language support
Dirk Niemeier wrote: > hello, > can anybody give me a todo list to change to german language support? > We are using SE 7.22 with standard language without any changes for NLS > or GLS. > > regards > Dirk Niemeier Hi, Personally, if I started with using German language datab…
Re: Checking datatype of CHAR variable in 4GL
John H. Frantz writes: > 3. I can't imagine anyone being interested in a log file growing at a > mad rate describing conversion error-codes that were handled by the > program. To say that the error log isn't really an error log but a > message log is kind of circumventing the is…
Re: Checking datatype of CHAR variable in 4GL
Alan Denney wrote: > > In article <6ch9gn$p5q$1@news.xmission.com>, > Marco Greco <marcog@linux.ctonline.it> wrote: > ... > >- inconsistency with sql error trapping behaviour: a comparable example would be > > to prompt the user for a quick sql statement, and PREPARE it with WH…
Re: Checking datatype of CHAR variable in 4GL
In article <p9evDCABX350Ew2j@smooth1.demon.co.uk>, David Williams <djw@smooth1.demon.co.uk> wrote: >>To make it more clear, this is the contents of my error log after running the >>following useless program (4gl/c 4.16UC2 x SCO 3.2.5.0) >>main >> define a smallint >> whe…
Troubles with gls
We have some problems with our Informix Online Workgroup Server 7.23 for Windows NT. When we - as user: Informix - try to start the Database Explorer on the NT 4 Server console, we get the following error message: "Unable to locate the loacale or convension file 'EN_US.1252'. Ch…
Re: Newbie Question on Informix/ViewPoint
Hey, that was what I was going to say.... Scoobs "Whatever it is I think I see, becomes a bunch of code to me....." Art S. Kagel wrote: > Gina Scott wrote: > > > > Hi I was wondering if anyone could help me? > > > > I have a Btrieve database and I need to convert/export/impo…
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: Informix ceasing to produce 4GL ???
HTML for screen handling for general bussiness type applications would not be a good idea at all. We are doing straight Java with normal GUI tools in Java. As to 4GL going away there is no risk of that. It's too important and will remain so for quite a few years more. Of course …
Re: -23101 Error
Taras Kopach wrote: > > Looks like you are using ESQL/C v. 7.20 or above. This versions include the > Global Language Support (GLS) which requires setting of specific env. > variables : > DB_LOCALE, CLIENT_LOCALE, SERVER_LOCALE. > Since you are using ODS 7.1 you haven't the GL…
New informaix GLS
We have a new informix 7.2x with the new Global Language support feature. Perviously we had the standard online 4.11 US english version. We use a lot of chinese on the old system (BIG5 multibyte) character set in our 4GL and forms. At first it did not work well but having worded…
Re: How can I insert a string var in a TEXT columns
On Wed, 12 Nov 1997, Christian Hernoux wrote: } I have a table with a field as a TEXT type } } In my 4GL program I have a string variable. } Ex: DEFINE MyVar CHAR(20248) } } LET MyVar = "blalcblacble",...,"blablabla" } } How can I insert this string varibale in a TEXT field of ta…
Re: Help! -23101 -> Unable to load locale categories.
Ingo wrote: > > Hi, to everyone! > > We have installed Online 7.22 on two separated SUNs. > After that, we installed GLS on these machines, and now the problem: > > One of the SUNs doesn`t have any problems using the GLS but the second > one > reports the error -23101! > I think,…
Re: Help! -23101 -> Unable to load locale categories.
Ingo <ingo@strauss-in.com> escreveu no artigo <3455A935.8BE84E86@strauss-in.com>... > Hi, to everyone! > > We have installed Online 7.22 on two separated SUNs. > After that, we installed GLS on these machines, and now the problem: > > One of the SUNs doesn`t have any problems usi…
Help! -23101 -> Unable to load locale categories.
Hi, to everyone! We have installed Online 7.22 on two separated SUNs. After that, we installed GLS on these machines, and now the problem: One of the SUNs doesn`t have any problems using the GLS but the second one reports the error -23101! I think, these SUNs will have completl…
CLI 2.5 and GLS
I am using CLI 2.5 under AIX. The CLI manual states that if connecting to Informix On-Line DS 7.2 or above, then CLI can take advantage of GLS. However I have found that CLI does not recognize the types NCHAR and NVCHAR. Does anyone have any information on using CLI with GLS? …
Test plan for 4GLs
This may not be the correct place to ask this question but we are being directed to test and evaluate the following 4GLs: 1. Oracle 2. Informix 3. Progress What we need is a test and evaluation plan, script, scenario, procedure, etc., to examine/compare the three products. Can…
Re: Informix equivalent for Oracle "lower"?
>Is there an Informix-equivalent to the following simple thing in >Oracle? > >update my_table set Column_1 = lower(Column_2) > > There is in IUS currently via a UDR. I think that I remember reading that this was to become a built-in function which would utilize GLS with 7.30. …
Re: Sybase isql converter
In article <MPG.e9a0d06de18fea1989680@nntp.ix.netcom.com> mikem214@ix.netcom.com (Mike McCaslin) writes: >I have some Sybase SQL that I need to convert to run with DBaccess. Does >anyone know of a conversion program? 8 fingers, 2 thumbs, pair of eyes & a brain. Sorry, been a f…
Re: Help! Need Text Database
Mark Plunkett <mark.plunkett@uchsc.edu> wrote: :Help me! : :I need database software to handle mostly text. Access won't allow more :than 255 characters in a field. What do you suggest? : :Thanks, Mark Informix Universal Server with one of the text datablades. This is of co…
Informix and unicode?
Can someone tell me, does Informix support unicode character sets (ISO 10646)? I can't seem to find anything about it in the GLS manuals. Any help appreciated. -darrel -- ========================================== Darrel Davis darreld@access.digex.net ThunderW…
Help needed : Version 5.x and 7.22 interwork
Friends, I have a problem connecting version 5.x clients via Informix STAR to OnLine 7.22 database. Version 7.22 will always use GLS, while Version 5.x has no concept of it. The problem is that aplication and data in database is in ISO8859-2 locale. I can not create database wit…
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…
Re: informix viewer
>Unfortunately, ROM seems to have problems contacting a database that >uses NLS as opposed to the GLS it likes to use. We could not (yet) get it >to work on NLS databases :-) > >Jens > I have no problems with OL 7.12 (NLS) and ROM. You must create new locale on the server named …
Re: GLS Japanese Language
Hi friend, I know Informix GLS works with Japanese language supplement. I think Informix people of Tokyo branch know about this product very well. You should contact them. Bye, Masahiko Okada Kenji Hino <kenji@alcatraz.net> wrote in article <34023DC9.9BA375E8@alcatraz.net>…
GLS Japanese Language
Has anybody got so called the International Language Supplement (ILS)? I am trying to get my 7.2x Informix database to work with Japanese language. However, my informix salesperson takes much time to find out the supplement. I wonder if anybody knows about this and actually used …
Locale/Conversion File on the client side
Hi everybody, I am trying to use Informix Object Manager (the new tool which informix for the first time distributing for free !!!!). The I-Login part successfully connects to the database server. But when I try to retrieve the database info, the following message occurs : " Ca…
Locale or Conversion File
Hi everybody, I am trying to use Informix Object Manager (the new tool which informix for the first time distributing for free !!!!). The I-Login part successfully connects to the database server. But when I try to retrieve the database info, the following message occurs : " Ca…
Re: Is there varchar2 for informix?
Nils Myklebust <Nils.Myklebust@idg.no> wrote in article <33eb3e7b.16487217@gate.idg.no>... > John Chen <sparkee@stealth.net> wrote: > : I want to know if there is another E/SQL variable besides text used > :to store character arrays with a size greater than 256. > > Think if w…
Re: Opinions Wanted: 4GL or New Era??
Dan, My company is in the process (and have been for a while now) of converting Foxbase for Unix to Informix. My reccomendation would be to use 4GL. I understand the frustration of trying to make 4GL programs work like Foxbase. After many weeks of ranting about 4GL I finally lea…
Re: Inserting an empty string inserts a space
Sorry, but Informix CAN distinguish NULL strings, empty strings, one-space strings, and multiple-spaces strings. However empty strings is not standard SQL, but an Informix extension. The ANSI standard for VARCHAR(n) corresponds to Informix VARCHAR(n,1), which means that a VARCHAR…
HELP - DCPA - INFORMIX Converison HELP!!!
Please help Any info regarding software/consulting houses regarding conversion of SNI DCPA applications (http://www.sni-usa.com/its/dcpa) to 7.2x informix. Base system includes SINIX UNIX 5.42 running on RM600XXX. Conversion would include over 800 screens and conversion of som…
DCPA-INFORMIX conversions
Please help Any info regarding software/consulting houses regarding conversion of SNI DCPA applications (http://www.sni-usa.com/its/dcpa) to 7.2x informix. Base system includes SINIX UNIX 5.42 running on RM600XXX. Conversion would include over 800 screens and conversion of som…
DCPA TO INFORMIX
Please help Any info regarding software/consulting houses regarding conversion of SNI DCPA applications (http://www.sni-usa.com/its/dcpa) to 7.2x informix. Base system includes SINIX UNIX 5.42 running on RM600XXX. Conversion would include over 800 screens and conversion of som…
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
Re: Inserting an empty string inserts a space
I don't know the particulars about how the data is handled internally by informix. Black box techniques reveal that informix doesn't seem to distinguish between an empty string, a string with a single space character, or strings with multiple space characters. Try to query from y…
Re: Converting SQLServer to Informix
Maybe no-one knows enough about LiveWire to be able to give you an answer. >From: Sean@elvis.saecrc.org >Date: Thu, 19 Jun 1997 16:35:45 -0600 >X-Informix-List-Id: <news.39427> > >In article <866585279.1279@dejanews.com>, chris@saecrc.org wrote: >> >> We have a contact manager o…
Re: Informix 5 to 7 Upgrade
In article <5mk2u1$bob@cssun.mathcs.emory.edu>, richardt@TheMusicStore.co.uk says... >(I think - memory is a bit hazy now). My application had lots of ACE >reports where the users were prompted for an integer. If a character >was entered by mistake (usually a '-' instead of '0', …
Re: SQL/INFORMIX (UPPER)
Jonathan Leffler wrote: > > >From: Nils Paulsson <nils.paulsson@mailbox.swipnet.se> > > > >I am not at all oriented (yet) in programing Informix procedures but why > >on earth using tons of if:s when the conversion for the letters "a" to > >"x" can be done by adding a konstant to…
Re: SQL/INFORMIX (UPPER)
frantz@centrum.is wrote: > > Here's another version of the upper SPL, similar to the one that > Mark Stock posted, but it doesn't require an additional call to > the trim function. 8< I am not at all oriented (yet) in programing Informix procedures but why on earth using tons o…
NEWERA - printing
We are doing a conversion from Informix 4gl to NEWERA 2.20 and are trying to use as much code as possible from the "old" system. "Start report name to printer" works OK but we would like to throw up a dialog box prompting for printer or screen without having to change the origina…
Re: Input --- for the "Why Not?" Dept.
Michael Hoffman wrote: > > Am I missing something, or is this another instance of Informix not being > able to do the most simplistic things: > You're missing something. Be sure to add at least two shots of whiskey to your morning coffee. It works for me, however, by the time …
Asian Language/Unicode support
I tried to store Chinese characters in Unicode UTF-8 format in my database. I am using NewEra 2.2 running on Win95 and Informix Online Dynamic Server 7.2 running on AIX. According to the documentations, without specifying a locale, the default locale will be en_us.8859-1. I manag…
GLS problem
Hello, I am using Informix OnLine 7.22 on Solaris (system V Release 4.0 SunOS 5.5.1.). My database is created by import with DB_LOCALE=en_us.8859-1. I would like to use 852 code page (standard code page in my country). When I try to use dbaccess with CLIENT_LOCALE=cs_cz.0354 (85…
Re: Czech and German Characters in the same database
stephane.magnan@eur.autodesk.com ("Stephane Magnan") wrote: : Hi, : : I'm trying to insert some German and Czech characters in the same : database. : : At the moment I cannot do it and I believe it's not possible with : Informix Online 7.20. : : Because, …
Re: GLS support for "onpload" ?
Stefan Weideneder wrote: > > I've noticed a comment, that the Parallel Loader does not support > the GLS. This comment is from October, 1996. Is anyone out there, who > can definitely tell me, if this is still true for versions higher than > version 7.12 ? I thought GLS only cam…
GLS support for "onpload" ?
Hi all, I've noticed a comment, that the Parallel Loader does not support the GLS. This comment is from October, 1996. Is anyone out there, who can definitely tell me, if this is still true for versions higher than version 7.12 ? TIA Stefan…
Communicating between Databases and GLS
I want to communicate from Informix Online 7.20.UC2 database to my SAP R/3 (release 2.2f) Informix Online 6.00.USAP2 Database. The 7.20.UC2 database is on a Sun box running Solaris 2.4 The 6.00.USAP2 database is on a RM600 running Sinix 5.42 When I set DBNLS=2, I can connect to …
Equivalent characters with COLLATION category of GLS files
The Guide to GLS Functionality provided with Online Server version 7.2 says on page 1-10 that it is possible to define in the COLLATION category of the locale GLS file equivalent characters in such a way that the database server considers the string Arizona, ARIZONA and arizona a…
??? "Guide to GLS Functionality" ???
Hi, we have problems with our charset, inserting Umlauts is not possible, and the "Guide to GLS Functionality" in Online 7.20, ... well, until this morning I tought I saw (and understood) many things, but this one confuses me to an extent never experienced before, at least for …
Re: GLS support
Mike Orszag <jmo@ricardo.econ.bbk.ac.uk> wrote: :I am having a problem with the Netscape LiveWire Pro product crashing :on an updateRow when there are foreign characters (Informix 7.12, :Enterprise 2.01, SGI IRIX). Someone told me something about GLS support; :does this solve th…
GLS support
I am having a problem with the Netscape LiveWire Pro product crashing on an updateRow when there are foreign characters (Informix 7.12, Enterprise 2.01, SGI IRIX). Someone told me something about GLS support; does this solve the problem or is there something else to do? Thanks. …
GLS - any experiences ?
Dear all, has anyone experiences with the GLS-functions of informix 7.20 (GLS = Global Language Supplement) compared with NLS. Thanks in advance Markus -- Markus Wette http://www.halstenbach.de Halstenbach ACT GMBH Telefon.: +49 2261 9902-14 Breidenbrucher…
Re: Informix's short table & column descriptors
Of course the only reason why such a restriction would exist in the ANSI standard is that some very large company insists on such a limitation so that their database can be compliant without a major rewrite. E.g. 1. 18 character table/column name limitation in DB2. 2. Externall…
GLS and I-Sql
Hi all, I'm a new Informix DBA and I have some problem to understand GLS. We have ONLINE 7.20 on SunSolaris. I'd like to insert in my databases some data with accent characters. I created a database (by default) without set the variables concerning …
Re: GLS and I-sql
Stephane Magnan wrote: > > Hi all, > > I'm a new Informix DBA and I have some problem to understand GLS. > > We have ONLINE 7.20 on SunSolaris. > > I'd like to insert in my databases some data with accent characters. > > I created a database (by default) …
GLS and I-sql
Hi all, I'm a new Informix DBA and I have some problem to understand GLS. We have ONLINE 7.20 on SunSolaris. I'd like to insert in my databases some data with accent characters. I created a database (by default) without set the variables concerning …
Re: Date String Conversion error
>From: Ernest Chen <chen@www.kaplan.com> >Date: Tue, 21 Jan 1997 12:04:46 -0500 >X-Informix-List-Id: <news.32827> > >The document for Online Server v7.1 says I can do this: > >insert into mytable (subscription_date, email) >values('1997-01-11 08:45', "hello"); > >subscription_dat…
Re: Converting ESQL/C code from Informix 5.05 to 7.1X; question
You may find that you do not need to do very much. For example, with 7.13.UC1 (and 7.21, 7.10, 6.00, 5.07, 5.03), the following code compiles to object file without any problem: #define K 96 EXEC SQL BEGIN DECLARE SECTION; char buffer[K] = "Abyssinia"; EXEC SQL END DECLARE SECT…
How to use GLS ?
Hi all ! Up to now we did not use the NLS feature of Informix OnLine. Nevertheless, we work in german environment by using the following settings: LANG=De_DE.88591 LC_MONETARY=En LC_NUMERIC=En DBNLS=0 or unset This works fine so far. Umlaute are no problem. We are using the engli…
Re: Converting ESQL/C code from Informix 5.05 to 7.1X; question
Mangalam Ananth wrote: > > I have an application using Informix 5.05 UC3. The module containing ESQL > code has to be modified for conversion to Informix 7.1X. > > I was informed that one of the steps in the code conversion, involves the > substitution of all `# define C preproc…
Converting ESQL/C code from Informix 5.05 to 7.1X; question
I have an application using Informix 5.05 UC3. The module containing ESQL code has to be modified for conversion to Informix 7.1X. I was informed that one of the steps in the code conversion, involves the substitution of all `# define C preprocessor symbols' used within a EXEC …
Re: multi-valued field?
Tony Vuong wrote: > > In article 537C@ibm.net, Steve Behman <sbehman@ibm.net> writes: > > Kevin Kane wrote: > > > > > > Hi. Is there such a thing in DB2 as a multi-valued field? By this I mean > > > that I have a column called, say, AUTOMOBILES. If a person has 2 > > > cars, then…
=?iso-8859-1?Q?RE=3A_Support_for_e=F1e_=28spanish_letter=29?=
Hi Javier! There is a feature called GLS (Global Language Support), Informix = products no longer need to specify how to process this culture-specific = information directly. Culture-specific information resides in a GLS locale. When an = Informix product needs culture-specific …
Re: how to convert datatypes ?
Michael Agbaglo wrote: > > "Billy Wheeler" <billy@west.co.za> schrieb im Beitrag > <581085$nbg@cssun.mathcs.emory.edu>... > > On 2 Dec 96 at 19:25, Michael Agbaglo (Mr Aggression) wrote: > > > > > create procedure foo() > > > define i integer; > > > define s string; > > > …
Re: dbload Using Native Types
rcave@condor.peregrine.com (Richard Cave) wrote: :I'm trying (unsuccessfully) to use dbload on a text file that contains :native types for integer and double. You mean there is binary data - so it is no text file, but a datafile? : Seems that dbload doesn't recognize :native t…
Re: Question: How will the Year 2000 bug impact your work?
I have had several preliminary meetings with prospective clients who have serious Y2K problems, most of them on mainframes running COBOL or RPG apps. So far all my analyses indicate that it would be far less expensive to re-write the entire apps in a modern 4GL like Progress and …
Debugging Tools
I'm reserching debugging tools for 4GLs - I'd appreciate anyone pointing out some information sources on the web. Thanks, Matt.…
debugging tools
I'm reserching debugging tools for 4GLs - I'd appreciate anyone pointing out some information sources on the web. Thanks, Matt.…
4GL debugging tools
I am researching debugging tools for 4GLs - informix in particular. I would appreciate anyone helping me out by directing me towards some sources on the web. Thanks, Matt.…
Re: HELP - Using a cursor in 4gl
I4GL is not designed to handle arbitrary databases. Your best bet is to use ESQL/C -- you could go digging around the IIUG archives (http://www.iiug.org) for SQLCMD if you don't want to code it yourself. But I'm biassed because I wrote it. If you insist on using I4GL, then (a)…
Re: Converting from Informix till SQL-server, Experiences ?
Mike Lemon wrote: > > billy@west.co.za (Billy Wheeler) wrote: > > >> Has anyone had any experience of converting a database > >> from Informix 5 to SQL-server. > > >We went the other way. We had a lot of problems because SQL server allows > >longer table names, etc. So you…
How to move from Postgres95 to Informix?
I have been tasked with translating a PostGres95 database to Informix Online. I heard rumour of a conversion tool already done. Do you know of it or any lead to it? Otherwise, I could use your advise on what approach you would take to migrate the data. Postgres95 runs on a Sp…
Re: Actual Used space
Cheryl Kendricks wrote: > > In all of this conversation no one has commited that npused is the DATA > size only! If my memory servers me correctly npused does not include the > INDEX size that is being used by the table. This to me is important when > you are want to factor the a…
Re: Help! Out of dataspace memory error
The 6.02 P-Code version contains a severe memory leak related to the USING clause. Check out bug #35807. If you use USING heavily in reports or for numeric to character conversions, this is likely your problem. There are other possible sources of error for this error #, but th…
Re: Good Informix bug found
Stuart Litel wrote: > > This is one of my favorite Informix bugs I have found in a while.... > .... > > select count(*) from table where table.date_field = "8/4/96" > > or > > select count(*) from table where table.date_field = today > > the SECOND query using TODAY (or today -1 …
Re: Assignment of ARG_VAL in Informix 6.0
steve, Steve, I ran your little bit of code using informix 4.00 and 5.0 engine and it does crash on the assignment with FORMS statement error number -1218. String to date conversion error so my guess is that you have a WHENEVER ERROR routine being called which is trapping the …
NewEra 2.11 Compile Error
After the installation of version 2.11 I tried to recompile a source and got the error -4407 "There is an unprintable character in the above line" because of using umlauts. Did I forgot somthing to configure depending on the new GLS feature.…
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: 4GL / New Era question.
> I heard a few new things today, can anyone confirm them? > > 1. It is relatively easy to convert from 4GL to New Era. Do you mean 4GL code or 4GL programmers? Code can be converted but it really depends on how much of your code is screen oriented. I personally would recommen…
4GL / New Era question.
I heard a few new things today, can anyone confirm them? 1. It is relatively easy to convert from 4GL to New Era. 2. New Era is a healthy product, going places, and will be a big player in the lucarative GUI market. 3. It is possible for NewEra code, which runs on a PC, to…
Informix 4GL to NewEra conversion tool
The Technology Group, Inc. offers TTG Application Generator. TTG Application Generator: 1. automatically generates Informix 4GL code, 2. converts screen based 4GL applications to Informix NewEra. Current users of the tool are migrating Informix 4GL applications in a fraction…
Re: Is Client/Server Dead? Conference May 15th
: neal@fohnix.metronet.com (Neal Howard) writes: : In article <DpLLyo.46s@cix.compulink.co.uk>, : Malcolm Weallans <onlinedbc@cix.compulink.co.uk> wrote: : >INFUSE will be holding a conference on May 15th entitled "Is : >Client/Server Dead?" at the Commonwealth Institute in…
Re: Port Informix 3.3 -> Current Version. How Difficult?
In article <4js8tn$380@leithaus.leitess.com>, broswell@syssrc.com says... >One side of the debate suggests porting the Informix 3.3 to a current >version running on a Pentium and SCO Unix. This side is claiming that >the port is trivial. > >The other side is claiming that the a…
Re: Sybase to Informix
informix has a kit which can convert tables, transact sql code, dblib calls etc. this should make your conversion process much easier. suggest that you call your local informix office for details. On Wed, 31 Jan 1996, Kenneth Winiecki wrote: > Due to circumstances beyond our co…
US-CA-SF-South Bay PA SQL Client/Server Windows/Unix Web
Business Application Developer needed for detail design and implementation of Advanced Client/Server applications. Join a small and growing team of Professional Developers dedicated to implementing high quality customized solutions that meet our customers' needs. Opening is for…
US-CA-SF-South Bay PA SQL Client/Server Windows/Unix Web
Business Application Developer needed for detail design and implementation of Advanced Client/Server applications. Join a small and growing team of Professional Developers dedicated to implementing high quality customized solutions that meet our customers' needs. Opening is for…
Re: porting 4.x 4GL code to 6.01 - question
In article <4dhjki$ftb@cssun.mathcs.emory.edu>, alan@dssmktg.com (Alan Goodman) says: > >I was wondering if anyone can add to the following list of >code changes when converting programs running under 4.1x tools to >6.01 4GL and 7.10 online engine. A couple of undocumented featu…
Re: [Q] LOCALE and ORDER by char field
Step 1: upgrade! You are using version 5.0x, and that is not NLS aware (NLS = National Language S[upport?]) and only ever sorts in character code order. The ALS (Asian Language Support) versions handle multi-byte characters and complex collation sequences, but the standard prod…
i4gl -> New Era Conversion Tool
Many people have been posting messages looking for a tool to aid them in the conversion process from 4gl to NewEra. Our company, The Technology Group, has developed such a tool. The application generator takes full advantage of the object oriented language combining the Informi…
Help in emulating an Informix form
Hello All, I am trying to find out if someone has attempted to implement their own screen handling mechanism, instead of using the Informix forms...perhaps using the curses library and ESQL/C code. The problem we face is described below. Please excuse the length. In our project…
Re: NewEra Apps - Anyone Building Them?
There are a number of 4GL VAR's who have migrated their applications to NewEra. Concepts Dynamic in Chicago (accounting, project management), Tecsys in Montreal (distribution, warehousing), and Relevant in San Ramon, CA (manufacturing) all have NewEra apps now. Most of these apps…
Re: Read/Write C-isam from PC
> Nils Hansson <m519@abc.se> writes: > Nils.Myklebust@ccmail.telemax.no wrote: > >The only way I know is to put an Informix SE database on > >top of your C-Isam files. As someone else mentioned there seems now to be ODBC drivers available to read C-Isam directly. If these w…
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…
Re: Help with select/between
Spokey the Wheeler (spokey@haunted.demon.co.uk) wrote: : In article: <43uhcu$4k7@ftcnews.nrcs.usda.gov> tammy@scooter (Tammy Croteau) writes: : > : > In a table I have the following data: : > AGCR : > AGST : > ALAR : > ANGE : > AVSA : > AXXA : > BRAM : > : > The user wants to wi…
Re: 4GLs that disappear
We had a similar problem in Interactive Unix, whereby 4GL's of ten characters seemed to get removed under certain circumstances. Solution : Change them all to 9 characters in length. Peter Wages (pwages@vse.net) wrote: : Has anyone seen this or am I going nuts? You write …
4GLs that disappear
Has anyone seen this or am I going nuts? You write a 4gl program under 1 userid. You compile it under another. You get an error indicating a problem with the backup file. The 4bl. You exit out of i4gl and both the 4gl and 4bl are empty files I guess the source and the …
Re: How "BETWEEN date1 AND date2" determines century
> > All this talk about dates!!! I am very concerned. Many of the data entry > screens developed in the past only allow room for an 8 character date > string. This is often on very busy screens. Please do not forget this > or leave it until year 1999. > > I would suggest that …
Re: Proper Name Converter
I have some code which will do what is required. Why don't you contact me directly so that we can discuss where we go from here. > Does anybody have any Informix 4GL code that they have written (and > willing to share) that will convert a file that contains all uppercase > char…
Re: How "BETWEEN date1 AND date2" determines century
All this talk about dates!!! I am very concerned. Many of the data entry screens developed in the past only allow room for an 8 character date string. This is often on very busy screens. Please do not forget this or leave it until year 1999. I would suggest that any organisat…
Proper Name Converter
Does anybody have any Informix 4GL code that they have written (and willing to share) that will convert a file that contains all uppercase characters to mixed case. The function needs to intelligently handle the proper conversion of proper names --- expecially first and last nam…
Re: Sizing of char,varchar and text fields
We have had similar needs in many cases. We have resorted to a separate table with shorter char-fields, an index and a "line number" field to store such data. We of course store the index in the main table. (Sometimes we have found it easier to use a serial field for the "line nu…
Re: Sizing of char,varchar and text fields
In article <412gpi$i50@sclinux.blm.gov> Gary Slagel <gslagel@sc.blm.gov> writes: >From: Gary Slagel <gslagel@sc.blm.gov> >Subject: Sizing of char,varchar and text fields >Date: 18 Aug 1995 16:57:22 GMT >I'm trying to figure out the best way to handle some large fields in my >dat…
4GL -> PL/SQL Conversion
I am looking for a tool to do the conversion of existing 4GL code in INFORMIX to PL/SQL that could be used within ORACLE. We have a real need to migrate away from INFORMIX to ORACLE. Any help would be much appreciated. -- .........................................................…
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
Re: Converting interval to decimal ?
Santiago Albanese <75030.2743@CompuServe.COM> wrote: > Is there a way to convert an hour to minutes interval to >a decimal value for a report ? . I am running a 4gl prog that >reports hors worked in the interval form of ( 8:40 ) for eigth >hors and forty minutes and I want to dis…
Re: INFORMIX WORLDWIDE: "BUSINESS CASUAL"
This is getting to be a very interesting topic of conversation. It just shows the difference in standards in different parts of the world. In the last message somebody said that business casual was what you would wear to eat in a good restaurant. WELL - Over here - ABROAD as i…
informix 2 oracle code conversion
does anyone know of a cross compiler or tool which will convert informix 4gl & forms to the oracle equivalent. Tony Holder RDL UK LTD Email:Tony@robinsuk.demon.co.uk 1 - 3 Sun Street Voice: 0171 638 9481 London, EC2A 2BJ …
Re: Third Party Search Tools
In article <3lph7f$rhj@booz.bah.com> tayloralec@bah.com "Alec Taylor" writes: > I was wondering if there are any third party products out there that will > allow fuzzy searching (such as Soundex) for Informix. We implement SOUNDEX in our own code, and hold a Soundex column in t…
Re: Cobol To Informix Conversion
In article <3kftcp$kf3$1@mhade.production.compuserve.com>, Peter Land <100522.3377@CompuServe.COM> says: > >I don't see how you could - COBOL is a richer language than 4GL. >Have you considered MicroFocus CST (COBOL/SQL Transparency). This >generates embedded SQL and allows COBOL…
Informix to Sybase Conversion
We are currently building a prototype using code from an existing system that uses Informix as its database. Part of this task includes converting files that contain Informix Embedded SQL to the equivalent for Sybase. We are responsible for converting a large number of files in…
[Q] Sybase & Informix
Hi, I am in the process of porting C,XMotif code, running on Sybase DBMS, to Informix DBMS. Both the system are on Unix. Sybase is on Sun OS using C shell while Informix is accessed via NEC terminal & uses K shell. I am new to Informix and would appreciate any information regardi…
Re: Can Informix SE handle 8-bit ASCII
cabaniss@cap.gwu.edu "Jelks H. Cabanissg III" writes: > Can Informix SE handle eight-bit ASCII? We want to use PCs as front-ends > to a Unix back-end database which would store European languages with > diacritical marks (accents, etc) using the PC character set. > > If at all …
Can Informix SE handle 8-bit ASCII
Can Informix SE handle eight-bit ASCII? We want to use PCs as front-ends to a Unix back-end database which would store European languages with diacritical marks (accents, etc) using the PC character set. If at all possible we would like to avoid storing the data as BLOBS. ----…
Re: Loading ASCII data
>From: Ting Barrow <tingb@delphi.com> >Subject: Re: Loading ASCII data >Date: Thu, 24 Nov 94 23:35:29 -0500 >X-Informix-List-Id: <news.9991> >Just a thought: we get same message frequently when the load file has >an incorrect number of pipes - usually because someone typed one i…
Re: How do you covert a number a character
From Jim Gordon: * > A co-worker is trying to do a query in ISQL in which he wants to compare * > a number field with a character field. The character field could * > either contain digits or could be a mixture of characters and * > digits. What he wants to do is to convert the…
Re: How do you covert a number a character
> A co-worker is trying to do a query in ISQL in which he wants to compare > a number field with a character field. The character field could > either contain digits or could be a mixture of characters and > digits. What he wants to do is to convert the number to a character > …
rapid prototype development
Am looking for information on the use of 4-GLs and rapid prototyping in the world of software development. Would like examples of successful commercial/defense use of rapid prototype as a software engineering strategy. Does not HAVE to be Informix-based info...just happens to b…
Re: Converting string to numerical data - regardless of errors
kerry@kcbbs.gen.nz (Kerry Sainsbury) writes: >In article <39bniu$kci@emory.mathcs.emory.edu>, >kestnb!mdk@uunet.uu.net (Michael Kastler) wrote: >Regarding checking if a string is numeric: >> variable crashes the program. I really, really don't want to turn on >> error trappin…
Re: How do I report a suspected bug to INFORMIX?
Speaking of running purify on informix code..... I am getting this UMR on a simple time conversion utility we wrote here: ---------------------------------------------------------- Purify (umr): uninitialized memory read: * This is occurring while in: strncpy [fp_…
Non-ANSI Informix databases and Intergraph
ANSI-mode Informix databases. Interesting things. There's no BEGIN WORK statement, and you must always specify the table owner as a part of its name. So given a million or so lines of code developed under Standard Engine and now running happily on both SE and non-ANSI Online s…
Re: Help with ESQL/C and float data types
In article <47040018@hpcc01.corp.hp.com>, dallara@hpcc01.corp.hp.com (Jon Dallara) writes: > We are encountering a possible conversion problem while using > ESQL/C and an On-Line 5.01 data base while inserting values > into table fields of type float. For example, we insert …
Help with ESQL/C and float data types
Howdy, We are encountering a possible conversion problem while using ESQL/C and an On-Line 5.01 data base while inserting values into table fields of type float. For example, we insert the value -11.71 into the table, but isql retrieves the value -12.38. Any clues as …
Re: sperform,sunos,istrip
}From: kraehe@bakunin.north.de (Michael Kraehe) }Subject: sperform,sunos,istrip }Date: Fri, 13 May 1994 20:00:31 GMT }X-Informix-List-Id: <news.6755> } }Hy Folks, } } perhaps Y have an answer to this problem. } } We have a Sparc running SunOs 4.1.2 and Informix 4.10. } Unfortunat…
Re: Strings in compiled forms
Michel Behna (mbehna@promus.com) wrote: > >jolomo@netcom.com (Joe Morris) writes: > >>Hello, > >> My site uses sccs for our version control and I'm forcing everyone > >>to embed string commands in their 4gls so that the 'what' command > >>will tell me which versions of the 4gl…
Strings in compiled forms
Hello, My site uses sccs for our version control and I'm forcing everyone to embed string commands in their 4gls so that the 'what' command will tell me which versions of the 4gls are in a compiled 4ge. Does anyone know of a good way to implement this in forms? The only way…
V/Forms anyone seen it?
Has anyone seen the new product V/Forms from Roger Sippl's start-up Visigenic Software? V/Forms was described in a recent edition of "Infoworld". It sounds alot like Powerbuilder but it will work with Informix's 4GLs. It would be interesting to hear the impressions of someone…
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…
Re: DBperl. Database Independent API for Perl.
This section was last modified on $Date: 1993/08/13 19:04:50 $ ============================================================ 2. CONVENTIONS, STRUCTURE and OPEN ISSUES ============================================================ 2.1 Architecture of a DBperl Application …
Re: uploading flag files
}->From: davids@Software.Mitel.COM (David So) }->Subject: uploading flag files }->Date: 22 Jul 93 20:34:07 GMT }->Reply-To: davids@Software.Mitel.COM (David So) }->Organization: Mitel. Kanata (Ontario). Canada. }-> }->Informix has export/import/load/unload facilities. }-> }->Howe…
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
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 values), the column is considered NULL by Informix…
Re: Storing non-printable chars in CHAR columns
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 values), the column is considered NULL by Informix. Note that a NULL column means a value which was not sup…
Re: Internationalization Support
Michael Haggerty writes: >Does Informix handle 8-bit clean characters or does it handle 7-bit ASCII >characters only? This is not my area of expertise, so please excuse me if the answers are not as detailed as you'd like. Our servers are coded "8-bit clean", so what you put in …
Soundex type search (fwd)
Luis Caamano writes: > > Hello, everybody. > > Does anybody knows of any way to implement sound matching searches > on character fields? That is, to match words that have the same > sound not the spelling? > > It don't care how as long as I'm reading from an informix database. > …
Re: 4GL conversion
> My Command is currently running INFORMIX SQL 2.10.03G. We are considering > buying and converting to 4GL product Rapid Development System. ... > Since I am a sceptic at heart, I thought I would ask the user group if they > have had any unanticipated problems converting/running…
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 …