Recent content by 138006

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