473,324 Members | 2,166 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Connection between DB2 personal and DB2 mainframe

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
http://community.webshots.com/user/ross_klatte
http://www.geocities.com/foundlingfather/
Nov 12 '05 #1
2 1718
"Ross Klatte" <kl********@aol.commmm> wrote in message
news:20***************************@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.
Nov 12 '05 #2
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" <kl********@aol.commmm> wrote in message
news:20***************************@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.


Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: middletree | last post by:
I'm used to doing ASP with SQL Server, but now I'm doing something with Access. Never understood connection strongs, but managed to get by with pasted code. Now, I can't make this work. Can anyone...
4
by: Erik-Jan Bakker | last post by:
Hi I am not a javascript expert and I have a problem that the guru's in this newsgroup probably can solve quickly. ;-) I've made a webpage with three frames: top, left and mainframe. I...
1
by: Terry Coccoli | last post by:
Can a version 7 middleware be bound to a version 6 database (UDB) ? Or does the client have to be on the same or lower version than the database ?
3
by: Andrew Johnson | last post by:
Hi, I am trying to make a UBD DB2 7.2 connection using the Java COM.ibm.db2.jdbc.app.DB2Driver via Tomcat 3.2.1 on Solaris (and also on an AIX system with 3.3.1). I am attempting this either...
6
by: jonefer | last post by:
I have two versions of a 'Downtime Application that will run in the event that the mainframe goes down 1) SQL Server ASP.NET app (accessed outside the mainframe network) 2) MS Access Version of...
14
by: WebMatrix | last post by:
Hello, I have developed a web application that connects to 2 different database servers. The connection strings with db username + password are stored in web.config file. After a code review,...
1
by: uli2003wien | last post by:
Dear group, i am a seasoned DB2-veteran (6 years exp.) on the Windows- and Linux-Server platform. Once in a while i had a look into DB2 on the mainframe but mostly only watching other people do...
2
by: gndzkdr | last post by:
hi all, i m new on Sql and i have a project related to C# and Sql. i have to do a project which must work on LAN, and there must be only one database file on main computer(Server Computer) and...
2
by: jimcleve | last post by:
Have an authentication/authorizaiton question. Our usual means to provide SYSADM authority for incoming connections to DB2 v8.2 on AIX has been to use SERVER authentication and set the...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.