生成 SPLX 文件

A

1

=connect("demo")

2

="D:\\file\\ETL\\"

3

=A1.query("SELECT Distinct GENDER FROM EMPLOYEE")

4

=A3.(GENDER).new(#:gender_id,~:gender).keys@i(gender)

5

=file(A2+"EMPLOYEE_GENDER.btx").export@b(A4)

6

=file(A2+"department.txt").import@t(DEPT,MANAGER;," ")

7

=A6.keys@i(DEPT)

8

=file(A2+"department.btx").export@b(A7)

9

=A1.cursor("SELECT EID,NAME,GENDER,BIRTHDAY,DEPT,SALARY,

FAMILY.EID AS FAMILY_EID,FAMILY.NAME AS FAMILY_NAME,RELATION,FAMILY.GENDER AS FAMILY_GENDER,AGE

FROM EMPLOYEE

LEFT JOIN FAMILY

ON EMPLOYEE.EID=FAMILY.EID

WHERE EID<?",arg1)

10

=A9.sortx(EID).new(#@:id,EID,NAME,A4.pfind(GENDER):GENDER,BIRTHDAY,A7.pfind(DEPT):DEPT,SALARY,

age(BIRTHDAY):EMP_AGE,FAMILY_EID,FAMILY_NAME,RELATION,FAMILY_GENDER,AGE)

11

=file(A2+"EMPLOYEE.ctx").create@yp(#id,EID,NAME,GENDER,BIRTHDAY,DEPT,SALARY,EMP_AGE,

FAMILY_EID,FAMILY_NAME,RELATION,FAMILY_GENDER,AGE).append(A10).close()

12

=A1.close()