Hello Dieter
Thanks for the reply. I mentioned RECODE mode in my 1st posting as it is causing issues with source table NULLs by displaying 0 for integer and blank for character in target table ( same DDL, different box)
Also, as earlier stated , on using INDICATOR mode in FE/FL scripts , i am getting this error:
Bad file or data definition.
**** 11:32:45 The length of: COLUMN_N in row: 1 was greater than defined.
Defined: 240, Received: 25409
Please find script using INDICATOR mode below:
------------------------------------------------
FAST EXPORT SCRIPT
------------------------------------------------
.LOGTABLE LOGDATABASENAME.LOGTABLENAME;
.LOGON PRODDB/USERID,PASSWORD;
DATABASE DATABASENAME
.BEGIN EXPORT ;
.EXPORT OUTFILE UNIX DIRECTORY LOCATION/FILENAME FORMAT FASTLOAD MODE INDICATOR;
LOCKING DATABASENAME.TABLENAME FOR ACCESS
SEL * FROM DATABASENAME.TABLENAME ;
.END EXPORT ;
.LOGOFF;
------------------------------------------------
FAST EXPORT SCRIPT
------------------------------------------------
ERRLIMIT 1000;
TENACITY 4;
SESSIONS 4;
SLEEP 6;
.LOGON TESTDB/USERID,PASSWORD;
DROP TABLE LOGDATABASENAME.ET_TABLENAME;
DROP TABLE LOGDATABASENAME.UV_TABLENAME;
.SET RECORD FORMATTED; /* using it or not , iam getting same error as mentioned above */
DEFINE FILE= UNIX DIRECTORY LOCATION/FILENAME;
SHOW;
BEGIN LOADING DATABASENAME.TABLENAME
ERRORFILES LOGDATABASENAME.ET_TABLENAME
,LOGDATABASENAME.UV_TABLENAME
CHECKPOINT 0
INDICATORS;
INS DATABASENAME.TABLENAME.*;
.END LOADING;
.LOGOFF;