We help IT Professionals succeed at work.

how to use defncopy?

edward97
edward97 asked
on
Medium Priority
2,254 Views
Last Modified: 2012-05-04
I am trying to use "defncopy to copy out | in the view, rules, default and triggers from one database to another.

for example
defncopy -Usa -P out /tmp/pb_cattbl.dcopy hf_prod pb_cattbl

What' wrong for the above statement?
Comment
Watch Question

Commented:
Your syntax appears fine.
Without knowing what exactly the problem is, it's hard to help, but...

1. Maybe the /tmp directory doesn't exist or have enough space.
2. If you're running this on a workstation, you may need to include the -S option (server name).
3. I'm sure you checked this one, but perhaps the DB name or object name is misspelled.
4. The Sybooks help says that defncopy won't work with objects created with Report Workbench
5. I'm just guessing, but pb_cattbl looks like a powerbuilder utility object.  You may not need to copy it.  Just get PB to create a new one.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.