PS Mixed - Difference between sql statements and metasql statements?

GeekInterview.com > Interview Questions > Peoplesoft > PS Mixed

Go To First | Previous Question | Next Question

PS Mixed | Question 9 of 200

Difference between sql statements and metasql statements?

Total Answers and Comments: 7

Last Update: October 25, 2009

Sponsored Links

Best Rated Answer

—

Submitted by: Pallavi

SQL Statements are PLaform Dependent where as Meta-SQL statements are Platform Independent

Above answer was rated as good by the following members:
bandisdevi

June 21, 2005 01:39:20

Vaibhav

RE: Difference between sql statements and metasql statements?

Insert Selec Update Insert.

Metasql - InsertSelect Select Selectinit

Is this answer useful? Yes | No

January 31, 2006 00:21:46

R.Guru Lakshmi

RE: Different sql statements and metasql statements.

SQL - INSERT UPDATE CREATE DELETEMETASQL - BIND EXECUTE EDITS SELECT SELECTINIT SQL TABLE TRUNCATE TABLE UPDATESTAS.

Is this answer useful? Yes | No

July 07, 2006 02:50:06

kiranchitla

Member Since: July 2006 Contribution: 5

RE: Different sql statements and metasql statements.

can u specify the difference between sql and meta sql

Is this answer useful? Yes | No

August 21, 2006 01:05:23

Ruchi Bhardwaj

RE: Different sql statements and metasql statements.

SQL statements:

The SQl statements are used to fetch/retrieve update insert delete data from the database. In PeopleSoft we use the sql stmts using sqlexec or createsql. Differnet sql statements are:

Select Insert Update Delete.

Meta Sqls:

Differnet RDBMS have differne date and time formats. though the component processor takes care of the automatic convesion but at the time of using the sqlexec the automatic conversion does not take place. So in order to understand this the meta sql concept has come. Whcih we can use in diff sql stmts. for example datetimein date time currentdatetime datetimeout etc.

dateIn: This is used in the where caluse of Select and update

dateout: This is used while selecting the data.

Is this answer useful? Yes | No

December 18, 2006 08:50:54

Pallavi

RE: Difference between sql statements and metasql stat...

SQL Statements are PLaform Dependent where as Meta-SQL statements are Platform Independent

Is this answer useful? Yes | No

1 0

Overall Rating: +1

November 28, 2008 01:24:52

Nitesh.Balakrishnan

Member Since: November 2008 Contribution: 1

RE: Difference between sql statements and metasql statements?

Meta Sql are peoplesoft specifiy terms which were used to replace platform dependent SQL statements to common terms.Using Meta Sql you can write platform independent SQL statements.

Is this answer useful? Yes | No

October 25, 2009 09:32:54

bandisdevi

Member Since: April 2008 Contribution: 21

RE: Difference between sql statements and metasql statements?

Sql: - Insert update create delete.
Meta Sql: - Bind Execute Edits Select Selectinit Sql Table Truncate Table. Sql statements are platform dependent where as meta sql statements r platform independent.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank