"prostrct list dbname" overwrites the dbname.st file Is there commandline to get a list of all the area's in the database without overwriting the current structurefile? i want to know from a script if the aifiles needed for activating afterimaging are already present in the database, and i don't want to change the stfile present. Is that possible? (11.3.2)
The prostrct list command can take a structure file name as a parameter.
prostrct list sports2000 foo.st will create or overwrite foo.st rather than overwriting sports2000.st.
- Copy current st file to st.old
- prostrct list dbname > dbname-st.out
- Copy st.old to dbname.st
[collapse]From: a.noteboom [mailto:bounce-anoteboom@community.progress.com]
Sent: Tuesday, May 20, 2014 7:58 AM
To: TU.OE.RDBMS@community.progress.com
Subject: prostrct listThread created by a.noteboom"prostrct list dbname" overwrites the dbname.st file Is there commandline to get a list of all the area's in the database without overwriting the current structurefile? i want to know from a script if the aifiles needed for activating afterimaging are already present in the database, and i don't want to change the stfile present. Is that possible? (11.3.2)Stop receiving emails on this subject.Flag this post as spam/abuse.
Flag this post as spam/abuse.
Stephanie: This does not work. You get the STDOUT output (all that verbal diarrhea) in filename.txt but the dbname.st file is still regenerated.
A.noteboom: You can use prostrct statistics :
$ prostrct statistics aim | grep a[1-9]
/db/aim/aim.a1 131072
/db/aim/aim.a2 131072
/db/aim/aim.a3 131072
/db/aim/aim.a4 131072
/db/aim/aim.a5 131072
You can also use rfutil db -C aimage list which will return an error and give you no information on physical AI files if AI is disabled OR give you the list of files. This is not an answer to your question but it might be useful to one of the readers.
- Copy current st file to st.old
- prostrct list dbname > dbname-st.out
- Copy st.old to dbname.st
Flag this post as spam/abuse.
Flag this post as spam/abuse.
Flag this post as spam/abuse.
[/collapse][/collapse][/collapse]Another way to get a list of AI areas, if you have access to an editor:
for each _area no-lock where _area-type = 7:
display _area-number _area-name.
end.
The prostrct list command can take a structure file name as a parameter.
prostrct list sports2000 foo.st will create or overwrite foo.st rather than overwriting sports2000.st.
Thank you for the answer Rob Fitzpatrick.
I ended up using "prostrct list db tempfile.st" and parsing the output.
I'm using this in a script to activate AI from my management tools.
thnx
I'm not able to mark your reply as the 'answer', because your first post containing the ABL code seem to mess up the html of the forum. Maybe one of the moderators of this forum can look into this?
> Maybe one of the moderators of this forum can look into this?
They are.