PREV 1 NEXT
Limit the number of record in a table
I want to limit the number of records that a user can input in a specific table. for instance, users should be able to subscribe to a race which are limited to 10 tracks. I would i to have a clause or something that might help my to prevent users from exceeding the number of tracks...
I want to limit the number of records that a user can input in a specific table. for instance, users should be able to subscribe to a race which are limited to 10 tracks. I would i to have a clause or something that might help my to prevent users from exceeding the number of tracks...
5 pts.
Strange problem with locking of records
Hi All, My program reads many records one by one, and will update the OLD KEY with NEW KEY in more than 100 files. If any run-time error/record locking the pgm will roll back the partial updates and continue with the next record. So, example take 5 records... in which I locked the 3rd record...
Hi All, My program reads many records one by one, and will update the OLD KEY with NEW KEY in more than 100 files. If any run-time error/record locking the pgm will roll back the partial updates and continue with the next record. So, example take 5 records... in which I locked the 3rd record...
Record Locking in Access 2007
How can I lock records in a simple Access database after updates? And, how do I set up the user interface to include only the form I would like for the user to complete? Software/Hardware used: Microsoft Access 2007
How can I lock records in a simple Access database after updates? And, how do I set up the user interface to include only the form I would like for the user to complete? Software/Hardware used: Microsoft Access 2007
Record Locking in SQLRPGLE
Hi All I have a SQLILE pgm which updates files through SQL statements. How to get the user id/job number which is locking the PF record through the program... if any data structure supports, whats the position of it... -Varun Software/Hardware used: AS/400
Hi All I have a SQLILE pgm which updates files through SQL statements. How to get the user id/job number which is locking the PF record through the program... if any data structure supports, whats the position of it... -Varun Software/Hardware used: AS/400
Record locking in iSeries
My program takes the input as file, and process those records one by one. Here I would like to add the commitment control, if any one record fails then roll back and continue with the next record. To test this, I need to lock the record in another session and to run the program to check the ROLBK....
My program takes the input as file, and process those records one by one. Here I would like to add the commitment control, if any one record fails then roll back and continue with the next record. To test this, I need to lock the record in another session and to run the program to check the ROLBK....
AS400 - File
I wanted to do Chain Kfld File1 If Found And Fld1 = 'Y' Update File Else Perform Next Chain Operation Endif Here I wanted to perform the Chain without Locking the Record. I wanted to perform Update Operation without Performing Read/Chain again if the Condition is True. How to achieve...
I wanted to do Chain Kfld File1 If Found And Fld1 = 'Y' Update File Else Perform Next Chain Operation Endif Here I wanted to perform the Chain without Locking the Record. I wanted to perform Update Operation without Performing Read/Chain again if the Condition is True. How to achieve...
When will AS/400 record lock?
Hi Guru's , I am new to RPG . I would like to know when record will be locked ? Example-1 : PGMA, using a PF1(Physical file) in input mode , PGMB using a logical file based on PF1, in input mode. In this case record will be locked or not (using read or chain or setll operation codes) ? If I will...
Hi Guru's , I am new to RPG . I would like to know when record will be locked ? Example-1 : PGMA, using a PF1(Physical file) in input mode , PGMB using a logical file based on PF1, in input mode. In this case record will be locked or not (using read or chain or setll operation codes) ? If I will...
Records lock error
I keep getting a records lock error even after I change the setting to no records lock.
I keep getting a records lock error even after I change the setting to no records lock.
Prevent record lock scenario with AS/400 ?
Suppose 2 users are accesssing the same record in a file.User 1 tried to update the record and while doing so he did not log-off from his update screen,while the user tries to do inquiry on that same record. As a result there will be a record lock situation.How to prevent this scenario ? i need...
Suppose 2 users are accesssing the same record in a file.User 1 tried to update the record and while doing so he did not log-off from his update screen,while the user tries to do inquiry on that same record. As a result there will be a record lock situation.How to prevent this scenario ? i need...
remove a trigger file record lock
I have a CLLE trigger program that is trying to set a job environment. I am manipulating the LIBL on the fly based on the location of the order and if it's TEST or LIVE. I get the info from the trigger input parms which has the order#, location, TEST or LIVE, order# and order status which is blank...
I have a CLLE trigger program that is trying to set a job environment. I am manipulating the LIBL on the fly based on the location of the order and if it's TEST or LIVE. I get the info from the trigger input parms which has the order#, location, TEST or LIVE, order# and order status which is blank...
Mysterious AS/400 record locking
We have been experiencing a surge in the number of occurrences of record locks in our shop. We make sure we follow the rules for preventing record locks. But I have seen programs where the UNLOCK is not used even though the UPDATE operation is embedded in between If-EndIf statements. At first I...
We have been experiencing a surge in the number of occurrences of record locks in our shop. We make sure we follow the rules for preventing record locks. But I have seen programs where the UNLOCK is not used even though the UPDATE operation is embedded in between If-EndIf statements. At first I...
AS/400 iSeries Submitted Job/Batch Record Lock issue
I have looked at the other record lock questions/answers on this board but have been unable to find an answer to this problem. I am trying to capture a record lock error in a submitted program. The program is coded to capture the File Status as shown below. I have tested this same record locking...
I have looked at the other record lock questions/answers on this board but have been unable to find an answer to this problem. I am trying to capture a record lock error in a submitted program. The program is coded to capture the File Status as shown below. I have tested this same record locking...
How to explicitely Lock a record of a file in a SQLRPGLE program using embeded SQLs?
How to explicitely Lock a record of a file in a SQLRPGLE program using embeded SQLs?
How to explicitely Lock a record of a file in a SQLRPGLE program using embeded SQLs?
RPGLE Record Lock Data
I have a program that get a Record Lock. I have captured the *status, however, I need the Program & User that initially read the record first.
I have a program that get a Record Lock. I have captured the *status, however, I need the Program & User that initially read the record first.
Batch Files - Record Locks
What is the most proficient technique to eliminate the record lock errors in batch processing?
What is the most proficient technique to eliminate the record lock errors in batch processing?
PREV 1 NEXT
