Difference between sql statements and metasql statements?

Showing Answers 1 - 4 of 4 Answers

Vaibhav

  • Jun 21st, 2005
 

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

  Was this answer useful?  Yes

R.Guru Lakshmi

  • Jan 31st, 2006
 

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

  Was this answer useful?  Yes

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

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions