>
>
> Hello,
> at the moment I build some scripts to handle DB2 data. To capture the
command output I try to use RxQueue
> and for simple samples as “DIR |RXQUEUE” it work.
> But for the following sample
>
> ‘DB2 –c –ec –m –t CONNECT TO database USER userid USING password’
> ‘DB2 –c –ec –m –t EXPORT TO “D:\TEST\test.ixf” OF IXF MESSAGES
“D:\TEST\test.log” SELECT * FROM table |RXQUEUE’
> Do I = 1 to queued()
> Say linein(“QUEUE:”)
> End
>
> I found in the queue always the message
> SQL1024N Connection to database lost.
> Without ‘|RXQUEUE’ the commands run successfully within a rexx script
>
> I know that is a very special question but anybody that already work with
db2 commands and can help me?
> regards
> Roger
>
>
>
> ------------------------------------------------------------------------------
> Flow-based real-time traffic analytics software. Cisco certified tool.
> Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer
> Customize your own dashboards, set traffic alerts and generate reports.
> Network behavioral analysis & security monitoring. All-in-one tool.
> http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk
>
> _______________________________________________
> Oorexx-users mailing list
> Oorexx-users@...
> https://lists.sourceforge.net/lists/listinfo/oorexx-users
>
Hi Roger,
i had the same Problem, and had rewritten my Program like this
/* REXX */
call ex_cmd "db2 connect to <database>"
call ex_cmd "db2 select creator, name from sysibm.systables"
call ex_cmd "db2 connect reset"
return
ex_cmd:
TEMP_FILE = SysTempFileName("MY_Temp_File.???")
command = arg(1)
/* include commandoption +o and -z */
if Translate(word(command , 1) ) = "DB2" Then command = word(command , 1)
"+o -z "Temp_file Subword(command, 2)
address cmd command
do while lines(Temp_File) > 0
Zeile = Linein(Temp_File)
say Zeile
End
delok = SysFileDelete(Temp_File)
return
Roger Bilau <sf@...> writes:
------------------------------------------------------------------------------
Open source business process management suite built on Java and Eclipse
Turn processes into business applications with Bonita BPM Community Edition
Quickly connect people, data, and systems into organized workflows
Winner of BOSSIE, CODIE, OW2 and Gartner awards
http://p.sf.net/sfu/Bonitasoft
_______________________________________________
Oorexx-users mailing list
Oorexx-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/oorexx-users
