Data Mover Commands

Data Mover

PeopleSoft Data Mover is an administrative tool used by DBA's. It is used for many purpose as mentioned:

1. It is used to move data from one database to another.
2. With Data mover we can create scripts not objects.
3. To install PeopleSoft database we require Data Mover.
4. Using Data Mover you can take backup of data.
5. You can rename record's and field's.

Data Mover Commands

• Export: Used to export data out of the database. A file is specified and the data gets loaded into it. Later this data can be used for importing into the same / different databases.

        SET OUTPUT C:/Folder_Name/File.DAT;

        SET LOG C:/Folder_Name/File.LOG;

        EXPORT Table_Name;

Populate values of drop-down list through peoplecode

Sometime we need to populate values of drop-down list based on value of another field or some other condition.

/*Declare Local Variable*/

Local SQL &SQL;

Local Rowset &rset;

Local Field &field;

Local string &type, &descr;

/* Getting the level 0 and level 1 records */

&rset= GetLevel0()(1).GetRowset(Scroll.TEST);

/* Getting the field to which the drop down is attached */

&field = &rset(1).GetRecord(Record.TEST).GetField(Field.VALUE);

/* Clearing all existing values*/

&field.ClearDropDownList();

/* SQL for fetching values that to be added in drop down.*/

&SQL = CreateSQL("select fieldvalue, xlatlongname from psxlatitem where fieldname='VALUE’");

While &SQL.Fetch(&fieldvalue, &xlatlongname)

   & field.AddDropDownItem(&fieldvalue, &xlatlongname);

End-While;