SAP Note 1484907 - DB6: Conditional hints

Component : DB2 Universal Database for Unix / NT -

Solution : https://service.sap.com/sap/support/notes/1484907 (SAP Service marketplace login required)

Key words :
%_hints db6 +[<search string 1>]        db6 <hint1>        db6 +[<search string 2>]        db6 <hint2> examples select, terms db6 luw udb db2luw db2udb guideline lib_dbsl reason, %_hints db6 +[<search string 1>]        db6 -[<search string 2>]        db6 <hint>search conditions, %_hints db6 +[<search string>]        db6 <hint>, %_hints db6 -[<search string>]        db6 <hint>, arbgb = idb6-arbgb%_hints db6 '-[%union, %arbgb_=]'        db6 '<tbscan table=''t100''/>', ]'        db6 '<tbscan table=''t100''/>', clauses dynamic column lists solution, apply multiple search conditions

Related Notes :

868888 DB6: Optimization Guidelines
150037Database hints in Open SQL for DB6 (DB2 for LUW)