Download Latest Version tpc-c-ifmx.tar.gz (392.7 kB)
Email in envelope

Get an email when there's a new version of IIUG Software Repository

Home / StoredProcedures / upper_spl
Name Modified Size InfoDownloads / Week
Parent folder
readme.txt 2020-05-11 870 Bytes
upper_spl.sql 2020-05-11 8.2 kB
Totals: 2 Items   9.1 kB 0
Subject: SQL/INFORMIX (UPPER)
Newsgroups: comp.databases.informix


From: "Mark D. Stock" <marks@west.co.za>
Date: Thu, 17 Apr 1997 17:06:38 +0200

> My request is :
> SELECT ROWID FROM EMP WHERE UPPER(FIRST_NAME)=UPPER('Tyler')
> UPPER is a ORACLE/SQL+ function.
> INFORMIX error is :
>  674: Procedure (upper) not found.
>  111: ISAM error:  no record found.
> Can you tell if UPPER or same function exist on INFORMIX.

You need to create the upper function like so:

Example of usage:
  select * from sometable where upper(name) = "NAOMI"
----------------------------------------------------------------------
John H. Frantz           Power-4gl: Extending Informix-4gl
frantz@centrum.is        http://www.rl.is/~john/pow4gl.html

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet
Source: readme.txt, updated 2020-05-11