Recent content by philippoommen1

Hi, you can compile the program using the LISTING option COMPILE x.p LISTING x.txt. see the Transaction Listing in the output file.

Hi All, Our SQL customers complain about the Dead Lock situation when a massive update happens..... However, customers using Progress DB have no issues. If you have any KB Links for achieving better performance, precautions to be taken while writing the code etc...(with respect to the SQL...

Hi Rob, Thanks a lot. From the list you mention, the Main difference is propath only. This utility is mainly for developers ONLY. We have Progress & SQL environments (SQL Shema holder). So when a developer checks out 1 program, we need to compile it in 4 environments (2 different versions of...

Hi, I am trying to build a utility to compile programs in different environments. When the user selects an environment and Press compile button run the below code CONNECT database -H dbserver -S 29000. Compile c:\temp\program.p save into e:\cmp\ . DISCONNECT database. My doubt is How can I...

Thank you. We have both Progress and SQL customers for the same application with the same code base. Performance-wise Progress customers are happy however in SQL DB is very slow. Do you have any suggestions to improve the performance? I mean any parameters either on the client-side or on the...

Thank you. Target database you mean SQL DB or Progress DB? Please explain. I want to know in this environment, a Progress DB Server will spawn and waiting for client connections? Why I am asking this doubt because I have not seen any -H, -S parameters in the client PF. Any link to read in...

Hi, Below is one of the lines in a Client PF file for a Progress (Schema Holder) SQL connection -RO -db c:\db\data\sports2000_sh -1 -db Dev -ld sports -U xxxxxxx -P yyyyyy -1 -Dsrv skip_schema_chec from the above line, my understanding is Database connection is Read-Only & Connection is the...

Thanks a lot. If I understood correctly In the third iteration after the Leave statement control will come to final END. I thought after the Leave (3rd iteration ) final END will be skipped. Thanks again.

Hi, Please clarify my doubt. In the below code When i = 3, Progress will release the lock and then leave OR, 3rd record will be in the Exclusive lock until we write the Release statement and then Leave? DEFINE VARIABLE i AS INTEGER NO-UNDO. FOR EACH Customer where customer.custnu < 5...

Thank you so much for the replies. I have one more clarification required. Below is the current appserver log message. [20/05/29@23:06:57.669-0400] P-020192 T-014932 1 AS -- (Procedure: 'STOCK-1 APPSERVER\STOCK\STCK0001-A.P' Line:3821) Lock wait timeout of 1800 seconds expired (8812) It would...

Thank you. My doubt is SQL performance is a bit lower than the Progress DB So that until creating / Writing in SQL completes, corresponding tables will be locked in Progress Db as well?

Hi, One of our clients is using Progress Schema Holder and maps to an MS SQL Server. Application is hanged for a long time. When we checked the asbroker log and found the below error. Can anyone help me sort out this issue? Is this raised due to the locking by SQL DB? Or shall we look into the...

Hi, I am using the below code to add new rows and copy-paste the contents to each row. I want to delete a particular row. Please help me in finding the exact code to DELETE one row which I created in the WORD document. DO cnt = 1 TO 3: ASSIGN W-CNT = W-CNT + 1. IF W-CNT = 1 THEN...

Hi, Customer reported that when they are using a RF screen some times it behaves wrongly after the user prints the label. I collected the 4GL trace from the client. After each print, it will go back to the parent screen. That is the proper behavior, however, sometimes it goes back to the main...

Hi, While I am testing a Delete method inside a class I am getting the below error. After seeing this error, I recreated the WAR files, re-started tomcat, UnDepoyed and deployed the services. Still the same error appearing. Can anyone throw light on the issue?