Skip to Content
author's profile photo Former Member
Former Member

combine two tables without common field

Hi Experts,

I have two database tables, DBSTATORA(stores inform about all the tables involved in infoproviders), and RSDODSO ( stores information about ODS Objects. I have to list the ods objects and its associated tables as the output, but there is no common field in these two tables how will i combine these two tables, can anyone please suggest me. Any help will be fine.

thanks,

Prabhu.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jun 03, 2005 at 05:31 AM

    Hi,

    Find find the key fields in two tables.

    Check those key fields are available in some other table.

    Try using logic by using those tables.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 03, 2005 at 05:56 AM

    Dear

    If you plz send me the column name of these two tables.

    ANOTHER solution without knowing the column name of these two table, there is a kind of join in databases that join is called Non Equi Join, and this join is specially used when there are not key columns to join let suppose there are two tables EMPLOYEE which has following columns

    -


    empno

    ename

    salary

    deptno

    and another table that is SALGRADE which has following columns

    -


    grade

    losal

    hisal

    if you want to find ename and grade of employees you can write the query

    SELECT ename, grade

    INTO ...

    FROM employee,salgrade

    WHERE sal BETWEEN losal and hisal.

    i have applied this query is ORACLE DATABASE, but i am sure with few modification you can run it in SAP.

    Rai

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Everyone,

      I know the ods tables names are stored like /bix/a<ods_name>00 and /bix/a<ods_name>40 and for change log it is /bic/b*. But my requirement is I have to display the size of the tables belonging to a particular ods object. So for all the tables the size is stored in DBSTATTORA which gives information about

      DBSTATTORA

      fields of this tables are:

      TNAME --> Table Name

      ANDAT --> Analyzing Date

      AMETH --> Analysis method for collecting Statistics

      NROWS --> No of rows in a table

      OCCBL --> Used blk(size) of table in KB

      EMPBL --> Empty blk(size) of table in KB

      AFREE --> Avg Freespace in a used db block

      INDBS --> Used Blk(size) of an index kb

      This is a table which stores the statistics information.

      It displays all the tables of infocubes and ods objects, but does tell that this table belongs to this infoprovider.

      I have to display data from this table as well as the infoprovider to which it belongs. So there is no proper information of database tables where the infocube and its associated tables like the facttable, dimtables are stored together. Same for the ods objects also.

      There are for ods object RSDODSOTABL which give information about ods object and the table name is stored differently <ods_name>_0000. How do i map this table with the DBSTATTORA table, the tablenames doesn't match. Same problem with RSTSODS table which give informaiton about change log table.

      And also for infocubes, there is RSDCUBE which gives information about infocubes but not the associated tables. So does anyone know where all these information is stored in some database tables. It would be of great help.

      Thanks a lot.

      Prab

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.