団体一括自動プロポーザル 開発時の考慮点【PRGR／PRCLにﾌｨｰﾙ

団体一括自動プロポーザル 開発時の考慮点


【PRGR／PRCLにﾌｨｰﾙﾄﾞを追加する際の注意点】
① 必ずMEGAと同時に本番移行しなければならない。
（事前にﾌｧｲﾙのみ修正して本番移行するわけにはいかない）
（例外）
PCGR/PRCLのﾌｨｰﾙﾄﾞを拡張した際は、PCより先にLIFE/Jを本番移行することが可能である。
〈申込ﾎｽﾄ送信〉ｱﾌﾟﾘｹｰｼｮﾝでLife/JのPRGR/PRCLに値をｾｯﾄする際にSQL文のINSERT文で明示的にﾌｨｰﾙﾄﾞを指定しているためｴﾗｰとならない。（拡張ﾌｨｰﾙﾄﾞが数字項目の際は、不可）

② 本番移行後にﾌｧｲﾙに権限設定する必要がある。
本番移行の翌朝（なるべく朝一）で、拡張したﾌｧｲﾙの権限設定を行なう。

【理由】
〈申込ﾎｽﾄ送信〉ｱﾌﾟﾘｹｰｼｮﾝが、Life/JのDB（PRGR, PRCL）にｱｸｾｽする際に、#APPUPLDR#というﾕｰｻﾞｰﾌﾟﾛﾌｧｲﾙを使用している。
ﾌｧｲﾙを拡張すると、#APPUPLDR#に付与されているﾌｧｲﾙの*CHANGE権限が消えてしまうため、権限を設定し直す必要がある・
テスト環境のﾌｧｲﾙも拡張した時点で権限を設定し直さないと、MEGAからﾌﾟﾛﾎﾟｰｻﾞﾙﾃﾞｰﾀをｱｯﾌﾟﾛｰﾄﾞすることができない点に注意。

③ 権限付与 → GRTOBJAUT（PF, LFのそれぞれに権限付与する必要あり）

Kết quả (Anh) 1:

Organizations place automatic proposal development considerations[Note that when you add a field to the PRGR/PRCL](1) must be MEGA and at the same time not to production migration.(To modify only files prior to production migration does not go)(Exception)Live migration LIFE/J prior to the PC when you extend a PCGR/PRCL field that is feasible.When q applications sent] application to set the value Life/J PRGR/PRCL in the SQL INSERT statement to explicitly specify field error. (Extended field item numbers when possible)(2) you need to set file permissions after the production migration.The morning after the production migration (as much as possible morning one), do permission settings for a file extension.[Reason]Q request sent"application to access Life/J DB (PRGR, PRCL) with user profile named #APPUPLDR#.File file to grow, and been granted to #APPUPLDR# * need to reset permissions CHANGE permission, so that-Note from MEGA upload proposal data again and set permissions at an extension file in the test environment, and you can't.(3) authorization → GRTOBJAUT (need to grant to each of the PF, LF and)

Kết quả (Anh) 2:

Organizations collectively automatic proposal considerations during development


[Notes when you add a field to PRGR / PRCL]
① must always be MEGA at the same time as the production migration.
(Beforehand not afford to production shifts to correct only file)
(exception)
when an extension of the field of PCGR / PRCL is, it is possible to production shifts earlier in the LIFE / J than PC.
Not an error because it specifies an explicit field in the INSERT statement in SQL statements when you set the value to PRGR / PRCL of Life / J in the <application host transmission> application. (When extension field is a number items, impossible)

② there is a need to permission settings in the file after the production migration.
In the next morning of production shifts (as much as possible first thing in the morning), and the authority setting of the expanded file.

[Reason]
<application host transmission> application, Life / J of DB (PRGR, PRCL) to access to, are using a user profile that is named # APPUPLDR #.
When you extend the file, # for APPUPLDR * CHANGE authority of grant that have been file to # disappears, there is a need to re-set the authority and
If you do not re-set the permissions at the time was also extended file test environment, Note that it is not possible to upload the proposal data from MEGA.

③ authorization → GRTOBJAUT (PF, there needs to be authorization to each of LF)

Kết quả (Anh) 3:

Considerations of developing automatic Consulting GroupNote that when you add the ﾌｨｰﾙﾄﾞ in PRGR and PRCL.As the production process should be MEGA and at the same time.In the production process must not be modified ﾌｧｲﾙ only)(exception).When the expansion of PCGR and PRCL ﾌｨｰﾙﾄﾞ, it is possible to PC LIFE J production and transition.In the application ﾎｽﾄ transmission. ｱﾌﾟﾘｹｰｼｮﾝ in Life and J PRGR and PRCL ｾｯﾄ value of SQL INSERT sentence statement explicitly specified for ﾌｨｰﾙﾄﾞ ｴﾗｰ. When the number of items (I, ﾌｨｰﾙﾄﾞ extension)It is necessary to transfer from production to ﾌｧｲﾙ after setting.The production of the next morning morning shift (if possible), the authority of the ﾌｧｲﾙ is carried out."The reason.That ﾎｽﾄ transmission application. ｱﾌﾟﾘｹｰｼｮﾝ, Life and J DB (PRGR, PRCL) ｱｸｾｽ, using ﾕｰｻﾞｰﾌﾟﾛﾌｧｲﾙ called # APPUPLDR #.In order to disappear CHANGE ﾌｧｲﾙ authority given to 、# APPUPLDR # ﾌｧｲﾙ to expand, the need to set and authorityExtended test environment at the time of ﾌｧｲﾙ is not set, the authority will not be able to MEGA from ｱｯﾌﾟﾛｰﾄﾞ ﾌﾟﾛﾎﾟｰｻﾞﾙﾃﾞｰﾀ attention.Whether the authority is given to each of the GRTOBJAUT (PF, LF authorization to need.