Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

InfoMaker on Oracle 7.3

2 posts in PB Infomaker Report Writer Last posting was on 1998-07-17 18:38:14.0Z
Alvie Yap Posted on 1998-07-17 10:16:18.0Z
Newsgroups: sybase.public.infomaker.general
Date: Fri, 17 Jul 1998 18:16:18 +0800
From: Alvie Yap <lvyap@pc.jaring.my>
Organization: Decom Systems Sdn. Bhd.
X-Mailer: Mozilla 4.01 [en] (Win95; I)
MIME-Version: 1.0
Subject: InfoMaker on Oracle 7.3
X-Priority: 1 (Highest)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 16
Message-ID: <348_35AF2471.E39E479D@pc.jaring.my>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6993
Article PK: 243021

Please help!! I face an error when I'm trying to do a outer join in the
Query windows.

Currently my server is DEC Alpha VMX machine (latest version and new
hardware) and Infomaker 5.0.

When I try to execute the below command (in query window) I received an
error as this
"SQLState=1000, [ORACLE][ODBC Oracle Driver][Oracle OCI]ORA-00933]; SQL
command not properly ended"

============
SQL Statement:
SELECT V_MRMR_MRMRD.MTLRQNNUM,
V_MRMR_MRMRD.REQUESTER,
EM.NAME
FROM {oj V_MRMR_MRMRD left outer join EM on V_MRMR_MRMRD.REQUESTER =
EM.EMPL_ID};


Terry Dykstra [TeamPS] Posted on 1998-07-17 18:38:14.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra [TeamPS]" <no_spam_tdykstra@cfol.ab.ca>
Subject: Re: InfoMaker on Oracle 7.3
Date: Fri, 17 Jul 1998 12:38:14 -0600
Lines: 30
Organization: Canadian Forest Oil Ltd.
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <348_#MQUphas9GA.209@forums.powersoft.com>
References: <348_35AF2471.E39E479D@pc.jaring.my>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6989
Article PK: 243018

Make sure there is a space at the end of each line. Sometimes they get
lost.
Also, have you configured the 'Query Governor' to allow outer joins.
Have you considered using the Native driver instead of ODBC?

--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.

Alvie Yap wrote in message <35AF2471.E39E479D@pc.jaring.my>...
>Please help!! I face an error when I'm trying to do a outer join in the
>Query windows.
>
>Currently my server is DEC Alpha VMX machine (latest version and new
>hardware) and Infomaker 5.0.
>
>When I try to execute the below command (in query window) I received an
>error as this
>"SQLState=1000, [ORACLE][ODBC Oracle Driver][Oracle OCI]ORA-00933]; SQL
>command not properly ended"
>
>============
>SQL Statement:
> SELECT V_MRMR_MRMRD.MTLRQNNUM,
> V_MRMR_MRMRD.REQUESTER,
> EM.NAME
> FROM {oj V_MRMR_MRMRD left outer join EM on V_MRMR_MRMRD.REQUESTER =
>EM.EMPL_ID};
>