In article <4bdd9tF10nf7gU1@individual.net>, srielau@ca.ibm.com says...
> Gert van der Kooij wrote:
> > In article <4bd80qF112nkvU1@individual.net>, srielau@ca.ibm.com says...
> >
> >> db2 declare mycurs cursor database DB1 user user1 using pwd1 for
> >> select two,one,three from abc.table1
> >>
> >
> > Hi Serge,
> > I found some info about this way of defining a cursor at
> > http://tinyurl.com/gk8v7 but not in the 'DECLARE CURSOR' docs. Should it
> > be there and is this going to be updated or is it described somewhere
> > else?
> > It would be great if it would also be possible in a regular select
> > statement.
> It has the smell of a CLP command This is not your regular cursor
> definition.
> Am I right that you are gearing towards 4 part names without need to
> create nicknames? _dbname_.schema.table.column
>
> Cheers
> Serge
>

You're right, I found it at http://tinyurl.com/gbpeg.
The 4 part name would be a great solution, but I guess authentication
against the remote database could be an issue.