Recent content by ajaysheth

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

I have used Humming Bird to connect to Telnet MFG/PRO on SUSE Linux . It works fine. I am not sure if Humming Bird is free. Thanks, Ajay.

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