Problem with RWDBUpdater in AIX 5.3

[suparswa2004]

I am using AIX 5.3. Here I have written a code to update a table.

The code is as follows.

// get the table
l_aRWDBTable_UserWorkGroup = l_aRWDBDataBase_Mod.table("USERWORKGROUP").tag("UWG");

// get the Updater
l_aRWDBUpdater_UserWorkGroup = l_aRWDBTable_UserWorkGroup .updater();


l_aRWDBUpdater_UserWorkGroup
<< l_aRWDBTable_UserWorkGroup ["LOGINTIME"].assignl_aRWDBTable_UserWorkGroup [DB_SYSTEM_DATE]);

DB_SYSTEM_DATE is #defined as "SYSDATE"

This generates a update statement like below.

UPDATE USERWORKGROUP UWG SET UWG.LOGINTIME = uwg.SYSDATE WHERE UWG.USERID = :ph12 AND UWG.WORKGROUPID = :ph13

This obviously creates error because uwg.SYSDATE is recognised as a column.

Please note that the same code works fine on Solaris.

Please help to resolve this. And please do not advise of using RWTime::now()

That would require me to change lots of things.

Please help.