devxlogo

Tip Bank

ESQL/C (9.2) UC3 Errors

Question: I have installed the version 9.2 of ESQLC, and when I try to run the program in the following manner: esql -e crdb.ec cc -c -I/home/informix/incl/esql crdb.c cc -ocrdb7.exe

Informix Data Types for Linking Images

Question: Does Informix have a data type similiar to SQL Server’s image or ntext to input paths to link images? Answer: I’d use a CHAR(25) or a VARCHAR field for

Percent Sign in SQL

Question: I have a table in which the key field has a value stored with a percent sign, like ‘1234%’.Using this value, I want to select from another table that

WAP IP Address

Question: Does WAP have a concept of IP address? Answer: You can get the gateway IP address and the terminal IP address using HTTP headers. WAP 1.1 currently has no

Constructors – Derived to Base

Question: My base class contains this constructor: class Parent { Parent(int a, int b, char* c);}; My derived class contains this constructor: class Child : public Parent { Child(int a);};

Manual Redirection of URL

Instead of using a META tag to re-direct a URL, simply place this code in place of the old page and a visitor will instantly be taken there. This piece

Listing all available SQL Server

Thanks to the SQL-DMO object model, it’s very easy to list all the available SQL Server 7.0 installations. For example, this code loads all the SQL Servers registered on the