cancel
Showing results for 
Search instead for 
Did you mean: 

why is a formatted search in 8.81 no more working in 9.1 PL 5 ?

Former Member
0 Kudos

Hi

Below formatted search is working well in 8.81

“SELECT Indicator =

            CASE substring(NNM1.seriesname,1,3)

                     WHEN 'HUB' then 'Hub'

                     ELSE   '   '        

            END    

FROM NNM1

WHERE NNM1.series = $[ORDR.SERIES]”

In 9.91, I've got an error : "Incorrect syntax near ""."

What am I doing wrong ?

Thanks

Accepted Solutions (0)

Answers (2)

Answers (2)

KennedyT21
Active Contributor
0 Kudos

Try this

SELECT

            CASE substring(NNM1.seriesname,1,3)

                     WHEN 'HUB' then 'Hub'

                     ELSE   '   '      

            END   Indicator

FROM NNM1

WHERE NNM1.series = $[ORDR.SERIES.0]

Former Member
0 Kudos

Hi, Thanks for your answer, but it gives me following error

"Incorrect syntax near 'ORDR.SERIES.0'.

KennedyT21
Active Contributor
0 Kudos

Try This

SELECT

            CASE substring(NNM1.seriesname,1,3)

                     WHEN 'HUB' then 'Hub'

                     ELSE   '   '     

            END   Indicator

FROM NNM1

WHERE NNM1.series = $[$139.88.0]

Former Member
0 Kudos

Still a syntax error...

"Incorrect syntax near '$[$139.88.0'

KennedyT21
Active Contributor
0 Kudos

SELECT

            CASE substring(NNM1.seriesname,1,3)

                     WHEN 'HUB' then 'Hub'

                     ELSE   '   '    

            END   Indicator

FROM NNM1

WHERE NNM1.series = $[$38.SERIES.0]

Rgds

Former Member
0 Kudos

If I replace $[ORDR.SERIES] with a hard coded value, then it works, so what is the correct syntax in 9.1 ?

Thanks

frank_wang6
Active Contributor
0 Kudos

SELECT

            CASE substring(NNM1.seriesname,1,3)

                     WHEN 'HUB' then 'Hub'

                     ELSE   '   '       

            END   Indicator

FROM NNM1

WHERE NNM1.series = $[ORDR.SERIES]

Try this.

Former Member
0 Kudos

Hi, Thanks for your reply but it gives me following error
Incorrect syntax near 'ORDR.SERIES'.