Email Alerts
-
SQL view that SELECTS on functions
This user was having an issue with his SQL view on his iSeries that SELECTS on a few functions. Db2 Expert Kent Milligan explained what was going on. Ask the Expert
-
Scheduling a SQL update statement
One user writes, "I need to run a SQL Update statement after hours, and it would be nice to schedule it. I saw your posting about the RUNSQLSTM command, but I've had no success with it. I tried saving my command in the STRSQL run, which it saved to a... Ask the Expert
-
Error message of null values
One user wrties, "In V5R3 I got the error message of null values not allowed in column or variable ZORD#T for SQL update." DB2 expert Kent Milligan offers some advice. Ask the Expert
-
Import a text file to a DB2 table
One user writes, "I need to "import" a text file located in the user computer to a DB2 table in the database, what's the best way to do this?" DB2 expert Kent Milligan offers some advice. Ask the Expert
-
Recommended index not used
One user writes, "Using SQL performance monitor of Operation Navigator, an index was recommended. I created the recommended index, but it looks like the system doesn't use it. I find it strange that the index is recommended and then not used. Is thi... Ask the Expert
-
SQL statement help needed
This user had a few questions regarding SQL statements. DB2 UDB expert Kent Milligan was on hand to help him out. Ask the Expert
-
Connecting WebSphere to a DB2 database
One user writes, "How can I connect WebSphere on my iSeries to a DB2 database on an AIX machine? We've tried a number of different methods configuring JDBC drivers, but nothing seems to work." Web development expert Jim Mason offered some advice. Ask the Expert
-
BETWEEN clause -- faster or slower SQL Performance?
Ask the Expert
-
PTF causing delays
Ask the Expert
-
Extracting data from Oracle database
Ask the Expert