SAP Note 485420 - iSeries: Database hints for Open SQL/Native SQL

Composant : DB2 for AS/400 -

Solution : https://service.sap.com/sap/support/notes/485420 (Connexion à SAP Service Marketplace requise)

Mots Clés :
dbs/db4/use_hints = 1 dbs/db4/use_hints = abap->1, dbs/db4/alternate~_qaqqinilib profile parameter, connid = '0400'      %_hints as400 '&reparse&' as400 'alternate_qaqqinilib', profile parameter dbs/sb4/use_hints, dbs/db4/qaqqinilib profile parameter, <statement> %_hints <selector> '<hint>' [<selector> '<hint>', dbs/db4/alternate_qaqqinilib = <mylib>, dbs/db4/qaqqinilib parameter, patch levels support optimization hints, hint as400 as400 '&reparse&'

Notes associées :

1109771DB4: Conditional Statement Hints
917461DB4: Improved Database Hint Handling / Performance
795106DB2/400: Enhanced Nested Table Expression Support
729136iSeries: SQL package R3sidX0000/ECMCT full
643056iSeries: SQL error 104 with OPTIMIZE FOR n ROWS
600968iSeries: Overwriting memory with database hints
531337iSeries: Performance with Open SQL "FOR ALL ENTRIES"
501572iSeries: EVI stage 2 support
481868iSeries: Access plans of single-execution SQL statements
306823
129385Database hints in Open SQL