You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

About Meta SQL

2 replies [Last post]
maheshkundu's picture
User offline. Last seen 10 years 33 weeks ago. Offline
Joined: 05/16/2008
Posts: 12

Wht's the concept of Meta SQL in App engine..Kindly can anybody explain it in details???
becoz i've seen it from peoplebooks..but not getting properly...........thanx in advance.....

Nitin's picture
User offline. Last seen 5 years 43 weeks ago. Offline
Joined: 06/30/2008
Posts: 73
Re: About Meta SQL

Meta SQL plays an important role on PeopleSoft language.It eases the complication involved in writing Platform specific code from developer prospective.
PeopleTools convert the Meta SQL into platform specific code at run time.

Nitin Bhatia

Lepa's picture
User offline. Last seen 2 years 20 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: About Meta SQL

Nitin is correct. Also, some meta sql like %select and %bind are almost always used in application engines. %select to assign values to variables and %bind to get that value from the variable. Another meta SQL that you see used most often is the %table. It is really easy and simple to use. Instead of writing your table name as PS_TABLE_NAME, you do the following %TABLE(TABLE_NAME).

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog