1. Record prepared:

Record 1: RL_TEST

Fields: RL_TEST1, RL_TEST2

Record2:RL_TEST2

Fields: RL_TEST2, RL_TEST3

Screen shot:

2. Data prepared:

TRUNCATE TABLE PS_RL_TEST;
TRUNCATE TABLE PS_RL_TEST2;
INSERT INTO PS_RL_TEST2 VALUES ('A','B');
COMMIT;

Data status:

3. Meta-SQL:

Ex1:

%InsertSelect (RL_TEST, RL_TEST2)

FROM PS_RL_TEST2

Data status:

Ex2:

%InsertSelect (RL_TEST, RL_TEST2, RL_TEST1 = 'H')

FROM PS_RL_TEST2

Data status:

Ex3:

%InsertSelect (RL_TEST, RL_TEST2, RL_TEST1 = 'H', RL_TEST2='H')

FROM PS_RL_TEST2

Data status:

Ex4:

%InsertSelect (RL_TEST, RL_TEST2 B, RL_TEST1 = B.RL_TEST3)

FROM PS_RL_TEST2 B

Data status:

Note:

1. FROM clause is a must, you can never lose it.

2. In the %InsertSelect clause, it is using Record name.

In the From clause, it is using Table name.

ITPub博客

PeopleSoft-%InsertSelect