Results 1 to 7 of 7

Thread: Db2-mq

  1. #1
    Join Date
    Jul 2012
    Posts
    5

    Question Unanswered: Db2-mq

    Hi all,
    I am working on DB2/MQ concept. Can any one help me with a way to put the contents of a db2 table in a queue.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    look at the info center - there is a complete chapter on mqsend and mqread....
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Jul 2012
    Posts
    5
    Quote Originally Posted by przytula_guy View Post
    look at the info center - there is a complete chapter on mqsend and mqread....
    thanks for ur info but the thing is we are already looking in to it. Can u give us some info other than what is there in info center.

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    all is in the books - if some info is missing - how can we know about it ?
    or what is you specific problem ? there are also some samples in the samples directory below sqllib
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  5. #5
    Join Date
    Jul 2012
    Posts
    1
    Hi,
    Me too working in MQ-DB2 concept..Did anyone worked on Q Capture or Q Apply programs in DB2, these are DB2 suppiled programs. If anyone worked on this, please reply.

    Thanks in Advance.

  6. #6
    Join Date
    Jul 2012
    Posts
    5
    Quote Originally Posted by przytula_guy View Post
    all is in the books - if some info is missing - how can we know about it ?
    or what is you specific problem ? there are also some samples in the samples directory below sqllib
    Thanks for ur reply. To be more specific I would like to put the multiple column values inside a queue and read them from the queue to update another database.

  7. #7
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    as indicated before mqsend and mqread are the functions to access mq queue's from sql
    look at the samples
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Tags for this Thread

Posting Permissions

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