Insert Data into Sorted Table
来源:互联网 发布:java可以做网站吗 编辑:程序博客网 时间:2024/05/07 05:54
今天使用APPEND LINES OF
ITAB_ILLEGAL_SORT_ORDER_BLK
Error analysis
INSERT/APPEND LINES OF SrcTab ... INTO/TO DstTab ...
However, when the line 1 of the source table SrcTab was inserted, the
sorting sequence - determined for the target table DstTab via
its key - was destroyed.
仔细查看发现table2 是sorted table,如果table1的key值不是按顺序排列的话,或者table2不为空,你插入的时候导致顺序错误。都会发生dump.
解决的办法: 使用 INSERT LINES OF table1 INTO TABLE table2.
同样的道理,单条插入的时候,可以使用
INSERT line INTO TABLE sorted_table.
来代替
APPEND
The program short dumps when appending a sorted table in the wrong sort order
data: sorted_tab type sorted table of ty_tab with non-unique key key, line type ty_tab.line-key = 1.append line to sorted_tab. "works fine"line-key = 2.append line to sorted_tab. "works fine"line-key = 1.append line to sorted_tab. "<==== Short dump here"
Use INSERT in stead:
data: sorted_tab type sorted table of ty_tab with non-unique key key, line type ty_tab.line-key = 1.insert line into table sorted_tab. "works fine"line-key = 2.insert line into table sorted_tab. "works fine" line-key = 1.insert line into table sorted_tab. "works fine"
Note If you had a UNIQUE key you would still get a short dump because you're using the same key twice
- Insert Data into Sorted Table
- Insert Data into Sorted Table
- SQL Server Insert data into table
- convert the Data from Table into Insert Sentence.
- SQL SERVER – Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE
- insert into data.mdb
- insert into data.mdb
- Insert data into a table using table variables and cross join
- Required_Field_OLEDB INSERT INTO .mdb data
- insert data into Oracle Clob
- Azure Basic - Insert data into BlockBlob, Table and Queue (with Diagnostic + Azure Storage Explore)
- Insert into a Cyclic Sorted List
- Insert into a Cyclic Sorted List
- Insert into a Cyclic Sorted List
- Insert into a Cyclic Sorted List
- Insert into a Cyclic Sorted List
- insert into table 插入多条数据
- VC insert into table() values(变量)
- oracle存储过程常用技巧
- 刷卡分期的套路有多深?信用卡、花呗、白条没有善人
- hdu 1963 Investment 完全背包
- Linux下如何查看高CPU占用率线程 LINUX CPU利用率计算
- 【HDU2255】奔小康赚大钱
- Insert Data into Sorted Table
- 面向对象七大基本原则
- matplotlib(学习三----全部命令行)
- Android Gson详解(二)
- 3155: Preprefix sum
- JS禁止页面中的一些操作事件
- python中如何判断路径是否存在
- ssm的事物回滚实现
- python爬虫-->验证码处理