Recent content by kajaeger

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?

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

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

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

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

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)

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!

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

Thanks so Much! That was the problem!

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

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?

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

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

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

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.