Aviso importante
Caso tenhas alguma
dúvida a respeito
da linguagem mande
um e-mail que terás
a resposta.
  C. A. Dornelles

SQL - SQLCODE's - Códigos positivos - +395


Volta a página anterior

Volta ao Menu Principal


Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

SQLCode +395
   
 
  • Causa
    • USER SPECIFIED OPTIMIZATION HINTS ARE INVALID (REASON CODE = reason-code).
      THE OPTIMIZATION HINTS ARE IGNORED.

      The optimization hints specified for this query are invalid.
      Areason-code in the following table can help identify why the hints were invalid:

      reason-code

      Description

      2

      		  TABNO is invalid

      3

      		  TNAME is not specified

      4

      		  TNAME is ambiguous

      5

      		  TABNO doesn't agree with TNAME

      6

      		  QBLOCKNO doesn't agree with TNAME

      7

      		  PAGE_RANGE is invalid

      8

      		  PREFETCH is invalid

      9

      		  METHOD is invalid

      10

      		  SORTN_JOIN is invalid

      11

      		  SORTC_JOIN is invalid

      12

      		  ACCESSTYPE is invalid

      13

      		  ACCESSCREATOR or ACCESSNAME is invalid

      14

      		  TYPE 1 index can't be used with isolation level 'UR'

      15

      		  Specified index can't be used as requested

      16

      		  Multi-index access can't be done

      17

      		  Invalid ACCESSTYPE combination

      18

      		  METHOD specified for first table accessed

      19

      		  Nested-loop join can't be done as requested

      20

      		  Merge join can't be done as requested

      21

      		  Hybrid join can't be done as requested

      22

      		  PARALLELISM_MODE requested can't be done

      23

      		  PARALLELISM_MODE is invalid

      24

      		  ACCESS_DEGREE is invalid

      25

      		  JOIN_DEGREE is invalid

      26

      		  A table is missing

      27

      		  A table is redundant

      28

      		  PRIMARY_ACCESSTYPE is invalid

      29

      		  ACCESS_PGROUP_ID is not specified

      30

      		  JOIN_PGROUP_ID is not specified

      31

      		  PARALLELISM_MODE is not specified

      32

      		  CREATOR or TNAME is invalid

      33

      		  Join sequence is incorrect

      34

      		  Full outer join requires merge join method

      35

      		  WHEN_OPTIMIZE is invalid or inconsistent

      99

      		  Unexpected error
  • Ação do sistema
    • The user-specified optimization hints are ignored.
      The access path is determined without the use of hints and processing continues normally.
  • Resposta ao Desenvolvedor
    • Correct the problem with the optimization hints, or disable their use for this query.

      SQLSTATE: 01628