Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by rkumar28

  1. rkumar28

    Liniking two tables in two different database machines

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

    Liniking two tables in two different database machines

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

    Append data from one Hash Array to Another Hash Array...

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

    Append data from one Hash Array to Another Hash Array...

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

    How to pring values from Perl Objects

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

    How to pring values from Perl Objects

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

    How to pring values from Perl Objects

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

    Generating the Dates between two Dates

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

    OLAP Function in DB2......

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

    Convert MS Access Query to SQL Server

    Will appreciate any advice to acheive this. Thanks
  11. rkumar28

    Convert MS Access Query to SQL Server

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

    Problem with result set generated by fast export

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

    Problem with result set generated by fast export

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

    How to validate telephone number in sql

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

    Passing the path as a variable in Fast Export

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

Part and Inventory Search

Back
Top