Dump/load sequences by program

Posted by Stefan Marquardt on 10-Mar-2015 10:39

I found some KB articles about to dump sequences but only one uses an existing program from prodict.pl:

000010326:

RUN prodict/load_seq.p (INPUT “_seq-val.d”,
                                              INPUT “c:/data/”).   

But I can't find the related dump program!

Posted by Stefan Drissen on 10-Mar-2015 10:46

http://www.progresstalk.com/threads/how-to-dump-_user-tables-and-sequence-values.122060/
 
 
 
[collapse]
From: Stefan Marquardt [mailto:bounce-Marquardt@community.progress.com]
Sent: dinsdag 10 maart 2015 16:40
To: TU.OE.Development@community.progress.com
Subject: [Technical Users - OE Development] Dump/load sequences by program
 
Thread created by Stefan Marquardt

I found some KB articles about to dump sequences but only one uses an existing program from prodict.pl:

000010326:

RUN prodict/load_seq.p (INPUT “_seq-val.d”,
                                              INPUT “c:/data/”).   

But I can't find the related dump program!

Stop receiving emails on this subject.

Flag this post as spam/abuse.

[/collapse]

All Replies

Posted by Stefan Drissen on 10-Mar-2015 10:46

 
 
 
[collapse]
From: Stefan Marquardt [mailto:bounce-Marquardt@community.progress.com]
Sent: dinsdag 10 maart 2015 16:40
To: TU.OE.Development@community.progress.com
Subject: [Technical Users - OE Development] Dump/load sequences by program
 
Thread created by Stefan Marquardt

I found some KB articles about to dump sequences but only one uses an existing program from prodict.pl:

000010326:

RUN prodict/load_seq.p (INPUT “_seq-val.d”,
                                              INPUT “c:/data/”).   

But I can't find the related dump program!

Stop receiving emails on this subject.

Flag this post as spam/abuse.

[/collapse]

Posted by Frank de Laat on 11-Mar-2015 07:23

Hi Stefan,

prodict/load_seq.p and all other dump and load programs are part of $DLC/src/prodict.pl.

For more details and information how to extract the procedure library go to:

knowledgebase.progress.com/.../15884

Good luck,

Frank

Posted by Stefan Marquardt on 11-Mar-2015 08:35

I used a manual dump procedure, found in the KB.

But why there isn't any easy usable counterpart of load_seq in prodict.pl available?

Posted by Håvard Danielsen on 11-Mar-2015 15:45

Since v11.0 prodict/dmpseqvals.p can be used to dump sequence values. It is different than the older prodict APIs in that it has to be run persistent. Note that most of the older load and dump also typically can be run persistent, since they have more options than what can be provided with the input parameter. They will have a doDump or doLoad method to do the actual operation.  

define variable hDump as handle no-undo. 

run prodict/dmpseqvals.p persistent set hDump. 
run setFileName in hDump ("seqvals.d").
run doDump in hDump.

---
In addition to setFileName(), you can control the outcome with setDirectory(), setSequenceSelection(key of a sequence),  setCodePage(), setSilent() - boolean true to suppress messages, setEffectiveTenant() and setTenantDir().

This thread is closed