Four part table name ...problem

Question

Four part table name ...problem

Nelson Viggiani-332216

Ten Centuries

Points: 1264
More actions
December 21, 2006 at 6:35 am

#118484

If I use this:
select * from LPUSA01.LPUSA01.EBSTSTNEW.BZRCRP
it bring only one record and I knwo that table(BZRCRP) as 5 records.
if I use this:
select
* from openquery(LPUSA01,'select client_number,client_name,bill_to_name,account_exec_name,invoice_number,invoice_type,cast(invoice_date as char(8000)),cast(invoice_due_date as char(8000)),invoice_gross,invoice_header_text, billtoname_bz,invoice_number_bz,headerTXT_bz,onloadtotalchrg_bz from BZRCRP')
it bring all 5 records...
Any ideas why this happens??? thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

John Mitchell-245523 SSC Guru Points: 148786 More actions · Answer 1

Nelson

The only thing I can think of is that you may have two tables called BZRCRP, one owned by dbo (with 5 records) and one owned by EBSTSTNEW (with 1 record).

John

Nelson Viggiani-332216 Ten Centuries Points: 1264 More actions · Answer 2

But 2 tables where?? on As400 ? I have no idea about 2 tables, How do I check for that??

thanks

John Mitchell-245523 SSC Guru Points: 148786 More actions · Answer 3

Ah - it's an AS400 database? I don't know anything about AS400, I'm afraid. However, if it's ANSI compliant, you should be able to run SELECT TABLE_SCHEMA, TABLE_NAME FROM LPUSA01.LPUSA01.INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'BZRCRP' against it.

John