Is this really NOT a feat

To: weller@zorro.cecer.army.mil who wrote: BW> I have been trying to do a join on two tables which I did not create. The > tables contain lists of chemical names. I want find the names which match > both tables and update a field in one table from matching data from the other > table. Following me so far. One of the tables has its chemical names all in > upper case. The other table has the names in both lower and upper case. BW> The problem is that Informix does not seem to have the ignore case feature? If you're using 4GL, you can get around this by using UPSHIFT(). BW> Is this really true or was the guy at technical support wrong? I can not Tech support are never wrong:) > believe this feature does not exist. IMHO, this is a very important feature > that should come as a basic package. It's like buying a car and finding out > it does not come with windshield wipers. And to put them on would be time > consuming and costly. I'm not sure about this. I've been an Informix user for 10 years now, and *I've* never missed it! BW> As a new user to Informix, could someone tell me what other basic features > does this software lack? Are there other glaring limitations with Informix. You sound pretty militant. Well, you would, coming from the miltary:) What database were you using before. What do you consider a "basic feature"? BW> I have the SQL ver. 4.1.1, SE ver. 5.01. It runs on a sparc10. BW> Does anyone have a solution to my problem of joining these two fields. > Altering the original data is out of the question as the lists are hundred ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Not at all! A simple 4GL program will do it for you: DECLARE get_chem CURSOR FOR SELECT * FROM table_nameFOR UPDATE FOREACH get_chem INTO p_table_name.* LET p_table_name.field_name = UPSHIFT(p_table_name.field_name) UPDATE table_name SET field_name = p_table_name.field_name WHERE CURRENT OF get_chem END FOREACH Anyway, IMHO it's not good to have different data in the fields joining two tables and relying on the engine to sort it out. Bad for performance, you know! :) Hope this helps. billy.wheeler@digitec.co.za --- . SPEED 1.40 [NR] . . <-- Grain of Salt. Take as needed with above advice ---- Digitec Online - 20 Nodes * Johannesburg, South Africa +27-11-476-2008 * Best BBS * Best Sysop * @digitec.co.za * RsaNET User Choice Awards 1993 *