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

When I tried: LOAD DATA INFILE * INTO TABLE TEMP RECORDS TERMINATED BY NEWLINE FIELDS TERMINATED BY ',' BEGINDATA ####A,########AA,AAAAAAAA,AAAAA,A,AAAAA,AAAA,AAAAA It failed because it was expecting "(" after the 'INTO TABLE' statement. Also, how and where do you specify which...

I do have a quick question...If I use the standard SQL*Loader method (using a control file with data), how do I handle records that aren't terminated by anything? Would this (NEWLINE) work? If not, how is it handled? LOAD DATA INFILE * INTO TABLE TEMP RECORDS TERMINATED BY NEWLINE FIELDS...

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

Like I said, I'm pretty green in Excel programming. Where would I input and run code like this? Thanks, Paul

Okay, cool. Do I have to do this manually for each sheet in each workbook, or is there an easier way? The reason I ask is because I'm dealing with over a Gig of data broken out in 27 excel workbooks each having 3 to 60 sheets. ;( That's a lot of copying/pasting! Also, Code1 and Code2 need to...

I'm pretty green in Excel programming. How exactly would I accomplish the above. Also that takes care of splitting the Part Nbr and Op Nbr, but how do I get the values to repeat? Thanks so much, 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 a similar question in regards to the first entry on this thread. My data is all in one query already and I have repeating part numbers and amounts but need to select the most recent reporting date from the result set of the query: PARTS_Query ----- P/N RPT_DT AMT SELECT PJM.PN...

ttt

Actually, I can join the two data sets in Access, but I don't get all of the results from Sheet2 back, only the ones that match the ID tag. I need to return all results from Sheet2 and set the dollar value to Null if there is no match. So I guess I need to know how to do it in both Access and...

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 actually need something that can seach the entire server using a where clause. Someone found this script for me: Create table #DB_Name (dbname varchar (100)) Create table #results (dbname varchar (100), tabName varchar (100), colName varchar (100)) Insert into #DB_Name(dbname) select...

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 tried it, but did not get any useful information.

They are Select queries. The queries are running but we're having response time problems. Here's the story...I work for a State Agency in Oklahoma. We have an Access system that is used by people in every county of the state. This system is updated each week with data from our legacy system...

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