Skip to Content
0
Former Member
Jun 21, 2008 at 04:29 PM

BPC package to copy date FRM one application to another

100 Views

Hello everyone

i don't know how to modifiy the default copy package in data manager, to copy data, not within a application, but from one application to another

please can you provide any help please , or give any advice, r where i can find help to modify the code

thanks in advance

'DEBUG(ON)

PROMPT(RADIOBUTTON,%CLEARDATA%,"Select the method for copying the data from the source to destination database",0,{"Merge data values (Copies specified records, leaving all remaining records in the destination intact)","Replace && clear data values (Copies specified records, and clears the data values for any records that mirror each entity/category/time combination defined in the source)"},{"0","1"})

PROMPT(RADIOBUTTON,%RUNLOGIC%,"Select whether to run default logic for stored values after copying",0,{"Yes","No"},{"1","0"})

PROMPT(RADIOBUTTON,%CHECKLCK%,"Select whether to check work status settings when importing data.",1,{"Yes, check for work status settings before importing","No, do not check work status settings"},{"1","0"})

PROMPT(COPYMOVEINPUT,%SELECTION%,%TOSELECTION%,"Select the members to COPY and where to",%DIMS%)

INFO(%TEMPFILE1%,%TEMPPATH%%RANDOMFILE%)

INFO(%TEMPFILE2%,%TEMPPATH%%RANDOMFILE%)

TASK(DUMP,APPSET,%APPSET%)

TASK(DUMP,APP,%APP%)

TASK(DUMP,USER,%USER%)

TASK(DUMP,FILE,%TEMPFILE1%)

TASK(DUMP,SQL,%SQLDUMP%)

TASK(DUMP,DATATRANSFERMODE,2)

TASK(CONVERT,INPUTFILE,%TEMPFILE1%)

TASK(CONVERT,OUTPUTFILE,%TEMPFILE2%)

TASK(CONVERT,CONVERSIONFILE,%CONVERSION_INSTRUCTIONS%)

TASK(LOAD,APPSET,%APPSET%)

TASK(LOAD,APP,%APP%)

TASK(LOAD,USER,%USER%)

TASK(LOAD,FILE,%TEMPFILE2%)

TASK(LOAD,DATATRANSFERMODE,4)

TASK(LOAD,DMMCOPY,1)

TASK(LOAD,CLEARDATA,%CLEARDATA%)

TASK(LOAD,RUNTHELOGIC,%RUNLOGIC%)

TASK(LOAD,CHECKLCK,%CHECKLCK%)

BEGININFO(%SQLDUMP%)

select %FACTDIMS%,SUM(SIGNEDDATA) AS SIGNEDDATA FROM (SELECT %FACTDIMS%,sum(SIGNEDDATA) as SIGNEDDATA FROM (SELECT %FACTDIMS%, SIGNEDDATA FROM TBLFACT%APP% WHERE %SELECTION% UNION ALL SELECT %FACTDIMS%,SIGNEDDATA FROM TBLFACTWB%APP% WHERE %SELECTION% UNION ALL SELECT %FACTDIMS%,SIGNEDDATA FROM TBLFAC2%APP% WHERE %SELECTION%) AS SourceTable GROUP BY %FACTDIMS% union all SELECT %FACTDIMS%,0 as SIGNEDDATA FROM (SELECT %FACTDIMS%,0 AS SIGNEDDATA FROM TBLFACT%APP% WHERE %TOSELECTION% UNION ALL SELECT %FACTDIMS%,0 AS SIGNEDDATA FROM TBLFACTWB%APP% WHERE %TOSELECTION% UNION ALL SELECT %FACTDIMS%,0 AS SIGNEDDATA FROM TBLFAC2%APP% WHERE %TOSELECTION%) AS zeroTable GROUP BY %FACTDIMS%) as TotalTable group by %FACTDIMS% OPTION(MAXDOP 1)

ENDINFO

ENDIFO