Information Systems:Saved SQL queries

From uniWIKI
Revision as of 10:46, 20 June 2016 by Norwinu (talk | contribs) (Created page with "=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 repl...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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 runnin on-demand, one-off queries, there is no convenient interface to access reusable queries. Thus, queries are saved in[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.

Detail:

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.

Retrieved from "https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:Saved_SQL_queries&oldid=2475"