what is the difference between the %SELECT and %SELECTINIT meta sql functions.

%select : if any values have not selected then previous value will be there

%selectinit : if any values have not selected then previous value will reinitiate to null

Different sql statements and metasql statements.

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

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.

Difference between 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:
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, the meta sql 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 Meta-SQL statements are Platform Independent