output.txt

id: 1
id: 2
id: 3
id: 4
id: 5
id: 6
id: 7
id: 251
id: 255
------------------------------------------
id: 1
id: 2
id: 3
id: 4
id: 5
id: 6
id: 7
id: 251
id: 255
id: 1

Program Name:		onmode
Build Version:		12.10.FC5W1WE
Build Number:		N036
Build Host:		lxvm-l172
Build OS:		Linux 2.6.18-128.el5
Build Date:		Thu May 7 21:51:58 CDT 2015
Build Timestamp:	2015-05-07T21:30:00-05
GLS Version:		glslib-6.00.FC6

test.py

#!/usr/bin/env python 

import ibm_db, sys, subprocess, os

conn = ibm_db.connect('DATABASE=test;HOSTNAME=172.22.1.12;UID=informix;PWD=apo;PORT=9091;', '', '')


try:
    ibm_db.exec_immediate(conn, "drop table mytable");
except:
    pass

ibm_db.exec_immediate(conn, """
create table mytable  
  ( 
    id integer not null , 
    t0 char(10) not null , 
    t1 char(40) not null , 
    t2 char(4), 
    t3 char(4), 
    t4 char(4), 
    t5 integer, 
    t6 integer, 
    t7 integer, 
    t8 integer, 
    t9 integer, 
    t10 integer, 
    t11 integer, 
    t12 integer, 
    t13 integer, 
    t14 integer, 
    t15 integer, 
    t16 integer, 
    t17 integer, 
    t18 integer, 
    t19 integer, 
    t20 integer, 
    t21 integer, 
    t22 integer, 
    t23 integer, 
    t24 integer, 
    t25 integer, 
    t26 integer, 
    t27 integer, 
    t28 integer, 
    t29 integer, 
    t30 integer, 
    t31 char(1), 
    t32 char(1), 
    t33 char(1), 
    t34 char(1), 
    t35 char(1), 
    t36 char(1), 
    t37 char(1), 
    t38 char(1), 
    t39 char(1), 
    t40 char(1), 
    t41 char(1), 
    t42 char(1), 
    t43 char(1), 
    t44 char(1), 
    t45 char(1), 
    t46 char(1), 
    t47 char(1), 
    t48 char(1), 
    t49 char(1), 
    t50 char(12), 
    t51 char(40), 
    t52 char(10), 
    t53 char(80), 
    t54 char(7), 
    primary key (id)  constraint "ther1".pk_mytable 
  )""")

str = '''"1","1","Massage"," ","00"," ","20","20","0","20","0","0","0","0","0","0","0","9","0","0","0","0","0","0","0","0","0","0","0","0","1","1000","T","J","N","J","J","J","N","N","N","J","J","J","N","J","J","N","N","N","J"," ","Mass"," "," "," "
"2","2","Lymphdrainage 1"," ","00"," ","20","20","0","20","0","0","0","0","0","0","0","9","0","0","0","0","0","0","0","0","0","0","0","0","2","2000","T","J","N","J","J","J","N","N","N","J","J","J","N","J","J","N","N","N","J"," ","Lymphdrainage"," "," "," "
"3","3","Lymphdrainage 2"," ","00"," ","40","20","0","40","0","0","0","0","0","0","0","9","0","0","0","0","0","0","0","0","0","0","0","0","3","3000","T","J","N","J","J","J","N","N","N","J","J","J","N","J","J","N","N","N","J"," ","Lymphdr."," "," "," "
"4","4","Moor"," ","00"," ","30","30","0","30","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","4","4000","T","N","N","J","J","J","N","N","N","J","J","J","N","J","J","N","N","N","J"," ","Lymphdr."," "," "," "
"5","5","Moor 2"," ","00"," ","30","30","0","30","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","5","5000","T","N","N","J","J","J","N","N","N","J","J","J","N","J","J","N","N","N","J"," ","Moor 2"," "," "," "
"6","6","Lehm"," ","00"," ","30","30","0","30","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","6","6000","T","N","N","J","J","J","N","N","N","J","J","J","N","J","J","N","N","N","J"," ","Massage/Moor"," "," "," "
"7","7","Lehm/2"," ","00"," ","30","30","0","30","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","7","7000","T","N","N","J","J","J","N","N","N","J","J","J","N","J","J","N","N","N","J"," ","Massage/Moor 2"," "," "," "
"251","251","Behandlungsblock 2"," ","00"," ","5","5","0","5","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","251","251000","T","N","N","J","N","J","N","N","N","J","J","J","N","J","J","N","N","N","J"," ","Rehab/Tag Block 2"," "," "," "
"255","255","Ordinationsbesuch"," "," "," ","5","5","0","5","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","255000","255000","T","N","N","N","J","J","N","N","N","J","N","J","N","J","J","N","N","N"," "," "," "," ","Bitte vor 1. mytable in die Ordination kommen."," "'''

for line in str.split("\n") :
   ibm_db.exec_immediate(conn,"insert into mytable values (" + line + ")")

ibm_db.exec_immediate(conn, """alter table mytable add ( 
t55   CHAR(10) default ' ' not null,
t56   CHAR(10) default ' ' not null,
t57 DATETIME YEAR TO SECOND DEFAULT CURRENT YEAR TO SECOND,
t58 DATE default '31121899' not null,
t59 char(7) default '#000000',
t60   CHAR(1) default 'N' not null,
t61   CHAR(1) default 'N' not null,
t62   INTEGER default 0 not null,
t63 CHAR (20)
)""")


def run(update=False):
    stmt = ibm_db.exec_immediate(conn, 'select * from mytable', {ibm_db.SQL_ATTR_CURSOR_TYPE: ibm_db.SQL_CURSOR_STATIC})
    while 1:
        row = ibm_db.fetch_tuple(stmt)
        if not row:
            break
        id = row[0]
        print "id: %d" % id

        if id == 1 and update:
            ibm_db.exec_immediate(conn, 'update mytable set t0=t0 where id=1')


run(False)
print "------------------------------------------"
run(True)


print 
os.system('onmode -version')