jkyeung

@echo off
cls
if %1. == . goto error
if not %2. == . goto error

python "%~dp0/create_bat_wrapper.py" %1
goto exit

:error
echo Drop exactly one file onto my icon.

jkyeung

import sys
import os

import xlsxwriter

os.chdir(sys.path[0])  # ensure working directory is the script directory

headings = ['Alpha', 'Beta', 'Gamma', 'Delta']

data = [

jkyeung

      *----------------------------------------------------------------*
     D parms           s              3  0                              
      *----------------------------------------------------------------*
     C                   eval      parms = %parms                       
     C     parms         dsply                                          
     C                   return                                         
      *----------------------------------------------------------------*

jkyeung

      *----------------------------------------------------------------*
     D var1            s              3  0 inz(1)                       
     D var2            s              3  0 inz(0)                       
     D var3            s              3  0                              
      *----------------------------------------------------------------*
     C                   if        %parms > 0                           
     C                   eval      var3 = var1/var2                     
     C                   endif                                          
     C                   return                                         
      *----------------------------------------------------------------*

jkyeung

from itoolkit import iToolKit, iCmd, iPgm, iData
from itoolkit.transport import DatabaseTransport

from localutils import odbc_connect

def program1(conn, in1):
    trans = DatabaseTransport(conn)
    itool = iToolKit(irow=False)
    itool.clear()
    itool.add(iPgm('pgm', 'SPLIT', {'lib': 'LIB1'})