program_id: KIN09CSV
db_type: SQLite
db_name: kin.db

db_tables:
  - name: DAILY_RECORDS
    columns:
      - name: EMP_ID
        type: CHAR(8)
        primary_key: true
      - name: TARGET_DATE
        type: CHAR(8)
        primary_key: true
      - name: TIME_IN
        type: CHAR(4)
      - name: TIME_OUT
        type: CHAR(4)
      - name: ANNUAL_LEAVE_H
        type: DECIMAL(6,1)
      - name: PERSONAL_LEAVE_H
        type: DECIMAL(6,1)
      - name: OFFICIAL_LEAVE_H
        type: DECIMAL(6,1)
      - name: SICK_LEAVE_H
        type: DECIMAL(6,1)
      - name: UNAPPROVED_ABSENT_H
        type: DECIMAL(6,1)
      - name: UPDATED_AT
        type: TIMESTAMP

  - name: MONTHLY_ABSENCE
    columns:
      - name: EMP_ID
        type: CHAR(8)
        primary_key: true
      - name: YEAR_MONTH
        type: CHAR(6)
        primary_key: true
      - name: ANNUAL_LEAVE_H
        type: DECIMAL(6,1)
      - name: PERSONAL_LEAVE_H
        type: DECIMAL(6,1)
      - name: OFFICIAL_LEAVE_H
        type: DECIMAL(6,1)
      - name: SICK_LEAVE_H
        type: DECIMAL(6,1)
      - name: UNAPPROVED_ABSENT_H
        type: DECIMAL(6,1)
      - name: UPDATED_AT
        type: TIMESTAMP

runs:
  - id: FULL
    command_line: "YEARMONTH=202607,MODE=FULL"
    seed_extra_rows:
      DAILY_RECORDS: 100
  - id: SHORT
    command_line: "YEARMONTH=202607,MODE=SHORT"

  # Fix A: PARM 组合 + 空结果集场景
  - id: missing_mode
    # WS-COMMA-CNT < 1 → 'WARNING: Missing MODE'（MODE 默认 FULL）
    command_line: "YEARMONTH=202607"
  - id: reordered_parm
    # KEY1=MODE（VALUE1→WS-MODE）+ KEY2=YEARMONTH（VALUE2→WS-YEARMONTH）
    command_line: "MODE=FULL,YEARMONTH=202607"
  - id: missing_ym
    # YEARMONTH 未指定 → SPACE → ABEND（SUB03END）
    command_line: "MODE=FULL"
  - id: empty_daily
    # 首 FETCH EOF：删除 DAILY_RECORDS 表 → 光标 OPEN/FETCH 失败 → SQLCODE≠0 → WS-DAILY-EOF
    # （delete_all_rows 空表时 gixsql 首次 FETCH 返回 SQLCODE=0，无法触发 EOF）
    command_line: "YEARMONTH=202607,MODE=FULL"
    drop_tables: [DAILY_RECORDS]

subprograms:
  - SUB02MSG
  - SUB03END