ITPub博客

首页 > Linux操作系统 > Linux操作系统 > PeopleSoft-%InsertSelect

PeopleSoft-%InsertSelect

原创 Linux操作系统 作者:l476861438 时间:2012-05-10 15:49:00 0 删除 编辑

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博客 ” ,链接:http://blog.itpub.net/24025515/viewspace-723243/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2012-03-15

  • 博文量
    8
  • 访问量
    13392