 |
| ADVICE: |
| >> |
Scheduling a SQL update statement
ASK THE EXPERTS :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 ... |
| >> |
Recommended index not used
ASK THE EXPERTS :Using SQL performance monitor of Operation Navigator, an index was recommended. I created the recommended index, but it looks ... |
| >> |
Import a text file to a DB2 table
ASK THE EXPERTS :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? |
| >> |
BETWEEN clause -- faster or slower SQL Performance?
ASK THE EXPERTS :My experienced mainframe DB2 colleagues have warned me that coding the predicate "WHERE part_no IS BETWEEN :foo AND :bar" is ... |
| >> |
PTF causing delays
ASK THE EXPERTS :We have an RPG SQL program that suddenly changed processing time. Before the group PTF we installed on February 19 this job ... |
| >> |
Creating SQL views
ASK THE EXPERTS :
Is there a way to create a SQL view where fields are dynamically obtained each time the View is used. I am trying to ... |
| >> |
Calling an RPG LE program from a SQL trigger procedure
ASK THE EXPERTS :
Is it possible to call an RPG LE program from SQL trigger procedure? Sample of SQL trigger:
Create trigger ... |
| >> |
Using RUNSQLSTM in a CL program
ASK THE EXPERTS :
I'm just learning how to use RUNSQLSTM in a CL program. In my SQL source member I'm trying to INSERT into a file using a ... |
| >> |
Removing stored procedures
ASK THE EXPERTS :How can I remove some of the stored procedures on my iSeries? |
| >> |
Viewing your DB2 log
ASK THE EXPERTS :How can I turn on and view the log in our DB2 system? With the log on I start a task from the Web client, which calls iSeries ... |
