devxlogo

The Latest

Running an EXE Using a Trigger

Question: I want to run an .exe using a trigger. Is there any stored procedure for running an .exe? For example, I want to run Notepad. Answer: The stored procedure

Informix Ontape Backups

Question: I need to do an ontape Level 0 backup but I need to bypass the “Press Enter to Continue.” Simply put, I want to type “Ontape -s -L 0”

Looking for Informix Server Sites

Question: I am trying to learn Informix. I have been developing Informix code to produce HTML files—effectively using Informix as a CGI. I want to do the following: Find someone

Informix SQL

Question: Are Transact SQL stored procedures currently running on a SQL Server 7.0 database compatible with a Informix database? Answer: No, you’ll have to translate them into Informix’s stored procedure

Log Error

Question: I am receiving this error in my log: connections rejected: no calls allowed for sqlexec.listener-thread err: = -27002 oserr: = 0errstr = : No connections allowed in Dynamic server

Use printStackTrace() method to generate stack

Stack trace is a kind of call stack, which maintains the call sequence of methods at any given point in time. Throwable class in Java provides a method called “printStackTrace()”

Use Of ‘Connect By’ clause for Hierarchal Query

The Connect By clause is useful for tables which have 2 or more columns with parent-child relationships. While displaying rows, we can use ‘LEVEL’ pseudo column to indent the results

Passing Objects in a Function

In Java, objects are passed to a function by reference, so you can manipulate the object data in the function and have that reflected outside the function also. If you

All the Changes, All the Time: Part I

his 10-Minute Solution was prompted by a question to the Ask the SQL Pro site regarding how best to capture changes that have occurred in a database. I will address

Paranoid and Proud of It: Planning Your Backups

n my first article on this subject, I discussed the need to have a healthy dose of paranoia when planning how to protect your systems and information. I also demonstrated

New PL/SQL Features in Oracle 8i: Part II

n my last article, “New PL/SQL Features in Oracle 8i: Part I“, I described some of the new features in Oracle 8i that extend the power, performance, and flexibility of

Surviving the Web Shift

he Web has changed software development forever, and it doesn’t take a prophet to know that this trend will continue. Even now, client/server and object-oriented programmers are tripping over basic

Interspersed Code and Declarations

The two previous tips discussed new features that were added to C99, and which C++ doesn’t support. This time I would like to present one of the changes that were

Reading a String from a File

classes overload the operators >> for reading from a file and word) // as long as sizeof hasn’t been reached { vs.push_back(word); //copy word to vector }} Related Posts Fei-Fei

Factorial Function

One of the classic examples of using recursion is calculating a factorial of a number. Here’s a typical implementation of this function: int factorial (int num){ if (num==1) return 1;

Variable Length Arrays

In C89 and C++, array dimensions must be declared using integer constant expressions. This allows the compiler to compute the array’s size at compile time. In C99, this rule was

Old-style Function Declarations

In earlier stages of C, function declarations looked like this: int func() /*no parameters inside parentheses*/int a,b; /*instead, parameters were declared here*/float f; /*another parameter*/{/* Related Posts Using sys.dm_db_index_physical_statsShield AI

Rebooting with NT’s Schedule Services

Question: How can I schedule an automatic reboot? I have the schedule service started and set up to start automatically, and I know how to dothe “at” commands. What I

Printer Error Message

Question: How do I fix the “a file xxxx.4gl cannot be written to” error, which occurs when I try toprint a document? Answer: Sorry, but I’m not a 4gl person.

Development Tools Windows 2000 Compliant?

Question: Our shop develops apps with VB 5.0 and 6.0. Are either of these versions of VBWindows 2000 compliant/compatible? Answer: Yes, they are. I have done a considerable bit of

Use Copy Web to Deploy a Web Application

Instead of copying all the files manually you can use the Copy Web Application feature in Visual InterDev 6.0 to easily move your Web application from one server to another.

Overloading Methods

Suppose you are writing a method in a class that accepts a parameter of a given type. Such a method can also be called with an argument of a different