Tip Bank

Question: How do I concatenate a value in Stored Procedures (e.g., select * from mytable, where mytable.field1 = field that I concatenate)? Answer: If you want to match field1 to

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

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

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

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

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);};

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

Using the SQL-DMO object model you can programmatically start, stop, pause, and continue the main SQL Server service. In the following code snippet the server is “MyServer”, and “sa” /

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