Re: SQLCode -512

#1

In article <cqv8nd$4qcc$1 (AT) news (DOT) boulder.ibm.com>, etpcorp (AT) yahoo (DOT) com says...

Quote:

I attempt the following:

select * from my.table1
union
select * from remote.my.table1

and I get sqlcode -512: The query reference to a remote object is invalid.

Can you post the contents of your SQLCA when you get the -512? In an
application program you can call DSNTIAR to format the SQLCA.

You may also want to apply PQ85022.

But, the ultimate answer is to call IBM and open a PMR.

--
Dougie Lawson
IBM Farnborough, UK

http://web.ukonline.co.uk/dougie.lawson

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: SQLCode -512

ibm.software.db2.mvs ibm.software.db2.mvs

Re: SQLCode -512 - 12-29-2004 , 04:12 PM