on 03-16-2007 11:38 PM
Hi Guys:
How I can run this query (SQL Transact from MS-SQL) but in MaxDB?!
select datalength(FIELDINFO),datalength(LOGICINFO),
datalength(EXTENSIONS)
from DYNPSOURCE
where PROGNAME = 'SAPMF05A' and DYNPNUMBER = '0110'
Seems the function DATALENGTH doesn't exist in MaxDB, similar is LENGTH but the field is LONG data type and doesnt support this function.
Thanks!
Regards,
Federico
Hi,
which MaxDB version are you using? Is the DB Unicode or not?
Our LENGTH function should perform similarly (in MaxDB version >= 7.6), but one would get the length in number of characters when using it on a Unicode-char field.
Regards,
Roland
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.