All,
Thanks for all your replies.
I am using Progress OE 10.1b.
I dont wish to have any additional callling programs to achieve this. I am not using buffer-copy copy since buffer-copy iterates record-by-record. I am expecting the source temp-table to have a million record.
Rgds,
AJ.
Hello All:
I need to copy all records from a Temp-table say "tt_source" to a temp-table "tt_target". I dont want to use the usual buffer-copy which loops through each record at one-time.
Is there a way to take a snap-shot of the temp-table and copy it as it is as another temp-table with a...
Dear All:
Does anyone know how to get the full set of test cases to test the ERP MFG/PRO? The test cases scenarios should be able to cover almost all major business functions.
Is this available anywhere. Any references will be appreciated?
Thanks in advance,
AJ.
Thanks for all your valuable inputs. It worked !!!! .
FrancoisL : Am using temp-table because am checking against some set of rules and only if qualified populating the values in temp-table. This is temp-table is finally written to the target DB.
Thanks,
AJ.
Hello All:
Need Help urgently. I have the below scenario:
program x.p
Initialize variables.
Do this.
Do that.
accept source table input.
run x2..p "Source Table".
buffer-copy tt target-db.
program x2.p
create dynamic table d1-table like {1}.
create dynamic temp-table...
Hello All:
I am trying to run a generic program that accepts a DB table name (mfg/pro) and copies its record to a dynamic temp-table through buffer-copy. I am able to do this and it works fine.
Whats strange is that the double underscore fields like pt__dte01 whose value in DB table is "?"...
abs_mstr stores the shipment details. It could be pre-shippers or shippers. The abs_id has a "p" prefixed for pre-shippers and has the shipper number for shippers. The abs_status field will tell you if the shipper is created, confirmed and invoiced.
The way mfg/pro stores records in this...
Victoria:
If you have the source code of mfg/pro check printing module, i think it is apckprb.p. Check the logic. As per the logic, it populates the details into a qad_wkfl and when confirmed by user "when first check was printed ok" it goes and commits those details into the actual DB table...
DRP - Distribution Requirement Planning.
This module helps you plan and meet the demand between different warehouses. The requirements is generated as demand from the site that needs the items and its exact number required and passed on to the site that has the sufficient supply. The sites are...
Hello All:
I need to know to the step by step sequence that is required to carry out a normal manufacturing cycle in mfg/pro. For example: In Distribution module, this would be Create SO, Shipment, Invoice, Invoice Post, AR Dr/Cr Memo, Receive payments, GL Unposted Entries, GL Post.
Can...
Pl. provide details on where is the DB and what is your environment.
To me it looks like the DB is not up. Start the DB (Windows or Unix Server) and then try to connect using the JDBC Driver.
HTH.
Thanks All for your valuable inputs. I have completed the work using -ld and executing the called programs using the "run" command and passing the logical names of the source and target DB.
I am working on to put such extraction programs in a batch to execute as a one-time script. Wish me...
Hello Progress Experts:
I need help to transfer data from Source DB to Target DB using data migration programs. The name of the Source DB and Target DB will be accepted at Runtime.
The Functionality of the data migration program will basically be to extract data from Source DB and populate...
Dear All,
I have encountered error no. 142 in Progress. I have re-checked the logic and it seems to be fine. Would like to know in what all cases does Progress generate error no. 142. Thanks in advance to all.
Regards,
Indra
I have a problem with comparing the two object code(compiled code) of a progress program. I do not have access to check the .p program. I checked the byte size to find out whether they are the same. The byte size is same, but the program is behaving differently in my QA and Production...
1. Use the query below to retrieve all the table and field information in your current database.
Query
for each _file where not _file-name begins "_" no-lock:
disp _file-name label "Tablename".
for each _field of _file...
The error message description goes likes this:
<segment-name> has exceeded its limit of <segment-size> bytes, in
<file-name> at line # <line-number>. (3307)
INTRODUCTION
============
This knowledgebase entry describes what goes into r-code
action code and expression code segments and how...
Hi,
You use 'FIND' when you want to find single unique record in a table. For example;
FIND ad_mstr WHERE ad_type = "customer" no-lock no-error.
IF AVAILABLE ad_mstr THEN
DISP ad_mstr.
1. Where ad_mstr is the name of the table and ad_type is the field you are querying.
2. You add...
Hi,
Try the code below;
Code
def var wkint as decimal format "zzz,zzz,zzz,zz9.99".
def var wkchar as char format "X(18)".
set wkint.
wkchar = string(wkint,"zzz,zzz,zzz,zz9.99").
output to "test.doc".
put wkchar.
output close.
HTH,
Rgds,
Ajay.
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.