openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/ST04_DB4_GET_SQR_WRAPPER:
    post:
      tags:
      - STU4_TCC
      summary: 'AS/400: Wrapper for ST04_DB4_GET_SQR_INFO'
      operationId: /rfc/ST04_DB4_GET_SQR_WRAPPER
      requestBody:
        content:
          application/json:
            schema:
              properties:
                ANY_OTHER_TIME:
                  type: integer
                  format: int64
                  description: 'QQOTHT: Any other time (DB2/400 database monitor)'
                AVERAGE_TIME:
                  type: integer
                  format: int64
                  description: 'QQAVGT:  Average Time           (DB2/400 DBMon)'
                CLOSE_TIME:
                  type: integer
                  format: int64
                  description: 'QQCLST: CLOSE time (DB2/400 database monitor)'
                FETCH_TIME:
                  type: integer
                  format: int64
                  description: 'QQFETT: FETCH time (DB2/400 database monitor)'
                LAST_TIME_USED:
                  type: string
                  maxLength: 26
                  description: 'QQLTU: Time last used (DB2/400 database monitor)'
                MAXIMUM_TIME:
                  type: integer
                  format: int64
                  description: 'QQMAXT: Maximum Time                 (DB2/400 DBMon)'
                MINIMUM_TIME:
                  type: integer
                  format: int64
                  description: 'QQMINT: Minimum Time                (DB2/400 DBMon)'
                OPEN_TIME:
                  type: integer
                  format: int64
                  description: 'QQOPNT: Open time (DB2/400 database  monitor)'
                RESETFLAG:
                  type: string
                  default: ' '
                  maxLength: 1
                  description: 'AS/400: Flag to indicate reset in ST04'
                STATEMENT_FUNCTION:
                  type: string
                  maxLength: 1
                  description: 'QQSTF: Statement function (DB2/400 database monitor)'
                TAB_NAME:
                  type: string
                  default: ' '
                  maxLength: 30
                  description: Table name
                TOP50:
                  type: string
                  default: Y
                  maxLength: 1
                  description: 'QQC11: Für unterschiedliche Verwendung abhängig von QQRID'
                USAGE_COUNTER:
                  type: integer
                  format: int64
                  description: 'QQCNT: Statement Usage Counter       (DB2/400 DBMon)'
                SQR0100:
                  type: array
                  items:
                    type: object
                    properties:
                      SYSID:
                        type: string
                        maxLength: 8
                        description: Name of the SAP System
                      IPLTIME:
                        type: string
                        maxLength: 14
                        description: Text field length 14
                      QQKEY:
                        type: string
                        maxLength: 17
                        description: 'iSeries: Key Field (Database Monitor)'
                      QQPLIB:
                        type: string
                        maxLength: 10
                        description: 'iSeries: Package/Program Library (Database Monitor)'
                      QQPNAM:
                        type: string
                        maxLength: 10
                        description: 'iSeries: Package/Program Name (Database Monitor)'
                      QQSNAM:
                        type: string
                        maxLength: 18
                        description: 'iSeries: Statement Name (Database Monitor)'
                      QQCNAM:
                        type: string
                        maxLength: 18
                        description: 'iSeries: Cursor Name (Database Monitor)'
                      QQSTF:
                        type: string
                        maxLength: 1
                        description: 'iSeries: Statement Function (Database Monitor)  enumValues: D=Delete,S=Select,O=Other (Commit, Rollback,...),I=Insert,U=Update,L=DDL'
                        enum:
                        - D
                        - S
                        - O
                        - I
                        - U
                        - L
                      TOTTIME:
                        type: integer
                        format: int64
                        description: 'iSeries: Total Time (Database Monitor)'
                      QQCNT:
                        type: integer
                        format: int64
                        description: 'iSeries: No. of Executions of a Statement (Database Monitor)'
                      QQARSS:
                        type: integer
                        format: int64
                        description: 'iSeries: Average Result Set Size (Database Monitor)'
                      QQAVGT:
                        type: integer
                        format: int64
                        description: 'iSeries:  Average Time (Database Monitor)'
                      QQMINT:
                        type: integer
                        format: int64
                        description: 'iSeries: Minimum Time  (Database Monitor)'
                      QQMAXT:
                        type: integer
                        format: int64
                        description: 'iSeries: Maximum Time (Database Monitor)'
                      QQOPNT:
                        type: integer
                        format: int64
                        description: 'iSeries: Open time (Database  Monitor)'
                      QQFETT:
                        type: integer
                        format: int64
                        description: 'iSeries: FETCH time (Database Monitor)'
                      QQCLST:
                        type: integer
                        format: int64
                        description: 'iSeries: CLOSE time (Database Monitor)'
                      QQOTHT:
                        type: integer
                        format: int64
                        description: 'iSeries: Any other time (Database Monitor)'
                      QQLTU:
                        type: string
                        maxLength: 26
                        description: 'iSeries: Time Last Used (Database Monitor)'
                      QQMETU:
                        type: string
                        maxLength: 26
                        description: 'iSeries: Timest. of Most Expensive Stmt.  (Database Monitor)'
                      PFILE:
                        type: string
                        maxLength: 30
                        description: 'iSeries: Table Name  (Database Monitor)'
                      QQSTTX_LEN:
                        type: integer
                        format: int32
                        description: 2 byte integer (signed)
                      QQSTTX:
                        type: string
                        maxLength: 8000
                        description: 'iSeries: Statement Text (Database Monitor)'
                      QQUSER:
                        type: string
                        maxLength: 10
                        description: 'iSeries: Job User (Database Monitor)'
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  SQR0100:
                    type: array
                    items:
                      type: object
                      properties:
                        SYSID:
                          type: string
                          maxLength: 8
                          description: Name of the SAP System
                        IPLTIME:
                          type: string
                          maxLength: 14
                          description: Text field length 14
                        QQKEY:
                          type: string
                          maxLength: 17
                          description: 'iSeries: Key Field (Database Monitor)'
                        QQPLIB:
                          type: string
                          maxLength: 10
                          description: 'iSeries: Package/Program Library (Database Monitor)'
                        QQPNAM:
                          type: string
                          maxLength: 10
                          description: 'iSeries: Package/Program Name (Database Monitor)'
                        QQSNAM:
                          type: string
                          maxLength: 18
                          description: 'iSeries: Statement Name (Database Monitor)'
                        QQCNAM:
                          type: string
                          maxLength: 18
                          description: 'iSeries: Cursor Name (Database Monitor)'
                        QQSTF:
                          type: string
                          maxLength: 1
                          description: 'iSeries: Statement Function (Database Monitor)  enumValues: D=Delete,S=Select,O=Other (Commit, Rollback,...),I=Insert,U=Update,L=DDL'
                          enum:
                          - D
                          - S
                          - O
                          - I
                          - U
                          - L
                        TOTTIME:
                          type: integer
                          format: int64
                          description: 'iSeries: Total Time (Database Monitor)'
                        QQCNT:
                          type: integer
                          format: int64
                          description: 'iSeries: No. of Executions of a Statement (Database Monitor)'
                        QQARSS:
                          type: integer
                          format: int64
                          description: 'iSeries: Average Result Set Size (Database Monitor)'
                        QQAVGT:
                          type: integer
                          format: int64
                          description: 'iSeries:  Average Time (Database Monitor)'
                        QQMINT:
                          type: integer
                          format: int64
                          description: 'iSeries: Minimum Time  (Database Monitor)'
                        QQMAXT:
                          type: integer
                          format: int64
                          description: 'iSeries: Maximum Time (Database Monitor)'
                        QQOPNT:
                          type: integer
                          format: int64
                          description: 'iSeries: Open time (Database  Monitor)'
                        QQFETT:
                          type: integer
                          format: int64
                          description: 'iSeries: FETCH time (Database Monitor)'
                        QQCLST:
                          type: integer
                          format: int64
                          description: 'iSeries: CLOSE time (Database Monitor)'
                        QQOTHT:
                          type: integer
                          format: int64
                          description: 'iSeries: Any other time (Database Monitor)'
                        QQLTU:
                          type: string
                          maxLength: 26
                          description: 'iSeries: Time Last Used (Database Monitor)'
                        QQMETU:
                          type: string
                          maxLength: 26
                          description: 'iSeries: Timest. of Most Expensive Stmt.  (Database Monitor)'
                        PFILE:
                          type: string
                          maxLength: 30
                          description: 'iSeries: Table Name  (Database Monitor)'
                        QQSTTX_LEN:
                          type: integer
                          format: int32
                          description: 2 byte integer (signed)
                        QQSTTX:
                          type: string
                          maxLength: 8000
                          description: 'iSeries: Statement Text (Database Monitor)'
                        QQUSER:
                          type: string
                          maxLength: 10
                          description: 'iSeries: Job User (Database Monitor)'
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
