Regarding Oracle connectivity issues
I have Oracle 7i and 9i installed on my PC under C:/ORANT and C:/ORA9 respectively. When i try to connect to Oracle from a front end application (Visual Basic v6)that takes as input the Database domain name and Database schema name as input and tries to establish a connection to Oracle using the OLE DB [...]

Answer Question   |  November 29, 2005  7:51 PM
Database, DB2, Oracle, SQL, Windows

Indexing on Large table
Hi, Is indexing on 5 keys of a table containing 100 fields more slower than indexing on same 5 keys of a table containing 150 fields. Both the tables (one containing 150 fields and other containing 100 fields) are similar except the 50 attributes which are redundant. Suppose there are 2 attributes common to both [...]

Answer Question   |  November 23, 2005  8:08 AM
Database, DB2, Oracle

Using Query returned values in Oracle Graphics 6i
Hi all, I wrote a query in Oracle Graphics Builder (6i)(Bar Graph). The query will return diff. categories(so multiple bars) wherein each category will contain atleast one subcategory(Maximum three). So, each bar will contain either one or all the three sub-categories. My requierement is to set the colors dynamically to the sub-categories based on the [...]

Answer Question   |  November 28, 2005  7:08 AM
Billing and customer care, Billing Support Systems, Business/IT alignment, Career development, Database, DB2, Desktops, Development, Financials, Human Resources, Intelligence, Interaction Center Technology, Maintenance Management, Management, Manufacturing, Marketing/Sales, Microsoft Windows, Oracle, Order Management, OS, Procurement, Product Lifecycle Management, Project management, Projects, Security, Servers, Service, Software, SQL, SQL Server, Supply Chain Planning, Training

SQL Server 2005 adoption
My name is Nick Bellistri and I am the assistant site editor for SearchSQLServer.com. I am interested in your thoughts on SQL Server 2005 adoption. Based on your knowledge of SQL Server 2005, what hurdles do you foresee in using the new DBMS? Do you think Management Studio will be more difficult to use than [...]

Answer Question   |  November 23, 2005  3:36 PM
Access, Database, DataCenter, DB2, Desktops, Management, Microsoft Office, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server, Windows

Migration from OS/390 to Z/OS V1.6 with CSP
We are migrating from OS/390 v2.10 to Z/OS V1.6 as V1.4 is no longer available.We still keep some old application development environment based on CSP/AD and CSP/AE. Is there any issue other than adopting the new LE library that we need to be aware of?

Answer Question   |  November 28, 2005  2:55 PM
390, DB2, Mainframe, zSeries

Stop bit problem: USB to Serial Converter attached to motion controller, unable to set for 7-E-2
I have three different USB to Serial converters, one of them an isolated converter from B&B. One brand of motion controller I work on uses EVEN parity / 7 data bits / 2 stop bits as its default. I find that none of my converters will work on the controller in this configuration. If I [...]

Answer Question   |  November 22, 2005  5:36 PM
3Com, Active Directory, ActiveX, Administration, Apache, Automated, Availability, BASIC, Benchmarking, Business Objects, C, Cabling, Cape Clear Cape Connect, Career development, Cisco, Clustering, Cognos, Crystal Reports, Data analysis, Data Junction, Data management and storage, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, Dell, Desktop management applications, Desktops, Development, DHCP, Distribution/logistics applications, DNS, Enterprise Desktop, Ethernet, Fault isolation, Fax and print management, FDDI, File, Frame Relay, Functional, H.323, Hardware, Hardware selection and management, Hewlett-Packard, Hewlett-Packard Application Server, Hubs, Hyperion, IBM, Informatica, Information Builders, Interoperability, Lifecycle development, Linux, Lotus Domino, Management, Manufacturing applications, Microprocessors, Microsoft Systems Management Server, Microsoft Windows, Migrations and upgrades, Monitoring, NCR, NCR/Teradata, Network applications management, Network connectivity, Network management software, Network monitoring, Network protocols, Network testing, Networking, Networking services, NIC, Novell IPX/SPX, Oracle, OS, Performance and availability, Performance management, Performance/Load, Ping, Power management, Printers, Programming Languages, Protocol analysis, Remote management, Routers, SAP, SAS Institute, Security, Servers, Software, Software testing, Software testing tools, SPSS, SQL Server, standards, Storage, Switches, Systems management software, TCP, Tech support, Thermal controls

sql query
There are 2 tables POLICY and NAME. The relationship between Policy and name is only the policy number. and ther relation ship is like many to one. I mean several policy number can have same name in the name table with that many records. Now my question is to find out the policy numbers having [...]

Answer Question   |  November 18, 2005  11:36 AM
Database, DB2, Oracle

Memory (helpfield) usage in Microsoft Access with VBA
Microsoft Access software is running on the desktop of every user, but the database is installed centrally on a server. More users can start and run on the same database simultaneously. In VBA I have various helpfields defined. What I want to know is: if more users are in the same part of the VBA [...]

Answer Question   |  November 17, 2005  7:59 AM
Access, Database, DB2, Oracle, VBA

Delete maximum records in a table
Hi! I need to Delete maximum records in a table that has 2 columns, such as Ord No. & Part No. Each Part No. can have many Ord Nos. I need to identify the Maximum Ord No per part No & delete the record from the table. Help would be much appreciated! Sarj

Answer Question   |  November 23, 2005  11:29 PM
Database, DB2, Oracle

Database Diagram Tool
Does anyone know of a free database diagram tool? I downloaded DBDesigner 4 (http://www.fabforce.net/dbdesigner4/), but it’s not working the way I would like. I could just create them in Access but that isn’t really ideal. I want to create diagrams of an existing database, not to create a new schema from scratch. Thanks in advance!

Answer Question   |  February 22, 2012  4:00 PM
Data analysis, Data warehousing applications, Database, DB2, Oracle

database down
can anybody tell me how to know “Exactly at what time the database has gone down

Answer Question   |  November 15, 2005  3:14 AM
Database, DB2, Oracle

sqlplus killed
when i say SQLPLUS at $ prompt it is saying KILLED, hence i could not able to connect to my database. can anybody clear me how to connect to my database

Answer Question   |  November 15, 2005  3:44 AM
Database, DB2, Oracle

Effect of DB migration on Interfaces
We are in the process of moving our R/3 4.6 system from Informix to DB2. What are the checks needed to ensure that the interfaces perform as expected. Thanks

Answer Question   |  November 13, 2005  3:33 PM
Basis, Database, DB2, Oracle, Upgrades / implementations

sql query
what is the query to find which user is executing what sql statement

Answer Question   |  November 15, 2005  1:09 AM
Database, DB2, Oracle

Connecting to the Database
I am trying to connect my project in Visual C++ 6.0 to the database in Microsoft Access 2003 using DAO but am receiving an error message stating that ‘unrecognised database format’, how can I do it then?

Answer Question   |  November 10, 2005  3:33 AM
Automated, Data analysis, Database, DataCenter, DB2, DB2 Universal Database, Development, Oracle, Software Quality Assurance, Software testing, Software testing tools, SQL

Name that computer?
Warning: this may be historic (1970′s, PDP-11, etc.) or might be fictional. Don’t loose sleep over this (although you might could get some additional insight around 9pm EST;-) And please don’t flame me either. Minicomputer, comparable phyiscal size to PDP-11 appears to be two CPU units 3-5 feet height, but one may be open reel [...]

Answer Question   |  November 11, 2005  4:13 PM
390, AS/400, DB2, Hardware, Hewlett-Packard Application Server, Linux, Mainframe, Servers

DFSMSdss / ADRDSSU (Dump Full or Copy Full)
I’m new to Systems Administratios on Z/OS Series MVS systems. I have one DASD volume that was one of the system default workpacks, (it was initizlized with a small VTOC). This volume (WRKSP1) has multiple types of data on it, VSAM files, flat files, PDS files, DB2 Archival log datasets. The issue is this. With [...]

Answer Question   |  May 30, 2011  1:07 PM
390, Backup & recovery, DB2, IBM, Mainframe, Storage

Java and Oracle
hi Sir, I have an application web based. using Oracle backend and Java front end. App server is in weblogic and Solaris os and two cpu with 8 applications. DB server is oracle 8.1.7 on Solaris This application is getting slow when number of threads are more ( like many users login and related activities) [...]

Answer Question   |  November 10, 2005  2:18 AM
Database, DB2, Oracle, SQL

Is java better thab vb ?
what do you think about this ? is that worth to learn java or you think the future is for vb?

Answer Question   |  November 3, 2005  12:04 AM
Database, DB2, Oracle

ZOS SOCKETS API
Trying to write a batch COBOL socket program to talk to cics sockets. I have the CICS API, I can not find the ZOS the correct manual for the sockets in batch COBOL.

Answer Question   |  November 3, 2005  3:55 PM
390, DB2, Mainframe, zSeries