Search results for query: *

Hi Can anyone tell me which BO metadata table holds BO universe Condition information along with BO Hierarchy information. Is there a UNV_CONDITION or similar table for that. Thanks in advance

Hi, I have a peculiar case There are 2 fact tables. The key of bot the tables is same. Now that key has referential integrity with another master table which has all possible valid combinations of Col1 , Col2, Col3. Now fact1 has records corresponding to records in the master table for all...

Hi, Thanks for the code. What was the nature of your background job? Was it a database query with so huge data. It seems all is lost due to this huge data volume. My code is running fine on a small vol of data.

Hi, I know this is a stupid question but pls let me ask it -- is the DBD documentation resdied inside the PERL installation? Where from can I get the documentation and hence the name of the maintainer? Regards

Hi All, Still there is some problem. It is working as mentioned above for my .1 M records but not responding for 270M rows. Please note that there is FULL Outer Join in the query so its understandable that there is lot of work done in the query --basically Merge Join sort of thing taking place...

Hi, These are all that i have: use DBI; use DBD::DB2::Constants; use DBD::DB2; $| = 1; use Tk; use Tk::Pane; use Tk::ProgressBar; Regards,

Hi, Do you mean the DB2 DBA in my project or someone else? Actually the problem is the huge volume of data. In some other setup with 0.1 million records I can complete the test within 20 mins. But with 270 million records the connection is getting down. However its ok when same query is running...

Hi, I have a PERL script which connects to a DB2 database from it. Now I have a very complex query on huge data 270 million records . It takes more than 2 hrs to run (this is ok and logical). When I run it from DB2 client its fine--infact the DB2 client remains connected for days. However when...

Hi, What i did is finally: Have a progress bar that I create while entering the loop where i run the SQL as mentioned above. And then destroy it just before going out. In this way I can keep the progress bar active. However I can't bring it up while I do Alt Tab. It resurfaces from the tray...

HI All, Thanks for the suggestions. icrf, for ur better understanding let me explain the situation. I have a .txt file whose contents are like this below: a1,b1 a2,b2 a3,b3 a4,b4 etc where a1,a2,a3,a4 are columns of table T1 of Database1 and b1,b2,b3,b4 are columns of table T1 of Database2...

Not Really. I just wanted to get some affirmitive nod from someone that looking in these areas may give some lead to my problem. If these are areas that are absolutely non-related to my proble, then I will not spend time on them. This is the basic objective :-)

Hi, In addition to that can anyone shed some light on the following concepts: 1) $tk_main --> update apart from updating the progress bar in the loop 2) update idletasks with and without 1) 3) TK :: After , TK :: Refresh etc 4) $b = MainWindow ->New; $a = $b -->ExecuteCommand Please advise

Yea Mike, Seen it and done that way but doesnt help. Instead it makes the actual process slower as well. And once I minimize the TK window and then try to maximize it , it just won't let me do that. After waiting for some time (the time it should take to run the job) I "End Task" TK from Task...

Hi, What is the "One Thing" that you changed and everything in ur world became fine :) Regards,

To add a little more-- I split my SQL into 2 and still its very heavy. However at the back end the query is running fine even if its slow. But the entire time the query is running, the frontend TK screen is absolutely frozen. How can I activate the TK window when there is no new event taking...

Hi, Thanks for the help. Now, I am more confused.The tool is running differently in different machines: In one machine (Win XP) its running ok meaning when u do ALT-TAB then the window gets eanbled after say about 2 secs and I can see the progress bar correctly. In another machine (Win 2K) its...

Hi The database resources are also being alarmingly eaten up. Ne forking or threading feature available in PERL? That may better the situation a bit. Regards

Hi, I tried with different number of columns for comparison. When I give 150 columns its working but it is hanging ("NOT RESPONDING") for 275 column-pair comparisons. Any suggestions? Thanks

Hi, Let me throw some more light on this. My comparison tool is scheduled to run on 2 views. My background program is PERL and I have a TK program to show the Progress Bar and throw appropriate error messages. Initially when I run the tool with small set of columns,the TK screen used to freeze...

Hi All, I have included the DoOneEvent(); within my code and it works. However due to this, for cases where the code was previously running fast enough (withut DoOneEvent) has become quite slow with DoOneEvent. Is there anyway to circumvent this problem? Is there any value of the parameter of...