6 Replies Latest reply: Oct 21, 2011 3:32 PM by Steven Hawkins RSS

metamatrix to teiid transition - SQL syntax question

Frank Sauer Newbie

Hello,

 

I am attempting to port all our metamatrix models over to teiid and am running into bizarre SQL parsing problems.

 

this works:

 

SELECT RTRIM(MED.BATDAT) as id

FROM FCC.MEDMAS AS MED

 

and so does this:

 

SELECT substring(MED.BATDAT, 4, 4) as id

FROM FCC.MEDMAS AS MED

 

but this gives a parsing error:

 

SELECT substring(RTRIM(MED.BATDAT), 4, 4) as id

FROM FCC.MEDMAS AS MED

 

[Error Code: 0, SQL State: 50000]  Remote org.teiid.api.exception.query.QueryParserException: Parsing error: Encountered "," at line 2, column 32.

Was expecting one of:

    "and" ...

    "between" ...

    "from" ...

    "in" ...

    "is" ...

    "like" ...

    "like_regex" ...

    "not" ...

    "or" ...

    "similar" ...

    ...

 

this seems so basic I must be doing something wrong. Interestingly, when I run this SQL against an EDS 5.1 installation it works fine but I don't know how to tell designer I am using EDS.

 

Any ideas?

 

Thanks,

 

Frank Sauer