This page (revision-12) was last changed on 26-Nov-2021 10:22 by kparrott

This page was created on 26-Nov-2021 10:22 by UnknownAuthor

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
12 26-Nov-2021 10:22 1 KB kparrott to previous
11 26-Nov-2021 10:22 1 KB kparrott to previous | to last
10 26-Nov-2021 10:22 1 KB kparrott to previous | to last
9 26-Nov-2021 10:22 1 KB kparrott to previous | to last
8 26-Nov-2021 10:22 704 bytes kparrott to previous | to last
7 26-Nov-2021 10:22 702 bytes kparrott to previous | to last
6 26-Nov-2021 10:22 703 bytes kparrott to previous | to last
5 26-Nov-2021 10:22 638 bytes kparrott to previous | to last
4 26-Nov-2021 10:22 687 bytes JMyers to previous | to last
3 26-Nov-2021 10:22 714 bytes JMyers to previous | to last
2 26-Nov-2021 10:22 547 bytes JMyers to previous | to last
1 26-Nov-2021 10:22 46 bytes UnknownAuthor to last

Page References

Incoming links Outgoing links
IMSQR
IMSQR

Version management

Difference between version and

At line 4 changed one line
The Show Query Results (IMSQR) allows you to run SQL queries (SELECTs) from inside the application, with out the need for a separate tool.
The Show Query Results (IMSQR) allows you to run SQL queries (SELECTs) from inside the application, without the need for a separate tool.
At line 6 changed one line
Data for the 'Show Query Results' screen is maintained on the [P2K_AM_CUSTOM_TABLES] and [P2K_AM_SQUERY_RESULTS] tables.
Data for the 'Show Query Results' screen is maintained on the [P2K_AM_CUSTOM_TABLES] and P2K_AM_SQUERY_RESULTS tables.
At line 10 changed 2 lines
;[Query Name|]:
;[Query Text|]:
;[Query Name|]: A user defined name given to the Query being done
;[Query Text|]:The Query Text box must begin with the word SELECT in upper case and will execute as soon as you change the focus out of the Query Text box to any other box on the screen.
At line 13 added 8 lines
;:2 examples of Query Texts are:
*SELECT * from all_directories - this will provide a list of all OUTPUT directories that are available in this db instance.
*SELECT job,what,broken from user_jobs - this will provide a list of any broken database jobs.
;[Lower section of form|]: This section displays the contents of the table that was queried.
At line 17 removed one line
[CLEANUP]
At line 27 added one line
This page (revision-12) was last changed on 26-Nov-2021 10:22 by kparrottTop