Oninit® Archive
Results for “SQL_LOGICAL_CHAR”
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 …
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, > \…
bson_update with special characters crashes session
Yeah, that seems to be some sort of tacit assumption in the documentation (everybody agreeing on what JSON is), and I'd support making it more explicit, with the JSON/BSON data types, with the bson_*() UDRs and also with genBSON(). A clear solution would be to disallow anything J…
Cast a datetime to character in default clause
Hi Y'all. (English REALLY needs a plural "you"!) I have a situation where a commercial software package goes bananas with datetime data types. But it is happy to work with a time stamp if it is character data type. I have been tasked with adding a few columns to a table. I am tr…
future support of UTF-8 character handling
Hi Roland, I am maybe missing some details but from my knowledge, SQL_LOGICAL_CHAR is basically a ratio that applies to define the size of CHAR/VARCHAR columns when creating an SQL table. So when you have SQL_LOGICAL_CHAR=3, it's as if you would do it by yourself, by converting C…
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 ------------------------------…
How to compile dbdelete utility for utils2_ak file
Nasiha: The error, -23101, is a locale error. Your current locale does not match the locale of the database: $ finderr 23101 -23101 Unable to load locale categories. An invalid locale name was supplied for the locale initialization. The environment variable specifying the locale…
Informix KMIP Encryption
Hello Team, One of my customers is migrating from the Local Key Store to KMIP Key Store. They have tried migrating from the Local Key Store to KMIP but the Database stops working. Any recommendation?? Regards Amit Kumar Thakur Software Engineer : Customer Success. ---------------…
V14.10.FC9 installer missing librarie(s)?
On my system (Kubuntu) the GSKIT files are linked directly into /lib/lib64: $ dir /usr/lib64 total 8 drwxr-xr-x 2 root root 4096 May 8 17:32 ./ drwxr-xr-x 16 root root 4096 Nov 14 2022 ../ lrwxrwxrwx 1 root root 42 Mar 16 04:44 ld-linux-x86-64.so.2 -> /lib/x86_64-linux-gnu/…
issue with the ODBC Driver
Hi B himagonolla, Based on information you shared there is difference between ODBC DSN values for CLIENT_LOCALE between SQL Server 2005 and SQL Server 2019 machines. In 2015 both CLIENT and DB LOCALEs are set to same value, hence no conversion taking place! and you are not seeing…
CREATE DATABASE and DB_LOCALE
Hi all, Normally, when DB_LOCALE is not defined, a CREATE DATABASE will use by default the ISO8859-1 encoding. I know also that when setting a DB_LOCALE that does not match the database locale, you get the following error at connection: 23197: Database locale information mismatch…
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…
Application or Internal User
I am suspecting this is a dumb question, and I'm actually hoping it is. Is there a way to tell which users that have access to a database are being used to connect to the database through an application and which ones are being used locally(someone logging into the box and then …
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
Now the rror is -23197 - Database locale information mismatch.…
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)…
SCHAPI: Error -23197 Database locale information m
Hello, we are runnig on IDS 11.70.UC3. I have table with CLOB - for example in database db1 (COLLATE is sk_SK.912): create table abc ( id serial, c clob); There are some data in this table. I need to schedule custom task for periodicaly unload data from this table to filesyste…
Bulgarian Locale
Hi, If you want to use Bulgarian locales for informix 11.70 or 12.10 you can use: bg_bg.8859-5 - for UNIX/Linux Cyrillic; bg_bg.cp1251 - for WINDOWS Cyrillic; bg_bg.MIK - for DOS Cyrillic; bg_bg.UTF-8 - for UTF code set coversion; All these code set conversion you can find in …
Informix 12 Unicode
The big problem is that there is no character length because nowhere informix allows you to define that. The current syntax just defines the bytes. It's up to the developer/dba to assume the ammount of bytes needed for the ammount of characters desired. You can find the value fr…
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?…
UTF-8 Conversion
Yeah by conversion I meant export/set locale/import. the sys* stuff I was referring to are the sysmaster and associated databases, not tables. sorry for the confusion.…
Pros & Cons for text datatype.
Here are some observations for data-types which can be used to hold more than 255 characters (a limitation for varchar) though char type may contain more data but it pads spaces and consumer more space. We compared lvarchar and text data-type A1: If an lvarchar column is added …
listener-thread: err = -25573: oserr = 72
Resolution to this type of problem also includes adding the remote (application) server to the local database servers' hosts file , and/or changing the order of host lookup in the hosts file; the disabling of DNS lookup when authentication was switched to local but not carried ou…
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.…
Unicode database
Yes, you are right. The Locale of the Database should be en_us.utf8 if it stores the unicode data. But when we want to use the informix tools like: dbexport/dbimport to change the non-unicode database, we should consider the target locale and the locale conversion table availab…
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…
JDBC type for Informix TEXT column?
The Informix JDBC driver, version 3.70.JC7 and earlier, when run against an Informix 11.70 server on Linux, reports that the JDBC type of a TEXT column is java.sql.Types#LONGVARCHAR. This seems OK. When we call resultSet.getObject("columName") on that column, however, it returns…
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…
Data type ?
Hi Peter, LONG is an Oracle data type for storing character data of variable length up to 2 Gigabytes in length (bigger version of the VARCHAR2 datatype). In Informix either text or clob would be an equivalent. If you have only up to 32000 bytes stored, you can use lvarchar(320…
Problem in changing locale via dbexport/dbimport
Dear All, I want to import an existing database having default locale settings as (DB_LOCALE=en_US.819 ;export DB_LOCALE), and my destination/target locale setting would be in Chinese language support locale as (DB_LOCALE=zh_cn.GB2312-80 ;export DB_LOCALE). But while dbimport, …
Conversion to UTF8
Hi, I am looking for some consultation about transfer from CP1250 to UTF8 (cs_CZ.1250 to cs_CZ.utf8). I found three troubles on internet and some tested: 1) sorting - our fields starting with czech characters are not sorted correctly Probably IBM Informix International Language S…
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 …
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 …
string-to-date conversion errors when database locale is UTF8?
All: I am getting an unexpected error doing string->date conversions when the database locale is UTF8. When I run the following test queries: SELECT TO_DATE('1900-01-01 00:00:00') FROM systables WHERE tabid = 1; SELECT TO_DATE(CAST(CURRENT YEAR TO SECOND AS varc…
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…
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
Tool to estimate the size of an index
Sorry, I forgot to provide the version of the installation: IBM Informix Dynamic Server Version 11.50.FC4 Operative System: AIX Version 6.1…
validating locale of a DB
Does anyone know the table where one can determine the locale a database was created with .. Thanks in advance ... v11.50.fc7 Aix 6.1 Peter Logan Senior Database Administrator Phone: 616/878-8309…
UTF8 with Informix
Hello, I am relativly new to informix and must make a migration from the typical 8859 charset to UTF8. My database with the UTF8-locale is working, BUT because of multibyte chars (and char/varchar - columns store bytes not chars) all of my field lengths are corrupt. So I found t…
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…
materialized view
Is there the equivalent of Oracle's materialized view available in Informix 11.5 ? We are migrating data that will require an initial bulk load from Informix to Oracle, and then delta loads. We were going to use HP Loader to unload files and then have an ETL process ( ODI ) to cl…
FW: Informix record member as array fails compilation
Hi We get the following compiler error when trying to create an Informix table with a member consisting of a 2-dimensional array using 4GL. Is it possible? Here is a copy of my code: create temp table ts_ac_tmp ( date_started date, lane_nr char(4…
ODBC - Database Locale Information Mismatch------W
The source DB (on IDS v11.x) is en_US.819 (default for IDS). I am trying to connect from an app via ODBC (using SDK 2.8 TC1 - required for another app) but keep erroring on the "Database locale information mismatch." error when connecting. I've looked into this issue pretty exten…
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…
Storage to SAN Migration
Hi, We are working with our vendor on migrating our Databases from Local Storage to SAN. Our Database is using the Raw Partion. Vendor has advised that they will create a similar character device link in the system from SAN ( we have around 250 character device links) and then c…
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…
local area connection!
OS is Win Xp Pro "Dray" <dray@dray.com> wrote in message news:gvj9a8$8nb$1@ss408.t-com.hr... > We added another lan card on the computer(informix server), but now we > have slower connection on database! Each card has it own ip range! On a > local server connection on the databas…
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…
Modify the "IBM INFORMIX ODBC DRIVER" Data Source
ids-bounces@iiug.org wrote on 12/12/2008 01:38:51: > How can I modify the "IBM INFORMIX ODBC DRIVER" Data Source - Database > Locale value from en_US.CP1252 to en_US.CP819 via a DOS batch script > (preferably) and/or VB script. > Do you want to change the value of database loca…
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
Fernando- yes, sure. Loading it with DB_LOCALE=en_us.utf8 CLIENT_LOCALE=en_us.utf8 I get: 34389: Illegal character has been found in the input string 847: Error in load file line 1. It breaks at the first occurence of a non ASCII character (the C4)in the field s1 of type t…
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.…
Java Multithreaded application gives -1 as PID
On Feb 18, 3:01 pm, mohitanch...@gmail.com wrote: > Version: IDS 10 > > I have a java application that is multithreaded and each thread > creates a new DB connection. But when I look at onstat -g ses I see > PID as -1. Could somebody tell me if this could be changed to reflect > …
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…
date conversion: date - datetime with EXTEND
Situation: data field StartDate with data type: datetime year to second With the SQL statement: select count(*) from table where StartDate = EXTEND ('1/1/2007',YEAR TO SECOND) i got error -1262 "on numeric character in datetime or interval". What' s wrong ? Without EXTEND …
Re: Informix ODBC Driver
Hi, What is the column fname being defined as ? Is it a char or a varchar ? or ... It will be helpful if you can give the schema of the whole customer table. And when you say special characters ? are they simple special characters like $%^& or UNICODE characters. Give the sa…
Informix ODBC Driver
IDS 9.40.FC8X3 on Solaris 9 ODBC Driver 3.82.0000 2.81.TC2 If I run this query (via Business Objects) SELECT id, title, gender, fname, lname FROM customer WHERE id = 1234567890 and the fname column includes special characters all columns after fname are returned…
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: Informix .NET and Polish locale (required help)
Hello and thank you for your response. The problem is that this data is not ours but from another vendor. I do not know what their locale was when they inserted the data. I made the query and the database locale is en_US.CP1252. Thanks !…
Informix .NET and Polish locale (required help)
Hello , we have an Informix Database that has Polish laguage data. The database locale is CP1252. The problem is that when we use the Informix .NET Client SDK Version 2.90.4.0 to retrieve this data we get an Unspecified Error -21000 exception. Moreover the characters of the polis…
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…
locale
Hello, Few Questions in the locale setting ================================= 1. Is it possible to have different locale (dbs_collate) value for the databases created (dbs_dbsname) ? OR 2. Are the database created should have the same locale value as teh sysmaster ? 3. I am ex…
Re: Locale setting
Hello, Thanks for the help. It indeed helped me to get some info on the locale setting. I had few addln queries on the locale setting. 1. Is it possible to have different locale (dbs_collate) value for the databases created (dbs_dbsname) ? OR 2. Are the database created shoul…
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…
Deny connect over network user informix
Hi, it's possible to deny connection to the informix database over tcp with user informix? So user informix works local only. Thanks Marco…
Locale setting
Hello, Thanks for the replies. My Q was : How can I know what the locale setting that is being used currently ? i.e., set the nondefault locale, <---- For example, to access a database with a Japanese SJIS locale, set both DB_LOCALE and CLIENT_LOCALE to ja_jp.sjis on the clien…
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…
Re: compiling informix IDS with PHP
Roland, Perhaps you would be so kind to share youre compilation scripts? Bye the way. I use SuSe 9.2 "Roland Wintgen" <rw@evg.de> schreef in bericht news:newscache$svuf9j$899$1@news.itemax.de... > Manas D schrieb: >> Danny, >> Please refer to the following article >> http://ww…
Re: compiling informix IDS with PHP
Well it's that document that I use. "Jean Georges Perrin" <jgp@iiug.org> schreef in bericht news:mailman.379.1164649133.29126.informix-list@iiug.org... > There is a complete article on dW re: installing PHP and Informix... > > Hih > > jgp > >> -----Original Message----- >> From:…
Re: compiling informix IDS with PHP
Manas D schrieb: > Danny, > Please refer to the following article > http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0606bombardier/ > > Thanks, > -Manas > > Danny De Koster wrote: >> Hi all, >> >> I want to use my informix database with PHP. But with the compilat…
compiling informix IDS with PHP
Hi all, I want to use my informix database with PHP. But with the compilation I get this. Any solutions? Thanks, Danny /bin/sh /usr/local/src/php-5.2.0/libtool --silent --preserve-dup-deps --mode=ins tall cp ext/wddx/wddx.la /usr/local/src/php-5.2.0/modules Installing PHP SAPI…
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…
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 …
Re: Informix 7.25 UC4 German Locales ODBC Driver
cosmoxx wrote: > Hi, > > I set on the ODBC driver > client locale: de_de.CP1252 > database locale: en_us.CP1252 > Translation library: > C:\\Programme\\IBM\\Informix\\Client-SDK\\bin\\igo4n304.dll > Translation option: 0 > > but nothing happens > > Thanks > Akbaba …
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…
Re: [Informix][Informix ODBC Driver] Database locale information mismatch
Try unchecking the "Use Server Database Locale" in the environment tab of the ODBC setup dialog on the windows side. We saw the exact same problem with IDS 10 when we first brought it in house. Hope this helps. -- Chris bobkot@gmail.com wrote: > I have download ClientSDK 2.90…
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…
Error -21005 inserting Euro symbol via ODBC driver 2.90 TC4
Hello, I have the folllowing problem: I want to insert the Euro Symbol in a character field in a Informix 10.00.FC4 database. With sqlcmd on Unix, there is no problem. But, if I try to insert the Euro symbol from am Windows XP System via ODBC or Informix.NET driver, I get the err…
A blob data type must be supplied within this context
Hi, I am working with Informix 7.31 and I would like to insert string data into a TEXT field as follows: insert into TABLE_DESTINY (TEXT_FIELD) select CHAR_FIELD from TABLE_ORIGIN; I get the message "A blob data type must be supplied within this context ". Is there any way I …
RE: [Informix][Informix ODBC Driver] Database locale information mismatch
You could try issuing the following statement and see what the engine is configured for. onstat -g env This will give you the environment of the engine. I believe it is listed there what the locale is set to. David -----Original Message----- From: informix-list-bounces@iiug.o…
[Informix][Informix ODBC Driver] Database locale information mismatch
I have download ClientSDK 2.90.TC4 I am trying to connect to an IDS10 database. My iLogin works fine, but I cannot set up the ODBC driver, I keep getting the message "[Informix][Informix ODBC Driver] Database locale information mismatch" I cannot leave it blank, under environme…
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?…
Warning: DB_LOCALE environment variable does not match locale of the database
Hi! When executing sql statements against a database in an informix 9.40.fc7 database server running on AIX 5.3 this warning message is generated: Warning: DB_LOCALE environment variable does not match locale of the database The client process environment is: SERVER_LOCALE no…
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…
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…
Informix ODBC dirver 3.10
you have not set INFORMIXDIR or one of the other environemnt variables appropiately or the locale of your database is different to that set in your client…
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.…
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…
chinese character can not insert into table
Hi! My informix database was created by locale=zh_cn.gb. I tried to insert a character that was not in GB2312 code set, but failed . I was wondering why informix database intend to prevent some chinese codes from insert into this database,it just incurs problems that migrating da…
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…
Changing the locale of Database
I have a database (IDS v9.3) in default english locale. I would like support multilingual data and hence would liek to change the encoding of the DB to en_utf8. My understanding is that I can not simply change the encoding of the loaded database. I need to create an empty DB wit…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
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: 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…
RE: ODBC error -23101 Unable to load locale categories
Hi. Try as below. Open ODBC setup window. Click Enviroment tab. Put %INFORMIXDIR%(Change your installed directory)\\bin\\ig04n304.dll on Translation library. Just my $0.02. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: "jded" <jdendrinos@hotmail.com> >Reply-To…
ODBC error -23101 Unable to load locale categories
I'm trying to connect to an Informix database server on a Unix machine from Windows XP. I'm using Informix ODBC Driver ver. 3.2.81 TC2. I can connect to other databases but if I try this I get this error about the locales. The difference of this database is that it has greek.iso8…
ODBC error -23101 Unable to load locale categories
I'm trying to connect to an Informix database server on a Unix machine from Windows XP. I'm using Informix ODBC Driver ver. 3.2.81 TC2. I can connect to other databases but if I try this I get this error about the locales. The difference of this database is that it has greek.iso8…
=?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…
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'?…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
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…
[IDS 7.31] convert Char to Numeric
Fred (au boulot) wrote: > I have a numeric value stored in a char row in a table. I need to calculate > a sum : > > select sum(qte * val_num_in_text) > from the_table > > i get an error : Character to numeric conversion error ! > > how can i convert the text value in numeric, i n…
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…
default time to acquire lock?
Is there a default time the database gives a local session (not distributed, not ER) to acquire a lock? I have been noticing what seems like a lot of locking issues since my upgrade to 9.4 and I am just not starting to really dig in.…
Inserting japanese/chinese data in blob data type
BLOB data type is to be used for binary data only. For storing character data , use CLOB data type. LLOYD SERRAO <lloyd_s@rediffmail.com> wrote: Dear All, When i try inserting japanese or chinese data in to blob data type it stores as junk, something like this 次ã#65533;« å…
UniCode support
Hi, There's a IDS9.3 on RedHat Linux with DataBase Local is en_US.CP1252. And I'm running Microsoft Reporting Services on win2003 Tranditional Chinese plus SQL Server 2000 sp3. It's fine to connect to Informix except for the Chinese preview, I got an unknow code on my report. I…
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…
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 _____________________________________…
Informix Dynamic Server 9.21 under Windows 2000
Hallo, I'm using an IDS under Windows 2000 with local user accounts for IDS autentification. I know that I can use local and domain accounts for this purpose. I acces to the database server from a terminal server with local accounts. Due to some reasons I don't want use AD domai…
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: -999 Not implemented yet.
"Mark D. Stock" <mdstock@mydassolutions.com> wrote in message news:<bvc7l9$gvg$1@terabinaries.xmission.com>... > LUQUE Valdivia Omar wrote: > > > Hi, > > > > > > Schema : > > -------------- > > > > CREATE TABLE "informix".cuentas_corrientes > > ( > > cod_empresa character(5) NO…
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…
Re: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
Re: -999 Not implemented yet.
LUQUE Valdivia Omar wrote: > Hi, > > > Schema : > -------------- > > CREATE TABLE "informix".cuentas_corrientes > ( > cod_empresa character(5) NOT NULL, > cod_anho character(4) NOT NULL, > cod_tipo_documento character(3) NOT NULL, > cod_num_doc character(10) NOT NULL, > co…
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…
How to convert carriage return to another char string in Informix SQL or 4GL
Wayne T wrote: > I am post this question for my co-worker, here is his questions. Any > help would be appreciated. > > Hi, > > In a databse table there is a field of type character or string - or > whatever informix calls it. This string contains new line characters > or carriag…
Multi-byte characters
Hi All, Does Informix data type support multi-byte characters. I need to insert data with multiple languages. I have a field with nchar(20). If i insert a english or french data of length 20 chars it inserts in to the table. But when i want to insert korean data of same length, …
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…
Arabic Data
Hi Every1. my client has got a data in Informix Online 5.x with r4gl used for the front end. the character based screen display in Arabic. The data stored in the field are numbers and on column is the name which is in Arabic. This data is exported using the unload utility to a…
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…
Changing database local / dbexport tapesize
Hi all, does anyone know a trick/workaround to change the locale of a database from en_US.819 to de_DE.819 without the dbexport/dbimport combo. If not: I would use dbexport/dbmport but the problem is the tapesize restriction of 2 GB. We're using 9.30UC6 under AIX 4.3.3 and the d…
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?…
Translation Library in Driver CSDK.2.81.TC1 for windows.
I have big problem. My database has Database Locale en_US.8859-1. My data inside: pl_PL.8859-2. How I may create Translation Library (to Informix driver ODBC/windows). Best regards Jarek…
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…
Naming Standards
Hi, Has anyone used some good meaning naming standards for database tables? We have mainly data and code tables. I was trying to develop some standard table prefixes that would make them easily distinguish between the type table types, such as d_<table name> for data tables and …
Re: (-23197) : Database locale information mismatch.
This is possible only if the 2 tables are code set compatible. That too is true only from 9.40.UC1. Like zh_tw.big5 (chinese) and en_us.8859 are not codeset compatible and hence you would receive -23197. But fr_fr.8859 (french) and en_us.8859 are codeset compatible and hence you…
(-23197) : Database locale information mismatch.
Hi all! Suppose I have connection to a db with concrete locale and want read data from another one with other locale (like from sysmaster:anytable), but sever gives me subj error. Is this operation possible at all?…
VARCHAR or not ?
Dirk Moolman wrote: > Solaris 8 > IDS 7.31 FD3 > > > We have to create a table, that will contain a code, a short description > and then a long description (up to 2000 characters). This is basically a > lookup table, and will be used for browsing, verifying and selecting > codes…
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 …
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…
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 …
connection with jdbc failed
Can anybody help me with this problem: Trying to connect to an informix database on a unix database server from my windows 2000 computer, I get the exception : -> Encoding or code set not supported I used this command: con = DriverManager.getConnection("jdbc:informix-sqli://m…
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…
How to get Locale supporting UTF8 for IDS 9.3 or higher ?.
Hi Friend, I am having questions regarding Unicode in IDS, i know that currently IDS supported to enable UTF8 code-set for Database and the works that we just have to do to get this stuff is that to set Databse evironment variable to locale UFT8 ?, i am using IDS 9.3 but i don't …
Locales, ODBC and SPL
Hi, I am using VB6 (RDO20.dll) and the newest Informix ODBC driver (3.32 .0000 2.50 tc2) to connect to Informix.2000 on Windows 2000. The client workstation is running NT4(sp5) The database was created with the default locale (en_US.CP1252) Client Settings: ODBC Driver setup,…
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: DATA TYPE QUESTION
The 255 character limit on Informix 7.3 is for VARCHAR, not CHAR. You can store up to 32,767 characters in a CHAR column. Hal Maner M Systems International, Inc. www.msystemsintl.com "Martin A. Marques" <martin@math.unl.edu.ar> wrote in message news:959mk9$c27$1@news.xmission.…
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…
Problems with Locale
I'm a non-expert at informix, I'm developing a c program for Informix on an AIX 4.3 box, using the CSDK 2.50, and I"m getting the error 23101 when I try to connect. I looked up the follwoing description: [root@p140 bin]# ./finderr -23101 -23101 Unable to load locale categories…
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…
How should I insert a file to Database?
My Informix Dynamic Server is V7.24 on Unix. I have to insert a file to DB(about 2K). I don't know how should I realize it. There is TEXT type in DB,But how can I insert/update the field using a simple SQL statement?(I can't use some functions that exist in higher version). Also,…
sdk and locale
Hi all, I'm trying to make the client sdk to work with my database. I installed the sdk on windows 98 and when I configure the environment in the Odbc driver setup it complains about the locales: "The displayed locale and codeset have not been found on the client machine.…
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…
Database Localization.
I'm embarking on a journey into the unknown. A client of mine has a software system that interfaces with various database vendors. The "configuation" data that exists in the database for the product is in english. The customer would like to "localize" their database for multip…
Re: Function Isnumeric
Rein Puksand wrote: > I have table: TEMP > num cont (Text data type) > ------------------------------- > 01 kkkd34 > 02 ddde > 03 112 > 04 23xk > 05 0000 > 06 krook00 > 07 kk34 > 08 12 > > I want to find rows where con…
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…
Is there ASCII or ISO8859-1 Data Type in Informix?
For example a data type char(4) with value 'abcd' instead input 'abcd', I would like input '979899100' as ASCII code or 'abcd' as ISO8859-1 code. This will allow me input some special character like Cent sign, Pound sign, Yen sign, Superscript 2/3 for square/cu…
Re: Connecting to multiple databases (one local, one remote
Alan, We need to use a parameter in the informix.ini file mcblockmode=2 otherwise we get a similar error. Regards David Ashby ______________________________ Reply Separator _________________________________ Hello, We are trying to connect to 2 datab…
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".…
Datatype IfxMRData with DBD::Informix
Hello I try do access the data type IfxMRData from the Excalibur Datablade under Informix 9.14.UC7 with the Perl library DBD::Informix 1.00. So far I can update and insert this type but the select does not bring the whole part of the field. The field is truncated. I read the FA…
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.…
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…
Searching text fields
if you have the lvarchar datatype you can still use like and matches on the text. and you have a very large amounts of data you can store there, up to 32K. Kief wrote: > Is there any way to search a column of type TEXT in Informix? > From the documentation the answer appears to…
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 …
Informix 4gl problem
Show us the declaration of the record appp_question and of the table(s) from which the data is being fetched. At a glance this should work. Art S. Kagel Usha M Rao wrote: > Hi, > In Informix 4gl when I fetch a record having 2000 characters(field of > type nchar(2000)) from th…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
load error
I'm getting a weird error when I attempt to load data into a table from a file. I'm running Informix 7.31.UC2 on HP-UX 10.20. Here is the error: $ dbaccess test - Database selected. > set lock mode to wait; Lockmode set. > load from add_ie3 insert into user_test; 404: T…
Informix-data type
I am using Informix Version 7.3. I want to define a varying length column,which takes upto 2000 characters Since NChar datatype is a fixed length character data type,I donot want to use that. I cannot define LVarchar .How can I resolve this problem? Usha…
Informix SPL - String Functions
Hi, I am an Oracle Developer, stuck in an Informix world. I am trying to do probably the simplest thing I can think of and cannot get it to work. What I am trying to do is given a string, go through it and find the occurences (what positions in the string) another string has. …
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 …
Connect Online and SE
I have two boxes setup for Informix Server: HP box with IDS 7.31.UC2X9 Linux box with SE 7.24.UC5 Both were up and did well jobs in local database services. Now I need to connect both, and the problem is ... in HP, I issue this command: isql dbname@Linux it tells me 329…
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…
Re: NULL characters in CHAR(n) data type?
--Boundary_(ID_wdQo6omzC864PHNPZDQyMQ) Content-type: text/plain; charset=us-ascii Content-disposition: inline Content-transfer-encoding: 7BIT Jim Why dont you use VARCHAR(n, 0)? HTH Sujit Jim Blye <jimblye@us.bim.com> on 01/14/2000 07:10:48 AM Please respond to Jim Blye <jim…
NULL characters in CHAR(n) data type?
Is there a way to store NULL characters in a CHAR(n) data type? When I try this, the NULL characters (0x00) get converted to spaces (0x20). Maybe there is an Informix attribute I could set that would change this behavior??? Since the data type is fixed length, I don't unders…
Esql/C Set Descriptor
I'm having trouble setting a descriptor for numeric types. I get a message that says: "Character to numeric conversion error." Here's what I'm doing: // allocate descriptor area, set count long l = 34; EXEC SQL BEGIN DECLARE SECTION; int index = 1; int type = SQLINT; char* d…
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…
missing en_us.1252 - installation problem
Informix 7.2, NT4 Workstation, SP3. Installed Informix from the local administrator account, set up the environment variables. The Informix tools seem to work fine, and I am able to create and populate a database. When I log on as any other user (including the Informix user), …
how to insert text into memo-blob ?
i have a little problem with an informix online 7.2 (?). on the client, there is an informix-cli 2.5 and i can insert text with carriage returns ("\\r\\n") into the memo-blob without problem: "insert into table_a (num, text) values ('1', 'this is a text');" on a client with info…
Re: Putting carriage returns into varchar field
Post version and front-end information. You should be able to stuff anything except a NULL character into a varchar column (need a char type to hold NULLS) depending on the capabilities of your front-end tools. In ESQL/C it is trivial and in 4GL not hard either. Art S. Kagel …
question about client locale
Hi everyone. We have a database with DB LOCALE set to de_CH.819. Does anyone know how to determine what CLIENT LOCALE could be used with this? HP-UX 10.20. IDS 7.31. I have an old example for the US database: For DB_LOCALE = en_us.8859-1, use Client_Locale = en_us.1252@dict.…
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…
Re: Multi-language support
Hi Denis, Denis GILARDIN wrote: > > Hi, > > I want to build an international database which support 40 european or pan > european languages. My informix environment is INFORMIX 7.22. Is GLS my > solution ? > yes and no. 1. If you will use char and varchar in your database you …
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…
Problem: dbexport and decimal values
When I do a database dbexport all decimal values are truncated in the unl files. Do you know why? IDS 7.23 for SCO OpenServer I think locale variables are OK. OK with onunload. OK with unload sentence. TIA…
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…
database locale information mismatch
Hi *.* On one of my servers I have two databases (lets say dba and dbb) cretated using different DB_LOCALEs (default and de_DE.1252). When I use use dba and then do: select <whatever> from dbb:sometable I get error -23197: database locale information mismatch. Is there any …
Re: Problems Connect NT-Clients to NLS-DBs (Locales)
Hi Guenther, Guenther Schmid wrote: > > Hi, > > On our 7.31-Server (Solaris 2.6) we have a lot of > NLS-Databases with the Database Locale set to "de". > When we try to connect to these databases using > NT-Clients we get the error message "Code sets of > the local categories ar…
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
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 table into character string. T…
How to define unicode columns on IDS7.3?
Hi! I try to insert Java unicode characters into IDS7.3 on Linux. I use JDBC connection to database. The problem is when I try to insert some local (slovene) characters they are not stored into database. (i.e. there are only ?? characters in database) I setup IDS with default L…
Access database : Locale problem !!!
Hi, I am working with 2 database server: Informix OnLine Workgroup server 7.22 on a NT Server. IDS Workgroup Edition 7.32 on a AIX 4.3 Server. I used dbaccess from the Unix server to create a new database on the NT Server. But when I try to access this database with any tools (d…
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…
Re: VARCHAR in table, CHAR in view
> So, I'm working on a system right now that has a requirement that the > character columns in our tables be of CHAR data type. This is due to an > interface with some legacy application and is not negotiable. > > My question is this- If I created a view against the table where t…
How to Change Locale??
Hi, Anyone knows safe way to change locale of database faster than unload/load data??…
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…
database.majorErrorCode = -406
Hello, I try connect to database from Netscape Liwire and .... database.majorErrorCode = -406 [VENDORLIB] Vendor Library Error: Unable to load locale categories. database.minorErrorCode = 0 Help me please! -------------------------- Roxana Spavioli roxs@tsubcero.com.ar…
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…
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 …
ODBC error (Database Locale).
When I try to connect with Informix Database using ODBC Informix Driver ( = 2.5, 2.8, Intersolv ) get the next error: SQL Error State:S1000, Native Error Code: FFFFA563, ODBC Error Database locale information mismatch. Infomix 7.20 win 98 Thank in advanced. jhernandez@geuropa…
SQL-SELECT between databases with different DB_LOCALES
I want to select something (serial, integer, datetime) from one database from another database, but the locales are different and I get an error-message.: 'SQL Error (-23197) : Database locale information mismatch.' How can I get my information correctly?…
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…
WGS 7.30TC7 (not) running on NT4 SP4
We have Problems to run 7.30 TC7 on a brand-new installed PC with NT4 SP4 (German Version). Either the Database can't get started in any way (Problems in creating the sysmaster-Database) or the Database crashes after a Reboot. We tried to install as Local-Administrator and as Do…
Centura in combination with Informix
Hallo, I have two questions about Informix - Centura : 1. Centura � Informix On SAM_AppStartup : Connect Sql-handle to local database Informix Dynamic Server Version 7.30.UC3 on Unix Release 5.44 Version C1012. When I need a patient-ID, I have to connect a second Sql-handle…
Centura - Informix
Hallo, I have two questions about Informix - Centura : 1. Centura � Informix On SAM_AppStartup : Connect Sql-handle to local database Informix Dynamic Server Version 7.30.UC3 on Unix Release 5.44 Version C1012. When I need a patient-ID, I have to connect a second Sql-handle…
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…
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…
Unable to load locale categories
Hi, I am getting an error when using the Informix ODBC drives to connect to my server using RDS. The error says "Unable to load locale categories". I am able to access the database using ADO. Thanks, Abe…
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…
UTC, time zone support for datetimes
After digging through the documentation, I was surprised to find no support for times zones in datetime data. For example, if I run: insert into mytable (when) values (current year to secord) I get the local time with no mention of time zone. So comparing values in mytable.wh…
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…
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…
Error -23101: Unable to load locale categories
I'm developing CGI/C scripts using Apache 1.3, Informix 7.2.4 and Linux 5.3. The scripts run well from the command line(!), but when i connect from Apache CGI : Error -23101 occurs: "An invalid locale name has been supplied for the locale initialization. The environment variable…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
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…
Re: Problems retrieving informix value fields through ODBC
>We have a software developed with Oracle Pro*C accessing data via Oracle >OCA >(Open Client Adapter) and ODBC to access Informix databases. > >All is fine except when we try to retrieve data form varchar and >smallint informix fields. In this situation we get the correct value +…
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…
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
Steven Primrose-Smith wrote: > > Hi, > > After struggling for an afternoon trying to get blobs into an Informix > database > via perl and DBI, without any Informix-specific docs, I wondered is there a > data type that supports strings longer than 256 chars without resorting to > …
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: Str Function
What if I need to do something like: select * from tableA where numeric_column[1,2]="15" without using a cursor. Jos� Miguel. Art S. Kagel wrote: > Jos� Miguel Giraldez R. wrote: > > > > Hi all: > > Would you be kindly to help this newbie to find the informix function, tha…
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 …
Access local database using INET
Is there a way to simulate I-NET access to a local database? Our LIVE environment comprises of two HP-UX, ie. one running Informix Online 5.0 and the other as the client running the Relay Module (Inet). However, we only have 1 HP-UX for development which is also serving the dat…
Re: Loading BYTE data types from DBACCESS?
Fred Prose wrote: > > I need to populate a table that will contain BYTE data types (employee > information and badge pictures). The character data is in delimited files > and the pictures are JPG images and both are available on my server. Is > there a way to accomplish this th…
Loading BYTE data types from DBACCESS?
I need to populate a table that will contain BYTE data types (employee information and badge pictures). The character data is in delimited files and the pictures are JPG images and both are available on my server. Is there a way to accomplish this through DBACCESS. I don't hav…
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…
Re: Informix column change column type from char to int
To put it simply: if there are only numerics in this field now, then ALTER TABLE will work just fine. If it finds any non-numerics then it will fail. In article <3639d910.0@news.one.net>, "Thomas J. Girsch" <tgirsch@iname.com> wrote: > You would need to run appropriate UPDAT…
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…
Re: Informix column change column type from char to int
You would need to run appropriate UPDATE statements to get rid of the alpha characters in that column before running the ALTER TABLE. Once you've eliminated all alpha characters, the ALTER TABLE will work. By itself, you can't do an ALTER TABLE from alpha to int if there are no…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
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…
Re: blanks in LOAD-file
Mark D. Stock wrote: > > ProzessDV wrote: > > > > I want to migrate from a DDB/4 database to OWS 7.22 on SCO 5.0.4. > > Unfortunately, when I use LOAD to insert data into the tables LOAD pads > > char-columns with blanks. Does anybody know how to suppress this filling with > > bl…
Re: blanks in LOAD-file
ProzessDV wrote: > > I want to migrate from a DDB/4 database to OWS 7.22 on SCO 5.0.4. > Unfortunately, when I use LOAD to insert data into the tables LOAD pads > char-columns with blanks. Does anybody know how to suppress this filling with > blanks? > > Thanks in advance for you…
Re: blanks in LOAD-file
ProzessDV wrote: > > I want to migrate from a DDB/4 database to OWS 7.22 on SCO 5.0.4. > Unfortunately, when I use LOAD to insert data into the tables LOAD pads > char-columns with blanks. Does anybody know how to suppress this filling with > blanks? There is no point, a CHAR or…
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 …
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…
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: database locale
MARTIN wrote in message <359992BD.7C0A0A7B@arrakis.es>... >I think that you can do by update tables with tabid 90 and 91 , but i >think this is very dangerous > >Rein Puksand wrote: >> >> Hi! >> >> Is there a way to change database locale without creating new database. >> >> Rein…
Re: database locale
I think that you can do by update tables with tabid 90 and 91 , but i think this is very dangerous Rein Puksand wrote: > > Hi! > > Is there a way to change database locale without creating new database. > > Rein Puksand > rpuksand@epbe.ee -- ____________________________________…
database locale
Hi! Is there a way to change database locale without creating new database. Rein Puksand rpuksand@epbe.ee…
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: Error -451 on unload statement
Hi Philippe, I think you hit bug 57342. You probably have unprintable characters in the text field. You can: - ensure that your text field does not have unprintable characters (we encountered this problem having null characters stored in a text field); - change the data type of…
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…
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…
Re: Local Database and $DBPATH
Richard Spitz wrote: > > Hi Informixers, > > how can I influence the way the DBPATH environment variable is evaluated > for database access? > > We are currently running Online/Star and SE/Net 5.10 concurrently on Please ignore my response as non-responsive. I misread the posti…
Re: Local Database and $DBPATH
Richard Spitz wrote: > > Hi Informixers, > > how can I influence the way the DBPATH environment variable is evaluated > for database access? > > We are currently running Online/Star and SE/Net 5.10 concurrently on > the same machine. I know that the SQLEXEC variable will determin…
Local Database and $DBPATH
Hi Informixers, how can I influence the way the DBPATH environment variable is evaluated for database access? We are currently running Online/Star and SE/Net 5.10 concurrently on the same machine. I know that the SQLEXEC variable will determine whether the Online or SE backend …
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: +…
Re: ODBC and binary data in character sql type
Hi! There are three problems you need to take care of: - How the ESQL/C API interprets your string with embedded ASCII NULLs. - The ODBC driver (have we seen THIS one before!!) - How a strings with embedded ASCII NULLs are stored. In ESQL/C a string of the type char or stri…
Re: Change Database Locale
> I have the same problem. > > the only way is export the database without set dblocale and clientlocale. > (if the actual locale is the default (en_us.819 or 8859-1 is the same). > Then set the clientlocale='en_us.819 and dblocale='new locale'.(or the > reverse? I don't remembe…
Re: Change Database Locale
You have to use dbexport or onunload to export the data. Then set your new locale and import the data again with dbimport or onload respectively. On Mon, 11 May 1998 18:48:39 +0200, Daniela Lemm <lemm.cgn@sni.de> wrote: >Hey, > >we are working with Informix 7.22. My Problem is …
Re: TO_CHAR informix-equivalent
javier mugueta unzu� wrote: > > There is an informix conversion function from numeric to character type Informix automatically converts from most data types to most others as long as the source and target types and the contained data are compatible (ie char and date are compatib…
Re: Change Database Locale
This is a multi-part message in MIME format. --------------6F3EBD43D5BB1567C47F1F57 Content-Type: text/plain; charset=iso-8859-1 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Content-Transfer-Encoding: 8bit The official way is to dbexport the datab…
Change Database Locale
This is a multi-part message in MIME format. --------------A4B695DBEB3F79AD16ABFB0C Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hey, we are working with Informix 7.22. My Problem is that the Locale of the Database is incorrect and I have to change…
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…
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: 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…
Case Insensitive Searches
We're trying to figure out how to make our Informix 7.22 database case insensitive when it comes to searching. I've read in the manual about the Collation Order either using the Code-Set Order or Localized Order, and if the Localized Order isn't specified, then the database defa…
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…
OWS: CLIENT LOCALE error
Hi, I got this error message when I in the command center, I select the one of the oline database server . Error message : Unable to connect to server ol_hpirpa because the server locale could not be converted to the client locale. Change the CLIENT_LOCALE environment varia…
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: Connecting to multiple databases (one local, one remote
Alan, We need to use a parameter in the informix.ini file mcblockmode=2 otherwise we get a similar error. Regards David Ashby ______________________________ Reply Separator _________________________________ Hello, We are trying to connect to 2 dat…
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…
Connecting to multiple databases (one local, one remote in New Era)
Hello, We are trying to connect to 2 databases: + 1 on the local database + 1 on a remote UNIX database Both databases are Informix. Connecting to 2 databases on the remote server causes no problems. Connecting to the local database or the remote database cause no problems ei…
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: Character Sets
Your solution lies in GLS (Global Language Support). This is available on the HP 7.23 db, not on NCR. At the 7.14 timeframe they called it NLS (National Language Support) which worked somewhat differently. Simply go to your manual store to find the GLS manual or go to http://www.…
Character Sets
Dear All, I have a problem: We have an insert statement that includes the character hex A9. The statement works on NCR running 7.14, but on HP running 7.23 we get an -202 error. The column to contain the value is type varcher(255). The insert statement is executed from a power…
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…
CLI with IIS
I am trying to use the Internet Database connector delivered with Microsoft's IIS to access my informix database through Informix CLI. I keep getting this error: [State=S1000][Error=-406][INTERSOLV][ODBC Informix driver][Informix]Unable to load locale categories Anyone have an…
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: -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: 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. …
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 …
Error with ODBC drivers 2
Good morning, Thanks to Mario Estrada for his fast answer, but I think it isn't right because I can access the database with local connection (seipcpip) using dbaccess (of the Standard Engine). Thanks, Alberto…
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 …
Re: Using character data types in a sub-query
otto@alldata.com (Doug Otto) wrote: :You may want to put this one in your notes to avoid hair loss: Here goes the null issue again. There is no hair loss whatever over this. See below. ...snip table description... :>SELECT count(*) : FROM table_1 : WHERE table_1.column_1 NOT …
Using character data types in a sub-query
You may want to put this one in your notes to avoid hair loss: ____ table_1 Column name Type Nulls column_1 char(20) yes table_2 Column name Type Nulls column_1 char(20) y…
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: Copying tables
On 4 Aug 97 at 11:11, Kevan wrote: > We currently have a system that involves two Informix databases, a > local Online 7 database and a remote Online 5 database. Because of > this remote connection we want to periodically take copies of > certain highly accessed tables on the r…
Finding DB_LOCALE of database
Hi, Within an ESQL/C client application, I would like to find the setting of the database locale stored in the system catalog of the database that my application has attached to. Does anyone know how I could do that? Your help is greatly appreciated. Vinhson Email: nguyenv@cog…
Re: Retrieving into char variable
Jacob Salomon wrote: > > Lee Wan Ling wrote: > > > > Hi there, > > I defined a host variable of type array of characters and > The STRING data type ... holds character data that *is* null terminated > and does not contain trailing blanks. > --- > > I have not tried this out…
Re: Retrieving into char variable
Lee Wan Ling wrote: > > Hi there, > I defined a host variable of type array of characters and > retrieved data of type varchar into it. The resultant data is padded > with blanks. > Does anyone knows how I can get INFORMIX to not do so by default? Well, we already know they…
Retrieving into char variable
Hi there, I defined a host variable of type array of characters and retrieved data of type varchar into it. The resultant data is padded with blanks. Does anyone knows how I can get INFORMIX to not do so by default? Regards, Wan-Ling…
RE: !HELP! Arabic characters - PB5.0, OnLine 7.20UC2, dbacc
On 17 Jul 97 at 0:39, Mr. Munaf A.Razzak wrote: > If I have understood correctly, data that is stored in Online comes > back on to a screen using PB which is fine, but the data retrieved > in dbaccess is junk. Not entirely. We can not use arabic characters in SQL statements - w…
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: Product Announcement: Free GUI DBA Tools
> Product Announcement: GUI Database Administration Tools, ROM 2.1. I use Informix-OnLine 7.12 with NLS capabilities. ROM works fine with C-localized databases, but when I tried to access 866-localized DB I got: Unable to locate the locale or conversion file "PC866" Please…
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…
Re: What is max. column name size?
> > Greetings everyone, > > I've got a couple really basic questions about Informix that I'd like to > know for comparison with Oracle and DB2. Thanks in advance for your > consideration. > > 1. When naming columns: > > A. How long can names be? 18 is ANSI standard 18 for …
Re: What is max. column name size?
Depends on what version you are using! Look in the Informix manuals. Michael Burr wrote: > > Greetings everyone, > > I've got a couple really basic questions about Informix that I'd like to > know for comparison with Oracle and DB2. Thanks in advance for your > consideration. >…
What is max. column name size?
Greetings everyone, I've got a couple really basic questions about Informix that I'd like to know for comparison with Oracle and DB2. Thanks in advance for your consideration. 1. When naming columns: A. How long can names be? B. What characters can be used (any spec…
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: 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…
Re: binary large object (BLOB) types
Vincent J. Buonassisi wrote: > > hi, > > i would like to know how a BLOB type field is sized in a table. does > informix have a default size, e.g., field width is initially 256 bytes > and is kept in memory? if the size of the data being stored is greater > than 256 does the da…
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…
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 …
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: Question regarding moving a database
Informix-List wrote: > >> A software package I support uses Informix Online as it DBMS engine. We > >> often need to bring back customer databases to the lab to recreate and > >> debug problems. > > >> Our software as it is currently written prohibits the use…
=?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: 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: Inserting NULL values into a column of type TEXT?
Jason Bodnar wrote: > > I'm trying to insert a NULL value into a column of type TEXT but am > getting the following error: > > 617: A blob data type must be supplied within this context. > Error in line 1 > Near character position 528 Jason, while I'm sure there is a way to use…
Inserting NULL values into a column of type TEXT?
I'm trying to insert a NULL value into a column of type TEXT but am getting the following error: 617: A blob data type must be supplied within this context. Error in line 1 Near character position 528 Here's the INSERT statement (trimmed for brevity): INSERT INTO current (titl…
Re: HELP: Informix 5, Varchar / Char types / Powerbuilder 4
This sounds more like you have used dbaccess/isql to write an SQL statement with a long literal string. There is a maximum of 255 characters for such strings. I don't know for sure, but I think this limit applies to ESQL/C and 4GL as well. The solution is to use a variable in som…
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: Informix 5, Varchar / Char types / Powerbuilder 4
Hans Nieuwenburg wrote: > > The Informix 5 varchar type can onle be 255 characters long while the char > type can be mutch longer. In a database we first had a vanchar field and > converted that to char to enlarge the field to 4096, somehow the database > comes back with an error…
Local database, Oracle server, Supercard and forms
HI, I am working on a project called PREDICT (Petroleum Ressource Evaluation, Data, Information, Concepts and Templates). The project was already partly developped when I arrived, using a Mac, Allegiant SuperCard and oracle 5 local database system stack 1.2 for hyperCard 1.5. Bec…
reading timestamp from audit trail files
Informix's Techinfo document #782 describes the format of the audit trail header as follows: Byte Data Type Values stored ----------------------------------------------------------------------- 1 -2 character aa - f…
Re: Foreign language support in Informix Online
> Is it possible to develope a "Chinese" database application using > Informix Online running in a Unix environment? Only the input screen > and printed report has to be in Chinese. How about using a front-end > tool that can support foreign languages? However some fields in the …
re: TEXT or BYTE
I'd like to try to clear up some confusion about the use of TEXT and locales. See comments enclosed in ">>>>>>" characters within the attached email. DAM Principal Tech Writer SCT Tech Pubs >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> >> TEXT data type …
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: User interface to access C-ISAM files
> dany@qc.bell.ca (Dany Ruel) writes: > Everybody knows if a user interface exists to view the records > in a C-ISAM file? 1. If you have only character data (unlikely, but...) use cat or more. 2. You may use hd to dump the file. Also not good, but usefull sumtimes. 3. You mi…
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
I havent seen a proper answer to this problem: > In article <441ek8$r7s@cssun.mathcs.emory.edu>, > Ward Kaatz <wardk@fourgen.com> wrote: > >At 02:31 9.22.95 GMT, Tammy Croteau wrote: > >}In a table I have the following data: > >}AGCR > >}AGST > >}ALAR > >}ANGE > >}AVSA…
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 …
New Era Question ?
Anyone know whether New Era , using ODBC connectivity, can access more than 1 database ? We wish to compare data in the Informix database to a local PC database and depending on what New Era uncovers, write back to one or both databases Anyone have any thoughts on this ?…
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: Datetime question
If you care about things like daylight savings time and timezone conversions, then the best thing to do is store datetimes using UTC (also known as GMT). Applications can convert between UTC and local time as needed. It would be nice if the database server would handle local tim…
Re: Data Modeling Problem
In article <3pqka3$qgp@tribune.usask.ca> Viswanath_Aiyah@engr.usask.ca (Viswanath Aiyah) writes: >From: Viswanath_Aiyah@engr.usask.ca (Viswanath Aiyah) >Subject: Data Modeling Problem >Date: 22 May 1995 18:14:27 GMT >Hello: > > Presently, the primary key of the root devic…
Re: How to store non-printable characters ?
Carlos Palma <cap@smd.pt> wrote: > > I've posted before one article similar to this, but as no answer came > by (except one sugestion concerning escapes, which didn't work) I'm > reposting it with another 'look': > > Anyone know what datatype should have a column that is intended…
Re: How to store non-printable characters ?
Carlos, It sounds like what you need is a text data type, which is a "blob" - for which you need the OnLine engine. This is an expensive option if you do not already have it. Regards, Pete Harris On 18 Apr 1995, Carlos Palma wrote: } I've posted before one article similar to t…
Re: Data Format Brainstorm!!
In article <cacclin.789345630@vanbc>, cacclin@vanbc.wimsey.com (Stephen Cacclin) writes: : I am looking for some helpful input from the various comp.* communities. : : Basically I want to know how various databases, languages, protocols etc. : store different data types. In other…
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: I-STAR Questions
hth (hhong@nova.umd.edu) wrote: : my application needs to access another Informix database on : different machine (called it A), machine A already had I-STAR installed, : while still be able to access the local database. My though is that : (it might be wrong), since this is a o…
Remote database problem
Hi Informixers, I am having problems changing from a local OnLine database ("local") to a remote database ("foreign@remote") from within 4GL RDS, but the same program when run from DBACCESS works perfectly without error. Here is the sql script: database local; close database;…
Printing Floating Decimal numbers
We store numeric data in a floating decimal point numeric column: DECIMAL(8) We can unload the data and it unloads fine: 123.456 or 12.345678 or 12345.0 In SQL Query, we can select and display the data as it was typed in, once the environmental variable "DBFLTMASK" is set to "-1…
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…
Re: Exclude characters
From Joey Duhon: * * >>> REQUEST: in a FORM, is there a way to satisfy the folowing: * >>> * >>> Allow all chars between ' ' (space) to '~' (i.e. printable stuff), * >>> except for the characters '|' (pipe) and '-' (minus). * >>> * >>> I have tried INCLUDE, but it seems this is o…
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: Character to numeric conversion error
vkg1@Ra.MsState.Edu (VINAY GIDWANI) writes: >I am a new user to informix. I was running this program and I get >error No 1213 - Character to numeric conversion error. You don't give the context in which you received the error, but you are most likely either attempting to select…
char database types blanks and nulls
Using Standard Engine This sometimes returns a blank field for the value of column1 $string column1[20]; $declare test_curs cursor for select distinct column1 into $column1 from test_table where column1 is not null; $open test_curs; $fetch test_curs; I know that the informix …
Re: character ----> integer
Quoting Josephine Kwan... > > Is there a function in ACE that converts a character field to an integer > field? Can it be easily done in the ACE Report program without > altering the data type in the database? > What I'd do (and I'm not sure if it would work) is have a dummy INTE…
character ----> integer
Is there a function in ACE that converts a character field to an integer field? Can it be easily done in the ACE Report program without altering the data type in the database? Thankx a bunch! Jo…