Question about IBM DB2 Connect Enterprise Edition for PC, Unix

1 Answer

After installing DB2 query is not executing

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
,adress CHAR(50)
,contact CHAR(50)
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.

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 for a data base and execute any query here ??

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

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

2 Suggested Answers

  • 258 Answers

SOURCE: i installed DB2 in my

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

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

HOW CAN I INSTALL MICROSOFT OFFICE ACCESS IN MY COMPUTER


  1. Click Start, point to Settings, and then click Control Panel.
  2. Double-click Add/Remove Programs, click Add New Programs, and then click CD or Floppy.
  3. Click Next.
  4. Click Browse.
  5. Locate the root folder of the Office source location, click Setup.exe, and then clickOpen.

    Setup.exe is added to the command line that appears in the Open box of the Run Installation Program dialog box.
  6. Click Finish to run Office Setup.
  7. If requested, type your customer name and product key (CD key) information in the appropriate boxes, and then click Next.

    Note The Next button is not available until you type a valid product key.
  8. Accept the End User License Agreement, and then click Next.
  9. Specify the location where you want to install Office, and then click Next.
  10. On the Choose which applications for setup to install page, click Next.

    If you click Choose detailed installation options for each application on theChoose which applications for setup to install page, and then click Next, the feature tree appears on the Choose installation options for all Office applications and tools page. Because Office Setup detects that you are using Terminal Services, the only installation states that are available are Not Available and Run from My Computer. By default, some features are set to Not Available. Do not change the installation states of these features to Run from My Computer, because you may experience problems with the Office programs that use these features.

    Warning By default, some features are set to Not Available to make sure that there is optimum performance in a Terminal Server environment, including the elimination of unexpected errors. Do not change the installation states of these features to Run from My Computer.

    Note If your Office source location is an administrative installation, Run from Networkis also displayed as an installation state.
  11. On the Begin installation page, click Install.
  12. When you receive a message that the installation completed successfully, click OK, clickNext, and then click Finish.

Nov 04, 2010 | Microsoft Office Professional 2007 Full...

1 Answer

I installed oracle 10g express edition.now I dono how to remove it. please let me kno how to uninstall it.I even stopped the oracle services but i dino abythin further.


Follow these steps:
  1. Open the Windows Services utility: From the Start menu, select All Programs, then Administrative Tools, and then Services.
  2. If any of the following Oracle services exist and have the status Started, then select each of the services, and click Stop:
    • OracleXE
    • OracleXETNSListener
    • OracleJobSchedulerXE
    • OracleXEClrAgent
    • OracleMTSRecoveryService
  3. Exit Services.
See also the Microsoft online help for more information on stopping services.
7.2.2 Step 2: Remove the Oracle Database XE Registry Editor Settings Follow these steps:
  1. Log on to Windows with Windows administrative privileges.
  2. Ensure that you followed the instructions under "Step 1: Stop the Oracle Database XE Services" to stop the Oracle Database XE services.
  3. Start the Registry Editor at a command prompt:
    SYSTEM_DRIVE:\> regedit
  4. Go to HKEY_CLASSES_ROOT.
  5. Delete the following keys:
    • NEED TO CONFIRM THE XE-SPECIFIC ONES.
  6. Go to HKEY_CURRENT_USER\Software.
  7. Under Microsoft\Windows\CurrentVersion\Explorer\MenuOrder\Start Menu\Programs, delete the Oracle Database 10g Express Edition key.
  8. Go to HKEY_LOCAL_MACHINE\SOFTWARE and search for the ORACLE group key.
  9. Expand the ORACLE group key and then delete the KEY_XE and OracleMTSRecoveryService keys.
  10. Go to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI.
  11. Expand the ODBCINST.INI key and remove the Oracle in XE key.
  12. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services.
  13. Delete the following keys:
    • OracleServiceXE
    • OracleXEClrAgent
    • OracleXETNSListener
  14. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application.
  15. Delete the Oracle.xe key.
  16. Exit the Registry Editor.
  17. Restart your computer.
7.2.3 Step 3: Update the System Variable Path Follow these steps:
  1. Open System from the Control Panel.
  2. In the System Properties dialog box, click the Advanced tab, then click the Environment Variables button.
  3. Select the system variable Path and edit the Path variable to remove the Oracle Database XE entry. For example:
    C:\oraclexe\app\oracle\product\10.2.0\server\bin;
  4. Save your changes and then exit the Control Panel.
7.2.4 Step 4: Remove Oracle Database XE from the Start Menu and Desktop Follow these steps:
  1. Select Start, then All Programs, and then Oracle Database 10g Express Edtion.
  2. Right-click Oracle Database 10g Express Edtion and from the menu, select Delete.
  3. On the desktop, right-click the Get Started with Oracle Database 10g Express Edition icon and from the menu, select Cut.
7.2.5 Step 5: Remove the Oracle Database XE Directories Follow these steps:
  1. Ensure that you have followed the instructions under "Step 1: Stop the Oracle Database XE Services" to stop all Oracle Database XE services.
  2. From the Windows Explorer, navigate to the directory where you installed Oracle Database XE, for example, c:\oraclexe.
  3. Right-click the Oracle Database XE installation directory and from the menu, select Delete.
7.2.6 Step 6: Install and Run the Windows Installer CleanUp Utility Run the Windows Installer CleanUp utility to remove the Windows Installation configuration information for the Oracle Database XE installation. You can download it from Microsoft at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;290301
he deinstallation completes, click Finish.

Sep 14, 2010 | Oracle Database 10g

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

How do i open a document which is saved on my desktop into Document Manager viewer. when i click the file am able to go to Document Manager Client.


If you go to the Document Manager client when you click the file, it sounds like the file is a .gml, which is a DM document link.
If it was e.g. a Word-file, it would've been opened just like Windows normally handles that filetype.

But, if you want to open document directly from viewer, launch the viewer from the DM program folder, e.g. C:\program files\ibm\db2 document manager\dmviewer.exe

Oct 14, 2009 | IBM DB2 Document Manager

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

I cannot print my documents even if there is Microsoft Office Document Imaging?


hi,
open Microsoft Office Document Imaging then opened the Tools menu, then
Options. In the Options window, select the "Other" tab and clicked on the "Reset" button under Default Program.

Then, close Microsoft Office Document Imaging and open windows explorer, navigated to an "*.MDI" file, right clicked it and chose "open with" "choose a program" then browse to the Microsoft Office Document Imaging executable found in the Office folder (don't remember the exact location) and select that executable to open *.MDI files and check the box "always use this program to open this file type".

Now, finally, the "File" menu in Microsoft Office Document Imaging will work

May 12, 2009 | Microsoft Office Professional 2007 Full...

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


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

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

1 Answer

Stored procedures


They are permanent procedures stored in the database that allow repeated execution of reusable SQL code. They are also compiled and stored in a cache repository to make their repeated execution more efficient.

The alternative to Stored Procedures is to use in-line queries "select * from table where field1 = value" hard-coded in your VB or C# application. This option though is less than ideal. Any change to the in-line query and you have to recompile the application.

The better way is to use a stored procedure, whose name doesn't change, and the parameters don't change. If the code has to change, then it's done in the stored procedure and recompiling the application isn't needed.

Oct 02, 2007 | Microsoft SQL Server Standard Edition for...

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

Related Topics:

911 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

joecoolvette
joecoolvette

Level 3 Expert

5660 Answers

Jax Planet
Jax Planet

Level 2 Expert

921 Answers

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

Answer questions

Manuals & User Guides

Loading...