Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. pheffley

    How to importing with different source/destination schemas

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

    Simple Join Help

    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)...
  3. pheffley

    Getting raw data from a macro'd workbook

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

    Importing Text File

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

    Importing Text File

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

    Importing Text File

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

    Excel - How to export with repeating values

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

    Excel - How to export with repeating values

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

    Excel - How to export with repeating values

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

    Excel - How to export with repeating values

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

    Maximum Date

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

    Need help merging two Excel spreadsheets

    ttt
  13. pheffley

    Need help merging two Excel spreadsheets

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

    Need help merging two Excel spreadsheets

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

    Query system tables

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

    Query system tables

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

    Foreign Key Problem

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

    How to view Access SQL statements after ODBC

    I tried it, but did not get any useful information.
  19. pheffley

    Using Access as a front end, having horrible response times

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

    How to view Access SQL statements after ODBC to DB2

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

Part and Inventory Search

Back
Top