Re: SQLSTMT

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

A couple things:

What command are you using?

You have an extra right-parenthesis in the middle of the statement, after 
the right square bracket.

I'm not sure that square brackets are valid - I could be wrong there. It is 
certainly not a valid iSeries name, but you could try putting quotation 
marks before and after the alias name. Not double apostrophes, by the way.

You must have "a" defined as an alias of the file name in the FROM clause, 
right? Otherwise "a.imports" won't be understood.

HTH
Vern

At 08:04 AM 8/20/2004, you wrote:


> HI I am trying to run a SQL
>
> SQLSTMT('Select a.imports as [Ticker]) from importpf') +
>
>
>
> I get the error that this is a bad token.
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Express yourself with Y! Messenger! Free. Download now.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.