Database Management Systems

Triggers

Does the AS/400 have a cross-reference file or files that give the same kind of information about triggers as QADBFDEP and QADBFCST do for dependent files and constraints? If so, what is/are they called? Thanks

Triggers

Does the AS/400 have a cross-reference file or files that give the same kind of information about triggers as QADBFDEP and QADBFCST do for dependent files and constraints? If so, what is/are they called? Thanks

How to avoid SQL7008 error from DB2 on iSeries?

We are deploying a J2EE application on a Websphere 5.2 Application Server. This application accesses a DB2 database on an iSeries server which is not supporting transactions. We have already removed all transactions from the XML configuration files. We cannot find a way to configure the...

Monitor Internet Bandwidth

Good day, we are using windows2000 smallbusiness server in our organisation with Exchange,Dns and Isa server configured. 1. I want to monitor the internet usage by the users. 2. I want to take a report on monthly or daily basis how much mb/gb utilised By Each User. Thanks for u'r reply in advance.

Sql Server Linked Server to iSeries

Hi everybody, I get the following exception [Non-interface error: CoCreate of DSO for MSDASQL returned 0x80040154] on an iSeries configured as Linked Server in MS-Sql Server everytime I attempt to execute a query (Read Only !) from any PC in a windows Workgroup exception for the PC on...

blanks ('') instead of NULL's in SQL Server 2000

I have a development team that wants to represent all fields with no values with a '' (blank) instead of using the database standard of NULL. The team is coding in C#. I am told it is easier for them to code around blanks than NULL's. Aside from taking up more space in the database than is...

DB2/400 SQL Sub Query Performance?

Here is the problem. Table INVEHH is a (Events header table) with about 500 records and INVEHD (Event Details) with about 22 million records. These tables are on a DB2/400 database. 1) Original Query that takes forever: select EVENT, INUMBR, ISTORE, EVHYY, EVHMM, EVHDD from...

Excel Help

What I have now is a simple excel spreadsheet to input numbers and info. What I want to do with it is make it a template and have one cell in the top left corner to add a new number in order each time a new user opens it. For example in the cell would be number 123 and the next time when someone...

Oracle In Linux

How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

Db2 to Oracle porting

I am in the process of planning to port a running DB2 instance on an IBM Mainframe to Oracle 9i running on Unix. Has anyone done does this before ? If yes, what should I be looking out for ? Any particular advice ? Thanks and Regards, Debu

SQL Server ODBC Configuration

I've got an NT web server in our DMZ that can't connect to an internal SQL Server 7 db on W2k box. Internally we have 2 domains. ODBC returns access denied/can't find server. When I put the websrv inside our net, ODBC works fine. Other servers in DMZ can connect to db. What is going on?

Starting isql*plus

Hi every one! I know that to start isql*plus in a browser, you are supposed to type something like: http://localhost:<port_number>/isqlplus Problem is, how do you determine the localhost and port number? Second, how can i use Enterprise manager to create reports about my tables in the Oracle...

Installing Oracle 9i Standard Edition on Windows Server 2003 with Xeon CPU: Why does Java Virtual Machine fail?

We are replacing an old NT 4.0 server with a new Windows Server 2003, the new hardware (a Compaq ProLiant) equipped with Intel Xeon CPU. The old server was running a couple of database instances in Oracle 8i Standard Edition, which we want/need to replace with the 9i version. The installation...

MIgrating SQL Server 2000 to Active Directory

When migrating a Server that hosts a SQL Server 2000 Instance from an NT Domain to an Active Directory Domain, What, if anything, needs to be done withing SQL Server for everything to work properly???? Since migrating the host Server to AD, my NT Authenticated SQL Server Logins are not working...

How to alter more than one existing columns in SQL 2000 Server?

I m working in SQL Server(2000) Enterprise Edition.When I m using "Alter Table <tablename> Alter Column <column name> (column definition)" for only 1 column then its working (using Query Analyzer). However when I m trying to alter more than 1 column, Query Analyzer is giving error...

Alternate way to stop Oracle Services on Win 2K Server-2

Our database server is a Machine running Windows 2K Server. We make our backups stopping the Oracle Service and then copying the files to other location (and then to tape), but in order to do this, the user loged in on the server must be an administrator, and this is a problem, because the backup...

Alternate way to stop Oracle Services on Win 2K Server

Our database server is a Machine running Windows 2K Server. We make our backups stopping the Oracle Service and then copying the files to other location (and then to tape), but in order to do this, the user loged in on the server must be an administrator, and this is a problem, because the backup...

EBCDIC to ASCII Conversion Tools

Good morning, Anyone know of any EBCDIC to ASCII conversion tools? Thanks in advance ...

data warehousing and dimensional modelling

is there any way to conclude if any particular schema (star,snow flake or any other) is most suitable for an industry type (pharma,manufacturing,retail, etc) irrespective of the paltform on which the data warehouse will be developed. Is there any book which dicusses this in depth or some online...

High-Level Overview via "Straw-man Diagram"

Good morn ... In effort to capture a high-level overview of all our database management systems in production, we developed a "straw-man"-like diagram that is intended to represent our core mission critical processing system and all related peripheral systems. The diagram basically illustrates...