> select * from ZT040 where IDUSERKUBUN = 'STHATTYU            ' order by SQLIST  (15:12:01.268)
> select * from ZT040 where IDUSERKUBUN = 'KBUNIT              ' order by SQLIST  (15:12:01.291)
> select NRHATTYU,DTHATTYU,DTHAKKOU,CDSIIRESAKI,UPDCOUNTER from DT020 where NRHATTYU='0000007'  (15:12:01.327)
> Update DT020 set DTHAKKOU = '2019-09-06 15:12:01.394' where NRHATTYU = '0000007'  (15:12:01.396)
> select * from DT021 where NRHATTYU = '0000007'  (15:12:01.409)
> select * from BT020 where NRTANPIN = '0000003'  (15:12:01.436)
> select * from ET010 where NRTANPIN = '0000003'  (15:12:01.469)
> Insert  into ET010 (NRTANPIN, SQLOT, CDSIIRESAKI, DTNYUKAYOTEI, QTNYUKAYOTEI, DTHAIKIYOTEI, FGKANRYO, NRTORIHIKI)  values('0000003', 1, 'YAMADA', '2019-09-06', 50, '2019-09-13', 'F', '0000085')   (15:12:01.507)
> Insert  into ET100 (NRTORIHIKI, NRTANPIN, SQLOT, DTYOTEI, KBYOTEI, QTYOTEI, NRSANSYO)  values('0000082', '0000003', 1, '2019-09-06', '10', 50, '0000007-1')   (15:12:01.534)
> Insert  into ET100 (NRTORIHIKI, NRTANPIN, SQLOT, DTYOTEI, KBYOTEI, QTYOTEI, NRSANSYO)  values('0000085', '0000003', 1, '2019-09-13', '30', 50, 'NONE')   (15:12:01.555)
> Update DT021 set SQLOT = 1 where NRHATTYU = '0000007' and SQHATTYU = 1  (15:12:01.575)
> select * from BT020 where NRTANPIN = '0000001'  (15:12:01.604)
> select * from ET010 where NRTANPIN = '0000001'  (15:12:01.690)
> Insert  into ET010 (NRTANPIN, SQLOT, CDSIIRESAKI, DTNYUKAYOTEI, QTNYUKAYOTEI, DTHAIKIYOTEI, FGKANRYO, NRTORIHIKI)  values('0000001', 8, 'YAMADA', '2019-09-06', 20, '2019-09-13', 'F', '0000086')   (15:12:01.735)
> Insert  into ET100 (NRTORIHIKI, NRTANPIN, SQLOT, DTYOTEI, KBYOTEI, QTYOTEI, NRSANSYO)  values('0000083', '0000001', 8, '2019-09-06', '10', 20, '0000007-2')   (15:12:01.787)
> Insert  into ET100 (NRTORIHIKI, NRTANPIN, SQLOT, DTYOTEI, KBYOTEI, QTYOTEI, NRSANSYO)  values('0000086', '0000001', 8, '2019-09-13', '30', 20, 'NONE')   (15:12:01.804)
> Update DT021 set SQLOT = 8 where NRHATTYU = '0000007' and SQHATTYU = 2  (15:12:01.817)
> select * from BT020 where NRTANPIN = '0000002'  (15:12:01.829)
> select * from ET010 where NRTANPIN = '0000002'  (15:12:01.862)
> Insert  into ET010 (NRTANPIN, SQLOT, CDSIIRESAKI, DTNYUKAYOTEI, QTNYUKAYOTEI, DTHAIKIYOTEI, FGKANRYO, NRTORIHIKI)  values('0000002', 4, 'YAMADA', '2019-09-06', 100, '2019-09-13', 'F', '0000087')   (15:12:01.884)
> Insert  into ET100 (NRTORIHIKI, NRTANPIN, SQLOT, DTYOTEI, KBYOTEI, QTYOTEI, NRSANSYO)  values('0000084', '0000002', 4, '2019-09-06', '10', 100, '0000007-3')   (15:12:01.902)
> Insert  into ET100 (NRTORIHIKI, NRTANPIN, SQLOT, DTYOTEI, KBYOTEI, QTYOTEI, NRSANSYO)  values('0000087', '0000002', 4, '2019-09-13', '30', 100, 'NONE')   (15:12:01.915)
> Update DT021 set SQLOT = 4 where NRHATTYU = '0000007' and SQHATTYU = 3  (15:12:01.928)
> select TXNAME,NRYUBIN,TXJYUSYO1,TXMAIL,TXHURIKOMISAKI,TXJYUSYO2,NRPHONE,NRFAX,CDSIIRESAKI from DT010 where CDSIIRESAKI='YAMADA'  (15:12:01.947)
> select NRHATTYU, SQHATTYU, QTHATTYU, PRKOUNYU, DTNYUKAYOTEI, QTNYUKA, QTZAIKO, DTNYUKA, NRTANPIN, UPDCOUNTER from DT021 where NRHATTYU='0000007' order by NRHATTYU,SQHATTYU  (15:12:03.568)
> select TXTANPIN,PRKOUNYU,CDSIIRESAKI,VLHAIKI,FGZAIKO,KBUNIT,VLUNIT,NRTANPIN from BT020 where NRTANPIN='0000003'  (15:12:03.585)
> select TXTANPIN,PRKOUNYU,CDSIIRESAKI,VLHAIKI,FGZAIKO,KBUNIT,VLUNIT,NRTANPIN from BT020 where NRTANPIN='0000001'  (15:12:03.636)
> select TXTANPIN,PRKOUNYU,CDSIIRESAKI,VLHAIKI,FGZAIKO,KBUNIT,VLUNIT,NRTANPIN from BT020 where NRTANPIN='0000002'  (15:12:03.662)
> Local-commit succeeded.  (15:12:04.049)
