Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
TBP wrote:
> annabz wrote:
>
>> Hello, I am trying to run dbexport in Informix database on NT to export
>> just one table, not the whole database. Does anyone know the syntax of
>> the
>> dbexport command to export only 1 table?
>>
>> Many thanks -- Anna
>>
>
> Interesting :D
>
> Well, you would have to use a combination of
>
> dbschema -d databasename -t tablename (-ss)> unload to "table.unl" select * from tablename;>
> Then use the dbschema produced to create the table
> then
> load from "table.unl" insert into tablename>
> Or you could use onunload to go from / to the same version
>
> Or you could use dbschema and then remote selects
>
> But, yes, this sounds like a nice feature reqeust :
>
> "Add table selectivity to the dbexport command"
>
Instead of Unload/Load you could use INSERT INTO tablenamebk SELECT *
FROM tablename
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.