simple question - DB2 Database

Daniel Wang

I am using the latest trial version of DB2 on Windows.

I would like to modify the contents of a table and Control Center allows me
to view the contents by right clicking on the table name selecting "sample
contents". But it seems it give me back a read only view. Is there a way to
change the contents via the gui?

Thanks.

Nov 12 '05 #1

Subscribe Reply

1257

Rhino

"Daniel Wang" <dh****@nothing .no.spam.com> wrote in message
news:ou8qc.3228 1$Lm3.20387@lak eread04...

I am using the latest trial version of DB2 on Windows.

I would like to modify the contents of a table and Control Center allows me to view the contents by right clicking on the table name selecting "sample
contents". But it seems it give me back a read only view. Is there a way to change the contents via the gui?

Yes, use the Command Center and issue an SQL statement like INSERT, UPDATE,
or DELETE against the table you want to change. You can launch the Command
Center from the Control Center; it's the one that has "C:>" in the icon.
(I'm running V7.2 and you're probably running V8.1.x so I'm not sure if the
icons are the same.)

If you mean that you don't want to type an SQL statement at all, you can
build one. The Interactive tab of the Command Center has a button for "SQL
Assist". If you press that and fill in the appropriate boxes on the Logon
tab of SQL Assist, you can build your query a step at a time. You specify
the table you want, then the columns, row conditions, etc. until you have
built your query. Then you press the Run button in SQL Assist to execute the
statement.

Rhino

Nov 12 '05 #2

Serge Rielau

Daniel,

There is a tool called the table-editor.
I've never used it, but here goes:
http://publib-b.boulder.ibm.com/Redb...ighlight=0,ims
(long link.. just search for "DB2 Table Editor" in www.ibm.com
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Nov 12 '05 #3

Blair Adamache

The version 8 Command Center allows you to edit table results after you
SELECT on the table.

Daniel Wang wrote:

I am using the latest trial version of DB2 on Windows.

I would like to modify the contents of a table and Control Center allows me
to view the contents by right clicking on the table name selecting "sample
contents". But it seems it give me back a read only view. Is there a way to
change the contents via the gui?

Thanks.

Nov 12 '05 #4

Similar topics

3704

A (Simple) Polymorphism Query

by: Patchwork | last post by:

Hi Everyone, Please take a look at the following (simple and fun) program: //////////////////////////////////////////////////////////////////////////// ///////////// // Monster Munch, example program #include <list>

C / C++

3433

Help needed programming a simple script

by: Proteus | last post by:

Any help appreciated on a small perl project I need to write for educator/teaching purposes. I have not programmed perl for some time, need to get up to speed, maybe some kind souls hrere will help me on this project? It looks to be a simple project, and I will start relearning pearl, but any help appreciated! I need to read and parse a simple text file (INPUT) containing multiple choice quiz questions (with titles) and answers, and...

Perl

5031

simple question (itoa, localtime)

by: Raskolnikow | last post by:

Hi! I have a very simple problem with itoa() or the localtime(...). Sorry, if it is too simple, I don't have a proper example. Please have a look at the comments. struct tm *systime; time_t currentTime; char day; char month;

C / C++

2168

Simple question on Treeview?

by: Peter | last post by:

Hello Thanks for reviewing my question. I would like to know how can I programmatically select a node Thanks in Advanc Peter

C# / C Sharp

2291

asp.net simple question

by: abcd | last post by:

I am trying to set up client machine and investigatging which .net components are missing to run aspx page. I have a simple aspx page which just has "hello world" printed.... When I request that page like http://machinename/dir1/hellp.aspx instead of running that page it starts downloding ...whats missing here ....why the aspx engine not running the page....

ASP.NET

118819

SIMPLE command to convert string to number? Not CAST or CONVERT.

by: dba_222 | last post by:

Dear Experts, Ok, I hate to ask such a seemingly dumb question, but I've already spent far too much time on this. More that I would care to admit. In Sql server, how do I simply change a character into a number?????? In Oracle, it is:

Microsoft SQL Server

2990

A simple class

by: Giancarlo Berenz | last post by:

Hi: Recently i write this code: class Simple { private: int value; public: int GiveMeARandom(void);

C / C++

3553

simple code performance question

by: galiorenye | last post by:

Hi, Given this code: A** ppA = new A*; A *pA = NULL; for(int i = 0; i < 10; ++i) { pA = ppA; //do something with pA

C / C++

2142

Writing a simple webservice

by: Phillip Taylor | last post by:

Hi guys, I'm looking to develop a simple web service in VB.NET but I'm having some trivial issues. In Visual Studio I create a web services project and change the asmx.vb file to this: Imports System.Web.Services Imports System.Web.Services.Protocols Imports System.ComponentModel <System.Web.Services.WebService(Namespace:="http:// wwwpreview.#deleted#.co.uk/~ptaylor/Customer.wsdl")_

Visual Basic .NET

5828

a really simple C++ abstraction around pthread_t...

by: Chris M. Thomasson | last post by:

I use the following technique in all of my C++ projects; here is the example code with error checking omitted for brevity: _________________________________________________________________ /* Simple Thread Object ______________________________________________________________*/ #include <pthread.h> extern "C" void* thread_entry(void*);

C / C++

9579

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10578

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10332

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

10321

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

7620

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

5651

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4300

transfer the data from one system to another through ip address

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

C# / C Sharp

3820

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2991

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General