Required Information

SADIQ AKBAR

Hi All,

Im newbie with Opentext,I would like to ask help on Opentext API,I have some employee documents in opentext and each document has unique value like Employee Number,and I need to add one more field and update all the existing records with new value which exists in another MS SQL Table

Lets say ,records in Opentext has as following

EmpNo name JoinDate (new Field)

1011 Jack
1019 Nelson
1022 Roi

In Ms Sql Table ,i have
EmpNo name JDate
1011 Jack 10/10/2009
1019 Nelson 21/12/2011
1022 Roi 28/03/2012

I need to update JDate with Join Date in Open text ,How can i achieve this ?Please help