on 08-19-2015 12:37 PM
Hello experts,
I am using @Variable('DBUSER' [DELIMITER = no_quote] ) but still the return value has single quote in generated sql statement.
SELECT DISTINCT
'MYDB'.FXN_CUSTOM_FUNCTION('08/19/2015 16:58:18')
FROM
MYTABLE
In above example MYDB is the output of @variable('DBUSER'), it is surrounded by single quotes and hence i am getting an error saying
[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot call methods on varchar.
Can any one tell me how to get out of single quotes here.
Thanks ,
Deepa.
Hi Deepa, Yes, I see that in the IDT guide chapter 18 For syntax @Variable('' [, DELIMITER=default | no_quote] ) must be in single quotes. and DBUSER Should be used as ..... @Variable('DBUSER' [,DELIMITER=no_quote]) check with the coma, Also is this a multisource unvierse? where are you using the @Variable? in the BEGIN_SQL OR END_SQL? IN JOIN? Calculated column, derived table?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Try with set the delimiter value to No in the PRM file and see if it will work.
Check section 3.4.15.25 DELIMIT_IDENTIFIERS page 120.
http://help.sap.com/businessobject/product_guides/boexir4/en/xi4sp11_universe_design_tool_en.pdf
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jacqueline,
Yes, @Variable is a string variable and BO has provided us an alternative way (like setting DELIMIT_IDENTIFIERS) to use it as non-quoted string for different purpose (as a schema name in my example above). But unfortunately these workarounds are not working for me.
Thanks,
Deepa.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.