HI,
We are facing an issue when we insert selection criteria in the SELECTION tab of Hashed file. The below is the select stmt
(COL1='1' or (COL1='2' and COL2=#Param1#) or (COL1='3' and COL2=#Param2#)) and COL3=#Param3#
Then it gives error when we select view data : DSD.UVOpen Retrieve: syntax error. Unexpected symbol. Token was "(". Scanned command was SELECT DSJOB_XML_HF WITH ( COL1 = "1" "or" ( .
NOTE: The hashed file does return data if I remove all the braces , but we are afraid that might change the functionality.
Did anyone work on nested selections in hashed file?
Thanks,
Nested selections (Selection Tab) in hashed file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 12
- Joined: Wed Jan 02, 2008 11:45 pm
- Location: Hyderabad
you should at lease write:
a apostroph ' before and after the param.
Code: Select all
(COL1='1' or (COL1='2' and COL2='#Param1#') or (COL1='3' and COL2='#Param2#')) and COL3='#Param3#'
Wolfgang Hürter
Amsterdam
Amsterdam
-
- Participant
- Posts: 12
- Joined: Wed Jan 02, 2008 11:45 pm
- Location: Hyderabad
WoMaWil wrote:you should at lease write:
a apostroph ' before and after the param.Code: Select all
(COL1='1' or (COL1='2' and COL2='#Param1#') or (COL1='3' and COL2='#Param2#')) and COL3='#Param3#'
Hi,
Thanks , we did try that and get the same error!
'(COL1='1' or (COL1='2' and COL2='#Param1#') or (COL1='3' and COL2='#Param2#'))' and COL3='#Param3#'
Also tried the below which lets us view the data but the logic does not work, the difference in the below stmt is we have used single quotes for the individual OR stmts.
(COL1='1' or '(COL1='2' and COL2='#Param1#')' or '(COL1='3' and COL2='#Param2#')') and COL3='#Param3#'
-
- Participant
- Posts: 12
- Joined: Wed Jan 02, 2008 11:45 pm
- Location: Hyderabad