> select * from ZT040 where IDUSERKUBUN = 'STNYUKA' order by SQLIST  (15:33:52.785)
> select * from ZT040 where IDUSERKUBUN = 'KBUNIT' order by SQLIST  (15:33:52.808)
> select * from ZT040 where IDUSERKUBUN = 'STNYUKA             ' order by SQLIST  (15:33:53.150)
> select * from ZT040 where IDUSERKUBUN = 'KBUNIT              ' order by SQLIST  (15:33:53.193)
> select DTNYUKAYOTEI,NRHATTYU,CDSIIRESAKI,QTNYUKA,PRKOUNYU,QTZAIKO,SQHATTYU,QTHATTYU,DTNYUKA,NRTANPIN,UPDCOUNTER from DT021 order by NRHATTYU,SQHATTYU  (15:33:53.337)
> select TXTANPIN,PRKOUNYU,CDSIIRESAKI,VLHAIKI,FGZAIKO,KBUNIT,VLUNIT from BT020 where NRTANPIN='0000001'  (15:33:53.360)
> select TXTANPIN,PRKOUNYU,CDSIIRESAKI,VLHAIKI,FGZAIKO,KBUNIT,VLUNIT from BT020 where NRTANPIN='0000002'  (15:33:53.609)
> select TXTANPIN,PRKOUNYU,CDSIIRESAKI,VLHAIKI,FGZAIKO,KBUNIT,VLUNIT from BT020 where NRTANPIN='0000003'  (15:33:53.733)
> select NRHATTYU,SQHATTYU,DTNYUKAYOTEI,NRHATTYU,CDSIIRESAKI,QTNYUKA,PRKOUNYU,QTZAIKO,SQHATTYU,NRTORIHIKI,QTHATTYU,DTNYUKA,NRTANPIN,SQLOT,UPDCOUNTER from DT021 where NRHATTYU='0000006' and SQHATTYU=1 and UPDCOUNTER=1  (15:33:59.164)
> select TXTANPIN,PRKOUNYU,CDSIIRESAKI,VLHAIKI,FGZAIKO,KBUNIT,VLUNIT,NRTANPIN from BT020 where NRTANPIN='0000001'  (15:33:59.248)
> select TXNAME,CDSIIRESAKI from DT010 where CDSIIRESAKI='YAMADA'  (15:33:59.260)
> select DTNYUKAYOTEI,NRHATTYU,CDSIIRESAKI,QTNYUKA,PRKOUNYU,QTZAIKO,SQHATTYU,NRTORIHIKI,QTHATTYU,DTNYUKA,NRTANPIN,SQLOT from DT021 where NRTORIHIKI='0000024' and (NRHATTYU!='0000006' or SQHATTYU!=1)  (15:34:02.133)
> update DT021 set DTNYUKAYOTEI='2015-09-24', CDSIIRESAKI='YAMADA', QTNYUKA=10, PRKOUNYU=1000, QTZAIKO=200, NRTORIHIKI='0000024', QTHATTYU=10, DTNYUKA='2019-09-06', NRTANPIN='0000001', SQLOT=2, UPDCOUNTER=2 where NRHATTYU='0000006' and SQHATTYU=1 and UPDCOUNTER=1  (15:34:02.136)
> Delete  from ET100 where NRTORIHIKI = '0000024'  (15:34:02.214)
> Insert  into ET200 (NRUKEBARAI, KBDENPYO, FGVALID, KBUKEBARAI, NRTANPIN, SQLOT, TXTEKIYO, DTUKEBARAI, QTUKEBARAI, AMUKEBARAI, NRTORIHIKI, NRSANSYO, DTFYEAR, DTMSEQ)  values('0000054', '1', 'T', '10', '0000001', 2, '山田生花卸', '2019-09-06', 200, 10800, '0000024', '0000006-1', 2019, 6)   (15:34:02.254)
> select * from ET010 where NRTANPIN = '0000001' and SQLOT = 2  (15:34:02.275)
> select * from BT020 where NRTANPIN = '0000001'  (15:34:02.284)
> Update ET010 set PRZAIKO = 54, QTNYUKO = 200, DTNYUKA = '2019-09-06', DTHAIKIYOTEI = '2019-09-13', UPDCOUNTER = 2.0 where NRTANPIN = '0000001' and SQLOT = 2 and UPDCOUNTER = 1  (15:34:02.323)
> Insert  into DT100 (NRSIIRE, KBDENPYO, FGVALID, KBKAITORI, CDSIIRESAKI, TXNAME, TXTEKIYO, DTTORIHIKI, AMTORIHIKI, AMTAX, NRSIHARAI, NRTORIHIKI, NRSANSYO, DTFYEAR, DTMSEQ)  values('0000022', '1', 'T', '10', 'YAMADA', '山田生花卸', 'バラ１２号', '2019-09-06', 10000, 800, '', '0000024', '0000006-1', 2019, 6)   (15:34:02.580)
> select AMSIIRE, UPDCOUNTER from DT010 where CDSIIRESAKI = 'YAMADA '  (15:34:02.628)
> Update DT010 set AMSIIRE = 18360, UPDCOUNTER = 17.0 where CDSIIRESAKI = 'YAMADA ' and UPDCOUNTER = 16  (15:34:02.641)
> Local-commit succeeded.  (15:34:02.653)
