Skip to content

Instantly share code, notes, and snippets.

View jkyeung's full-sized avatar

jkyeung

4 followers · 1 following
View GitHub Profile
@jkyeung
jkyeung / create_bat_wrapper.bat
Created July 13, 2022 16:16
Generate a .bat file to use for invoking a Python script
@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
jkyeung / autofilter_demo_001.py
Created October 24, 2019 19:27
Autofilter demo in Python with XlsxWriter
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
jkyeung / PARMCOUNT.rpgle
Last active April 24, 2019 15:53
Problem with iPgm parameters in python-itoolkit
*----------------------------------------------------------------*
D parms s 3 0
*----------------------------------------------------------------*
C eval parms = %parms
C parms dsply
C return
*----------------------------------------------------------------*
@jkyeung
jkyeung / XPGM1.rpgle
Last active April 24, 2019 03:07
Problem with iPgm parameters in python-itoolkit
*----------------------------------------------------------------*
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
jkyeung / test.py
Last active April 23, 2019 20:49
Problem with iPgm parameters in python-itoolkit
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'})