Subject ISQL behaviour different in windows and linux
Author McKenna, Simon (RGH)
Hi,

When passing command line parameters, why does
the Windows version of ISQL accept db aliases
and the Linux version does not?

Or...what am I doing wrong in the Linux call?

Background:

Developing using Eclipse in both Windows and Linux,
using Ant as a cross-platform build tool.

Example:

<target name="Drop-Database" depends="Check-Database-Exists" if="Database.Exists">
<exec executable="${sql.bin}">
<arg line='${db.file} -u "${sql.user}" -p "${sql.pass}" -i "${sql.scripts}/Drop.Database.sql"'/>
</exec>
</target>

Under Windows, db.file property can be an alias,
under Linux ISQL assumes it's the database name
and assumes the current directory is where the
database lives.

I believe the alias set in Linux is correct as I
can connect to the database through ibWebAdmin and
my own app using an alias, just not ISQL.

Caveat: I'm still feeling my way around Linux and
Ant, so it's probably my mistake, be gentle :)

peace - si
sshnug.com