INTERVIEW QUESTIONS PEOPLESOFT PEOPLECODE DETAILS

Question: Difference between MetaSQL and normal SQL in PeopleCode?

Answer: SQL Statements are Platform Dependent, where as MetaSQL statements are Platform Independent.
MetaSQL: - %Bind, %Execute Edits, %Select, %SelectInit, %Sql, %Table, %Truncate Table.
SQL: The SQL statements are used to fetch/retrieve, update, insert, delete data from the database. In PeopleSoft we use the SQL statements using SQLExec or CreateSQL. Different SQL statements are: Select, Insert, Update, Create and Delete.
MetaSQL: Different RDBMS have different date and time formats. Though the component processor takes care of the automatic conversion but at the time of using the SQLExec the automatic conversion does not take place. So in order to understand this, MetaSQL concept has come. Which we can use in diff SQL stmts. for example %datetimein, %date, %time, %currentdatetime, %datetimeout etc.
%dateIn: This is used in the where clause of "Select and update"
%dateout: This is used while selecting the data.

SQL Statements are Platform Dependent, where as MetaSQL statements are Platform Independent.
MetaSQL: - %Bind, %Execute Edits, %Select, %SelectInit, %Sql, %Table, %Truncate Table.
SQL: The SQL statements are used to fetch/retrieve, update, insert, delete data from the database. In PeopleSoft we use the SQL statements using SQLExec or CreateSQL. Different SQL statements are: Select, Insert, Update, Create and Delete.
MetaSQL: Different RDBMS have different date and time formats. Though the component processor takes care of the automatic conversion but at the time of using the SQLExec the automatic conversion does not take place. So in order to understand this, MetaSQL concept has come. Which we can use in diff SQL stmts. for example %datetimein, %date, %time, %currentdatetime, %datetimeout etc.
%dateIn: This is used in the where clause of "Select and update"
%dateout: This is used while selecting the data. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question