Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Functions that we can use in Peoplesoft 1
- Thread starter learn2PS
- Start date
-
1
- #2
Hi Learn2PS,
That is a pretty broad question - and not sure how much PeopleBooks will cover in the query section.
However at a high level, query will support most if not all functions of the underlying database that PeopleSoft is running on. Having said that, it is often a chore to convince query that it can use the function. One of the frustrations of query is that often a function will only work on the right side expression - not the left even though the sql produced is the same - so if the code looks right and fails, try switching where the function is used.
A couple of things it won't do - you can do unions, but not "union all", no result intersect/minuses type functions, and you cannot use a "from" clause or comments in an expression.
There is also support for a number of metasql variables if you want to use those - you can find reference to these in the PeopleCode reference books.
Not sure of that quite answers your question, but happy to help if you have some examples of what you are trying to do.
That is a pretty broad question - and not sure how much PeopleBooks will cover in the query section.
However at a high level, query will support most if not all functions of the underlying database that PeopleSoft is running on. Having said that, it is often a chore to convince query that it can use the function. One of the frustrations of query is that often a function will only work on the right side expression - not the left even though the sql produced is the same - so if the code looks right and fails, try switching where the function is used.
A couple of things it won't do - you can do unions, but not "union all", no result intersect/minuses type functions, and you cannot use a "from" clause or comments in an expression.
There is also support for a number of metasql variables if you want to use those - you can find reference to these in the PeopleCode reference books.
Not sure of that quite answers your question, but happy to help if you have some examples of what you are trying to do.
- Status
Similar threads
- Locked
- Question
- Locked
- Question