Question about IBM DB2 Connect Enterprise Edition for PC, Unix
I go from all programs -> IBM DB2-> DBCOPY1(default)-> command line tools-> command editor
From the editor i write a simple query to create a table
CREATE TABLE student
name CHAR(50) NOT NULL
,std_id INTEGER NOT NULL
PRIMARY KEY (std_id)
But showing .....
CREATE TABLE student ( name CHAR(50) NOT NULL ,std_id INTEGER NOT NULL ,adress CHAR(50) ,contact CHAR(50) PRIMARY KEY (std_id) )
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL1024N A database connection does not exist. SQLSTATE=08003
SQL1024N A database connection does not exist.
There is no connection to a database. Other SQL statements cannot be
processed unless an SQL CONNECT was previously executed.
The command cannot be processed.
If the error occurred when disconnecting from the database, continue
processing. If the error occurred on another SQL statement, issue an SQL
CONNECT statement and resubmit the command or statement.
what should i do for a data base and execute any query here ??
Could you check whether you are connected to the database, where you are trying to create table,
check the database list, then connect to the database you want then execute the table creation ddl,
if no db found then create a database then proceed.
Posted on Feb 05, 2009
SOURCE: i installed DB2 in my
Before you create a table you need to:-
1. create a database
2. create a username and password or use the admin generated userid
3. connect to the database
you can then create a table and use the database
Please post if you do not know how to do this and i'll give you some links
Posted on Feb 10, 2009
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Oct 18, 2016 | Computers & Internet
on Oct 03, 2010 | Computers & Internet
Oct 11, 2012 | Google Chrome
Dec 21, 2009 | Texas Instruments TI-84 Plus Calculator
Oct 14, 2009 | IBM DB2 Document Manager
Mar 23, 2009 | Microsoft Computers & Internet
Dec 05, 2008 | IBM DB2 Connect Enterprise Edition for PC,...
Nov 28, 2008 | IBM WebSphere Studio Application Developer...
May 29, 2008 | Macromedia Contribute 3 And FlashPaper 2...
913 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: