SAP Reports / Programs | Basis Components | ABAP Workbench, Java IDE and Infrastructure | Activation Program, Conversion Program, DB Utility, MC, SPDD(BC-DWB-DIC-AC) SAP BC

comments icon Comments

SINDXINF SAP ABAP Report - Program for Creating Database-Specific Indexes (Informix)







SINDXINF is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). Below is the basic information available for this SAP report including which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC. Also check out the submitted Comments related to this SAP report or see any standard documentation available.

If you would like to execute this report or see the full code listing simply enter SINDXINF into the relevant SAP transactions such as SE38 or SE80


ABAP code to call this SAP report using the submit statement

This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.






SUBMIT SINDXINF. "Basic submit
SUBMIT SINDXINF AND RETURN. "Return to original report after report execution complete
SUBMIT SINDXINF VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
    See more syntax options for the ABAP SUBMIT statement


Text pool values


Selection Text: LOG_DEV = Log (D=screen, F=file)
Title: Program for Creating Database-Specific Indexes (Informix)
Text Symbol: 007 = Index of APQI (Informix) exists
Text Symbol: 008 = Index of DOKCR Informix-specific created
Text Symbol: 009 = Index of DOKCR (Informix) created
Text Symbol: 010 = Index of DSYDS Informix-specific created
Text Symbol: 011 = Index of DSYDS (Informix) exists
Text Symbol: 012 = VBLOG is converted in VBHDR, VBMOD, VBDATA
Text Symbol: 006 = Index of APQI Informix-specific created
Text Symbol: 000 = Create DB-specific indexes (Informix)
Text Symbol: 001 = Create DB-specific indexes (Informix)
Text Symbol: 002 = Indexes of D010LINF (Informix) exist
Text Symbol: 003 = Indexes of VBLOG (Informix) exist
Text Symbol: 004 = Index of D010LINF Informix-specific created
Text Symbol: 005 = Index of FBLOG Informix-specific created
Text Symbol: 020 = Error when creating the index on the DB
Text Symbol: 022 = No free program found for code generation
Text Symbol: 023 = A program could not be written
Text Symbol: 024 = A program could not be generated
Text Symbol: 019 = Error when actively writing the index
Text Symbol: 013 = Index of VBMOD (Informix) exists
Text Symbol: 014 = Index of VBDATA (Informix) exists
Text Symbol: 015 = Index of VBMOD Informix-specific created
Text Symbol: 016 = Index of VBDATA Informix-specific created
Text Symbol: 017 = Error when writing the index to the ABAP/4 Dict.
Text Symbol: 018 = Indexes to the table are not consistent


INCLUDES used within this REPORT SINDXINF

INCLUDE: RADBTOUM.
INCLUDE RADDBPR0 .


TABLES used within REPORT and the associated SELECT statement:





No SAP DATABASE tables are accessed within this REPORT code!


Function Modules used within report and the associated call statement:

DD_INDEX_NAME
  CALL FUNCTION 'DD_INDEX_NAME'
       EXPORTING
            INDEXNAME = IINDEXNAME
            TABNAME   = ITABNAME
       IMPORTING
            DBINDEX   = DBINDEX.

DB_DROP_INDEX
  CALL FUNCTION 'DB_DROP_INDEX'
       EXPORTING
            DBINDEX               = DBINDEX
            TABNAME               = ITABNAME
       IMPORTING
            SUBRC                 = RC
       EXCEPTIONS
            INDEX_NOT_DROPPED     = 01
            PROGRAM_NOT_GENERATED = 02
            PROGRAM_NOT_WRITTEN   = 03.

DD_INDEX_INTERFACE
 CALL FUNCTION 'DD_INDEX_INTERFACE'
      EXPORTING
 "         LANGUAGE         = SY-LANGU
           TABLE_NAME       = TABNAME
 "         TRANSPORT_NUMBER = ' '
           INDEX_NAME       = INDX_ID
           UNIQUE           = UNI_FLAG
           ACTION           = 'U'
           SHORTTEXT        = INDX_TXT
           ACTIVATE         = 'X'
           NO_TRANSP_REQUEST = 'X'
      IMPORTING
           ACTFAILED        = FLAG
      TABLES
           INDEX_FIELDS     = TAB1
      EXCEPTIONS
           CANCELLED        = 01
           ALREADY_EXIST    = 02
           PERMISSION_ERROR = 03
           NAME_NOT_ALLOWED = 04
           DB_ACCESS_ERROR  = 05
           BASETAB_ERROR    = 06
           NOT_EXIST        = 07.

ENQUEUE_ESRDIRE
    CALL FUNCTION 'ENQUEUE_ESRDIRE'
         EXPORTING
              NAME         = PROGNAME
         EXCEPTIONS
              FOREIGN_LOCK = 1.


Contribute (Add Comments)

Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.







The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.

This will then be available for everyone to easily find by simply searching on the report name SINDXINF or its description.


   
 

SINDXINF - Program for Creating Database-Specific Indexes (Informix)
SINDXINF - Program for Creating Database-Specific Indexes (Informix)
SINDXADA - Report for Starting INDEXADA (ADABAS-Specific Indexes) as Batch
SINDXADA - Report for Starting INDEXADA (ADABAS-Specific Indexes) as Batch
SIM_C_E_TOP - SIMCETOP
SIM_C_E_F01 - SIMCEF01