Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: PatrickP61
- Order by date
-
Hi all- I have couple of questio
Man72 Try this: 1. Write a query that retrieves all the table names. 2. Export that data list into a file. 3. Create a query that grants the authority you want based on a variable tablename. 4. Edit the data list from #2 in such a way to call #3 query. 5. Import the data list into a...- PatrickP61
- Post #2
- Forum: IBM: DB2
-
Cannot find row on Table
db2dude, I had the same problem and found out that the value of certain rows were in different case (upper or lower) than my query. In QMF, the default setting is to change all lower case to uppercase before submitting the query. So while your query in QMF may seem to be identical to COBOL...- PatrickP61
- Post #4
- Forum: IBM: DB2
-
QMF prompted input carried over multiple queries
Hi Scott, You have two options: The easiest is the GLOBAL option. ADV: Easiest to program DIS: Once the globals are set, they remain in effect until the session ends. You can solve this by imbedding the RESET GLOBAL ALL at the end of the proc. __________________________________...- PatrickP61
- Post #3
- Forum: IBM: DB2
