| FNLOAD DOWNLOAD to extract data from db [message #610227] |
Tue, 18 March 2014 10:50  |
 |
dag1ngapr1nce
Messages: 19
Registered: June 2012
Location: UK
|
Junior Member |
|
|
Hi I'm trying to extract data from db into ldt file to then load onto another db, however my ldt file only contains data for a single row. The DOWNLOAD sql held within the lct returns multiple rows when run against the db.
Is there a setting in either the xdf or the lct file that controls how many rows can be displayed in the ldt file.
Contents of the ldt is as follows (expecting 23 sets of XXCP_SYS_ENGINE_CTL_X data):
# $Header$
# dbdrv: exec fnd bin FNDLOAD bin &phase=daa checkfile:~PROD:~PATH:~FILE &ui_apps 0 Y UPLOAD @FND:patch/115/import/xxcp_sys_engine_ctl.lct @~PROD:~PATH/~FILE
LANGUAGE = "US"
LDRCONFIG = "xxcp_sys_engine_ctl.lct"
#Source Database valencia
#RELEASE_NAME 12.2.2
# -- Begin Entity Definitions --
DEFINE XXCP_SYS_ENGINE_CTL_X
KEY PREVIEW_CTL VARCHAR2(3)
BASE SOURCE_ID VARCHAR2(4)
BASE SHORT_CODE VARCHAR2(4)
BASE ENGINE_INTERFACE_VIEW VARCHAR2(30)
BASE PREVIEW_INTERFACE_VIEW VARCHAR2(30)
BASE TARGET_TABLES VARCHAR2(1)
BASE PASS_THROUGH VARCHAR2(1)
BASE FORCAST VARCHAR2(1)
BASE CREATED_BY VARCHAR2(15)
BASE CREATION_DATE VARCHAR2(20)
BASE LAST_UPDATED_BY VARCHAR2(15)
BASE LAST_UPDATE_DATE VARCHAR2(20)
BASE LAST_UPDATE_LOGIN VARCHAR2(15)
BASE MD_ID VARCHAR2(22)
BASE SETTLEMENT VARCHAR2(1)
BASE ENGINE_CTL_NAME VARCHAR2(50)
BASE ARCHIVE_INTERFACE_NAME VARCHAR2(30)
END XXCP_SYS_ENGINE_CTL_X
# -- End Entity Definitions --
BEGIN XXCP_SYS_ENGINE_CTL_X "0"
SOURCE_ID = "1"
SHORT_CODE = "GL"
TARGET_TABLES = "Y"
PASS_THROUGH = "Y"
FORCAST = "N"
CREATED_BY = "-1"
CREATION_DATE = "12-MAR-14"
SETTLEMENT = "Y"
END XXCP_SYS_ENGINE_CTL_X
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
