|
by: Mortimer |
last post by:
Hi,
I hope someone can help. I can't seem to find the answer to this
anywhere. I need to change the SQL terminator from a semicolon (;) to
an exclamation point within SPUFI in order to process a file of SQL
statements. The reason I need to make the change is the SQL contains
imbedded semicolon characters within text values. There are also
imbedded double-quotes and text values are enclosed within
single-quotes.
As far as I can tell,...
|
by: Jagdip Singh |
last post by:
Hi,
What is SPUFI
regards,
jagdip
|
by: Narender Singh |
last post by:
Hi All,
Is there anyway i can run the Online Spufi panel in batch. I don't
want to use the DSNTEP2 program, b'cause it has a limit of 133 Record
length. And apart from these i don't have access to other DB2
utilities to access DB2.
Thanks & Regards,
Naren
|
by: waimanlau |
last post by:
Hi all!
System Specs: DB2 UDB 7 on z/OS 390
The Problem: I want to execute a DDL file in my allocated Data Set. But
the only thing that happens, when I press Enter is, that SPUFI jumps
back to the DB2 Utilities Menu.
|
by: Aanand |
last post by:
Hi all,
A crazy thought just popped up into my head.
Supposing your site didnt have SPUFI / QMF / Candle / Platinum or any
tool that would let u create and run your SQLs, which would be the best
way to get your data?
(fyi we use SPUFI, CANDLE and PLATINUM)
I think there is a method to use IKJEFT01 and the DSN SYSTEM / some
|
|
by: mvsguy |
last post by:
I'm a sysprog who is new to DB2. I've installed both QMF & SPUFI.
SPUFI seems far more flexible than QMF. Could someone explain the
difference? What does QMF do that SPUFI can't?
Regards,
MVSGuy
|
by: mohandaspradeep |
last post by:
Hi
Is there any restriction in coding number of queries in a single file for a Batch SPUFI in DB2?
Can a Batch SPUFI have any no of queries in it ?
|
by: LA1 |
last post by:
I have telecomuter that logs into a mainframe to use a DB2 database. The client uses SPUFI to edit the database and make changes. The client has received from us a new notebook. Both his old and new notebook do the same thing , the client edits the data set through SPUFI, then saves or exits there is an audible tone. The tone is OK it is just that with the new notebook the tone is really load. I do not think it is a windows generated sound....
|
by: karpalmera |
last post by:
Hello! I am using UDB 8 in Z/OS and I am trying to execute this statement in SPUFI
select dept, name, row_number() over()
from staff
It just doesn't work. Here is the error message:
---------+---------+---------+---------+---------+---------+---------+---------
SELECT DEPT, NAME, ROW_NUMBER() OVER() FROM DBPROD.STAFF;
---------+---------+---------+---------+---------+---------+---------+---------
DSNT408I SQLCODE = -104, ERROR: ...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|