Vaibhav

• Jun 21st, 2005

 

Insert, Selec, Update, Insert.  
 
Metasql - %InsertSelect, %Select, %Selectinit

R.Guru Lakshmi

• Jan 31st, 2006

 

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

kiranchitla

 Profile Answers by kiranchitla 

• Jul 7th, 2006

 

can u specify the difference between sql and meta sql

Ruchi Bhardwaj

• Aug 21st, 2006

 

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.

Pallavi

• Dec 18th, 2006

 

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

Nitesh.Balakrishnan

 Profile Answers by Nitesh.Balakrishnan 

• Nov 28th, 2008

 

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.

bandisdevi

 Profile Answers by bandisdevi Questions by bandisdevi

• Oct 25th, 2009

 

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.