Question about IBM DB2 Connect Enterprise Edition for PC, Unix

1 Answer

I installed DB2 in my laptop . then i go to all programs->DBCOPY1(default)-> command line tools -> command editor then write down query to create a table but i cant build it it is 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. Explanation: 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. User response: 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. sqlcode: -1024 sqlstate: 08003 What should i do???

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 258 Answers

Hi,

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

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
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.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Step by step instructions on how to create a macro, create form f


You can create a macro by using the macro recorder to record a sequence of actions, or you can create a macro from scratch by entering Visual Basic for Applications code in the Visual Basic Editor.
Open a new document.
From the Tools menu, choose Customize.
Click the Commands tab and then scroll down in the Categories box and select Macros. You’ll see the names of any macros you've created in the Commands box on the right-hand side.
Click, hold, and drag your macro onto any toolbar and release, as shown in Figure D. A button with the name of the macro will appear on the toolbar.

May 25, 2010 | Microsoft Office Word 2007 Full Version...

1 Answer

The shape of the cursor in Visual Foxpro


I, too, am a veteran of DOS to Windows conversions, in fact, I make my living at it. But I learned over a decade ago to get over the differences, like using Tab instead of Enter to move around the screen, and of course, the cursor shape.

If you want your converted program to be accepted by people who have never seen DOS, you need it to follow Windows UI conventions.

Dec 13, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Creating a default directory in Quattor Pro (11?)


The solution was two-fold although I am not positive they are related. Download and install Service Pac 2, for Wordperfect Office X3. This file addresses Vista related issues and so may be crucial for programs originally written for XP. Once that file was installed, in QPro go to Tools/Settings/File Options and enter the path of the subdirectory you wish to open. Use a final "/". Perhaps, use another subdirectory for backups (the third line on the page). It worked fine.

Bill

Jun 03, 2009 | Corel WordPerfect® Office X3 Standard...

1 Answer

Outlook 2003 font format removed after sending


It depends on the settings of the receiver's email program.

Mar 18, 2009 | Microsoft Computers & Internet

1 Answer

After installing DB2 query is not executing


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.

Dec 05, 2008 | IBM DB2 Connect Enterprise Edition for PC,...

1 Answer

DB2 Connect and Excel


hi, you can use the SQL Drill freeware addin (http://www.sqldrill.com) It is an addin which lets you connect to ODBC compliant databases (DB2, Oracle, SQL Server etc..)
hth

Dec 03, 2008 | IBM DB2 Connect Enterprise Edition for PC,...

5 Answers

SQL SERVER 2000


Perform following steps to recover sql server database:
  • Create a database with same size that you are trying to recover
  • Shutdown the SQL server
  • Swap old mdf file with new mdf file
  • Start the SQL server
  • Database may go in suspect
  • Set database in emergency mode
  • Run DBCC CHECKDB with repair_allow_data_loss to repair database


USE [master]
GO
ALTER DATABASE [RdmStoreInformation] SET EMERGENCY
GO
ALTER DATABASE [RdmStoreInformation] SET SINGLE_USER
GO
DBCC CHECKDB ([RdmStoreInformation], REPAIR_ALLOW_DATA_LOSS)
GO
ALTER DATABASE [RdmStoreInformation] SET MULTI_USER
GO
ALTER DATABASE [RdmStoreInformation] SET ONLINE


It may result some data loss. If you don't want to lose any single data then use 3rd party SQL repair software from Stellar Phoenix.

Mar 19, 2008 | Computers & Internet

3 Answers

Excel vba password recovery


You can but you will need software. Search for google for VBA password recovery tools. Search for the appropriate crack you have it all . .

Dec 30, 2007 | Microsoft Excel for PC

1 Answer

Ms access


Stored Procedures don't exist in MS Access. You do have the following options though. Queries, which are just select or action queries. VB Code, which you can write using Query Objects as if you were writing a Visual Basic application. These can be Functions or Subroutines. In these, you would use the standard programming techniques with while and for loops, etc.

You can create complex situations combining the two of these. A function in the VB code area can accept through parameters, the single values (line by line, record by record) in a query and act on them and manipulate the values.

For example: create a query that does a select phone from address. Create a function in vb called public function StripDashesInPhone(Phone as string) which then uses VB coding to strip dashes from each phone value passed in. To make it all work, in the query on one of the field columns put "NewPhone: StripDashesInPhone([Phone])" and for every record processed in the query, the function is called with the [Phone] field value passed in to the function and the action is processed and returned.

Other than writing a function that is activated by a form button click, which opens the current db and opens a table and process it, just like in VB, this is about as close to cursors and oracle procedures as you get.

I wish it was more, but ...

Oct 09, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
IBM DB2 Connect Enterprise Edition for PC, Unix Logo

Related Topics:

236 people viewed this question

Ask a Question

Usually answered in minutes!

Top IBM Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18333 Answers

Donald DCruz
Donald DCruz

Level 3 Expert

17129 Answers

Are you an IBM Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...