analytics/informix/etc/smi_load.bat

@echo off

REM Allow opening of each database in it's locale
set DBNLS=2

REM Access system databases in English
set DB_LOCALE=en_us.8859-1
set CLIENT_LOCALE=en_us.8859-1

set OUTFILE=%INFORMIXDIR%\etc\buildsmi.out
set SYSEXTSPSQLFILE=%INFORMIXDIR%\etc\tempsysextsp.sql
set SYSAUDITOUTFILE=%INFORMIXDIR%\etc\tempsysaudit.out
set COLCOUNT=0

cd %INFORMIXDIR%\etc
if errorlevel 1 goto BADDIR

IF EXIST %SYSAUDITOUTFILE% (
   FOR /f "delims== " %%i IN ('type %SYSAUDITOUTFILE%') do set COLCOUNT=%%i
   del %SYSAUDITOUTFILE%
) ELSE set COLCOUNT=0

IF %COLCOUNT% == 18 (
%INFORMIXDIR%\bin\dbaccess sysmaster - < %INFORMIXDIR%\etc\smi_load.in2 >> %OUTFILE% 2>&1
) ELSE (
%INFORMIXDIR%\bin\dbaccess sysmaster - < %INFORMIXDIR%\etc\smi_load.in1 >> %OUTFILE% 2>&1
)

IF NOT EXIST %INFORMIXDIR%\etc\sysextspaces.unl goto CHECKFAILURE

echo load from '%INFORMIXDIR%\etc\sysextspaces.unl' insert into sysextspaces;> %SYSEXTSPSQLFILE%
dbaccess -e sysmaster - < %SYSEXTSPSQLFILE% > %OUTFILE% 2>&1
del /F %SYSEXTSPSQLFILE%

:CHECKFAILURE
findstr /I "error" %OUTFILE%
if errorlevel 1 goto LOASUCC

echo "The reload of sysmaster failed." >> %OUTFILE%
echo "See %INFORMIXDIR%\etc\buildsmi.out for more information." >> %OUTFILE%
goto DONE

:BADDIR
echo error: Could not chdir to %INFORMIXDIR%\etc >> %OUTFILE%
goto DONE

:LOASUCC
echo The load of sysmaster was successful.

:DONE