Convert table entry from text to numeric
I have generated a table that has a 4 char text field. I want add a column and convert this text field that is numbers to numeric so that both coexist.
View Answer
| Aug 11 2008 12:10 AM GMT
| asked by
LHammer
Query Management Facility
How to restrict QMF to execute predefined queries only?
Hi, is there a way to restrict the usage of QMF/390 to predefined queries/procedures only? Some users should not be able to edit or create SQL statements on their own.Thank you very much.RegardsMichael
View Answer
| Jul 25 2008 8:01 AM GMT
| asked by
Meichhar
QMF, Query Management Facility, DB2
QMF issue
I have my QMF for windows version 8.1 Fix Pack 13, and I try to run this instructionINSERT INTO destination table SELECT * FROM origin tableand every time I receive this error message:An error occurred while running the query. destrination table not valid for operation.(SQL code = -7008, SQL...
Answer Question
| Jun 2 2008 9:28 PM GMT
| asked by
Tiburonblanco
SQL, QMF, Query Management Facility
Unloading specific records in a foreign key, cascade format.
Hi,We have DB2 version 8, os/390. I know how to use QMF and JCL.I would like to unload, to files, specific records that I would enter, by the key, in a where clause. The record would then cascade down to unload ALL tables, with a specified TBCREATOR name based on foreign keys. I would like the...
View Answer
| May 13 2008 6:33 PM GMT
| asked by
Donnaw
DB2 Administration, OS/390, DB2
