HPE NonStop SQL/MX Error – 13029 Found host variable(s) declared as long. The size of this data type is 4 bytes for 32-bit and 8 bytes for 64-bit applications. This can cause unintended behavior if not used properly.

In this blog post, let’s learn about the error message “13029 Found host variable(s) declared as long. The size of this data type is 4 bytes for 32-bit and 8 bytes for 64-bit applications. This can cause unintended behavior if not used properly.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

13029 Found host variable(s) declared as long. The size of this data type is 4 bytes for 32-bit and 8 bytes for 64-bit applications. This can cause unintended behavior if not used properly.

Reason for the Error

32-bit and 64-bit modes have different sizes for long data type. Because of this, there might be some differences in behavior between 32-bit and 64-bit applications.

Solution

Review the use of long data type in the application. You can ignore this warning if you intend to use 8 byte data type in 64-bit mode and a 4 byte data type in 32-bit mode. Consider using int data type if you intend to use 4 byte data type in both 32-bit and 64-bit modes, and using a long data type if you intend to use 8 byte data type in both modes. Also, if you want to maintain a single source code and compile the application for both 32-bit and 64-bit modes, consider using int for 32-bit storage and long for 64-bit storage

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this blog post, let’s learn about the client error message “EngineNotSupported with HTTP Status 400” when working with PolarDB...
  • Data
  • December 15, 2022
In this blog post, let’s learn about the client error message “EngineVersionNotSupported with HTTP Status 400” when working with PolarDB...
  • Data
  • December 15, 2022
In this blog post, let’s learn about the client error message “IncorrectDBClusterLockMode with HTTP Status 400” when working with PolarDB...
  • Data
  • December 15, 2022