PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Datamover script issues

edited Jun 30, 2011 10:15AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 4 commentsAnswered
 I am trying to run the below export script using Datamover and getting syntax error but, while I try to run in WinSQL (DB2) the select script works fine

SET LOG C:\GL\ISSUE\LEDGER_ADB_HLD_20110629_00336_Dup.log;
SET OUTPUT C:\GL\ISSUE\LEDGER_ADB_HLD_20110629_00336_Dup.Dat;
EXPORT LEDGER_ADB_HLD A WHERE A.BUSINESS_UNIT = '00336'
AND EXISTS (SELECT 'X'
  FROM PS_LEDGER_ADB_HLD B
  WHERE A.BUSINESS_UNIT     = B.BUSINESS_UNIT  AND A.FISCAL_YEAR       =  B.FISCAL_YEAR     
  AND A.ACCOUNTING_PERIOD =  B.ACCOUNTING_PERIOD   AND A.LEDGER     =  B.LEDGER      
  AND A.ACCOUNT    =  B.ACCOUNT   AND A.ALTACCT        =  B.ALTACCT      

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center