Recent content by rkumar28

Thanks for the response. I am not trying to link DB2 table with Oracle. Actually I am trying to link two tables in DB2 that are on different databases....one in Production and the other in QA.... Thanks

Hi, I have worked on Oracle database and am new to DB2 UDB. Is there a way I can join two tables in two different databases on diferent machines. Like in Oracle we have DB links. Do we have anything similar like DB Link in DB2 UDB. I am trying to do something like below: select Col1, Col2...

Thanks Miller and Svar for replying. Thanks for the suggestion. Yes...I am trying to store eveything in single hash. I think what you are suggesting make sense and is more efficient. I will remove the merge statement. Please correct me if I understood it correctly.I have to write both queries...

Hi, I have three functions as below. The two functions get_monthly_data() and get_daily_data() gets Monthly and Daily related data into their respective Hash array(see the function below). Both the functions has same fields. All I am trying to do is to merge(append the data from one hash to...

Hi, I think I found the problem. I found little similar post in this forum. I tried implementing it and it seems to work. I changed the code in the sub get_leaves function as below and it seems to work fine: sub show_leaves { my ($ar_groups, $aref_files, $F1, $F2, $G1, $G2, $level); my ($i...

Hi, Thanks a bunch for taking time reading my problem and replying. I tried changing the return statement to return($href_child); but I hit the error at other place and my program is not even getting to sub get_leaves function. Actually make_group function has to return $aref_groups as this...

I have a main function called make_file() that gets all the IDs and Associated filenames into an hash array ($href_data). This hash is getting passed into another function make_file() where an object 'hr_data_file' (in blue text below) is getting created. All I am trying to do is to call this...

Hi, I am a newbie in perl. I will really appreciate any help and advice. I have a Oracle table that contains quite a few Filenames. I am trying to write a perl script thats generates all the possible dates between two dates that is passed as a parameter to Perl script and concatenate these...

Hi, I have a question regarding the DB2 UDB 8.1. I have a query in Oracle 9i that needs to be rewritten on DB2(UDB). This Oracle query is using an OLAP Analytic function RATIO_TO_REPORT. I am trying to write this in DB2 as DB2(UDB) doesn't have this function so far. I have tried RATIOTOREPORT...

Will appreciate any advice to acheive this. Thanks

Hi, I am working on a query that was written in MS Access by someone else. I am trying to convert that query to SQL Server as we will be running this query in sql server. There are few functions in the query like “FIRST”,”LAST” AND “RIGHT” that is only recognized by MS Access and not SQL...

Will appreciate any advice in this regard..... Thanks Raj

Hi, I am running a fast export to generate a datafile. I am doing a SUM in the field. The field is defined as decimal(9,4) in the table and is nullable. My fast export is given below. I am passing each record as a character field to avoid any unwanted binary data as a part of my record. SELECT...

Just incase if this is still an issue. Look into this link and modify the query as per your need. http://www.teradata.com/teradataForum/shwmessage.aspx?forumid=1&messageid=1530#bm1539 Thanks Raj

Hello, I am working on Fast Export scripts to generate files in WINDOWS environment. I am hardcoding the full directory path where the output file needs to be generated. Problem is, I have more than 30 fast export scripts and when we migrate into QA environment from DEV in WINDOWS we have to...