Follow the below steps to create the trigger for the tables
1.Create the Sequence
Syntax
Create Sequence G02491P.TRIGGER_SEQ1 as INTEGER
Start With 1
Increment by 1
MinValue 1
MaxValue 2147483647
Cache 24
2.Create the function
[code]
Syntax
Create Function G02491P.get_next ()
Returns INTEGER
Specific get_next
Language SQL
Deterministic
External Action
Reads SQL Data
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
Recent comments
2 years 16 weeks ago
2 years 21 weeks ago
2 years 21 weeks ago
2 years 22 weeks ago
2 years 23 weeks ago
2 years 23 weeks ago
2 years 25 weeks ago
2 years 27 weeks ago
2 years 30 weeks ago
2 years 35 weeks ago