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

    Insert using Select

    Any chance XP Access has this functionality? Thanks for your help. mlong [afro]
  2. mjlong999

    Insert using Select

    I would like to perform an insert based on a select statement. The catch here is that I would like to insert the records using a pass-through query, where the select is based on a table from the Access database. For example, a pass through query like this... insert into OracleDB.table1(cola)...
  3. mjlong999

    pass-through queries

    That worked! Thank you for your quick response. Thank you, Mike
  4. mjlong999

    pass-through queries

    Hello all. I would like to insert data from an Access 97 table/query into an existing Oracle 8 table. I realize that a link table query should work, and I have proven that it does in my environment. However, because I am linking to Siebel tables, some of the links fail, as the Siebel tables...
  5. mjlong999

    call exe and pass in parameters

    I normally call an .exe file from the command prompt or using a .bat file, and pass it parameters. I would like to automate this using a vb program. I have tried the shell visual basic function, but it doesn't seem to handle parameters. I also tried to use the SendKeys function with the...
  6. mjlong999

    Spooling data

    I am trying to use the db2cmd utility to spool my result set to a flat file. I have no problem getting the data into the flat file, however, it always contains some db2 header and footer information. Does anyone know how to remove this from the output file, either using a db2cmd option or...
  7. mjlong999

    db2cmd option for increasing column width

    Db2 version 6.1 I have a job which is using the db2cmd utility to import data from a flat file into a db2 table. One of the columns, a varchar(1500), is being truncated at 35 characters when it is imported. Additionally, I noticed that our db2 software package defaults to a max column...
  8. mjlong999

    problem performing update sql

    It worked!!!! Thank you so much Terry!!!!!!!!!!!!!!!!!!!!! --Mike Long
  9. mjlong999

    problem performing update sql

    Using SQL Server 7 (very soon 2000)! I have two tables (a & b) that have the same key (a.key, b.key) and a few of the same fields (a.checksum, b.checksum). I'm trying to compare the records in these tables, and wherever the same keys do not have matching checksum fields, then I would like to...

Part and Inventory Search

Back
Top