openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/MSS_EXPLAIN_SQL_STMT_RS:
    post:
      tags:
      - SFMSS_PERF
      summary: MS SQL server function to get statistics, showplan for SQL stmt execution.
      operationId: /rfc/MSS_EXPLAIN_SQL_STMT_RS
      requestBody:
        content:
          application/json:
            schema:
              properties:
                CON_NAME:
                  type: string
                  default: DEFAULT
                  maxLength: 30
                  description: Logical name of a Database Connection
                SQLCODE:
                  type: array
                  items:
                    type: object
                    properties:
                      TEXTLINE:
                        type: string
                        maxLength: 255
                        description: MS sql server - stored procedure text line
                SQLEXEC_PLAN:
                  type: array
                  items:
                    type: object
                    properties:
                      STMTTEXT:
                        type: string
                        maxLength: 2048
                        description: Text of showplan output
                      STMTID:
                        type: integer
                        format: int32
                        description: 'MSS: Plan statement ID'
                      NODEID:
                        type: integer
                        format: int32
                        description: 'MSS: Plan node ID'
                      PARENT:
                        type: integer
                        format: int32
                        description: 'MSS: Plan parent node'
                      PHYSICALOP:
                        type: string
                        maxLength: 32
                        description: MSS:Plan physical operation name
                      LOGICALOP:
                        type: string
                        maxLength: 32
                        description: 'MSS: Plan logical operation name'
                      ARG:
                        type: string
                        maxLength: 2048
                        description: 'MSS: Plan arguments'
                      DEFVAL:
                        type: string
                        maxLength: 2048
                        description: 'MSS: Plan defined values'
                      ESTROWS:
                        type: number
                        description: 'MSS: Plan estimated rows'
                      ESTIO:
                        type: number
                        description: 'MSS: Plan estimated IO'
                      ESTCPU:
                        type: number
                        description: 'MSS: Plan estimated CPU'
                      AVGROWSZ:
                        type: integer
                        format: int32
                        description: 'MSS: Plan average row size'
                      TOTSUBTREECO:
                        type: number
                        description: 'MSS: Plan total subtree cost'
                      OUTPUTLIST:
                        type: string
                        maxLength: 2048
                        description: 'MSS: Plan output list'
                      WARNINGS:
                        type: string
                        maxLength: 64
                        description: 'MSS: Plan warnings'
                      OPTYPE:
                        type: string
                        maxLength: 32
                        description: 'MSS: Plan operation type'
                      PARALLEL:
                        type: string
                        maxLength: 8
                        description: 'MSS: Plan parallel flag'
                      ESTEXECS:
                        type: integer
                        format: int64
                        description: 'MSS: Plan estimated executions'
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  SQLCODE:
                    type: array
                    items:
                      type: object
                      properties:
                        TEXTLINE:
                          type: string
                          maxLength: 255
                          description: MS sql server - stored procedure text line
                  SQLEXEC_PLAN:
                    type: array
                    items:
                      type: object
                      properties:
                        STMTTEXT:
                          type: string
                          maxLength: 2048
                          description: Text of showplan output
                        STMTID:
                          type: integer
                          format: int32
                          description: 'MSS: Plan statement ID'
                        NODEID:
                          type: integer
                          format: int32
                          description: 'MSS: Plan node ID'
                        PARENT:
                          type: integer
                          format: int32
                          description: 'MSS: Plan parent node'
                        PHYSICALOP:
                          type: string
                          maxLength: 32
                          description: MSS:Plan physical operation name
                        LOGICALOP:
                          type: string
                          maxLength: 32
                          description: 'MSS: Plan logical operation name'
                        ARG:
                          type: string
                          maxLength: 2048
                          description: 'MSS: Plan arguments'
                        DEFVAL:
                          type: string
                          maxLength: 2048
                          description: 'MSS: Plan defined values'
                        ESTROWS:
                          type: number
                          description: 'MSS: Plan estimated rows'
                        ESTIO:
                          type: number
                          description: 'MSS: Plan estimated IO'
                        ESTCPU:
                          type: number
                          description: 'MSS: Plan estimated CPU'
                        AVGROWSZ:
                          type: integer
                          format: int32
                          description: 'MSS: Plan average row size'
                        TOTSUBTREECO:
                          type: number
                          description: 'MSS: Plan total subtree cost'
                        OUTPUTLIST:
                          type: string
                          maxLength: 2048
                          description: 'MSS: Plan output list'
                        WARNINGS:
                          type: string
                          maxLength: 64
                          description: 'MSS: Plan warnings'
                        OPTYPE:
                          type: string
                          maxLength: 32
                          description: 'MSS: Plan operation type'
                        PARALLEL:
                          type: string
                          maxLength: 8
                          description: 'MSS: Plan parallel flag'
                        ESTEXECS:
                          type: integer
                          format: int64
                          description: 'MSS: Plan estimated executions'
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
