Results 1 to 5 of 5
  1. #1
    Member
    Join Date
    Oct 2008
    Posts
    390
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Post Combine 2 SQL tables.

    How to combine 2 different SQL tabels

    i.e. select nodes.node_name, events.result from events,nodes

    I want to combine events and nodes table together to gather plateform_name information from Nodes table and backup status information from Events table

    i have tsm 6.1,


    does any one did this thing ....

    Thanks

  2. #2
    Senior Member domino's Avatar
    Join Date
    Nov 2005
    Location
    Germany
    Posts
    703
    Thanks
    1
    Thanked 24 Times in 22 Posts

    Default

    show the example for "infos about schedules and associations"

    http://www.tsmguide.co.cc/p/database...-list-all.html
    If Microsoft is the answer, I want my problem back!

  3. #3
    Member
    Join Date
    Oct 2008
    Posts
    390
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    I already browse thru that website but i didnt find my answer I need to run this script

    select events.node_name,events.status,events.result,event s.actual_start,nodes.platform_name from events events, nodes nodes where events.node_name=nodes.node_name order by events.node_name,events.status,events.result,event s.actual_start,nodes.platform_name

    but its not working ..

  4. #4
    Senior Member
    Join Date
    Jul 2008
    Location
    Birmingham, UK
    Posts
    537
    Thanks
    0
    Thanked 5 Times in 4 Posts

    Default

    Hi.

    You have a space on the first line and last line event s.actual_start

    It works for me on TSM 5.5.4

    What error do you get when you run it ?

    Cheers

  5. #5
    Member
    Join Date
    Oct 2008
    Posts
    390
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    yes the script is working with 5.5 but on 6.1 it gives me the below error.....

    select events.node_name,events.status,events.result,event s.actual_start,nodes.platform_name from events events, nodes nodes where events.node_name=nodes.node_name order by events.node_name,events.status,events.result,event s.actual_start,nodes.platform_name
    ANR0162W Supplemental database diagnostic information: -1:42S22:-206 ([IBM][CLI Driver][DB2/AIX64] SQL0206N "NODES.NODE_NAME" is not valid in the context where it is used.
    SQLSTATE=42703
    ).
    ANR2940E The command 'select events.node_name , events.status , events.result , events.actual_start , nodes.platform_name from events events , NODESVIEW NODESVIEW where
    events.node_name = nodes.node_name order by events.node_name , events.status , events.result , events.actual_start , nodes.platform_name ' contains an unknown SQL column name.
    ANS8001I Return code 3.

Similar Threads

  1. V6 Tables
    By TSMCON in forum TSM Reporting & Monitoring
    Replies: 1
    Last Post: 05-18-2010, 03:49 AM
  2. Tsm sql tables
    By influx in forum Scripting
    Replies: 2
    Last Post: 02-24-2010, 06:45 PM
  3. combine two select statements
    By tenpin in forum Scripting
    Replies: 3
    Last Post: 03-20-2009, 11:44 AM
  4. Possible to combine two servers?
    By hackbarth in forum TSM Server
    Replies: 5
    Last Post: 03-16-2007, 03:59 AM
  5. Link between tables
    By bstanek in forum Scripting
    Replies: 2
    Last Post: 06-09-2005, 03:19 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •