Recent IT Questions

1 - 4 of 4
<<PREVIOUS 1 NEXT>>

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


1 - 4 of 4
<<PREVIOUS 1 NEXT>>