as400 join sqlserver...

[nuria]

hi

I have an AS400 table and SQL server table and need do a JOIN in a
select, I did this:

SELECT GNORP.COORG, GNORG.ORDES, GNORP.CPAIS, GNPAI.PADES, GNORP.ORV01
FROM ((GNORP GNORP LEFT OUTER JOIN GNORG GNORG ON GNORP.COORG =
GNORG.COORG) LEFT OUTER JOIN SERVIDOR_CBL.GN_3_0.dbo.GNPAI GNPAI ON
GNORP.CPAIS = GNPAI.COPAI) ORDER BY GNORP.COORG, GNORP.CPAIS

in this case "SERVIDOR_CBL.GN_3_0.dbo.GNPAI" I said the
serverName.BDName.Owner.TableName

But give me an error... Anyone know how can I do this??

Thanks in advance...

[Serge Rielau]

nuria wrote:

hi

I have an AS400 table and SQL server table and need do a JOIN in a
select, I did this:

SELECT GNORP.COORG, GNORG.ORDES, GNORP.CPAIS, GNPAI.PADES, GNORP.ORV01
FROM ((GNORP GNORP LEFT OUTER JOIN GNORG GNORG ON GNORP.COORG =
GNORG.COORG) LEFT OUTER JOIN SERVIDOR_CBL.GN_3_0.dbo.GNPAI GNPAI ON
GNORP.CPAIS = GNPAI.COPAI) ORDER BY GNORP.COORG, GNORP.CPAIS

in this case "SERVIDOR_CBL.GN_3_0.dbo.GNPAI" I said the
serverName.BDName.Owner.TableName

But give me an error... Anyone know how can I do this??

Thanks in advance...

Where do you run the select? Websphere II?
If so you need to use NICKNAME

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

[nuria]

I use JDBC in a java application. I execute the sentence in the AS400
connection but I have another connection to the sqlserver too...
Serge Rielau <sr*****@ca.ibm.com> wrote in message news:<39*************@individual.net>...

nuria wrote:

hi

I have an AS400 table and SQL server table and need do a JOIN in a
select, I did this:

SELECT GNORP.COORG, GNORG.ORDES, GNORP.CPAIS, GNPAI.PADES, GNORP.ORV01
FROM ((GNORP GNORP LEFT OUTER JOIN GNORG GNORG ON GNORP.COORG =
GNORG.COORG) LEFT OUTER JOIN SERVIDOR_CBL.GN_3_0.dbo.GNPAI GNPAI ON
GNORP.CPAIS = GNPAI.COPAI) ORDER BY GNORP.COORG, GNORP.CPAIS

in this case "SERVIDOR_CBL.GN_3_0.dbo.GNPAI" I said the
serverName.BDName.Owner.TableName

But give me an error... Anyone know how can I do this??

Thanks in advance...

Where do you run the select? Websphere II?
If so you need to use NICKNAME