Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003
    Posts
    35

    Unanswered: db2 stored procedures not returning data

    Hi db2 experts,
    I have migrated st proc from sybase to db2 v7.1 through db2 migration tool kit,I have checked all db2 statements and syntax in stored procedures everything looks correct in db2 and there is no error in db2 SP, but its not returning any data when its running in db2, db2 table consists data perhaps its running in sybase and returning set of data's.
    If anyone helps me it will great ful for me.
    thanks in advance.
    muthu

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Muthu,
    If you could supply us with the source code for the SPs (both sybase and db2), we might be able to help.

    Andy

  3. #3
    Join Date
    Mar 2003
    Posts
    35

    Re: db2 stored procedures not returning data

    [QUOTE]Originally posted by nmkumaran
    Hi db2 experts,
    I have migrated st proc from sybase to db2 v7.1 through db2 migration tool kit,I have checked all db2 statements and syntax in stored procedures everything looks correct in db2 and there is no error in db2 SP, but its not returning any data when its running in db2, db2 table consists data perhaps its running in sybase and returning set of data's.
    If anyone helps me it will great ful for me.
    thanks in advance.
    muthu
    [/QUO
    Thanks Andy,
    I got the solution.

Posting Permissions

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