CLS ECHO ************************************************************************************ ECHO * ECHO * Step 5.1: Creating the layout for loading ECHO * ECHO ************************************************************************************ ECHO .SET ERROROUT STDOUT >> layout.bteq ECHO .RUN FILE logon.txt >> layout.bteq ECHO .SET DEFAULTS >> layout.bteq ECHO .SET FORMAT OFF >> layout.bteq ECHO .SET FOLDLINE OFF >> layout.bteq ECHO .SET SIDETITLES OFF >> layout.bteq ECHO .SET WIDTH 254 >> layout.bteq ECHO .SET FOLDLINE ON 7 >> layout.bteq ECHO .EXPORT REPORT FILE = dbc_col.txt; >> layout.bteq ECHO SEL >> layout.bteq ECHO ^'.FIELD^' ^(CHAR^(10^)^) ^(TITLE ^'^'^) >> layout.bteq ECHO , fname ^(TITLE ^'^'^) >> layout.bteq ECHO ,^'^*^' ^(CHAR^(3^)^) ^(TITLE ^'^'^) >> layout.bteq ECHO , TRIM(ftype) ^|^| ^';^' (CHAR(20)) ^(TITLE ^'^'^) >> layout.bteq ECHO FROM >> layout.bteq ECHO ^( >> layout.bteq ECHO SELECT >> layout.bteq ECHO rank(fieldid ASC) (char(20)) as fid >> layout.bteq ECHO ,b.FieldName (char(35)) as fname >> layout.bteq ECHO ,CASE FieldType >> layout.bteq ECHO when 'DA' Then ^'VARCHAR(10)^' >> layout.bteq ECHO when 'CF' Then ^'VARCHAR^(^' ^|^| TRIM(CAST(MAXLENGTH as INTEGER)) ^|^| ^'^)^' >> layout.bteq ECHO when 'CV' Then ^'VARCHAR^(^' ^|^| Trim(CAST(MAXLENGTH as INTEGER)) ^|^| ^'^)^' >> layout.bteq ECHO when 'I' Then ^'VARCHAR(20)^' >> layout.bteq ECHO when 'D' Then ^'VARCHAR(20)^' >> layout.bteq ECHO when 'I2' Then ^'VARCHAR(20)^' >> layout.bteq ECHO when 'I1' Then ^'VARCHAR(20)^' >> layout.bteq ECHO when 'TS' Then ^'VARCHAR(19)^' >> layout.bteq ECHO when 'F' Then ^'VARCHAR(30)^' >> layout.bteq ECHO else fieldType >> layout.bteq ECHO END (CHAR(20)) as ftype >> layout.bteq ECHO FROM >> layout.bteq ECHO dbc.tables2 a inner join dbc.tvfields b on a.tvmID = b.tableid >> layout.bteq ECHO inner join dbc.dbase c on a.databaseid = c.databaseid >> layout.bteq ECHO WHERE c.DatabasenameI = ^'%1^' >> layout.bteq ECHO AND a.TVMName = ^'%2^' >> layout.bteq ECHO ) a ORDER BY fid >> layout.bteq ECHO ; >> layout.bteq ECHO. >> layout.bteq ECHO .EXPORT RESET >> layout.bteq ECHO. >> layout.bteq ECHO .LOGOFF >> layout.bteq ECHO .QUIT >> layout.bteq BTEQ < layout.bteq > layout.log echo 'Mload Script Preparation step 1' pause