how to Grant the Schema :-
GRANT SELECT ON SCHEMA "SCHEMA NAME" TO _SYS_REPO WITH GRANT OPTION
(We can give semicolon";" also at the end of the statement.
Coding for Payment Due Date :- 1}Create two new fields by using below Logic: 2} (1) Payment_due_date = if "SHKZG" ='S' then Date(ZFBDT) , else add days between Date(ZFBDT) and int(ZBD1T)
Comments
Post a Comment