User Profile

Collapse

Profile Sidebar

Collapse
gunjangogia
gunjangogia
Last Activity: Sep 27 '08, 07:58 PM
Joined: Sep 21 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • gunjangogia
    started a topic retrieving information from 2 tables
    in DB2

    retrieving information from 2 tables

    Hi everyone,

    Could someone please help me out. I am having problems retrieving information from a table where 2 attributes are foreign keys of the SAME attribute in another table....

    The tables are
    USER(id, name, type_login)
    STUDENT(student_id, mentor_id)

    here, student_id and mentor_id are foreign keys of the USER table....
    I need to get a list of all the students with their respective...
    See more | Go to post
    • gunjangogia
      replied to Clob
      in DB2
      Hi,
      This is not an answer to your question but a doubt....

      Could you tell me for what you use the datatype clob?
      And the difference between blob and clob

      Thanks
      Gunjan
      See more | Go to post

        Leave a comment:

      • gunjangogia
        started a topic blob and clob
        in DB2

        blob and clob

        Hello everybody,

        Could u please tell me the when we should use blob and when to adopt clob???

        I read in the previous posts about storing files in the databse. The 2 methods mentioned were storing the file path in the database while the other being using the blob datatype. For a medium scale application which is better. Will there be performance issues?
        Also do i need to do anything different when i am storing...
        See more | Go to post
        No activity results to display
        Show More
        Working...