Search results for query: *

I have a DMP file that I need to import into my shcema. It was exported from an entirley different database/user. I get the following: Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0...

I have three tables that I am trying to join: Plan Oper Master_PDN The Plan & Oper tables are joined by Plan#; the Oper & Master_PDN are joined by PDN: Select a.RCC From Plan a where Plan# in (select b.Plan# from oper b, Master_PDN c where b.PDN = c.PDN)...

I have an Excel workbook that was designed to provide calculated data from 1-M worksheets based on the selection. All I see when I open this file is the menu screen where several radio buttons are grouped. Once one is selected and you click the calculate button, a formatted spreadsheet...

I have a delimited text file that I need to bring into my database. In the past, I've used ETL tools, but I don't have access to those anymore. Can this be done through enterprise manager, SQL*Plus, Command Prompt? I just have a stand-alone version of 9i. Thanks, Paul

I have several workbooks that contain several worksheets. They were created sequentially by workbook/worksheet with headings only in the first workbook. The data is grouped by an Operation Number "OP NBR". I need to import this data into an Access database and have the OP NBR have it's own...

I have two spreadsheets. Each sheet shares a common field that serves as an ID tag (mixed text and numbers). Sheet1 has just this ID and a dollar value associated to it. Sheet2 has many more fields but less total records compared to Sheet1. I need to take the dollar amount in Sheet1 and...

I need to produce a list of tables by database for a particular server from Enterprise Manager. How can this be done? I've seen syscolumns in the master database, but no systables... Thanks, Paul

I have two tables. One has a nullable foreign key of the other but the stored procedure that inserts into the records into the child table fails: Error occured: [IBM][CLI Driver][DB2] SQL0530N The insert or update value of the FOREIGN KEY "FKSSRTSK" is not equal to any value of the parent key...

I am running an MS Access 2K front end that hits a DB2 db. I need to view the translated/formatted SQL that DB2 gets to do some performance tuning. I can't simply copy and paste the Access SQL into the DB2 analyzer. I could change the statement manually, but I have a ton of queries so this...

I am running an MS Access 2K front end that hits a DB2 db. I need to view the translated/formatted SQL that DB2 gets to do some performance tuning. I can't simply copy and paste the Access SQL into the DB2 analyzer. I could change the statement manually, but I have a ton of queries so this...

I'm experiencing very high response times using Access to Access versus Access to DB2(00:00:03 vs. 00:03:00). I would like to use Explain (or some other analyzer), but I don't know how to 'grab' the formatted query before it hits the database. Explain won't accept the original Access query and...

How do you forward engineer an ORM to an ERD model?

You know how every so often you're asked to do something way beyond your realm of responsibility? Well, I've been asked to put together standards for the DBA's in our organization. The current standards are very general, out of date, and only cover the basics like naming conventions. I need...

I was told that there is an ODBC Driver for IMS available. I would like to be able to connect to IMS through CA Erwin in order to reverse engineer some databases. I was told by a CA Rep that this was possible for an ODBC for IMS. Is this true? If so, where can I find it? If not, what...

I work for a State Gov't agency and we have users with both 95 and 2000 versions of Access. I have to be able to have a running app for both versions. We are using Access to store and run the queries/reports, but the tables are linked from DB2. Whenever I run the following query, I receive an...

I work for a State Gov't agency and we have users with both 95 and 2000 versions of Access. I have to be able to have a running app for both versions. We are using Access to store and run the queries/reports, but the tables are linked from DB2. Whenever I run the following query, I receive an...

I'm trying get some queries to work that use the DateAdd function. The queries originally refernced another Access DB, but now the tables I'm referencing reside in DB2 and are accessed by a link (actually they are views). I can query dates without error if no functions are used. However, I think...