But you can use the CLP against DB2 for zOS if you have DB2 Connect,
which comes with the CLP. This would allow you to route zOS data to the
disk on the Windows machine.

Mark A wrote:

> "Ross Klatte" <klatteross@aol.commmm> wrote in message
> news:20040403224705.16223.00000468@mb-m23.aol.com...
>
>>I have downloaded the personal version of DB2 on my home computer, and I
>
> work
>
>>with the IBM Z/OS version of DB2 at work.
>>There seem to be some differences.
>>For example, at home I have an ECHO command to block out the actual SQL
>
> Select
>
>>statements, but that does not seem to be available on the IBM Spufi.
>>Also, the command
>>UPDATE COMMAND OPTIONS USING R ON 'D:\DB2\TEXTOUT.TXT'
>>is very nice on my home box, but I cannot figure out how to do that on the
>
> IBM
>
>>Spufi. How do I route the output (minus the Select statement) to a disk
>
> file
>
>>instead of to a print file?
>>
>>
>>Ross
>>Vontay, Virginia
>
>
> DB2 for OS/390 is a different product than DB2 for Windows, etc. The two
> products are mostly the same at the DML level, somewhat the same at the DDL
> level, and quite different at the utility/command level. SPUFI is not the
> equivalent of the CLP.
>
>