DB2 Questions and Answers

Recent IT Questions

161 - 180 of 387

Delivery system

hi there, i was wonderinf if you guys have any codes in VB.6 about Delivery system. i'm using using it as a reference for my thesis. any help would be great! thanks! :)

View Answer   |  Dec 6 2006  6:54 AM GMT
Oracle, SQL, DB2
asked by playah07

  0 pts.

AMD Sempron

Hi all, I have one desktop running on AMD sempron 2200. In my home network. It?s clock speed is 1.5 GHz as per manufacture?s specification. but in system properties It showing only 800 MHz. OS is using XP SP2. But it working very smoothly. Anybody have any idea about why it likes this?

View Answer   |  Dec 6 2006  4:25 AM GMT
Tech support, Hardware, Networking
asked by squibc4

  0 pts.

Database Tuning Advisor "not permitted" error on SQL Server 2005 DE

Hi! I've bought the Visual Studio 2005 Professional Edition and with it comes Visual Studio SQL Server 2005 Developers Edition. I've installed it and started developing my applications, but now when I try to tune it with the Database Tuning Advisor I get the error-message: "Tuning this edition of...

View Answer   |  Nov 28 2006  10:05 AM GMT
Security, Oracle, SQL
asked by volrat

  0 pts.

Daylight savings - Change in politics

Greets to all, First off, where I live (WA, Australia) we have had a change in politics. We now have daylight savings starting in 1 week. The problem is as follows. Details * 3 Domains (not linked to each other) * Multiple external sites (not tied back to base) * Multiple DB systems and...

View Answer   |  Nov 24 2006  9:34 AM GMT
Hardware, Networking, Security
asked by Nephi1

  0 pts.

Oracle sql and compare date

Hello! I need help. I want to compare two dates and count how many days its between them. ex. 2006-09-22 and 2006-10-06 resulst: 14 days Hope fore help. //Lin

View Answer   |  Nov 24 2006  3:36 AM GMT
Oracle, SQL, DB2
asked by MissNew

  0 pts.

Excel Spreadsheets

We developed some kind of database with excel spreadsheets to draw monthly stats for diffrent departments. It works as follows: Individual spreadsheets(formulated)feeds into a master Link spreadsheets(data) we then use Pivots for our reports. The problem that I now expierence is that: 1. The...

View Answer   |  Nov 21 2006  2:42 AM GMT
Security, Oracle, Servers
asked by joshua5

  5 pts.

hi all

last day i installed one new xp theam on my xp system. recently i noticed that "RUN" option deleted from my start menu. can anybody help me in this problem ? thanks in advance

View Answer   |  Nov 21 2006  2:29 AM GMT
Tech support, Administration, Hardware
asked by squibc4

  0 pts.

Oracle Parse - Instr

I'm receiving a string pipe delimited I need to extract the data between pipes until the end of string. How do I do this? I currently have FUNCTION fParseValue (pValueMeters varchar2) return varchar2 is v_meter1 varchar2; begin v_meter1 := instr (pValueMeters, '|', 1, 1); ...

View Answer   |  Nov 15 2006  9:59 AM GMT
Oracle, SQL, DB2
asked by Dava19

  0 pts.

DB Migration from 8.1.7 to 10gR1

I want to migrate from 8i(8.1.7) to 10gR1 in a new server. I will shutdown 8i and run with 10gR1 in a new server. If any of my application not working with 10g ,i need to fall back to 8i in old server. Is it possible to take only the delta changes from 10gR1 which has happend for such duration...

View Answer   |  Nov 14 2006  9:25 AM GMT
Oracle, DB2, Database
asked by ajmalziyad

  0 pts.

MS SQL Server 2000

Hi All, Can we connect remotely (from outside LAN) to a MS SQL server 2000 using enterprise manager? If so, what are the steps?

View Answer   |  Nov 8 2006  0:53 AM GMT
Security, Oracle, PC/Windows Connectivity
asked by Sudh2k

  0 pts.

OPNQRYF's MAPFLD

I am trying to create an OPNQRYF and use MAPFLD. I need to place conitionally one of two fields into ALPHANAME, I defined in MAPFLD. These fields are conditionally placed as follows: LNAME ===> ALPHANAME if LNAME is filled. BUS_NAME==> ALPHANAME if LNAME is blank APHANAME is defined...

View Answer   |  Nov 7 2006  1:25 PM GMT
AS/400, Oracle, IBM
asked by JohndeCoville

  0 pts.

Testing how long an SQL script will takfe to run

Running Oracle 9.2.x. We have to sun a couple of SQL scripts that will make some changes to tables/data. Is there a way of finding out approximately how long these scripts will take without actually running them? Is there some tool I can use to do this? Or some rule of thumb?

View Answer   |  Nov 6 2006  8:19 PM GMT
Oracle, DB2, Database
asked by pingsc

  0 pts.

security problem

Hello, I have small workgroup having 10 computers in my office. I do some personal work in office like using yahoo messenger, checking personal e-mails and some online banking site. But how does one of my senior knows it? I do everything lonely and securely so that nobody in the office knows it....

View Answer   |  Oct 31 2006  3:44 AM GMT
Tech support, Disaster Recovery, Networking
asked by BinooDas1234

  10 pts.

ODBC connections

We have a database that is specifically designed for our industry. We want to be able to export the information into a mailing list. This is the email that I received from IT. "You cannot export to an access database, but you can connect to the KIDS database with Access or with Excel query to...

View Answer   |  Oct 24 2006  2:04 PM GMT
Security, Oracle, SQL
asked by Jade0571

  10 pts.

Urgent Help: web-Forms 6i don't work after Upgrading the db from 8i to 10g

Hi, We have web-Forms 6i that are deployed on a server A and run against a database installed on a server B. The database was recently upgrated from version 8.1.7.4.0 to 10g AND moved from the server C to the server B. However we're using now for the server B the alias we've used for the server C....

View Answer   |  Oct 24 2006  11:28 AM GMT
Tech support, Installation, Migration
asked by 108108

  0 pts.

Tools for DDS to DDL migration

Hi, My Profile: I have a legacy DDS defined DB2/400 database and my IT staff are telling me that for true SQL/ODBC access we either need to migrate the database over to DDL defined tables or add unique indexes to the existing DDS structure. My Question: Do we really need to alter the DDS database...

View Answer   |  Oct 24 2006  11:21 AM GMT
Oracle, DB2, Database
asked by newbie400

  0 pts.

VB.Net of Visual Studio.Net 2003 VS Visual Basic 2005 Express Edition

Good Day! Would be appreciate if there is solution for the following problem: - In VB.Net of Visual Studio.Net 2003, developer can click and drag a table listed in the Server Explorer from a connected database to the form. This will add OleDbConnection control and OleDbDataAdapter control to the...

View Answer   |  Oct 22 2006  9:31 AM GMT
Windows, Programming Languages, Security
asked by hunkgym

  5 pts.

R2

does anyone know if windows server R2 is compatible with exchange 2003?

View Answer   |  Oct 20 2006  3:51 PM GMT
Tech support, Hardware, Networking
asked by wolfden

  0 pts.

good PL/SQL user guide

I am interested in a good reference guild for PL/SQL which explain all utilitity commands and configuration patterns and files. Your help is much appreciated.

View Answer   |  Oct 19 2006  10:57 AM GMT
Oracle, DB2, Database
asked by hfeshari

  0 pts.

dynamic visual basic form based on access database table

I am useing an access database table to populate some lists. I want to dynamicly add picture boxes that I use to seperate the list box as if lined based on how many records I have in the database. Basicly, I just need to know how to add a control by code. I don't want to have to place 100...

View Answer   |  Oct 18 2006  12:39 AM GMT
Oracle, Visual Basic, DB2
asked by YitoGraft

  0 pts.

161 - 180 of 387