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!

  • Congratulations SkipVought 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. kajaeger

    Invalid Precision from Oracle to DB2 in DataStage

    I am getting the error- INVALID precision when trying to move data from a large Oracle table into a DB2 table with the same characteristics in DataStage 7.1. I don't understand what to look for to resolve this- can anyone help?
  2. kajaeger

    Unattended install

    We used install shield to install our ODBC drivers...
  3. kajaeger

    Does SQR support the keyword CASE..look at this one

    If you are using Oracle8i- case statements are not supported.....
  4. kajaeger

    copying data

    Hmm- I haven't tried backporting. But, it sounds like you are doing a full export. Don't do a full export- try doing a export specifying the tables you need or a particular owner (example OWNER=TESTSCHEMA) when you import, the constraints,etc will still come. You just won't get the user...
  5. kajaeger

    newbie help urgent plzz??

    Are you running ORacle 8i Server or Client? Sounds like you don't have the right information in your ORA files (TNSNAMES.ORA and/or SQLNET.ORA, listener.ora)- did you create a sample database or are you trying to connect to a remote db? Is there a DBA working with you? He/She should be able to...
  6. kajaeger

    FINDING an EXACT VALUE

    Actually I am talking about doing a find in a macro- is there a way to make it "find entire cells" in the macro- example: Set oColumnDef = ThisWorkbook.Worksheets.Item("Column Def") Set oRange = oColumnDef.Range("A:A").Find(sTableName)
  7. kajaeger

    FINDING an EXACT VALUE

    Is there an excel function that does an EXACT find- not a substring find in cells? For example if I look for the word address in a column-range search, it finds both the cells for vendor_address and address. I only want to find the "address" value. Ideas? Thank you!
  8. kajaeger

    Macro to paste range to new worksheet loses formats

    I am writing a macro that copies certain ranges into a CSV file to load data into Oracle. But, when I try to copy my range, sometimes the values are getting messed up. How can I maintain the formatting of my pasted range when pasting into a CSV file? I keep losing my formats. For example I...
  9. kajaeger

    EXCEL Formula result not displaying

    Thanks so Much! That was the problem!
  10. kajaeger

    EXCEL Formula result not displaying

    Didn't work- it was already unchecked. I checked it and unchecked it but I still cannot get formulas to show calculation
  11. kajaeger

    EXCEL Formula result not displaying

    I cannot get even a simple formula such as =SUM(30 + 60) to work in my EXCEL spreadsheet. It works fine in other spreadsheets, but when I press enter on this particular spreadsheet all I can see is my formula. I don't see the result value...advice?
  12. kajaeger

    Writing Encrypted Value to Registry failing help!

    Honestly, I am clueless here. I cannot even define the string with a square in it without getting an error on the variable declaration line of the vbs code. My WISE installation isn't accepting the string either. I cannot even pull the encypted value into a reg file and execute reg file and...
  13. kajaeger

    VBS Popup Window - Possible?

    Wscript.echo or msgbox() will pop up windows on your screen. If you want to open a web window,try something like what I do to popup a log-file in notepad here, by calling the application you want to open- hope it helps: '************************************************ ' CallExecutable Sub '...
  14. kajaeger

    Writing Encrypted Value to Registry failing help!

    I need to write an encrypted value to the registry it looks like a square in the first position + "mra".. vbscript thinks its a "return" and gives me an "Unterminated string constant" message with a "Code :800A0409" when I try to write the string. Ideas...
  15. kajaeger

    Checking group privileges from VBS

    i didn't know there was another way....Yes, I am interested. I am just looking for any way to do it from vbs. Thanks so much for the help.
  16. kajaeger

    Checking group privileges from VBS

    I need to verify what members a user is part of before continuing a vbs script. SO, I found the ifmember.exe microsoft utility can do this..... I am trying to parse the output of the IFMEMBER.EXE microsoft utility to a text file. I can get it to run when I do it manually from an open command...
  17. kajaeger

    Passing Parameters to a VBS script

    How do you pass a parameter (or list of parameters) to a VBS script? Any help appreciated. i know how to pass parameters to Subs, but I want to pass parameters to the main program from the command-line. Thanks! Kimberly

Part and Inventory Search

Back
Top