Hi All I am facing an issue when I am trying to execute Ant Script in Suse Linux Environment. I am using Ant Version 1.6.1. I am using exec Tag in Build.xml to make connection to DB2 Database and then using Exec Tag again to execute a SQL File
<exec executable="db2" output="db2-nagano.txt" append="true"> <arg line="-v CONNECT TO dummy USER db2admin USING db2pass" /> </exec> <exec executable="db2" output="db2-nagano.txt" append="true"> <arg line="-f getNaganoInfo.sql" /> </exec> In this case I would like that both Exec Commands should execute in same Shell Environment so that Connection made by First Tag can be used by Tag 2 However I guess Ant is executing both the Command in different shell environment and therefore connection made is not passed to next command while executing sql file. Hence I am getting Error for "No Connection made to database". This Script seems to be working perfectly fine in Windows Environment. Also If I manually type my Command on prompt at Linux shell then also I get correct result. Only when I try to do this task using Ant Script I am getting this Error which suggest that exec Command is not executing in same shell in Linux. Can some one please suggest me workaround for this issue as this has become a High Prioroty Issue. Thanks and Regards ------------------------------------------------------------------------------------------------------------------ Kapil Bajaj India Software Labs IBM Software Group. Email : [EMAIL PROTECTED]