Search results for query: *

Dear all I have been trying to get a test environment setup so that a few of us at work can learn the basics before our live system, goes live !!! I am having some real problems! During the installation of 4.6C I got the RADDBDIF error. I checked the SAP OSS and found that the program could...

Dear All I am having problems with an Oracle installation that I have recently undertaken. I have done a created two instances of a database on the one Windows 2000 Advanced Server box. The problem I am having is that only one Intelligent Agent/Data Gather will come online at a time. Please...

Hello What I want to do is retrieve the contents of a directory, from which I will import data. The reason I want to do a listing is that the number of files may vary, although all of them will be CSV format. I want to then loop round and import each one. I know that I can use...

Hi people! I am starting a new role where the company has implemented SANDs Nucleus database. I was wondering whether anyone reading this might be able to give me an insight into the workings of Nucleus. Most importantly the database uses Bit-Map Vector Indexing, which I believe is not really...

Hi everyone ! I have a quick question regarding Index usage. I am wanting to speed up an update, the columns that I am using to link the relevant tables are not indexed. I was wondering how the UPDATE command uses the INDEX created on a column? Any assistance appreciated. OLAPer ::->

In a correlated sub query is it better to use EXISTS or IN? Is it dependent on whether or not an index exists? Here is an example: UPDATE TABLE1 A SET A.COL1 = (SELECT B.COL2 FROM TABLE2 B WHERE...

Hey gurus ! I am trying to run this SQL statement, but it won't run ! Please tell me why ! UPDATE S_CONTACT A SET A.CREATED_BY = (SELECT B.S_Employee_ROW_ID FROM TEMP.UP_S_CONTACT B...

Hi everyone I have a query that is boggling me ! I have three tables, e.g. S_CONTACT, EIM_CONTACT and S_EMPLOYEE. ============== S_CONTACT - Created_by - Row_id =============== EIM_CONTACT - Created_by - T_Contact__RID =============== S_EMPLOYEE - Row_id - Login =============== The...

I am in desperate need of some assistance please. Whilst attempting to LOAD FROM a CSV file to a table in DB2 I get errors. The database falls over. Please please help, the load command is too long to post here, so if you e-mail me I will forward the details to you..... Here is the error...

Hi, this is my first ever thread.....<br><br>I'm probably going about this in the wrong way, your assistance will be greatly appreciated, let's see if I can explain :<br><br>I am currently in the process of developing a Performance Monitoring/reporting ROLAP solution.&nbsp;&nbsp;I have a number...