Search results

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...

tbl_a has unique index on tbl_a.item tbl_b has unique index on tbl_b.indx tbl_c has unique index on tbl_c.order

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.

Replace {mfdtitle.i} with {mfdeclre.i} and it will work without the "Press space bar" message. Also change "batch run" to "batchrun".

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

Why not add this to your restore script: echo Y >restore.rst dir /b ICMASLIV.* >>restore.rst

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.

Hi, You can find user login data in the uslh_hist table.

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.

Just create a fake batch id with a name that comes up first when using arrow down key (like _blank) It worked for me.

It should look like this: cd_ref cd_type cd_lang cd_seq X F1 Delete 1/1 1/2 1/3 1/4 1/5 2/1 3/1 BO02001 PO 1 X - Yes

facts: Hyper-V RH Enterprise Linux 5 OE10.2B QAD2010SE Start parameters: -B 125000 -bibufs 100 -aibufs 150 -c 350 -L 80000 -Mf 60 -n 300 -spin 60000 6 instances of proapw 1 instance of probiw 1 instance of proaiw 2 instances of prowdog 200 active users Problem: During Net Change MRP...

Thanks Tom, your presentation was very helpfull.

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 part of your escape codes is wrong: /027&l2E It should be /027&l2 for Letter or /027&l26 for A4 The E in your code resets all previous settings.

Did you get this to work? I've been looking for a way to get defaults for a long time. Please share your experience.