?
Solved

how to use defncopy?

Posted on 1997-09-02
1
Medium Priority
?
1,987 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?
0
Comment
Question by:edward97
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 2

Accepted Solution

by:
Srw earned 100 total points
ID: 1098019
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.
0

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
Learn how to use the free Acronis True Image app to easily transfer data between iPhones and Android phones.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question