You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ant.apache.org by Dwayne Walker <wb...@gmail.com> on 2007/04/09 19:57:43 UTC
calling a DB2 request.
Hi I am having a problem passing some sql to the db2cmd via ant. This
is very confusing as I am doing this exact thing elseware with no
problem (just differant sql, and I have verified the sql is valid) but
in this one I am having problems. Any time I run this I get the
folowing message from the db2 clp window that opens up.
SQL0104N An unexpected token "SET" was found following
"<identifier>".
Expected tokens may include: "NEW". SQLSTATE=42601
C:\eclipse_workspace\massSQL>
I don't know what is going on here but I am by no means familiar with
db2cmd and all that so any help is apreachated. If I could get this to
work in a batch file or from a command line I am sure I could get the
ant part of it on my own. it is the db2 that is giving me issues.
thanks. Dwayne
this is the console log from ant of what is being passed.
Apache Ant version 1.7.0 compiled on December 13 2006
Buildfile: C:\eclipse_workspace\massSQL\count.xml
parsing buildfile C:\eclipse_workspace\massSQL\count.xml with URI =
file:/C:/eclipse_workspace/massSQL/count.xml
Project base dir set to: C:\eclipse_workspace\massSQL
Build sequence for target(s) `query' is [init, query]
Complete build sequence is [init, query, query3, query2, ]
init:
[antlib:org.apache.tools.ant] Could not load definitions from resource
org/apache/tools/ant/antlib.xml. It could not be found.
[loadfile] loading C:\eclipse_workspace\massSQL\transactionCount.sql
into property sql
[loadfile] loaded 383 characters
[echoproperties] #Ant properties
[echoproperties] #Mon Apr 09 11:12:51 CDT 2007
[echoproperties] DSTAMP=20070409
[echoproperties] TODAY=April 9 2007
[echoproperties] TSTAMP=1112
[echoproperties] ant.core.lib=C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant.jar
[echoproperties] ant.file=C\:\\eclipse_workspace\\massSQL\\count.xml
[echoproperties] ant.file.dailyTransactions=C\:\\eclipse_workspace\
\massSQL\\count.xml
[echoproperties] ant.home=C\:\\eclipse\\plugins\\org.apache.ant_1.7.0
[echoproperties] ant.java.version=1.5
[echoproperties] ant.library.dir=C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib
[echoproperties] ant.project.name=dailyTransactions
[echoproperties] ant.version=Apache Ant version 1.7.0 compiled on
December 13 2006
[echoproperties] awt.toolkit=sun.awt.windows.WToolkit
[echoproperties] basedir=C\:\\eclipse_workspace\\massSQL
[echoproperties] database=db0z
[echoproperties] eclipse.pdebuild.home=/C\:/eclipse/plugins/
org.eclipse.pde.build_3.2.1.r321_v20060823/./
[echoproperties] eclipse.pdebuild.scripts=/C\:/eclipse/plugins/
org.eclipse.pde.build_3.2.1.r321_v20060823/scripts/
[echoproperties] eclipse.pdebuild.templates=/C\:/eclipse/plugins/
org.eclipse.pde.build_3.2.1.r321_v20060823/templates/
[echoproperties] errorFile=dailyTransactionsError.txt
[echoproperties] file.encoding=Cp1252
[echoproperties] file.encoding.pkg=sun.io
[echoproperties] file.separator=\\
[echoproperties] java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment
[echoproperties] java.awt.printerjob=sun.awt.windows.WPrinterJob
[echoproperties] java.class.path=C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-antlr.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-apache-bcel.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-apache-bsf.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-apache-log4j.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-apache-oro.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-apache-regexp.jar;C\:\\eclipse\\plugins
\\org.apache.ant_1.7.0\\lib\\ant-apache-resolver.jar;C\:\\eclipse\
\plugins\\org.apache.ant_1.7.0\\lib\\ant-commons-logging.jar;C\:\
\eclipse\\plugins\\org.apache.ant_1.7.0\\lib\\ant-commons-net.jar;C\:\
\eclipse\\plugins\\org.apache.ant_1.7.0\\lib\\ant-jai.jar;C\:\\eclipse\
\plugins\\org.apache.ant_1.7.0\\lib\\ant-javamail.jar;C\:\\eclipse\
\plugins\\org.apache.ant_1.7.0\\lib\\ant-jdepend.jar;C\:\\eclipse\
\plugins\\org.apache.ant_1.7.0\\lib\\ant-jmf.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-jsch.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-junit.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-launcher.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-netrexx.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-nodeps.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-starteam.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-stylebook.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-swing.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-testutil.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-trax.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-weblogic.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\commons-net-1.4.1.jar;C\:\\eclipse\\plugins
\\org.apache.ant_1.7.0\\lib\\jakarta-oro-2.0.8.jar;C\:\\eclipse\
\plugins\\org.apache.ant_1.7.0\\lib\\xercesImpl.jar;C\:\\eclipse\
\plugins\\org.apache.ant_1.7.0\\lib\\xml-apis.jar;C\:\\eclipse\
\configuration\\org.eclipse.osgi\\bundles\\10\\1\\.cp\\lib\
\remoteAnt.jar;C\:\\IBM\\WebSphere\\AppServer\\java\\lib\\tools.jar;C\:
\\eclipse\\plugins\\org.eclipse.swt.win32.win32.x86_3.2.2.v3235a.jar
[echoproperties] java.class.version=49.0
[echoproperties] java.endorsed.dirs=C\:\\Program Files\\Java\
\jre1.5.0_06\\lib\\endorsed
[echoproperties] java.ext.dirs=C\:\\Program Files\\Java\\jre1.5.0_06\
\lib\\ext
[echoproperties] java.home=C\:\\Program Files\\Java\\jre1.5.0_06
[echoproperties] java.io.tmpdir=C\:\\DOCUME~1\\WalkeD\\LOCALS~1\\Temp\
\
[echoproperties] java.library.path=C\:\\WINDOWS\\system32;.;C\:\
\WINDOWS\\system32;C\:\\WINDOWS;C\:\\Program Files\\IBM\\WebSphere MQ\
\Java\\lib;C\:\\WINDOWS\\system32;C\:\\WINDOWS;C\:\\WINDOWS\\System32\
\Wbem;C\:\\Program Files\\IBM\\IBM CICS Transaction Gateway\\BIN;C\:\
\apache-ant-1.7.0\\bin;C\:\\j2sdk1.4.1_01\\bin;C\:\\Program Files\\IBM\
\WebSphere MQ\\bin;C\:\\Program Files\\IBM\\WebSphere MQ\\WEMPS\\bin;C
\:\\Program Files\\TextPad 4;C\:\\Program Files\\PuTTY;C\:\\PROGRA~1\
\IBM\\SQLLIB\\BIN;C\:\\PROGRA~1\\IBM\\SQLLIB\\FUNCTION;C\:\\PROGRA~1\
\IBM\\SQLLIB\\SAMPLES\\REPL;;C\:\\Program Files\\Visual Explain\\lib;C
\:\\Program Files\\CVSNT\\;C\:\\eclipse\\configuration\
\org.eclipse.osgi\\bundles\\718\\1\\.cp
[echoproperties] java.runtime.name=Java(TM) 2 Runtime Environment,
Standard Edition
[echoproperties] java.runtime.version=1.5.0_06-b05
[echoproperties] java.specification.name=Java Platform API
Specification
[echoproperties] java.specification.vendor=Sun Microsystems Inc.
[echoproperties] java.specification.version=1.5
[echoproperties] java.vendor=Sun Microsystems Inc.
[echoproperties] java.vendor.url=http\://java.sun.com/
[echoproperties] java.vendor.url.bug=http\://java.sun.com/cgi-bin/
bugreport.cgi
[echoproperties] java.version=1.5.0_06
[echoproperties] java.vm.info=mixed mode
[echoproperties] java.vm.name=Java HotSpot(TM) Client VM
[echoproperties] java.vm.specification.name=Java Virtual Machine
Specification
[echoproperties] java.vm.specification.vendor=Sun Microsystems Inc.
[echoproperties] java.vm.specification.version=1.0
[echoproperties] java.vm.vendor=Sun Microsystems Inc.
[echoproperties] java.vm.version=1.5.0_06-b05
[echoproperties] line.separator=\r\n
[echoproperties] os.arch=x86
[echoproperties] os.name=Windows XP
[echoproperties] os.version=5.1
[echoproperties] outputFile=dailyTransactions.out.txt
[echoproperties] path.separator=;
[echoproperties] schema=isdb1
[echoproperties] sql=connect to db0z user dmfstr1 using dfstr101; SET
SCHEMA isdb1; Select count (*) from isdb1.SUBTRANSACTION s,
isdb1.subtransactiontype st where s.SUBTRANSACTIONTYPE_SUBTRANSA12 \=
st.subtransactiontypeid and s.subtransactionstatusid \= 2 and
st.SUBTRANSACTIONMODULEID in (1,2,5,7,8,9) and s.createdon between
'2007-04-09 00\:01\:01.000000' and '2007-04-09 23\:59\:01.424000';\t
\t \t quit;
[echoproperties] sqlCommands=transactionCount.sql
[echoproperties] sun.arch.data.model=32
[echoproperties] sun.boot.class.path=C\:\\Program Files\\Java\
\jre1.5.0_06\\lib\\rt.jar;C\:\\Program Files\\Java\\jre1.5.0_06\\lib\
\i18n.jar;C\:\\Program Files\\Java\\jre1.5.0_06\\lib\\sunrsasign.jar;C
\:\\Program Files\\Java\\jre1.5.0_06\\lib\\jsse.jar;C\:\\Program Files\
\Java\\jre1.5.0_06\\lib\\jce.jar;C\:\\Program Files\\Java\\jre1.5.0_06\
\lib\\charsets.jar;C\:\\Program Files\\Java\\jre1.5.0_06\\classes
[echoproperties] sun.boot.library.path=C\:\\Program Files\\Java\
\jre1.5.0_06\\bin
[echoproperties] sun.cpu.endian=little
[echoproperties] sun.cpu.isalist=
[echoproperties] sun.desktop=windows
[echoproperties] sun.io.unicode.encoding=UnicodeLittle
[echoproperties] sun.jnu.encoding=Cp1252
[echoproperties] sun.management.compiler=HotSpot Client Compiler
[echoproperties] sun.os.patch.level=Service Pack 2
[echoproperties] today=2007-04-09
[echoproperties] user.country=US
[echoproperties] user.dir=C\:\\eclipse_workspace\\massSQL
[echoproperties] user.home=C\:\\Documents and Settings\\WalkeD
[echoproperties] user.language=en
[echoproperties] user.name=walked2
[echoproperties] user.timezone=
[echoproperties] user.variant=
[echoproperties] userName=********
[echoproperties] userPass=********
query:
[delete] Could not find file C:\eclipse_workspace\massSQL
\dailyTransactions.out.txt to delete.
[exec] Current OS is Windows XP
[exec] Error redirected to C:\eclipse_workspace\massSQL
\dailyTransactionsError.txt
[exec] Executing 'cmd.exe' with arguments:
[exec] '/c db2cmd db2 -tx connect to db0z user ******* using
*******; SET SCHEMA isdb1; Select count (*) from isdb1.SUBTRANSACTION
s, isdb1.subtransactiontype st where s.SUBTRANSACTIONTYPE_SUBTRANSA12
= st.subtransactiontypeid and s.subtransactionstatusid = 2 and
st.SUBTRANSACTIONMODULEID in (1,2,5,7,8,9) and s.createdon between
'2007-04-09 00:01:01.000000' and '2007-04-09 23:59:01.424000';
quit; -z dailyTransactions.out.txt'
[exec]
[exec] The ' characters around the executable and arguments are
[exec] not part of the command.
[sleep] sleeping for 20000 milliseconds
BUILD SUCCESSFUL
Total time: 20 seconds
the contents of the folowing files are being used.
===count.xml===(pass and username have been blanked for posting)
<project name="dailyTransactions" default="query" basedir=".">
<target name="init" description="prep directories and set times
etc...">
<tstamp>
<format property="today" pattern="yyyy-MM-dd" />
</tstamp>
<property name="schema" value="isdb1" />
<property name="database" value="db0z" />
<property name="userName" value="*******" />
<property name="userPass" value="******" />
<property name="outputFile" value="dailyTransactions.out.txt" />
<property name="sqlCommands" value="transactionCount.sql" />
<property name="errorFile" value="dailyTransactionsError.txt" />
<loadfile property="sql" srcFile="transactionCount.sql" >
<filterchain>
<striplinebreaks/>
</filterchain>
<filterchain>
<replacestring from="THESCHEMA"
to="${schema}" />
</filterchain>
<filterchain>
<replacestring from="DATABASE"
to="${database}" />
</filterchain>
<filterchain>
<replacestring from="THEUSERNAME"
to="${userName}" />
</filterchain>
<filterchain>
<replacestring from="THEPASSWORD"
to="${userPass}" />
</filterchain>
<filterchain>
<replacestring from="THEDATE" to="${today}" />
</filterchain>
</loadfile>
<echoproperties />
</target>
<target name="query" depends="init" description="execute sql quarrey
">
<delete file="${outputFile}" />
<exec executable="cmd.exe" os="Windows XP" error="${errorFile}"
resultproperty="queryResult" failonerror="false" timeout="180000">
<arg value="/c db2cmd db2 -tx ${sql} -z
${outputFile}" />
</exec>
<sleep seconds="20" />
</target>
</project>
===transactioncount.sql===
connect to DATABASE user THEUSERNAME using THEPASSWORD;
SET SCHEMA THESCHEMA;
Select count (*)
from THESCHEMA.SUBTRANSACTION s, THESCHEMA.subtransactiontype st
where s.SUBTRANSACTIONTYPE_SUBTRANSA12 = st.subtransactiontypeid and
s.subtransactionstatusid = 2 and
st.SUBTRANSACTIONMODULEID in (1,2,5,7,8,9) and
s.createdon between 'THEDATE 00:01:01.000000' and 'THEDATE
23:59:01.424000';
quit;
--
__________________________________
No matter how responsible he may seem,
Never give your Gun to a Monkey.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org
Re: calling a DB2 request.
Posted by Dwayne Walker <wb...@gmail.com>.
Sorry for the delay in response Greg but I wanted to thank you for
your advise. when I split it out to have two arguments only it worked
just fine. If I break it out more than that it doesn't seem to work.
at any rate I have it functioning just don't entirely understand the
db2clp very well.
Thanks for your help.
Dwayne
On 4/9/07, Ditrick, Gregory <gr...@fmr.com> wrote:
> Actually, it looks like you'll need combinations of the two(2).
>
> I'd do this:
> <arg value="/c" />
> <arg line="db2cmd db2 -tx ${sql} -z ${outputFile}" />
>
> You may have to break it apart more than that. Try what you might think
> makes sense.
>
>
>
> GregD
> 6-8309
>
> -----Original Message-----
> From: Ditrick, Gregory
> Sent: Monday, April 09, 2007 2:36 PM
> To: Ant Users List
> Subject: RE: calling a DB2 request.
>
> Dwayne,
>
> Change this line:
>
> <arg value="/c db2cmd db2 -tx ${sql} -z ${outputFile}" />
>
> To this:
>
> <arg line="/c db2cmd db2 -tx ${sql} -z ${outputFile}" />
>
>
> The <arg value> will put quotes around the arg to treat it as 1 argument
> instead of individual args.
>
> Or
>
> Use multiple <arg value> for each of your arguments.
>
>
> I hope this helps.
>
> Later,
>
>
> GregD
> 6-8309
>
> -----Original Message-----
> From: Dwayne Walker [mailto:wb5plj@gmail.com]
> Sent: Monday, April 09, 2007 1:58 PM
> To: user@ant.apache.org
> Subject: calling a DB2 request.
>
> Hi I am having a problem passing some sql to the db2cmd via ant. This
> is very confusing as I am doing this exact thing elseware with no
> problem (just differant sql, and I have verified the sql is valid) but
> in this one I am having problems. Any time I run this I get the
> folowing message from the db2 clp window that opens up.
>
> SQL0104N An unexpected token "SET" was found following
> "<identifier>".
> Expected tokens may include: "NEW". SQLSTATE=42601
> C:\eclipse_workspace\massSQL>
>
> I don't know what is going on here but I am by no means familiar with
> db2cmd and all that so any help is apreachated. If I could get this to
> work in a batch file or from a command line I am sure I could get the
> ant part of it on my own. it is the db2 that is giving me issues.
>
> thanks. Dwayne
>
> this is the console log from ant of what is being passed.
> Apache Ant version 1.7.0 compiled on December 13 2006
> Buildfile: C:\eclipse_workspace\massSQL\count.xml
> parsing buildfile C:\eclipse_workspace\massSQL\count.xml with URI =
> file:/C:/eclipse_workspace/massSQL/count.xml
> Project base dir set to: C:\eclipse_workspace\massSQL
> Build sequence for target(s) `query' is [init, query]
> Complete build sequence is [init, query, query3, query2, ]
> init:
> [antlib:org.apache.tools.ant] Could not load definitions from resource
> org/apache/tools/ant/antlib.xml. It could not be found.
> [loadfile] loading C:\eclipse_workspace\massSQL\transactionCount.sql
> into property sql
> [loadfile] loaded 383 characters
> [echoproperties] #Ant properties
> [echoproperties] #Mon Apr 09 11:12:51 CDT 2007
> [echoproperties] DSTAMP=20070409
> [echoproperties] TODAY=April 9 2007
> [echoproperties] TSTAMP=1112
> [echoproperties] ant.core.lib=C\:\\eclipse\\plugins\
> \org.apache.ant_1.7.0\\lib\\ant.jar
> [echoproperties] ant.file=C\:\\eclipse_workspace\\massSQL\\count.xml
> [echoproperties] ant.file.dailyTransactions=C\:\\eclipse_workspace\
> \massSQL\\count.xml
> [echoproperties] ant.home=C\:\\eclipse\\plugins\\org.apache.ant_1.7.0
> [echoproperties] ant.java.version=1.5
> [echoproperties] ant.library.dir=C\:\\eclipse\\plugins\
> \org.apache.ant_1.7.0\\lib
> [echoproperties] ant.project.name=dailyTransactions
> [echoproperties] ant.version=Apache Ant version 1.7.0 compiled on
> December 13 2006
> [echoproperties] awt.toolkit=sun.awt.windows.WToolkit
> [echoproperties] basedir=C\:\\eclipse_workspace\\massSQL
> [echoproperties] database=db0z
> [echoproperties] eclipse.pdebuild.home=/C\:/eclipse/plugins/
> org.eclipse.pde.build_3.2.1.r321_v20060823/./
> [echoproperties] eclipse.pdebuild.scripts=/C\:/eclipse/plugins/
> org.eclipse.pde.build_3.2.1.r321_v20060823/scripts/
> [echoproperties] eclipse.pdebuild.templates=/C\:/eclipse/plugins/
> org.eclipse.pde.build_3.2.1.r321_v20060823/templates/
> [echoproperties] errorFile=dailyTransactionsError.txt
> [echoproperties] file.encoding=Cp1252
> [echoproperties] file.encoding.pkg=sun.io
> [echoproperties] file.separator=\\
> [echoproperties] java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment
> [echoproperties] java.awt.printerjob=sun.awt.windows.WPrinterJob
> [echoproperties] java.class.path=C\:\\eclipse\\plugins\
> \org.apache.ant_1.7.0\\lib\\ant-antlr.jar;C\:\\eclipse\\plugins\
> \org.apache.ant_1.7.0\\lib\\ant-apache-bcel.jar;C\:\\eclipse\\plugins\
> \org.apache.ant_1.7.0\\lib\\ant-apache-bsf.jar;C\:\\eclipse\\plugins\
> \org.apache.ant_1.7.0\\lib\\ant-apache-log4j.jar;C\:\\eclipse\\plugins\
> \org.apache.ant_1.7.0\\lib\\ant-apache-oro.jar;C\:\\eclipse\\plugins\
> \org.apache.ant_1.7.0\\lib\\ant-apache-regexp.jar;C\:\\eclipse\\plugins
> \\org.apache.ant_1.7.0\\lib\\ant-apache-resolver.jar;C\:\\eclipse\
> \plugins\\org.apache.ant_1.7.0\\lib\\ant-commons-logging.jar;C\:\
> \eclipse\\plugins\\org.apache.ant_1.7.0\\lib\\ant-commons-net.jar;C\:\
> \eclipse\\plugins\\org.apache.ant_1.7.0\\lib\\ant-jai.jar;C\:\\eclipse\
> \plugins\\org.apache.ant_1.7.0\\lib\\ant-javamail.jar;C\:\\eclipse\
> \plugins\\org.apache.ant_1.7.0\\lib\\ant-jdepend.jar;C\:\\eclipse\
> \plugins\\org.apache.ant_1.7.0\\lib\\ant-jmf.jar;C\:\\eclipse\\plugins\
> \org.apache.ant_1.7.0\\lib\\ant-jsch.jar;C\:\\eclipse\\plugins\
> \org.apache.ant_1.7.0\\lib\\ant-junit.jar;C\:\\eclipse\\plugins\
> \org.apache.ant_1.7.0\\lib\\ant-launcher.jar;C\:\\eclipse\\plugins\
> \org.apache.ant_1.7.0\\lib\\ant-netrexx.jar;C\:\\eclipse\\plugins\
> \org.apache.ant_1.7.0\\lib\\ant-nodeps.jar;C\:\\eclipse\\plugins\
> \org.apache.ant_1.7.0\\lib\\ant-starteam.jar;C\:\\eclipse\\plugins\
> \org.apache.ant_1.7.0\\lib\\ant-stylebook.jar;C\:\\eclipse\\plugins\
> \org.apache.ant_1.7.0\\lib\\ant-swing.jar;C\:\\eclipse\\plugins\
> \org.apache.ant_1.7.0\\lib\\ant-testutil.jar;C\:\\eclipse\\plugins\
> \org.apache.ant_1.7.0\\lib\\ant-trax.jar;C\:\\eclipse\\plugins\
> \org.apache.ant_1.7.0\\lib\\ant-weblogic.jar;C\:\\eclipse\\plugins\
> \org.apache.ant_1.7.0\\lib\\ant.jar;C\:\\eclipse\\plugins\
> \org.apache.ant_1.7.0\\lib\\commons-net-1.4.1.jar;C\:\\eclipse\\plugins
> \\org.apache.ant_1.7.0\\lib\\jakarta-oro-2.0.8.jar;C\:\\eclipse\
> \plugins\\org.apache.ant_1.7.0\\lib\\xercesImpl.jar;C\:\\eclipse\
> \plugins\\org.apache.ant_1.7.0\\lib\\xml-apis.jar;C\:\\eclipse\
> \configuration\\org.eclipse.osgi\\bundles\\10\\1\\.cp\\lib\
> \remoteAnt.jar;C\:\\IBM\\WebSphere\\AppServer\\java\\lib\\tools.jar;C\:
> \\eclipse\\plugins\\org.eclipse.swt.win32.win32.x86_3.2.2.v3235a.jar
> [echoproperties] java.class.version=49.0
> [echoproperties] java.endorsed.dirs=C\:\\Program Files\\Java\
> \jre1.5.0_06\\lib\\endorsed
> [echoproperties] java.ext.dirs=C\:\\Program Files\\Java\\jre1.5.0_06\
> \lib\\ext
> [echoproperties] java.home=C\:\\Program Files\\Java\\jre1.5.0_06
> [echoproperties] java.io.tmpdir=C\:\\DOCUME~1\\WalkeD\\LOCALS~1\\Temp\
> \
> [echoproperties] java.library.path=C\:\\WINDOWS\\system32;.;C\:\
> \WINDOWS\\system32;C\:\\WINDOWS;C\:\\Program Files\\IBM\\WebSphere MQ\
> \Java\\lib;C\:\\WINDOWS\\system32;C\:\\WINDOWS;C\:\\WINDOWS\\System32\
> \Wbem;C\:\\Program Files\\IBM\\IBM CICS Transaction Gateway\\BIN;C\:\
> \apache-ant-1.7.0\\bin;C\:\\j2sdk1.4.1_01\\bin;C\:\\Program Files\\IBM\
> \WebSphere MQ\\bin;C\:\\Program Files\\IBM\\WebSphere MQ\\WEMPS\\bin;C
> \:\\Program Files\\TextPad 4;C\:\\Program Files\\PuTTY;C\:\\PROGRA~1\
> \IBM\\SQLLIB\\BIN;C\:\\PROGRA~1\\IBM\\SQLLIB\\FUNCTION;C\:\\PROGRA~1\
> \IBM\\SQLLIB\\SAMPLES\\REPL;;C\:\\Program Files\\Visual Explain\\lib;C
> \:\\Program Files\\CVSNT\\;C\:\\eclipse\\configuration\
> \org.eclipse.osgi\\bundles\\718\\1\\.cp
> [echoproperties] java.runtime.name=Java(TM) 2 Runtime Environment,
> Standard Edition
> [echoproperties] java.runtime.version=1.5.0_06-b05
> [echoproperties] java.specification.name=Java Platform API
> Specification
> [echoproperties] java.specification.vendor=Sun Microsystems Inc.
> [echoproperties] java.specification.version=1.5
> [echoproperties] java.vendor=Sun Microsystems Inc.
> [echoproperties] java.vendor.url=http\://java.sun.com/
> [echoproperties] java.vendor.url.bug=http\://java.sun.com/cgi-bin/
> bugreport.cgi
> [echoproperties] java.version=1.5.0_06
> [echoproperties] java.vm.info=mixed mode
> [echoproperties] java.vm.name=Java HotSpot(TM) Client VM
> [echoproperties] java.vm.specification.name=Java Virtual Machine
> Specification
> [echoproperties] java.vm.specification.vendor=Sun Microsystems Inc.
> [echoproperties] java.vm.specification.version=1.0
> [echoproperties] java.vm.vendor=Sun Microsystems Inc.
> [echoproperties] java.vm.version=1.5.0_06-b05
> [echoproperties] line.separator=\r\n
> [echoproperties] os.arch=x86
> [echoproperties] os.name=Windows XP
> [echoproperties] os.version=5.1
> [echoproperties] outputFile=dailyTransactions.out.txt
> [echoproperties] path.separator=;
> [echoproperties] schema=isdb1
> [echoproperties] sql=connect to db0z user dmfstr1 using dfstr101; SET
> SCHEMA isdb1; Select count (*) from isdb1.SUBTRANSACTION s,
> isdb1.subtransactiontype st where s.SUBTRANSACTIONTYPE_SUBTRANSA12 \=
> st.subtransactiontypeid and s.subtransactionstatusid \= 2 and
> st.SUBTRANSACTIONMODULEID in (1,2,5,7,8,9) and s.createdon between
> '2007-04-09 00\:01\:01.000000' and '2007-04-09 23\:59\:01.424000';\t
> \t \t quit;
> [echoproperties] sqlCommands=transactionCount.sql
> [echoproperties] sun.arch.data.model=32
> [echoproperties] sun.boot.class.path=C\:\\Program Files\\Java\
> \jre1.5.0_06\\lib\\rt.jar;C\:\\Program Files\\Java\\jre1.5.0_06\\lib\
> \i18n.jar;C\:\\Program Files\\Java\\jre1.5.0_06\\lib\\sunrsasign.jar;C
> \:\\Program Files\\Java\\jre1.5.0_06\\lib\\jsse.jar;C\:\\Program Files\
> \Java\\jre1.5.0_06\\lib\\jce.jar;C\:\\Program Files\\Java\\jre1.5.0_06\
> \lib\\charsets.jar;C\:\\Program Files\\Java\\jre1.5.0_06\\classes
> [echoproperties] sun.boot.library.path=C\:\\Program Files\\Java\
> \jre1.5.0_06\\bin
> [echoproperties] sun.cpu.endian=little
> [echoproperties] sun.cpu.isalist=
> [echoproperties] sun.desktop=windows
> [echoproperties] sun.io.unicode.encoding=UnicodeLittle
> [echoproperties] sun.jnu.encoding=Cp1252
> [echoproperties] sun.management.compiler=HotSpot Client Compiler
> [echoproperties] sun.os.patch.level=Service Pack 2
> [echoproperties] today=2007-04-09
> [echoproperties] user.country=US
> [echoproperties] user.dir=C\:\\eclipse_workspace\\massSQL
> [echoproperties] user.home=C\:\\Documents and Settings\\WalkeD
> [echoproperties] user.language=en
> [echoproperties] user.name=walked2
> [echoproperties] user.timezone=
> [echoproperties] user.variant=
> [echoproperties] userName=********
> [echoproperties] userPass=********
> query:
> [delete] Could not find file C:\eclipse_workspace\massSQL
> \dailyTransactions.out.txt to delete.
> [exec] Current OS is Windows XP
> [exec] Error redirected to C:\eclipse_workspace\massSQL
> \dailyTransactionsError.txt
> [exec] Executing 'cmd.exe' with arguments:
> [exec] '/c db2cmd db2 -tx connect to db0z user ******* using
> *******; SET SCHEMA isdb1; Select count (*) from isdb1.SUBTRANSACTION
> s, isdb1.subtransactiontype st where s.SUBTRANSACTIONTYPE_SUBTRANSA12
> = st.subtransactiontypeid and s.subtransactionstatusid = 2 and
> st.SUBTRANSACTIONMODULEID in (1,2,5,7,8,9) and s.createdon between
> '2007-04-09 00:01:01.000000' and '2007-04-09 23:59:01.424000';
> quit; -z dailyTransactions.out.txt'
> [exec]
> [exec] The ' characters around the executable and arguments are
> [exec] not part of the command.
> [sleep] sleeping for 20000 milliseconds
> BUILD SUCCESSFUL
> Total time: 20 seconds
>
> the contents of the folowing files are being used.
> ===count.xml===(pass and username have been blanked for posting)
> <project name="dailyTransactions" default="query" basedir=".">
>
> <target name="init" description="prep directories and set times
> etc...">
> <tstamp>
> <format property="today" pattern="yyyy-MM-dd" />
> </tstamp>
> <property name="schema" value="isdb1" />
> <property name="database" value="db0z" />
> <property name="userName" value="*******" />
> <property name="userPass" value="******" />
> <property name="outputFile"
> value="dailyTransactions.out.txt" />
> <property name="sqlCommands"
> value="transactionCount.sql" />
> <property name="errorFile"
> value="dailyTransactionsError.txt" />
> <loadfile property="sql" srcFile="transactionCount.sql"
> >
> <filterchain>
> <striplinebreaks/>
> </filterchain>
> <filterchain>
> <replacestring from="THESCHEMA"
> to="${schema}" />
> </filterchain>
> <filterchain>
> <replacestring from="DATABASE"
> to="${database}" />
> </filterchain>
> <filterchain>
> <replacestring from="THEUSERNAME"
> to="${userName}" />
> </filterchain>
> <filterchain>
> <replacestring from="THEPASSWORD"
> to="${userPass}" />
> </filterchain>
> <filterchain>
> <replacestring from="THEDATE"
> to="${today}" />
> </filterchain>
> </loadfile>
> <echoproperties />
> </target>
>
> <target name="query" depends="init" description="execute sql
> quarrey
> ">
> <delete file="${outputFile}" />
> <exec executable="cmd.exe" os="Windows XP"
> error="${errorFile}"
> resultproperty="queryResult" failonerror="false" timeout="180000">
> <arg value="/c db2cmd db2 -tx ${sql} -z
> ${outputFile}" />
> </exec>
> <sleep seconds="20" />
> </target>
> </project>
>
> ===transactioncount.sql===
> connect to DATABASE user THEUSERNAME using THEPASSWORD;
>
> SET SCHEMA THESCHEMA;
>
> Select count (*)
> from THESCHEMA.SUBTRANSACTION s, THESCHEMA.subtransactiontype st
> where s.SUBTRANSACTIONTYPE_SUBTRANSA12 = st.subtransactiontypeid and
> s.subtransactionstatusid = 2 and
> st.SUBTRANSACTIONMODULEID in (1,2,5,7,8,9) and
> s.createdon between 'THEDATE 00:01:01.000000' and 'THEDATE
> 23:59:01.424000';
>
> quit;
>
> --
> __________________________________
> No matter how responsible he may seem,
> Never give your Gun to a Monkey.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
> For additional commands, e-mail: user-help@ant.apache.org
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
> For additional commands, e-mail: user-help@ant.apache.org
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
> For additional commands, e-mail: user-help@ant.apache.org
>
>
--
__________________________________
No matter how responsible he may seem,
Never give your Gun to a Monkey.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org
RE: calling a DB2 request.
Posted by "Ditrick, Gregory" <gr...@fmr.com>.
Actually, it looks like you'll need combinations of the two(2).
I'd do this:
<arg value="/c" />
<arg line="db2cmd db2 -tx ${sql} -z ${outputFile}" />
You may have to break it apart more than that. Try what you might think
makes sense.
GregD
6-8309
-----Original Message-----
From: Ditrick, Gregory
Sent: Monday, April 09, 2007 2:36 PM
To: Ant Users List
Subject: RE: calling a DB2 request.
Dwayne,
Change this line:
<arg value="/c db2cmd db2 -tx ${sql} -z ${outputFile}" />
To this:
<arg line="/c db2cmd db2 -tx ${sql} -z ${outputFile}" />
The <arg value> will put quotes around the arg to treat it as 1 argument
instead of individual args.
Or
Use multiple <arg value> for each of your arguments.
I hope this helps.
Later,
GregD
6-8309
-----Original Message-----
From: Dwayne Walker [mailto:wb5plj@gmail.com]
Sent: Monday, April 09, 2007 1:58 PM
To: user@ant.apache.org
Subject: calling a DB2 request.
Hi I am having a problem passing some sql to the db2cmd via ant. This
is very confusing as I am doing this exact thing elseware with no
problem (just differant sql, and I have verified the sql is valid) but
in this one I am having problems. Any time I run this I get the
folowing message from the db2 clp window that opens up.
SQL0104N An unexpected token "SET" was found following
"<identifier>".
Expected tokens may include: "NEW". SQLSTATE=42601
C:\eclipse_workspace\massSQL>
I don't know what is going on here but I am by no means familiar with
db2cmd and all that so any help is apreachated. If I could get this to
work in a batch file or from a command line I am sure I could get the
ant part of it on my own. it is the db2 that is giving me issues.
thanks. Dwayne
this is the console log from ant of what is being passed.
Apache Ant version 1.7.0 compiled on December 13 2006
Buildfile: C:\eclipse_workspace\massSQL\count.xml
parsing buildfile C:\eclipse_workspace\massSQL\count.xml with URI =
file:/C:/eclipse_workspace/massSQL/count.xml
Project base dir set to: C:\eclipse_workspace\massSQL
Build sequence for target(s) `query' is [init, query]
Complete build sequence is [init, query, query3, query2, ]
init:
[antlib:org.apache.tools.ant] Could not load definitions from resource
org/apache/tools/ant/antlib.xml. It could not be found.
[loadfile] loading C:\eclipse_workspace\massSQL\transactionCount.sql
into property sql
[loadfile] loaded 383 characters
[echoproperties] #Ant properties
[echoproperties] #Mon Apr 09 11:12:51 CDT 2007
[echoproperties] DSTAMP=20070409
[echoproperties] TODAY=April 9 2007
[echoproperties] TSTAMP=1112
[echoproperties] ant.core.lib=C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant.jar
[echoproperties] ant.file=C\:\\eclipse_workspace\\massSQL\\count.xml
[echoproperties] ant.file.dailyTransactions=C\:\\eclipse_workspace\
\massSQL\\count.xml
[echoproperties] ant.home=C\:\\eclipse\\plugins\\org.apache.ant_1.7.0
[echoproperties] ant.java.version=1.5
[echoproperties] ant.library.dir=C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib
[echoproperties] ant.project.name=dailyTransactions
[echoproperties] ant.version=Apache Ant version 1.7.0 compiled on
December 13 2006
[echoproperties] awt.toolkit=sun.awt.windows.WToolkit
[echoproperties] basedir=C\:\\eclipse_workspace\\massSQL
[echoproperties] database=db0z
[echoproperties] eclipse.pdebuild.home=/C\:/eclipse/plugins/
org.eclipse.pde.build_3.2.1.r321_v20060823/./
[echoproperties] eclipse.pdebuild.scripts=/C\:/eclipse/plugins/
org.eclipse.pde.build_3.2.1.r321_v20060823/scripts/
[echoproperties] eclipse.pdebuild.templates=/C\:/eclipse/plugins/
org.eclipse.pde.build_3.2.1.r321_v20060823/templates/
[echoproperties] errorFile=dailyTransactionsError.txt
[echoproperties] file.encoding=Cp1252
[echoproperties] file.encoding.pkg=sun.io
[echoproperties] file.separator=\\
[echoproperties] java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment
[echoproperties] java.awt.printerjob=sun.awt.windows.WPrinterJob
[echoproperties] java.class.path=C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-antlr.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-apache-bcel.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-apache-bsf.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-apache-log4j.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-apache-oro.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-apache-regexp.jar;C\:\\eclipse\\plugins
\\org.apache.ant_1.7.0\\lib\\ant-apache-resolver.jar;C\:\\eclipse\
\plugins\\org.apache.ant_1.7.0\\lib\\ant-commons-logging.jar;C\:\
\eclipse\\plugins\\org.apache.ant_1.7.0\\lib\\ant-commons-net.jar;C\:\
\eclipse\\plugins\\org.apache.ant_1.7.0\\lib\\ant-jai.jar;C\:\\eclipse\
\plugins\\org.apache.ant_1.7.0\\lib\\ant-javamail.jar;C\:\\eclipse\
\plugins\\org.apache.ant_1.7.0\\lib\\ant-jdepend.jar;C\:\\eclipse\
\plugins\\org.apache.ant_1.7.0\\lib\\ant-jmf.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-jsch.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-junit.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-launcher.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-netrexx.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-nodeps.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-starteam.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-stylebook.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-swing.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-testutil.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-trax.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-weblogic.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\commons-net-1.4.1.jar;C\:\\eclipse\\plugins
\\org.apache.ant_1.7.0\\lib\\jakarta-oro-2.0.8.jar;C\:\\eclipse\
\plugins\\org.apache.ant_1.7.0\\lib\\xercesImpl.jar;C\:\\eclipse\
\plugins\\org.apache.ant_1.7.0\\lib\\xml-apis.jar;C\:\\eclipse\
\configuration\\org.eclipse.osgi\\bundles\\10\\1\\.cp\\lib\
\remoteAnt.jar;C\:\\IBM\\WebSphere\\AppServer\\java\\lib\\tools.jar;C\:
\\eclipse\\plugins\\org.eclipse.swt.win32.win32.x86_3.2.2.v3235a.jar
[echoproperties] java.class.version=49.0
[echoproperties] java.endorsed.dirs=C\:\\Program Files\\Java\
\jre1.5.0_06\\lib\\endorsed
[echoproperties] java.ext.dirs=C\:\\Program Files\\Java\\jre1.5.0_06\
\lib\\ext
[echoproperties] java.home=C\:\\Program Files\\Java\\jre1.5.0_06
[echoproperties] java.io.tmpdir=C\:\\DOCUME~1\\WalkeD\\LOCALS~1\\Temp\
\
[echoproperties] java.library.path=C\:\\WINDOWS\\system32;.;C\:\
\WINDOWS\\system32;C\:\\WINDOWS;C\:\\Program Files\\IBM\\WebSphere MQ\
\Java\\lib;C\:\\WINDOWS\\system32;C\:\\WINDOWS;C\:\\WINDOWS\\System32\
\Wbem;C\:\\Program Files\\IBM\\IBM CICS Transaction Gateway\\BIN;C\:\
\apache-ant-1.7.0\\bin;C\:\\j2sdk1.4.1_01\\bin;C\:\\Program Files\\IBM\
\WebSphere MQ\\bin;C\:\\Program Files\\IBM\\WebSphere MQ\\WEMPS\\bin;C
\:\\Program Files\\TextPad 4;C\:\\Program Files\\PuTTY;C\:\\PROGRA~1\
\IBM\\SQLLIB\\BIN;C\:\\PROGRA~1\\IBM\\SQLLIB\\FUNCTION;C\:\\PROGRA~1\
\IBM\\SQLLIB\\SAMPLES\\REPL;;C\:\\Program Files\\Visual Explain\\lib;C
\:\\Program Files\\CVSNT\\;C\:\\eclipse\\configuration\
\org.eclipse.osgi\\bundles\\718\\1\\.cp
[echoproperties] java.runtime.name=Java(TM) 2 Runtime Environment,
Standard Edition
[echoproperties] java.runtime.version=1.5.0_06-b05
[echoproperties] java.specification.name=Java Platform API
Specification
[echoproperties] java.specification.vendor=Sun Microsystems Inc.
[echoproperties] java.specification.version=1.5
[echoproperties] java.vendor=Sun Microsystems Inc.
[echoproperties] java.vendor.url=http\://java.sun.com/
[echoproperties] java.vendor.url.bug=http\://java.sun.com/cgi-bin/
bugreport.cgi
[echoproperties] java.version=1.5.0_06
[echoproperties] java.vm.info=mixed mode
[echoproperties] java.vm.name=Java HotSpot(TM) Client VM
[echoproperties] java.vm.specification.name=Java Virtual Machine
Specification
[echoproperties] java.vm.specification.vendor=Sun Microsystems Inc.
[echoproperties] java.vm.specification.version=1.0
[echoproperties] java.vm.vendor=Sun Microsystems Inc.
[echoproperties] java.vm.version=1.5.0_06-b05
[echoproperties] line.separator=\r\n
[echoproperties] os.arch=x86
[echoproperties] os.name=Windows XP
[echoproperties] os.version=5.1
[echoproperties] outputFile=dailyTransactions.out.txt
[echoproperties] path.separator=;
[echoproperties] schema=isdb1
[echoproperties] sql=connect to db0z user dmfstr1 using dfstr101; SET
SCHEMA isdb1; Select count (*) from isdb1.SUBTRANSACTION s,
isdb1.subtransactiontype st where s.SUBTRANSACTIONTYPE_SUBTRANSA12 \=
st.subtransactiontypeid and s.subtransactionstatusid \= 2 and
st.SUBTRANSACTIONMODULEID in (1,2,5,7,8,9) and s.createdon between
'2007-04-09 00\:01\:01.000000' and '2007-04-09 23\:59\:01.424000';\t
\t \t quit;
[echoproperties] sqlCommands=transactionCount.sql
[echoproperties] sun.arch.data.model=32
[echoproperties] sun.boot.class.path=C\:\\Program Files\\Java\
\jre1.5.0_06\\lib\\rt.jar;C\:\\Program Files\\Java\\jre1.5.0_06\\lib\
\i18n.jar;C\:\\Program Files\\Java\\jre1.5.0_06\\lib\\sunrsasign.jar;C
\:\\Program Files\\Java\\jre1.5.0_06\\lib\\jsse.jar;C\:\\Program Files\
\Java\\jre1.5.0_06\\lib\\jce.jar;C\:\\Program Files\\Java\\jre1.5.0_06\
\lib\\charsets.jar;C\:\\Program Files\\Java\\jre1.5.0_06\\classes
[echoproperties] sun.boot.library.path=C\:\\Program Files\\Java\
\jre1.5.0_06\\bin
[echoproperties] sun.cpu.endian=little
[echoproperties] sun.cpu.isalist=
[echoproperties] sun.desktop=windows
[echoproperties] sun.io.unicode.encoding=UnicodeLittle
[echoproperties] sun.jnu.encoding=Cp1252
[echoproperties] sun.management.compiler=HotSpot Client Compiler
[echoproperties] sun.os.patch.level=Service Pack 2
[echoproperties] today=2007-04-09
[echoproperties] user.country=US
[echoproperties] user.dir=C\:\\eclipse_workspace\\massSQL
[echoproperties] user.home=C\:\\Documents and Settings\\WalkeD
[echoproperties] user.language=en
[echoproperties] user.name=walked2
[echoproperties] user.timezone=
[echoproperties] user.variant=
[echoproperties] userName=********
[echoproperties] userPass=********
query:
[delete] Could not find file C:\eclipse_workspace\massSQL
\dailyTransactions.out.txt to delete.
[exec] Current OS is Windows XP
[exec] Error redirected to C:\eclipse_workspace\massSQL
\dailyTransactionsError.txt
[exec] Executing 'cmd.exe' with arguments:
[exec] '/c db2cmd db2 -tx connect to db0z user ******* using
*******; SET SCHEMA isdb1; Select count (*) from isdb1.SUBTRANSACTION
s, isdb1.subtransactiontype st where s.SUBTRANSACTIONTYPE_SUBTRANSA12
= st.subtransactiontypeid and s.subtransactionstatusid = 2 and
st.SUBTRANSACTIONMODULEID in (1,2,5,7,8,9) and s.createdon between
'2007-04-09 00:01:01.000000' and '2007-04-09 23:59:01.424000';
quit; -z dailyTransactions.out.txt'
[exec]
[exec] The ' characters around the executable and arguments are
[exec] not part of the command.
[sleep] sleeping for 20000 milliseconds
BUILD SUCCESSFUL
Total time: 20 seconds
the contents of the folowing files are being used.
===count.xml===(pass and username have been blanked for posting)
<project name="dailyTransactions" default="query" basedir=".">
<target name="init" description="prep directories and set times
etc...">
<tstamp>
<format property="today" pattern="yyyy-MM-dd" />
</tstamp>
<property name="schema" value="isdb1" />
<property name="database" value="db0z" />
<property name="userName" value="*******" />
<property name="userPass" value="******" />
<property name="outputFile"
value="dailyTransactions.out.txt" />
<property name="sqlCommands"
value="transactionCount.sql" />
<property name="errorFile"
value="dailyTransactionsError.txt" />
<loadfile property="sql" srcFile="transactionCount.sql"
>
<filterchain>
<striplinebreaks/>
</filterchain>
<filterchain>
<replacestring from="THESCHEMA"
to="${schema}" />
</filterchain>
<filterchain>
<replacestring from="DATABASE"
to="${database}" />
</filterchain>
<filterchain>
<replacestring from="THEUSERNAME"
to="${userName}" />
</filterchain>
<filterchain>
<replacestring from="THEPASSWORD"
to="${userPass}" />
</filterchain>
<filterchain>
<replacestring from="THEDATE"
to="${today}" />
</filterchain>
</loadfile>
<echoproperties />
</target>
<target name="query" depends="init" description="execute sql
quarrey
">
<delete file="${outputFile}" />
<exec executable="cmd.exe" os="Windows XP"
error="${errorFile}"
resultproperty="queryResult" failonerror="false" timeout="180000">
<arg value="/c db2cmd db2 -tx ${sql} -z
${outputFile}" />
</exec>
<sleep seconds="20" />
</target>
</project>
===transactioncount.sql===
connect to DATABASE user THEUSERNAME using THEPASSWORD;
SET SCHEMA THESCHEMA;
Select count (*)
from THESCHEMA.SUBTRANSACTION s, THESCHEMA.subtransactiontype st
where s.SUBTRANSACTIONTYPE_SUBTRANSA12 = st.subtransactiontypeid and
s.subtransactionstatusid = 2 and
st.SUBTRANSACTIONMODULEID in (1,2,5,7,8,9) and
s.createdon between 'THEDATE 00:01:01.000000' and 'THEDATE
23:59:01.424000';
quit;
--
__________________________________
No matter how responsible he may seem,
Never give your Gun to a Monkey.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org
RE: calling a DB2 request.
Posted by "Ditrick, Gregory" <gr...@fmr.com>.
Dwayne,
Change this line:
<arg value="/c db2cmd db2 -tx ${sql} -z ${outputFile}" />
To this:
<arg line="/c db2cmd db2 -tx ${sql} -z ${outputFile}" />
The <arg value> will put quotes around the arg to treat it as 1 argument
instead of individual args.
Or
Use multiple <arg value> for each of your arguments.
I hope this helps.
Later,
GregD
6-8309
-----Original Message-----
From: Dwayne Walker [mailto:wb5plj@gmail.com]
Sent: Monday, April 09, 2007 1:58 PM
To: user@ant.apache.org
Subject: calling a DB2 request.
Hi I am having a problem passing some sql to the db2cmd via ant. This
is very confusing as I am doing this exact thing elseware with no
problem (just differant sql, and I have verified the sql is valid) but
in this one I am having problems. Any time I run this I get the
folowing message from the db2 clp window that opens up.
SQL0104N An unexpected token "SET" was found following
"<identifier>".
Expected tokens may include: "NEW". SQLSTATE=42601
C:\eclipse_workspace\massSQL>
I don't know what is going on here but I am by no means familiar with
db2cmd and all that so any help is apreachated. If I could get this to
work in a batch file or from a command line I am sure I could get the
ant part of it on my own. it is the db2 that is giving me issues.
thanks. Dwayne
this is the console log from ant of what is being passed.
Apache Ant version 1.7.0 compiled on December 13 2006
Buildfile: C:\eclipse_workspace\massSQL\count.xml
parsing buildfile C:\eclipse_workspace\massSQL\count.xml with URI =
file:/C:/eclipse_workspace/massSQL/count.xml
Project base dir set to: C:\eclipse_workspace\massSQL
Build sequence for target(s) `query' is [init, query]
Complete build sequence is [init, query, query3, query2, ]
init:
[antlib:org.apache.tools.ant] Could not load definitions from resource
org/apache/tools/ant/antlib.xml. It could not be found.
[loadfile] loading C:\eclipse_workspace\massSQL\transactionCount.sql
into property sql
[loadfile] loaded 383 characters
[echoproperties] #Ant properties
[echoproperties] #Mon Apr 09 11:12:51 CDT 2007
[echoproperties] DSTAMP=20070409
[echoproperties] TODAY=April 9 2007
[echoproperties] TSTAMP=1112
[echoproperties] ant.core.lib=C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant.jar
[echoproperties] ant.file=C\:\\eclipse_workspace\\massSQL\\count.xml
[echoproperties] ant.file.dailyTransactions=C\:\\eclipse_workspace\
\massSQL\\count.xml
[echoproperties] ant.home=C\:\\eclipse\\plugins\\org.apache.ant_1.7.0
[echoproperties] ant.java.version=1.5
[echoproperties] ant.library.dir=C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib
[echoproperties] ant.project.name=dailyTransactions
[echoproperties] ant.version=Apache Ant version 1.7.0 compiled on
December 13 2006
[echoproperties] awt.toolkit=sun.awt.windows.WToolkit
[echoproperties] basedir=C\:\\eclipse_workspace\\massSQL
[echoproperties] database=db0z
[echoproperties] eclipse.pdebuild.home=/C\:/eclipse/plugins/
org.eclipse.pde.build_3.2.1.r321_v20060823/./
[echoproperties] eclipse.pdebuild.scripts=/C\:/eclipse/plugins/
org.eclipse.pde.build_3.2.1.r321_v20060823/scripts/
[echoproperties] eclipse.pdebuild.templates=/C\:/eclipse/plugins/
org.eclipse.pde.build_3.2.1.r321_v20060823/templates/
[echoproperties] errorFile=dailyTransactionsError.txt
[echoproperties] file.encoding=Cp1252
[echoproperties] file.encoding.pkg=sun.io
[echoproperties] file.separator=\\
[echoproperties] java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment
[echoproperties] java.awt.printerjob=sun.awt.windows.WPrinterJob
[echoproperties] java.class.path=C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-antlr.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-apache-bcel.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-apache-bsf.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-apache-log4j.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-apache-oro.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-apache-regexp.jar;C\:\\eclipse\\plugins
\\org.apache.ant_1.7.0\\lib\\ant-apache-resolver.jar;C\:\\eclipse\
\plugins\\org.apache.ant_1.7.0\\lib\\ant-commons-logging.jar;C\:\
\eclipse\\plugins\\org.apache.ant_1.7.0\\lib\\ant-commons-net.jar;C\:\
\eclipse\\plugins\\org.apache.ant_1.7.0\\lib\\ant-jai.jar;C\:\\eclipse\
\plugins\\org.apache.ant_1.7.0\\lib\\ant-javamail.jar;C\:\\eclipse\
\plugins\\org.apache.ant_1.7.0\\lib\\ant-jdepend.jar;C\:\\eclipse\
\plugins\\org.apache.ant_1.7.0\\lib\\ant-jmf.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-jsch.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-junit.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-launcher.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-netrexx.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-nodeps.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-starteam.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-stylebook.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-swing.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-testutil.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-trax.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant-weblogic.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\ant.jar;C\:\\eclipse\\plugins\
\org.apache.ant_1.7.0\\lib\\commons-net-1.4.1.jar;C\:\\eclipse\\plugins
\\org.apache.ant_1.7.0\\lib\\jakarta-oro-2.0.8.jar;C\:\\eclipse\
\plugins\\org.apache.ant_1.7.0\\lib\\xercesImpl.jar;C\:\\eclipse\
\plugins\\org.apache.ant_1.7.0\\lib\\xml-apis.jar;C\:\\eclipse\
\configuration\\org.eclipse.osgi\\bundles\\10\\1\\.cp\\lib\
\remoteAnt.jar;C\:\\IBM\\WebSphere\\AppServer\\java\\lib\\tools.jar;C\:
\\eclipse\\plugins\\org.eclipse.swt.win32.win32.x86_3.2.2.v3235a.jar
[echoproperties] java.class.version=49.0
[echoproperties] java.endorsed.dirs=C\:\\Program Files\\Java\
\jre1.5.0_06\\lib\\endorsed
[echoproperties] java.ext.dirs=C\:\\Program Files\\Java\\jre1.5.0_06\
\lib\\ext
[echoproperties] java.home=C\:\\Program Files\\Java\\jre1.5.0_06
[echoproperties] java.io.tmpdir=C\:\\DOCUME~1\\WalkeD\\LOCALS~1\\Temp\
\
[echoproperties] java.library.path=C\:\\WINDOWS\\system32;.;C\:\
\WINDOWS\\system32;C\:\\WINDOWS;C\:\\Program Files\\IBM\\WebSphere MQ\
\Java\\lib;C\:\\WINDOWS\\system32;C\:\\WINDOWS;C\:\\WINDOWS\\System32\
\Wbem;C\:\\Program Files\\IBM\\IBM CICS Transaction Gateway\\BIN;C\:\
\apache-ant-1.7.0\\bin;C\:\\j2sdk1.4.1_01\\bin;C\:\\Program Files\\IBM\
\WebSphere MQ\\bin;C\:\\Program Files\\IBM\\WebSphere MQ\\WEMPS\\bin;C
\:\\Program Files\\TextPad 4;C\:\\Program Files\\PuTTY;C\:\\PROGRA~1\
\IBM\\SQLLIB\\BIN;C\:\\PROGRA~1\\IBM\\SQLLIB\\FUNCTION;C\:\\PROGRA~1\
\IBM\\SQLLIB\\SAMPLES\\REPL;;C\:\\Program Files\\Visual Explain\\lib;C
\:\\Program Files\\CVSNT\\;C\:\\eclipse\\configuration\
\org.eclipse.osgi\\bundles\\718\\1\\.cp
[echoproperties] java.runtime.name=Java(TM) 2 Runtime Environment,
Standard Edition
[echoproperties] java.runtime.version=1.5.0_06-b05
[echoproperties] java.specification.name=Java Platform API
Specification
[echoproperties] java.specification.vendor=Sun Microsystems Inc.
[echoproperties] java.specification.version=1.5
[echoproperties] java.vendor=Sun Microsystems Inc.
[echoproperties] java.vendor.url=http\://java.sun.com/
[echoproperties] java.vendor.url.bug=http\://java.sun.com/cgi-bin/
bugreport.cgi
[echoproperties] java.version=1.5.0_06
[echoproperties] java.vm.info=mixed mode
[echoproperties] java.vm.name=Java HotSpot(TM) Client VM
[echoproperties] java.vm.specification.name=Java Virtual Machine
Specification
[echoproperties] java.vm.specification.vendor=Sun Microsystems Inc.
[echoproperties] java.vm.specification.version=1.0
[echoproperties] java.vm.vendor=Sun Microsystems Inc.
[echoproperties] java.vm.version=1.5.0_06-b05
[echoproperties] line.separator=\r\n
[echoproperties] os.arch=x86
[echoproperties] os.name=Windows XP
[echoproperties] os.version=5.1
[echoproperties] outputFile=dailyTransactions.out.txt
[echoproperties] path.separator=;
[echoproperties] schema=isdb1
[echoproperties] sql=connect to db0z user dmfstr1 using dfstr101; SET
SCHEMA isdb1; Select count (*) from isdb1.SUBTRANSACTION s,
isdb1.subtransactiontype st where s.SUBTRANSACTIONTYPE_SUBTRANSA12 \=
st.subtransactiontypeid and s.subtransactionstatusid \= 2 and
st.SUBTRANSACTIONMODULEID in (1,2,5,7,8,9) and s.createdon between
'2007-04-09 00\:01\:01.000000' and '2007-04-09 23\:59\:01.424000';\t
\t \t quit;
[echoproperties] sqlCommands=transactionCount.sql
[echoproperties] sun.arch.data.model=32
[echoproperties] sun.boot.class.path=C\:\\Program Files\\Java\
\jre1.5.0_06\\lib\\rt.jar;C\:\\Program Files\\Java\\jre1.5.0_06\\lib\
\i18n.jar;C\:\\Program Files\\Java\\jre1.5.0_06\\lib\\sunrsasign.jar;C
\:\\Program Files\\Java\\jre1.5.0_06\\lib\\jsse.jar;C\:\\Program Files\
\Java\\jre1.5.0_06\\lib\\jce.jar;C\:\\Program Files\\Java\\jre1.5.0_06\
\lib\\charsets.jar;C\:\\Program Files\\Java\\jre1.5.0_06\\classes
[echoproperties] sun.boot.library.path=C\:\\Program Files\\Java\
\jre1.5.0_06\\bin
[echoproperties] sun.cpu.endian=little
[echoproperties] sun.cpu.isalist=
[echoproperties] sun.desktop=windows
[echoproperties] sun.io.unicode.encoding=UnicodeLittle
[echoproperties] sun.jnu.encoding=Cp1252
[echoproperties] sun.management.compiler=HotSpot Client Compiler
[echoproperties] sun.os.patch.level=Service Pack 2
[echoproperties] today=2007-04-09
[echoproperties] user.country=US
[echoproperties] user.dir=C\:\\eclipse_workspace\\massSQL
[echoproperties] user.home=C\:\\Documents and Settings\\WalkeD
[echoproperties] user.language=en
[echoproperties] user.name=walked2
[echoproperties] user.timezone=
[echoproperties] user.variant=
[echoproperties] userName=********
[echoproperties] userPass=********
query:
[delete] Could not find file C:\eclipse_workspace\massSQL
\dailyTransactions.out.txt to delete.
[exec] Current OS is Windows XP
[exec] Error redirected to C:\eclipse_workspace\massSQL
\dailyTransactionsError.txt
[exec] Executing 'cmd.exe' with arguments:
[exec] '/c db2cmd db2 -tx connect to db0z user ******* using
*******; SET SCHEMA isdb1; Select count (*) from isdb1.SUBTRANSACTION
s, isdb1.subtransactiontype st where s.SUBTRANSACTIONTYPE_SUBTRANSA12
= st.subtransactiontypeid and s.subtransactionstatusid = 2 and
st.SUBTRANSACTIONMODULEID in (1,2,5,7,8,9) and s.createdon between
'2007-04-09 00:01:01.000000' and '2007-04-09 23:59:01.424000';
quit; -z dailyTransactions.out.txt'
[exec]
[exec] The ' characters around the executable and arguments are
[exec] not part of the command.
[sleep] sleeping for 20000 milliseconds
BUILD SUCCESSFUL
Total time: 20 seconds
the contents of the folowing files are being used.
===count.xml===(pass and username have been blanked for posting)
<project name="dailyTransactions" default="query" basedir=".">
<target name="init" description="prep directories and set times
etc...">
<tstamp>
<format property="today" pattern="yyyy-MM-dd" />
</tstamp>
<property name="schema" value="isdb1" />
<property name="database" value="db0z" />
<property name="userName" value="*******" />
<property name="userPass" value="******" />
<property name="outputFile"
value="dailyTransactions.out.txt" />
<property name="sqlCommands"
value="transactionCount.sql" />
<property name="errorFile"
value="dailyTransactionsError.txt" />
<loadfile property="sql" srcFile="transactionCount.sql"
>
<filterchain>
<striplinebreaks/>
</filterchain>
<filterchain>
<replacestring from="THESCHEMA"
to="${schema}" />
</filterchain>
<filterchain>
<replacestring from="DATABASE"
to="${database}" />
</filterchain>
<filterchain>
<replacestring from="THEUSERNAME"
to="${userName}" />
</filterchain>
<filterchain>
<replacestring from="THEPASSWORD"
to="${userPass}" />
</filterchain>
<filterchain>
<replacestring from="THEDATE"
to="${today}" />
</filterchain>
</loadfile>
<echoproperties />
</target>
<target name="query" depends="init" description="execute sql
quarrey
">
<delete file="${outputFile}" />
<exec executable="cmd.exe" os="Windows XP"
error="${errorFile}"
resultproperty="queryResult" failonerror="false" timeout="180000">
<arg value="/c db2cmd db2 -tx ${sql} -z
${outputFile}" />
</exec>
<sleep seconds="20" />
</target>
</project>
===transactioncount.sql===
connect to DATABASE user THEUSERNAME using THEPASSWORD;
SET SCHEMA THESCHEMA;
Select count (*)
from THESCHEMA.SUBTRANSACTION s, THESCHEMA.subtransactiontype st
where s.SUBTRANSACTIONTYPE_SUBTRANSA12 = st.subtransactiontypeid and
s.subtransactionstatusid = 2 and
st.SUBTRANSACTIONMODULEID in (1,2,5,7,8,9) and
s.createdon between 'THEDATE 00:01:01.000000' and 'THEDATE
23:59:01.424000';
quit;
--
__________________________________
No matter how responsible he may seem,
Never give your Gun to a Monkey.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org