CAPI.Exec and joins

JOHN_LE_(LockMarUser3_(Delete)_2316094)

I'm trying to create an SQL SELECT statement, joining two tables. However, using the TABLE.column syntax seems to be causing problems... i.e.SELECT emp.empnum from employee emp ...Shouldn't this work, or is there something else I need to do when using CAPI.Exec?Thanks.

eLink User

Message from Sean M Alderman via eLinkThere is a 255 character limit for CAPI.Exec sql statements.Try -Select a.col1, b.col2 from table1 a, table2 b where a.colX = b.colY;Also you may wish to look to see if there is an existing view thatpresents the data you need. This can significantly save characters inthe sql string. For instance, I use the WEBNODES view quite often, evenif I don't need everything it returns, it's just easier to build a sqlstatement like select * from webnodes where blah blah blah. This letsme put more junk in my where clause to make sure I get the rightrecords.eLink Discussion: Development Discussion wrote:> > CAPI.Exec and joins> Posted by LockMarUser3 on 07/30/2001 03:19 PM> > I'm trying to create an SQL SELECT statement, joining two tables. However, using the TABLE.column syntax seems to be causing problems... i.e.> SELECT emp.empnum from employee emp ...> Shouldn't this work, or is there something else I need to do when using CAPI.Exec?> Thanks.> > [To reply to this thread, use your normal e-mail reply function.]> > ============================================================> > Discussion: Development Discussion> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=786303&objAction=view> > Livelink Server:> https://knowledge.opentext.com/knowledge/livelink.exe-- Sean M. AldermanITRACK Systems AnalystPACE/NCI - NASA Glenn Research Center(216) 433-2795