I got it. Just add one more option: -z ';'

Thanks

-------------- Original message ----------------------
From: "ngatran" <db2udbdba-ezmlmshield-x55511694.[Email address protected]
> Hi,
>
> I am using db2expl to get access plan:
>
> db2expln -d dbname -t -f query.sql -g
>
> It only works if the query in query.sql is on one line. How can I make it work
> for a many-line query?
>
> Thanks
> Nga
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>


DB2 & UDB email list listserv db2-l LazyDBA home page