https://owl.unipharm.com/mediawiki/index.php?action=history&feed=atom&title=Information_Systems%3ASaved_SQL_queries 2026-09-01T09:59:50Z Revision history for this page on the wiki MediaWiki 1.35.4 https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:Saved_SQL_queries&diff=3526&oldid=prev 2016-06-23T07:06:05Z

<p></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 07:06, 23 June 2016</td> </tr><tr> <td colspan="2" class="diff-lineno">Line 11:</td> <td colspan="2" class="diff-lineno">Line 11:</td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>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.</div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>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.</div></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td> </tr> <tr> <td class="diff-marker">−</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[Category:<del class="diffchange diffchange-inline">Information</del> <del class="diffchange diffchange-inline">Systems:DB2</del>]]</div></td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[Category:<ins class="diffchange diffchange-inline">IBM</ins> <ins class="diffchange diffchange-inline">i</ins>]]</div></td> </tr> <tr> <td class="diff-marker">−</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[Category:<del class="diffchange diffchange-inline">Information</del> <del class="diffchange diffchange-inline">Systems:SQL</del>]]</div></td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[Category:<ins class="diffchange diffchange-inline">Database</ins> <ins class="diffchange diffchange-inline">Query</ins>]]</div></td> </tr> <tr> <td class="diff-marker">−</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[Category:Information Systems:Query]]</div></td> <td colspan="2" class="diff-empty">&#160;</td> </tr> <tr> <td class="diff-marker">−</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[Category:Business Intelligence]]</div></td> <td colspan="2" class="diff-empty">&#160;</td> </tr> <!-- diff cache key wikidb:diff:wikidiff2:1.12:old-2486:rev-3526:1.11.0 --> </table>

Norwinu https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:Saved_SQL_queries&diff=2486&oldid=prev 2016-06-20T18:21:34Z

<p></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 18:21, 20 June 2016</td> </tr><tr> <td colspan="2" class="diff-lineno">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=Overview=</div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=Overview=</div></td> </tr> <tr> <td class="diff-marker">−</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>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<del class="diffchange diffchange-inline">\n</del> SQL\ Queries to be opened and run within this tool. This wiki page explains the individual queries.</div></td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>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.</div></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=Saved Queries=</div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=Saved Queries=</div></td> </tr> <!-- diff cache key wikidb:diff:wikidiff2:1.12:old-2485:rev-2486:1.11.0 --> </table>

Norwinu https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:Saved_SQL_queries&diff=2485&oldid=prev 2016-06-20T18:20:29Z

<p></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 18:20, 20 June 2016</td> </tr><tr> <td colspan="2" class="diff-lineno">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=Overview=</div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=Overview=</div></td> </tr> <tr> <td class="diff-marker">−</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>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.</div></td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>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\<ins class="diffchange diffchange-inline">n</ins> SQL\ Queries to be opened and run within this tool. This wiki page explains the individual queries.</div></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=Saved Queries=</div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=Saved Queries=</div></td> </tr> <!-- diff cache key wikidb:diff:wikidiff2:1.12:old-2484:rev-2485:1.11.0 --> </table>

Norwinu https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:Saved_SQL_queries&diff=2484&oldid=prev 2016-06-20T18:20:08Z

<p><span dir="auto"><span class="autocomment">Overview</span></span></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 18:20, 20 June 2016</td> </tr><tr> <td colspan="2" class="diff-lineno">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=Overview=</div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=Overview=</div></td> </tr> <tr> <td class="diff-marker">−</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>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.</div></td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>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<ins class="diffchange diffchange-inline">\</ins> DB2<ins class="diffchange diffchange-inline">\</ins> SQL<ins class="diffchange diffchange-inline">\</ins> Queries to be opened and run within this tool. This wiki page explains the individual queries.</div></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=Saved Queries=</div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=Saved Queries=</div></td> </tr> <!-- diff cache key wikidb:diff:wikidiff2:1.12:old-2483:rev-2484:1.11.0 --> </table>

Norwinu https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:Saved_SQL_queries&diff=2483&oldid=prev 2016-06-20T18:19:37Z

<p></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 18:19, 20 June 2016</td> </tr><tr> <td colspan="2" class="diff-lineno">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=Overview=</div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=Overview=</div></td> </tr> <tr> <td class="diff-marker">−</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>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<del class="diffchange diffchange-inline">[[</del>file://///superserver.unipharm.local/Tech/common/Saved DB2 SQL Queries<del class="diffchange diffchange-inline">]]</del> to be opened and run within this tool. This wiki page explains the individual queries.</div></td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>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<ins class="diffchange diffchange-inline"> </ins>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.</div></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=Saved Queries=</div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=Saved Queries=</div></td> </tr> <!-- diff cache key wikidb:diff:wikidiff2:1.12:old-2482:rev-2483:1.11.0 --> </table>

Norwinu https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:Saved_SQL_queries&diff=2482&oldid=prev 2016-06-20T17:51:22Z

<p><span dir="auto"><span class="autocomment">LineCodesNotInPurchaseTable</span></span></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 17:51, 20 June 2016</td> </tr><tr> <td colspan="2" class="diff-lineno">Line 11:</td> <td colspan="2" class="diff-lineno">Line 11:</td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>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.</div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>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.</div></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td> </tr> <tr> <td class="diff-marker">−</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[<del class="diffchange diffchange-inline">:</del>Category:Information Systems:DB2]]</div></td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[Category:Information Systems:DB2]]</div></td> </tr> <tr> <td class="diff-marker">−</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[<del class="diffchange diffchange-inline">:</del>Category:Information Systems:SQL]]</div></td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[Category:Information Systems:SQL]]</div></td> </tr> <tr> <td class="diff-marker">−</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[<del class="diffchange diffchange-inline">:</del>Category:Information Systems:Query]]</div></td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[Category:Information Systems:Query]]</div></td> </tr> <tr> <td class="diff-marker">−</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[<del class="diffchange diffchange-inline">:</del>Category:Business Intelligence]]</div></td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[Category:Business Intelligence]]</div></td> </tr> <!-- diff cache key wikidb:diff:wikidiff2:1.12:old-2481:rev-2482:1.11.0 --> </table>

Norwinu https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:Saved_SQL_queries&diff=2481&oldid=prev 2016-06-20T17:51:09Z

<p></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 17:51, 20 June 2016</td> </tr><tr> <td colspan="2" class="diff-lineno">Line 10:</td> <td colspan="2" class="diff-lineno">Line 10:</td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>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.</div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>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.</div></td> </tr> <tr> <td colspan="2" class="diff-empty">&#160;</td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"></td> </tr> <tr> <td colspan="2" class="diff-empty">&#160;</td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[:Category:Information Systems:DB2]]</div></td> </tr> <tr> <td colspan="2" class="diff-empty">&#160;</td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[:Category:Information Systems:SQL]]</div></td> </tr> <tr> <td colspan="2" class="diff-empty">&#160;</td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[:Category:Information Systems:Query]]</div></td> </tr> <tr> <td colspan="2" class="diff-empty">&#160;</td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[:Category:Business Intelligence]]</div></td> </tr> <!-- diff cache key wikidb:diff:wikidiff2:1.12:old-2480:rev-2481:1.11.0 --> </table>

Norwinu https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:Saved_SQL_queries&diff=2480&oldid=prev 2016-06-20T17:49:40Z

<p>Norwinu moved page <a href="/mediawiki/index.php?title=Saved_SQL_queries&amp;action=edit&amp;redlink=1" class="new" title="Saved SQL queries (page does not exist)">Saved SQL queries</a> to <a href="/mediawiki/index.php/Information_Systems:Saved_SQL_queries" title="Information Systems:Saved SQL queries">Information Systems:Saved SQL queries</a> without leaving a redirect</p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 17:49, 20 June 2016</td> </tr> <!-- diff cache key wikidb:diff:wikidiff2:1.12:old-2479:rev-2480:1.11.0 --> </table>

Norwinu https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:Saved_SQL_queries&diff=2479&oldid=prev 2016-06-20T17:49:13Z

<p><span dir="auto"><span class="autocomment">Overview</span></span></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 17:49, 20 June 2016</td> </tr><tr> <td colspan="2" class="diff-lineno">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=Overview=</div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=Overview=</div></td> </tr> <tr> <td class="diff-marker">−</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>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 <del class="diffchange diffchange-inline">runnin</del> 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.<del class="diffchange diffchange-inline"> </del></div></td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>In 2016,<ins class="diffchange diffchange-inline"> the</ins> [[Information Systems:<ins class="diffchange diffchange-inline">Run SQL Scripts | </ins>Run SQL Scripts]] tool of the [[Information Systems:<ins class="diffchange diffchange-inline">IBM Access Client Solutions | </ins>IBM Access Client Solutions]] software package began to be used heavily as a replacement for Query/400 (WRKQRY). Since this tool is primarily for <ins class="diffchange diffchange-inline">running</ins> 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.</div></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=Saved Queries=</div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=Saved Queries=</div></td> </tr> <!-- diff cache key wikidb:diff:wikidiff2:1.12:old-2478:rev-2479:1.11.0 --> </table>

Norwinu https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:Saved_SQL_queries&diff=2478&oldid=prev 2016-06-20T17:47:40Z

<p><span dir="auto"><span class="autocomment">LineCodesNotInPurchaseTable</span></span></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 17:47, 20 June 2016</td> </tr><tr> <td colspan="2" class="diff-lineno">Line 8:</td> <td colspan="2" class="diff-lineno">Line 8:</td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>'''Explanation:'''</div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>'''Explanation:'''</div></td> </tr> <tr> <td colspan="2" class="diff-empty">&#160;</td> <td class="diff-marker">+</td> <td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"></td> </tr> <tr> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>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.</div></td> <td class="diff-marker">&#160;</td> <td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>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.</div></td> </tr> <!-- diff cache key wikidb:diff:wikidiff2:1.12:old-2477:rev-2478:1.11.0 --> </table>

Norwinu