Tomas Monks
  • Male
Share on Facebook
Share

Tomas Monks's Discussions

SQLEXEC function..

Started this discussion. Last reply by Pradeep Nimmathota Apr 19. 4 Replies

What is the purpose of the SQLEXEC function? What are its benefits and draw backs?Continue

Tree Changes Audit

Started this discussion. Last reply by Sharad Singh Jun 26, 2013. 3 Replies

Is it possible to audit changes to a tree? I tried adding audit field change (ADD, UPDATE, DELETE) to PSTREELEAF and PSTREENODE with no luck.Continue

Gifts Received

Gift

Tomas Monks has not received any gifts yet

Give a Gift

 

Tomas Monks's Page

Latest Activity

Pradeep Nimmathota replied to Tomas Monks's discussion SQLEXEC function..
"SQLExec function is used to perform database operation (insert,update,delete,select etc) from peoplecode. It starts a new session for database connection & commits. and also effects the performance  it is better to use CreateSQL, which…"
Apr 19
Satyajit Mishra replied to Tomas Monks's discussion SQLEXEC function..
"hi SQLExec function is used to perform database operation (insert,update,delete,select etc) from peoplecode. It starts a new session for database connection & commits. "
Jun 12, 2016
Tomas Monks liked Delbert Deitz's video
May 27, 2014
Teddy Leight liked Tomas Monks's discussion SQLEXEC function..
Mar 20, 2014
Dori Charlie replied to Tomas Monks's discussion SQLEXEC function..
"SQLEXEC is used to execute the sql statements (select, insert,update,delete).We can get only one row at a time."
Feb 20, 2014
Tomas Monks posted a discussion

SQLEXEC function..

What is the purpose of the SQLEXEC function? What are its benefits and draw backs?See More
Feb 19, 2014
Bo Bernstein liked Tomas Monks's discussion Tree Changes Audit
Jun 28, 2013
Sharad Singh replied to Tomas Monks's discussion Tree Changes Audit
"I agree with Waneta, you can create database level trigger to record the audit entries. Step 1: Navigate to PeopleTools > Utilities > Audit > Update Database Level Auditing and create the trigger…"
Jun 26, 2013
Dori Charlie liked Tomas Monks's discussion Tree Changes Audit
Jun 25, 2013
Waneta Winkleman replied to Tomas Monks's discussion Tree Changes Audit
"Can be achieved by creating three different database triggers for ADD, UPDATE & DELETE if you are interested to Audit only a particular Tree i.e. DEPARTMENT."
Jun 25, 2013
Tomas Monks joined Auri Gray's group
Thumbnail

Peoplesoft Grant Management

PeopleSoft Grants Management group handles issues and queries related with Grants, Research Administration, proposal generation, award tracking, bill generationSee More
Jun 10, 2013
Stuart Trott liked Tomas Monks's discussion Tree Changes Audit
Jun 4, 2013
Tomas Monks liked Willy Raynes's discussion Financial Batch jobs were failing due to too many files opened
Jun 4, 2013
Teddy Leight liked Tomas Monks's discussion Tree Changes Audit
Jun 4, 2013
Clementine Grimshaw liked Tomas Monks's discussion Tree Changes Audit
Jun 3, 2013

Comment Wall

  • No comments yet!

You need to be a member of myPeopleSoft to add comments!

Join myPeopleSoft

 
 
 

PeopleSoft Jobs in US

Videos

  • Add Videos
  • View All

© 2017   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service