|
View previous topic :: View next topic
|
| Author |
Message |
sgiri
Warnings : 1
New User
Joined: 07 Aug 2007
Posts: 20
Location: chennai
|
|
|
|
hi all,
Pls let me know how can we compare 2 longvar variables through the DB2 query. |
|
| Back to top |
|
 |
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
| do you mean varchar? |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
If you post your definitions and what you want to do, it will help. |
|
| Back to top |
|
|
sgiri
Warnings : 1
New User
Joined: 07 Aug 2007
Posts: 20
Location: chennai
|
|
|
|
| I am getting -134 error when comapring the 2 longvar variables. Pls let me know how can i compare them through a Db2 Query |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
sgiri,
You need to explain what is the definition of 'longvar variables' or by this what are you referring to? |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
SQL code -134:
| Quote: |
| A long string was referenced in a context in which long strings are not allowed. For an exhaustive list of such contexts, refer to Varying Length Character Strings in Chapter 3 of SQL Reference. |
Start using proper terminology. If you still can't understand why your query is returning the -134, post your sql, ddl and we can help. |
|
| Back to top |
|
|
|
|
