I expected that to work too, but it doesn't.
My first try was this:
for each tbl_a no-lock,
first tbl_b no-lock where tbl_b.item = tbl_a.item,
each tbl_c no-lock where tbl_c.order = tbl_b.order
and tbl_c.stats = "B":
display tbl_a.item tbl_c.order.
end.
This...
I have three tables:
Item
4251
4252
4253
Indx Item Order
1 4251 100
2 4251 105
3 4251 110
4 4251 115
5 4252 200
6 4252 205
7 4252 210
8 4253 300
Order Stat
100 A
105 A
110 B
115 B
200 A
205 A
210 B
300 B
Now i...
Hi jchellap,
You could use this code to check for valid account-subaccount combinations.
find cr_mstr no-lock
where cr_domain = global_domain
and cr_type = "SUB_ACCT"
and cr_code = posub
and poacct >= cr_code_beg
and poacct <= cr_code_end no-error.
m_flag = avail cr_mstr.
Hi jchellap
You can find these values in table qad_wkfl using this key:
qad_key1 = "GLCD_DET"
qad_key2 = string(glcd_year,"9999") + string(glcd_per, "999") + glcd_entity
Values are in decimal fields where 1 is Yes.
ap_closed = (qad_decfld[1] = 1)
ar_closed = (qad_decfld[2] = 1)
fa_closed =...
Your sequence seems correct to me, unless you are using a modified version of popomt.p.
Possibly your problem starts before this part of your sequence. The best way to find out is to follow the sequence in a manual session.
Hi,
Is there any perfomance difference when using one large fixed extent or several fixed extents of 2 GB instead.
Assuming that for both situations the fixed extents are not full.
Regards, Rene
Red Hat Enterprise Linux 5 64 bit
Open Edge 10.2
usrl_det is for Licensed Application Details. This doens't contain login history.
Login history might not be available in your version.
You would have to get it from the database log file.
You have to take into account that so_mstr has some array fields like so_slspsn and so_comm_pct with only one label. Your query will export 4 fields instead of one for so_slspsn.
We use progress 9.1D and we have two After Image extents.
st file:
a /ext2/mfgdata/prod/mfgprod.a1
a /ext2/mfgdata/prod/mfgprod.a2
Sometimes we run into the limit of 2 gb and the database crashes.
How can we setup these after image files with fixed and growing extents?
Hi,
I want to write a util to change all sod_due_date fields to be the same as the so_due_date. Do i need to change any other field? I'm not sure what happens exactly when changing sod_due_date manually using 7.1.1.
Thanks for help.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.