gbase数据、南大通用产品文档：GBase8a定长文本加载

示例
建表语句：
CREATE TABLE t (i INT, vc VARCHAR(10), c CHAR(10));
数据文件：
099121413321565086687636597553
587231374843706182211816625391
371909169687901865998438248540
768084517620945445680375033918
521019961269855481454503093679
872098120283548973190459767139
047458772732776053730815273248
749195982779059832391367570454
773781140773581380240166238167
733086147402918352113773075709
加载过程：
gbase> LOAD DATA INFILE 'ftp://192.168.88.141/load_data/definer.tbl'
INTO TABLE test.t DATA_FORMAT 4 FIELDS LENGTH'1,10,10';
Query OK, 10 rows affected
Task 1128 finished, Loaded 10 records, Skipped 0 records
查询入库数据：
gbase> select * FROM dual;
+------+------------+------------+
| i
| vc
| c
|
+------+------------+------------+
|
3 | 7190916968 | 7901865998 |
|
0 | 4745877273 | 2776053730 |
|
0 | 9912141332 | 1565086687 |
|
7 | 7378114077 | 3581380240 |
|
5 | 8723137484 | 3706182211 |
|
7 | 3308614740 | 2918352113 |

GBase 8a MPP Cluster 产品手册
5 数据库管理指南
文档版本953（2022-09-15）
南大通用数据技术股份有限公司
1205
|
7 | 6808451762 | 0945445680 |
|
5 | 2101996126 | 9855481454 |
|
8 | 7209812028 | 3548973190 |
|
7 | 4919598277 | 9059832391 |
+------+------------+------------+
10 rows in set

DECLARE
p VARCHAR2(30);
n PLS_INTEGER := 37;
BEGIN
FOR j in 2..ROUND(SQRT(n)) LOOP
IF n MOD j = 0 THEN
p := ' is not a prime number';
GOTO print_now;
END IF;
END LOOP;
p := ' is a prime number';
<>
DBMS_OUTPUT.PUT_LINE(TO_CHAR(n) || p);
END;

--Result:
--37 is a prime number

GBase 8s PL/SQL手册
南大通用数据技术股份有限公司
- 57 -

NUMERIC 数据类型与定点 DECIMAL 同义。