> select DTNYUKAYOTEI,NRHATTYU,CDSIIRESAKI,QTNYUKA,PRKOUNYU,QTZAIKO,SQHATTYU,QTHATTYU,DTNYUKA,NRTANPIN,UPDCOUNTER from DT021 order by NRHATTYU,SQHATTYU  (13:07:41.887)
> select TXTANPIN,PRKOUNYU,CDSIIRESAKI,VLHAIKI,FGZAIKO,KBUNIT,VLUNIT from BT020 where NRTANPIN='0000001'  (13:07:41.904)
> select TXTANPIN,PRKOUNYU,CDSIIRESAKI,VLHAIKI,FGZAIKO,KBUNIT,VLUNIT from BT020 where NRTANPIN='0000002'  (13:07:41.930)
> select TXTANPIN,PRKOUNYU,CDSIIRESAKI,VLHAIKI,FGZAIKO,KBUNIT,VLUNIT from BT020 where NRTANPIN='0000003'  (13:07:42.022)
> select NRHATTYU,SQHATTYU,DTNYUKAYOTEI,NRHATTYU,CDSIIRESAKI,QTNYUKA,PRKOUNYU,QTZAIKO,SQHATTYU,NRTORIHIKI,QTHATTYU,DTNYUKA,NRTANPIN,SQLOT,UPDCOUNTER from DT021 where NRHATTYU='0000006' and SQHATTYU=2 and UPDCOUNTER=1  (13:07:45.914)
> select TXTANPIN,PRKOUNYU,CDSIIRESAKI,VLHAIKI,FGZAIKO,KBUNIT,VLUNIT,NRTANPIN from BT020 where NRTANPIN='0000002'  (13:07:45.929)
> select TXNAME,CDSIIRESAKI from DT010 where CDSIIRESAKI='YAMADA'  (13:07:45.936)
> select NRHATTYU,SQHATTYU,DTNYUKAYOTEI,NRHATTYU,CDSIIRESAKI,QTNYUKA,PRKOUNYU,QTZAIKO,SQHATTYU,NRTORIHIKI,QTHATTYU,DTNYUKA,NRTANPIN,SQLOT,UPDCOUNTER from DT021 where NRHATTYU='0000007' and SQHATTYU=1 and UPDCOUNTER=1  (13:07:45.956)
> select TXTANPIN,PRKOUNYU,CDSIIRESAKI,VLHAIKI,FGZAIKO,KBUNIT,VLUNIT,NRTANPIN from BT020 where NRTANPIN='0000003'  (13:07:45.973)
> select NRHATTYU,SQHATTYU,DTNYUKAYOTEI,NRHATTYU,CDSIIRESAKI,QTNYUKA,PRKOUNYU,QTZAIKO,SQHATTYU,NRTORIHIKI,QTHATTYU,DTNYUKA,NRTANPIN,SQLOT,UPDCOUNTER from DT021 where NRHATTYU='0000007' and SQHATTYU=2 and UPDCOUNTER=1  (13:07:45.991)
> select TXTANPIN,PRKOUNYU,CDSIIRESAKI,VLHAIKI,FGZAIKO,KBUNIT,VLUNIT,NRTANPIN from BT020 where NRTANPIN='0000001'  (13:07:46.006)
> select NRHATTYU,SQHATTYU,DTNYUKAYOTEI,NRHATTYU,CDSIIRESAKI,QTNYUKA,PRKOUNYU,QTZAIKO,SQHATTYU,NRTORIHIKI,QTHATTYU,DTNYUKA,NRTANPIN,SQLOT,UPDCOUNTER from DT021 where NRHATTYU='0000007' and SQHATTYU=3 and UPDCOUNTER=1  (13:07:46.027)
> select DTNYUKAYOTEI,NRHATTYU,CDSIIRESAKI,QTNYUKA,PRKOUNYU,QTZAIKO,SQHATTYU,NRTORIHIKI,QTHATTYU,DTNYUKA,NRTANPIN,SQLOT from DT021 where NRTORIHIKI='0000025' and (NRHATTYU!='0000006' or SQHATTYU!=2)  (13:07:48.418)
> select DTNYUKAYOTEI,NRHATTYU,CDSIIRESAKI,QTNYUKA,PRKOUNYU,QTZAIKO,SQHATTYU,NRTORIHIKI,QTHATTYU,DTNYUKA,NRTANPIN,SQLOT from DT021 where NRTORIHIKI='0000082' and (NRHATTYU!='0000007' or SQHATTYU!=1)  (13:07:48.425)
> select DTNYUKAYOTEI,NRHATTYU,CDSIIRESAKI,QTNYUKA,PRKOUNYU,QTZAIKO,SQHATTYU,NRTORIHIKI,QTHATTYU,DTNYUKA,NRTANPIN,SQLOT from DT021 where NRTORIHIKI='0000083' and (NRHATTYU!='0000007' or SQHATTYU!=2)  (13:07:48.430)
> select DTNYUKAYOTEI,NRHATTYU,CDSIIRESAKI,QTNYUKA,PRKOUNYU,QTZAIKO,SQHATTYU,NRTORIHIKI,QTHATTYU,DTNYUKA,NRTANPIN,SQLOT from DT021 where NRTORIHIKI='0000084' and (NRHATTYU!='0000007' or SQHATTYU!=3)  (13:07:48.433)
> update DT021 set DTNYUKAYOTEI='2015-09-24', CDSIIRESAKI='YAMADA', QTNYUKA=10, PRKOUNYU=1000, QTZAIKO=1000, NRTORIHIKI='0000025', QTHATTYU=10, DTNYUKA='2019-12-20', NRTANPIN='0000002', SQLOT=2, UPDCOUNTER=2 where NRHATTYU='0000006' and SQHATTYU=2 and UPDCOUNTER=1  (13:07:48.437)
> Delete  from ET100 where NRTORIHIKI = '0000025'  (13:07:48.450)
> Insert  into ET200 (NRUKEBARAI, KBDENPYO, FGVALID, KBUKEBARAI, NRTANPIN, SQLOT, TXTEKIYO, DTUKEBARAI, QTUKEBARAI, AMUKEBARAI, NRTORIHIKI, NRSANSYO, DTFYEAR, DTMSEQ)  values('0000058', '1', 'T', '10', '0000002', 2, '山田生花卸', '2019-12-20', 1000, 10800, '0000025', '0000006-2', 2019, 9)   (13:07:48.475)
> select * from ET010 where NRTANPIN = '0000002' and SQLOT = 2  (13:07:48.481)
> select * from BT020 where NRTANPIN = '0000002'  (13:07:48.488)
> Update ET010 set PRZAIKO = 11, QTNYUKO = 1000, DTNYUKA = '2019-12-20', DTHAIKIYOTEI = '2019-12-27', UPDCOUNTER = 2.0 where NRTANPIN = '0000002' and SQLOT = 2 and UPDCOUNTER = 1  (13:07:48.497)
> Insert  into DT100 (NRSIIRE, KBDENPYO, FGVALID, KBKAITORI, CDSIIRESAKI, TXNAME, TXTEKIYO, DTTORIHIKI, AMTORIHIKI, AMTAX, NRSIHARAI, NRTORIHIKI, NRSANSYO, DTFYEAR, DTMSEQ)  values('0000026', '1', 'T', '10', 'YAMADA', '山田生花卸', 'カスミ草', '2019-12-20', 10000, 800, '', '0000025', '0000006-2', 2019, 9)   (13:07:48.590)
> select AMSIIRE, UPDCOUNTER from DT010 where CDSIIRESAKI = 'YAMADA '  (13:07:48.594)
> Update DT010 set AMSIIRE = 33480, UPDCOUNTER = 21.0 where CDSIIRESAKI = 'YAMADA ' and UPDCOUNTER = 20  (13:07:48.599)
> update DT021 set DTNYUKAYOTEI='2019-09-06', CDSIIRESAKI='YAMADA', QTNYUKA=1, PRKOUNYU=2000, QTZAIKO=50, NRTORIHIKI='0000082', QTHATTYU=1, DTNYUKA='2019-12-20', NRTANPIN='0000003', SQLOT=1, UPDCOUNTER=2 where NRHATTYU='0000007' and SQHATTYU=1 and UPDCOUNTER=1  (13:07:48.604)
> Delete  from ET100 where NRTORIHIKI = '0000082'  (13:07:48.617)
> Insert  into ET200 (NRUKEBARAI, KBDENPYO, FGVALID, KBUKEBARAI, NRTANPIN, SQLOT, TXTEKIYO, DTUKEBARAI, QTUKEBARAI, AMUKEBARAI, NRTORIHIKI, NRSANSYO, DTFYEAR, DTMSEQ)  values('0000059', '1', 'T', '10', '0000003', 1, '山田生花卸', '2019-12-20', 50, 2160, '0000082', '0000007-1', 2019, 9)   (13:07:48.634)
> select * from ET010 where NRTANPIN = '0000003' and SQLOT = 1  (13:07:48.638)
> select * from BT020 where NRTANPIN = '0000003'  (13:07:48.643)
> Update ET010 set PRZAIKO = 43, QTNYUKO = 50, DTNYUKA = '2019-12-20', DTHAIKIYOTEI = '2019-12-27', UPDCOUNTER = 1.0 where NRTANPIN = '0000003' and SQLOT = 1 and UPDCOUNTER = 0  (13:07:48.652)
> Insert  into DT100 (NRSIIRE, KBDENPYO, FGVALID, KBKAITORI, CDSIIRESAKI, TXNAME, TXTEKIYO, DTTORIHIKI, AMTORIHIKI, AMTAX, NRSIHARAI, NRTORIHIKI, NRSANSYO, DTFYEAR, DTMSEQ)  values('0000027', '1', 'T', '10', 'YAMADA', '山田生花卸', 'スミレ１号', '2019-12-20', 2000, 160, '', '0000082', '0000007-1', 2019, 9)   (13:07:48.731)
> Update DT010 set AMSIIRE = 35640, UPDCOUNTER = 22.0 where CDSIIRESAKI = 'YAMADA ' and UPDCOUNTER = 21  (13:07:48.739)
> update DT021 set DTNYUKAYOTEI='2019-09-06', CDSIIRESAKI='YAMADA', QTNYUKA=1, PRKOUNYU=1000, QTZAIKO=20, NRTORIHIKI='0000083', QTHATTYU=1, DTNYUKA='2019-12-20', NRTANPIN='0000001', SQLOT=8, UPDCOUNTER=2 where NRHATTYU='0000007' and SQHATTYU=2 and UPDCOUNTER=1  (13:07:48.745)
> Delete  from ET100 where NRTORIHIKI = '0000083'  (13:07:48.757)
> Insert  into ET200 (NRUKEBARAI, KBDENPYO, FGVALID, KBUKEBARAI, NRTANPIN, SQLOT, TXTEKIYO, DTUKEBARAI, QTUKEBARAI, AMUKEBARAI, NRTORIHIKI, NRSANSYO, DTFYEAR, DTMSEQ)  values('0000060', '1', 'T', '10', '0000001', 8, '山田生花卸', '2019-12-20', 20, 1080, '0000083', '0000007-2', 2019, 9)   (13:07:48.777)
> select * from ET010 where NRTANPIN = '0000001' and SQLOT = 8  (13:07:48.782)
> select * from BT020 where NRTANPIN = '0000001'  (13:07:48.787)
> Update ET010 set PRZAIKO = 54, QTNYUKO = 20, DTNYUKA = '2019-12-20', DTHAIKIYOTEI = '2019-12-27', UPDCOUNTER = 1.0 where NRTANPIN = '0000001' and SQLOT = 8 and UPDCOUNTER = 0  (13:07:48.795)
> Insert  into DT100 (NRSIIRE, KBDENPYO, FGVALID, KBKAITORI, CDSIIRESAKI, TXNAME, TXTEKIYO, DTTORIHIKI, AMTORIHIKI, AMTAX, NRSIHARAI, NRTORIHIKI, NRSANSYO, DTFYEAR, DTMSEQ)  values('0000028', '1', 'T', '10', 'YAMADA', '山田生花卸', 'バラ１２号', '2019-12-20', 1000, 80, '', '0000083', '0000007-2', 2019, 9)   (13:07:48.868)
> Update DT010 set AMSIIRE = 36720, UPDCOUNTER = 23.0 where CDSIIRESAKI = 'YAMADA ' and UPDCOUNTER = 22  (13:07:48.875)
> update DT021 set DTNYUKAYOTEI='2019-09-06', CDSIIRESAKI='YAMADA', QTNYUKA=1, PRKOUNYU=1000, QTZAIKO=100, NRTORIHIKI='0000084', QTHATTYU=1, DTNYUKA='2019-12-20', NRTANPIN='0000002', SQLOT=4, UPDCOUNTER=2 where NRHATTYU='0000007' and SQHATTYU=3 and UPDCOUNTER=1  (13:07:48.879)
> Delete  from ET100 where NRTORIHIKI = '0000084'  (13:07:48.891)
> Insert  into ET200 (NRUKEBARAI, KBDENPYO, FGVALID, KBUKEBARAI, NRTANPIN, SQLOT, TXTEKIYO, DTUKEBARAI, QTUKEBARAI, AMUKEBARAI, NRTORIHIKI, NRSANSYO, DTFYEAR, DTMSEQ)  values('0000061', '1', 'T', '10', '0000002', 4, '山田生花卸', '2019-12-20', 100, 1080, '0000084', '0000007-3', 2019, 9)   (13:07:48.906)
> select * from ET010 where NRTANPIN = '0000002' and SQLOT = 4  (13:07:48.911)
> Update ET010 set PRZAIKO = 11, QTNYUKO = 100, DTNYUKA = '2019-12-20', DTHAIKIYOTEI = '2019-12-27', UPDCOUNTER = 1.0 where NRTANPIN = '0000002' and SQLOT = 4 and UPDCOUNTER = 0  (13:07:48.922)
> Insert  into DT100 (NRSIIRE, KBDENPYO, FGVALID, KBKAITORI, CDSIIRESAKI, TXNAME, TXTEKIYO, DTTORIHIKI, AMTORIHIKI, AMTAX, NRSIHARAI, NRTORIHIKI, NRSANSYO, DTFYEAR, DTMSEQ)  values('0000029', '1', 'T', '10', 'YAMADA', '山田生花卸', 'カスミ草', '2019-12-20', 1000, 80, '', '0000084', '0000007-3', 2019, 9)   (13:07:49.002)
> Update DT010 set AMSIIRE = 37800, UPDCOUNTER = 24.0 where CDSIIRESAKI = 'YAMADA ' and UPDCOUNTER = 23  (13:07:49.009)
> Local-commit succeeded.  (13:07:49.019)
