User Profile

Collapse

Profile Sidebar

Collapse
chamath
chamath
Last Activity: Oct 28 '11, 02:58 AM
Joined: Oct 26 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • chamath
    started a topic Federated Database Objects
    in DB2

    Federated Database Objects

    Is it possible to create Federated Database Objects Between two Db2 Databases Sitting on Different instances in the same Server.

    Eg

    ServerDbS1
    Instance_01
    Dbs1_01
    Dbs1_02
    Instance_02
    Dbs2_01
    Dbs2_02
    Can we create Federated Database Objects between Dbs1_01 and Dbs2_01
    See more | Go to post
    • chamath
      replied to Select null as xyz from sysibm.sysdummy1
      in DB2
      Well You Can Select Null same as in Oracle (i.e select Null as Val1 from dual). Try the following SQL in DB2 (v 9.5)

      Select cast(NULL as CHAR) as v1 From sysibm.sysdummy 1

      and to make sure that it is returning Null i check the results using nvl

      e.g.
      Select nvl(cast(NULL as CHAR),'ok thi is null') as v1 From sysibm.sysdummy 1

      I tried these Command in Toad for DB2
      See more | Go to post

        Leave a comment:

      No activity results to display
      Show More
      Working...