Re: syntax issue

[CRPence <CRPbottle@xxxxxxxxx>]

  The default for SQL is to use the Authorization Identifier as the 
qualifier for unqualified TABLE-references in a statement.

  Resolve the issue in one of the following ways:

  - change the connection properties to use *SYS naming vs *SQL naming, 
for which unqualified table-references use *LIBL; then of course, the 
TABLE names expected to be found must be in the Library List of the 
server job... which is yet more connection properties

  - SET CURRENT SCHEMA to the library name where the file(s) reside

  - explicitly qualify the TABLE name with its schema [library] name

Regards, Chuck

On 24 May 2013 15:14, Crystal Reports wrote:
> I did run finally the SQL query but had some errors why is it using
> my  name as the library
>
> Connected to relational database S9090abc on 1nn.1nn.n.n as
> crystalcleardecisions - 644367/Quser/Qzdasoinit
>
> SELECT <<SNIP>>
> FROM       OEORH41  INNER JOIN REFER1 <<SNIP>>
>
> SQL State: 42704
> Vendor Code: -204
> Message: [SQL0204] OEORH41 in crystalcleardecisions type *FILE not
> found. <<SNIP>>