Problem with defncopy [Archive]

SegFahlt

01-14-02, 22:20

I'm having some problems with defncopy

when I issue the following command
defncopy -Umyuser -Pmypass -Smysvr out btmp dbname dbo.tbl_name

it just gives me an empty tbmp file(well.not empty)
/* ### DEFNCOPY: END OF DEFINITION */

I do have full select privs on syscomments and sysobjects tables.

any ideas? or is there another way to extract the DDL for each object i need(tables, views and procs) via Unix command line(no perl on my box)

TIA, i'm hurting here.

bill

fadace

11-22-02, 11:09

Defncopy doesn't work to extract the table DDL. Only working with the stored procedures (because it reads syscomments)

To extract the DDL of a table, use Sybase Central, PowerDesigner ... or write (or download) some existing tools (like geniddl)