Difference between revisions of "Information Systems:Saved SQL queries"
| (9 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
=Overview= |
=Overview= |
||
| − | In 2016, [[Information Systems:Run SQL Scripts]] tool of the [[Information Systems:IBM Access Client Solutions]] software package began to be used heavily as a replacement for Query/400 (WRKQRY). Since this tool is primarily for |
+ | In 2016, the [[Information Systems:Run SQL Scripts | Run SQL Scripts]] tool of the [[Information Systems:IBM Access Client Solutions | IBM Access Client Solutions]] software package began to be used heavily as a replacement for Query/400 (WRKQRY). Since this tool is primarily for running on-demand, one-off queries, there is no convenient interface to access reusable queries. Thus, queries are saved in file://///superserver.unipharm.local/Tech/common/Saved\ DB2 SQL\ Queries to be opened and run within this tool. This wiki page explains the individual queries. |
=Saved Queries= |
=Saved Queries= |
||
| Line 8: | Line 8: | ||
'''Explanation:''' |
'''Explanation:''' |
||
| + | |||
Many items have line codes assigned to them to aid in the purchase suggestion process. Purchase suggestions are maintained in an ASW table, and new ones can be made based on these line codes. Buyers constantly assign/remove line codes from items and from the purchase suggestion table, which over time has led to some stale line codes that no longer appear in the purchase suggestion table. |
Many items have line codes assigned to them to aid in the purchase suggestion process. Purchase suggestions are maintained in an ASW table, and new ones can be made based on these line codes. Buyers constantly assign/remove line codes from items and from the purchase suggestion table, which over time has led to some stale line codes that no longer appear in the purchase suggestion table. |
||
| + | |||
| + | [[Category:IBM i]] |
||
| + | [[Category:Database Query]] |
||
Latest revision as of 00:06, 23 June 2016
Overview
In 2016, the Run SQL Scripts tool of the IBM Access Client Solutions software package began to be used heavily as a replacement for Query/400 (WRKQRY). Since this tool is primarily for running on-demand, one-off queries, there is no convenient interface to access reusable queries. Thus, queries are saved in file://///superserver.unipharm.local/Tech/common/Saved\ DB2 SQL\ Queries to be opened and run within this tool. This wiki page explains the individual queries.
Saved Queries
LineCodesNotInPurchaseTable
This query displays any line codes that do not appear in the purchase suggestion table.
Explanation:
Many items have line codes assigned to them to aid in the purchase suggestion process. Purchase suggestions are maintained in an ASW table, and new ones can be made based on these line codes. Buyers constantly assign/remove line codes from items and from the purchase suggestion table, which over time has led to some stale line codes that no longer appear in the purchase suggestion table.