Return
-
Title
Compare fails with "Default host is not defined" when running via .bat file on Windows. -
Description
Compare fails with "Default host is not defined: use the 'host' command or '[on host]' option" when running compare from Windows via .bat file.
-
Cause
Shareplex does not like spaces in the where clause when used via a Windows .bat file.
-
Resolution
Remove the space before and after the > in the where clause, for example:
cd "C:\Program Files\Quest Software\SharePlex\bin\"
C:
REM Max length of a Shareplex command is 255 Chars below is only 147 Chars
SP_CTRL COMPARE TABLE JDEDTA.F0101 TO JDEDTA.F0101 TARGET SORAPRDCAL2@O.PROD KEY WHERE "ABUPMJ>JDEDTA.JULIENDATE(SYSDATE-250)" on soraprdcal:2200