Results 1 to 2 of 2

Thread: create nickname

  1. #1
    Join Date
    Dec 2002
    Posts
    25

    Wink Unanswered: create nickname

    as I can create nickname with less columns than the table origin..
    thanks!!!

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605

    Re: create nickname

    Originally posted by zarconja
    as I can create nickname with less columns than the table origin..
    thanks!!!
    Hi,

    I don't understand your question. Would you like to ask if you can create the nickname with less columns than the remote table has?

    You can't create nickname with less columns than the remote table has. But you can create federated view with only desired columns (you have to create the nickname first, then federated view).

    Sintax
    Create federated view name_of_new_view select col1, col2 from schema.nickname

    Hope this helps,
    Grofaty

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •