Topic
6 replies Latest Post - ‏2012-05-14T15:56:12Z by SystemAdmin
SystemAdmin
SystemAdmin
1632 Posts
ACCEPTED ANSWER

Pinned topic rebind statement error

‏2012-04-26T03:05:44Z |
I was doing an alter of a stored proc using Data Studio 3.1 and it produced a bind statement at the end of the ddl and said it was in error. i.e. it produced the statement in error. I have attached a screen dump of the message. I really don't need DS to produce errors as I can produce plenty of my own
Updated on 2012-05-14T15:56:12Z at 2012-05-14T15:56:12Z by SystemAdmin
  • JM3C_Tony_Leung
    JM3C_Tony_Leung
    5 Posts
    ACCEPTED ANSWER

    Re: rebind statement error

    ‏2012-04-27T17:39:05Z  in response to SystemAdmin
    Hi Andrew,

    I cannot find the screen shot that you attached to your post. Can you attach it again?

    Also, there are multiple ways to alter a stored procedure in Data Studio. Can you give us the steps that you used to alter the stored procedure?

    Thank you for reporting this problem and make Data Studio better in the future.
  • SystemAdmin
    SystemAdmin
    1632 Posts
    ACCEPTED ANSWER

    Re: rebind statement error

    ‏2012-04-30T22:22:20Z  in response to SystemAdmin
    Attached again
  • JM3C_Tony_Leung
    JM3C_Tony_Leung
    5 Posts
    ACCEPTED ANSWER

    Re: rebind statement error

    ‏2012-05-01T04:55:47Z  in response to SystemAdmin
    Thanks. Got it. We'd investigate.
  • SystemAdmin
    SystemAdmin
    1632 Posts
    ACCEPTED ANSWER

    Re: rebind statement error

    ‏2012-05-02T21:12:13Z  in response to SystemAdmin
    Hi Andrew,

    Which version of DB2 LUW are you using? The syntax of this statement has changed over time in releases of DB2, so we may need to check the syntax for this version of DB2.

    Thanks,
    Patrick
  • SystemAdmin
    SystemAdmin
    1632 Posts
    ACCEPTED ANSWER

    Re: rebind statement error

    ‏2012-05-04T05:29:39Z  in response to SystemAdmin
    DB2 on Solaris 9.7.3 via Db2 9.7.5 client on Windows
    • SystemAdmin
      SystemAdmin
      1632 Posts
      ACCEPTED ANSWER

      Re: rebind statement error

      ‏2012-05-14T15:56:12Z  in response to SystemAdmin
      Hi Andrew,

      So far I haven't been able to reproduce this issue using DB2 LUW 9.7.5. Can you please let me know what sort of alter you are doing on your stored procedure, as well as send me the DDL that is flagged with an error?

      Thanks,
      Patrick