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 |
|---|---|---|
| how to create application status in peoplesoft campus solutions 8.9 version | PeopleSoft Functional | 05/17/2012 - 4:09am |
| horizantal text in charts | PeopleSoft Technical | 05/10/2012 - 4:57am |
| no current buffer context error | PeopleSoft Technical | 05/10/2012 - 1:19am |
| Integration Broker : Operating Instance/Pub Contracts/Sub Contracts | PeopleSoft Technical | 04/24/2012 - 11:05am |
Recent comments
1 day 42 min ago
2 days 13 hours ago
2 days 13 hours ago
2 days 23 hours ago
3 days 4 hours ago
4 days 4 hours ago
5 days 4 hours ago
1 week 3 days ago
1 week 3 days ago
1 week 4 days ago