RE: SQLSTMT

["Himes, Jay" <jehimes@xxxxxxxxxxx>]

You cannot specify a table designator on a field if you haven't
specified it for the table

These are valid ways to sue a table designation in this statement:
None:
        select imports as ticker from importpf
Table Name:
        select importpf.imports as ticker from importpf
Renamed Table:
        select a.imports as ticker from importpf as a

Also, I believe that brackets are an MS convention; I don't think the
are legal on OS/400.

Jay Himes
Liberty University


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Berman
Sent: Friday, August 20, 2004 9:05 AM
To: Midrange Systems Technical Discussion
Subject: SQLSTMT



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.