Hi, i need to conv from Hex to Integer can this be done using SQL with Informix ?? ie select integer(hex_data_column) from mytable thanks, DSE

darren.edgerton@reece.com.au

01-07-2005 06:54 AM
Martin Fuerderer

Do you have an e-mail address I can contact you offline on ? Dirk Moolman Database and Unix Administrator MXGROUP

Dirk Moolman

01-07-2005 06:31 AM
Dirk Moolman

Does anyone here know of a GOOD suse linux newsgroup / mailing list I can join ? Dirk Moolman Database and Unix Administrator MXGROUP

Dirk Moolman

01-05-2005 02:24 PM
Joerg Volz

We use MS Access 2000, 2002 & 2003 with our IDS 7.3 engine with no issues using Intersolv 3.11 drivers. We have an IDS 9.4 server waiting in the...

Gary Quiring

01-05-2005 11:12 AM
Obnoxio The Chav

--0-2144078626-1104853420=:29671 Content-Type: text/plain; charset=us-ascii I am creating an update statistics script for my server. I believe the...

Floyd Wellershaus

01-04-2005 09:15 PM
Art S. Kagel

forall2see_2000 (AT) yahoo (DOT) com said: It's "you're", not "your", you halfwitted, spamming tosser. What about the capitalization of your first...

Obnoxio The Chav

01-04-2005 01:34 PM
Obnoxio The Chav

my dear friends, i found this awesome website in which you can post screenshots of your computer, everyone's doing it it is awesome!! you can even...

redsheep_pt@yahoo.com

01-03-2005 07:29 PM
Obnoxio The Chav

Hi goup, I need to start administering an Informix database that runs on an AIX server. I've no problem using unix systems (specially linux) but I...

Nuno Paquete

01-03-2005 06:36 PM
Cesae Cruz

Happy New Year! The next Washington (DC) Area IBM-Informix User Group meeting is: Next Quarterly Meeting is: Date: Thursday, January 27,...

Lester Knutsen

01-03-2005 06:17 PM
Richard Kofler

This is all in SPL, Solaris 8, 9.40UC3 select count(*) from table1, table2 where join and datetime between "2004-09-29 09:57:58.00" AND "2004-12-29...

Paul Watson

01-03-2005 11:11 AM
Art S. Kagel

I have to mention that IBM fixed the download for the trial, and I was able to download. .... very impressed with the reponse...

Jean Sagi

01-03-2005 01:50 AM
Jonathan Leffler

I am working on the third edition of SQL FOR SMARTIES. If anyone has an SQL programming technique, trick or tip that they think should be in the...

jcelko212@earthlink.net

01-01-2005 01:49 PM
jcelko212@earthlink.net

I am posting this as a new message as I could not see my original post. I think I know what the prob. was. I used -d option incorrectly. Looks like...

Hari Gupta

01-01-2005 03:01 AM
Hari Gupta

rkusenet wrote: As far as Informix is confirmed, it was all very much "The horse never rode and the bridge never crossed"

superboer

12-31-2004 06:15 PM
John Carlson

Happy New Year! *<:-)

Data Goob

12-31-2004 12:59 PM
Data Goob

Mark Townsend said: People in glass houses, etc. :o) -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule"

Obnoxio The Chav

12-31-2004 04:52 AM
Obnoxio The Chav

what does: let l_dte1 = "2004-09-29 09:57:58.00" let l_dte2 = "2004-12-29 09:57:58.00" select count(*) from table1, table2 where join and datetime...

superboer

12-31-2004 02:42 AM
superboer

Is there anyone on this group that also works with Oracle ? Dirk Moolman Database and Unix Administrator MXGROUP

Dirk Moolman

12-30-2004 11:03 PM
John Carlson

I need to lock a ROW in an Informix table and hold onto that lock until the end of a transaction. During this transaction, 2 seperate Java processes...

BigBob

12-30-2004 05:19 PM
BigBob

I'm helping a group with a database reorganization. System info: 4-way 332 MHz IBM F50, 3GB RAM Local SCSI disks for OS & file system 2 RAID-10...

bothwellno@spam.duke.edu

12-30-2004 04:35 PM
Art S. Kagel

Does anyone have an update on this bug? I'm also seeing this now (IDS 9.40.FC4W4). I tried running update statistics for the procedure (spl_dbinfo)...

Sean Baker

12-30-2004 12:47 PM
Alexey Sonkin

I downloaded the Linux package, IIUG-IDS-9-4-UC2-linux.zip to install on Fedora core. I had no trouble setting the environment, or using cpio or...

Rokken

12-30-2004 07:45 AM
Rokken

Hi, I am a Data Recovery Specialist and Professional Data Recovery Software Developer in New Delhi. I've placed the Complete SOURCE CODE of One of...

Author Tarun Tyagi

12-29-2004 02:35 PM
Author Tarun Tyagi

--0-1812285848-1104274518=:69443 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi, When I running a : dbexport...

Cesae Cruz

12-29-2004 01:32 PM
Art S. Kagel

Hi Friends, I found a new VOIP forum, where there is a good syndication of VOIP technical white papers. It is really worth checking out...

erika_angella@yahoo.com

12-29-2004 09:51 AM
Jean Sagi

Leopold Bloom said: "Bah! Humbug!" is the traditional Christmas greeting here. :o) HDR? In that case, you need to remember that your problematic...

Obnoxio The Chav

12-29-2004 08:12 AM
Obnoxio The Chav

--Concider the following situation: --An application is trying to analyze bank's balance --during the operational day - that is, some records --in...

superboer

12-28-2004 08:26 PM
DA Morgan

rkusenet wrote: It would certainly be my recommendation in Oracle to use Advanced Queuing or Streams. But from my experience FOR UPDATE works in...

PK

12-28-2004 08:15 AM
Serge Rielau

I have been gathering information about this system. At the end really strange things end up not being true. This is another time it happens. Though...

Leopold Bloom

12-28-2004 06:00 AM
Ben Thompson

Hello, I have a question regarding combining queries. We have this CMS (Smartsite) for our website which has a meeting and a calendar module. The...

Marco Hoefman

12-28-2004 05:50 AM
Ben Thompson

Hi all, I was wondering how we can read data from an Informix (IDS) database on another machine. Do I need to metion in the sqlhosts file the other...

Danny De Koster

12-27-2004 02:05 PM
Fernando Ortiz

Folks, I'm trying to do something on IDS9.4 NT (NT4 and W2K) that doesn't seem to be documented anywhere. I'm trying to create database chunks...

joe@lumbley.com

12-25-2004 11:35 PM
John Carlson

Dear All, We have Informix 9.21 running on Solaris and using Java for application development. At present we have our Database as ISO-8859 we are...

kalpana

12-25-2004 08:18 PM
Alexey Sonkin

Hi. I am a DBA who is new to Informix technology. My application produced 5 deadlock situations yesterday. In the /tmp directory I have...

Vedster

12-25-2004 07:48 PM
Alexey Sonkin

Folks, I'm trying to do something on IDS9.4 NT (NT4 and W2K) that doesn't seem to be documented anywhere. I'm trying to create database chunks...

joe@lumbley.com

12-25-2004 07:24 PM
joe@lumbley.com

hi, In simple words 'How to view / Read the various elements values in a structure at a particular point of my DRV ?' The Story is ->>>> i am using...

bluekarthik@yahoo.com

12-25-2004 08:31 AM
bluekarthik@yahoo.com

IIUG Insider (Issue #54) December 2004 Highlights: Editorials, sponsorship programs, & More... Online at...

emailer@iiug.org

12-24-2004 05:15 PM
emailer@iiug.org

We are scheduled to have our IT systems audited next month by Deloitte Touche Tohmatsu. I would really like to get a copy of their security check...

Andy

12-24-2004 03:29 AM
Pero

We currently are running Solaris 8 with IDS9.21UC2. We have filled our disks and need to add external drives with new controllers. Unfortunately...

Bob Bankay

12-23-2004 02:01 PM
Obnoxio The Chav

Hello, I'm having a hard time coming up with an SQL statement that returns just orphan records. Here's what I've got (don't worry too much about the...

William Fields

12-23-2004 01:47 PM
Art S. Kagel

Hi folks, before I spend some time maybe re-inventing the wheel, does anyone have some C source for functions that manipulate BLOBs from 4GL? We're...

Andrew Hamm

12-23-2004 12:41 PM
Pero

I have a vendor supplied application. The images (JPG format) are stored in a byte field within IDS 9.4 database. I need to download these images...

Rajesh Kapur

12-23-2004 12:34 PM
Pero

Hello, We are having some problems with an Informix database and, as I´m pretty new to this environment, would appreciate any help. We have an...

Leopold Bloom

12-23-2004 11:36 AM
Bobb

Hi, Can someone tell me why when I compile the loselect.c (delivered with the ClientSDK) with Micorsoft Visual Studio 6 or Borland's C++ Builder 5...

Bart Huls

12-23-2004 10:40 AM
Bart Huls

Hi Everyone, IDS: Version 9.30.UC2X7 SuSe Linux 2.4.21 We received the following error messages in our log file: 12:26:42 Logical Log 11992...

Heinz Weitkamp

12-22-2004 10:02 AM
Brice

"Art S. Kagel" <kagel (AT) bloomberg (DOT) net> schreef in bericht news:41c8ac1e$0$17969$afc38c87@... Thanks to all DeeWee

DeeWee

12-22-2004 03:39 AM
Simmons, Keith

Fernandez DO NOT post HTML DO NOT DO NOT put Informix data on Raid 5 DO NOT Engine? O/S? Processors? Memory? Data Set Size? No of Concurrent...

Simmons, Keith

12-21-2004 01:36 PM
Art S. Kagel

I have finally gotten the trial version of IDS 9.4 running. I can access the stores database using ODBC and Delphi. But when I transfer the test...

dlgllhn@inhisstepssoftware.com

12-21-2004 01:26 PM
Art S. Kagel

Gustavo Tobares wrote: PLEASE do not post MIME. It more than triples the bandwidth required to download and store your posting. Don't need to. ...

Art S. Kagel

12-21-2004 01:11 PM
Obnoxio The Chav

Hi, generally I recommend a newer release of 9.40 (i.e. 9.40.xC4 or the current 9.40.xC5) rather than any 9.30 release. These 9.40 releases all...

Martin Fuerderer

12-21-2004 07:49 AM
Bill Dare