1 - 12 of 12
PREVIOUS 1 NEXT
AS/400 records
Suppose i have 3 members. how to read the records from all the members without using OVRDBF
Suppose i have 3 members. how to read the records from all the members without using OVRDBF
75 pts.
How do you know if a record exists without doing a READ and CHAIN?
How do you know if a record exists without doing a READ and CHAIN? is it possible with BIF's or ? Software/Hardware used: AS/400
How do you know if a record exists without doing a READ and CHAIN? is it possible with BIF's or ? Software/Hardware used: AS/400
Avoid reading uncommitted records in AS400...
is it possible to avoid reading uncommited records in AS400?
is it possible to avoid reading uncommited records in AS400?
Sequenced Records
In one of our tables there is a sub-table that keeps records based on sequence numbers. These numbers vary from record to record. Is there any logic statements within as400 queries that will tell it to just pick the most recent and Active sub-record for each record? Any help you can give would...
In one of our tables there is a sub-table that keeps records based on sequence numbers. These numbers vary from record to record. Is there any logic statements within as400 queries that will tell it to just pick the most recent and Active sub-record for each record? Any help you can give would...
DSPFD - Asking for some explainin about a field in DSPFD output
Would you kind to explain me what reflects the field "Rejected records by key selection" ?, What could be the reason for rejecting a record in a I/O operation. Thanks.
Would you kind to explain me what reflects the field "Rejected records by key selection" ?, What could be the reason for rejecting a record in a I/O operation. Thanks.
AS/400 SQL Update for matching records
I have a file of five fields containing a number of records. I want to update the value of field 5 on a second record where the second record matches the first record for the first three fields, but where field 4 is the opposite (negative) value of field 4 on the first record.EG: Record 1 12345678,...
I have a file of five fields containing a number of records. I want to update the value of field 5 on a second record where the second record matches the first record for the first three fields, but where field 4 is the opposite (negative) value of field 4 on the first record.EG: Record 1 12345678,...
Maximum number of records that can be stored
What is the Maximum number of records that can be stored on an as400 data file.
What is the Maximum number of records that can be stored on an as400 data file.
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...
Extracting Only Numbers from String in AS400
I have thousands of address records in AS400 and need to extract only the numbers from the records. Example: 5770 South 900 West #2 and I want it to look like 57709002 Is there any way to do this in AS400? Thank you.
I have thousands of address records in AS400 and need to extract only the numbers from the records. Example: 5770 South 900 West #2 and I want it to look like 57709002 Is there any way to do this in AS400? Thank you.
must reorganize huge file over thanksgiving
We have a file with 4 million active records and 200 million deleted records , I want to reorganize on Thanksgiving. Plan is to copy out (cpyf) , clrpfm, then copy back (cpyf). My question is will the 'clrpfm' run for hours ??
We have a file with 4 million active records and 200 million deleted records , I want to reorganize on Thanksgiving. Plan is to copy out (cpyf) , clrpfm, then copy back (cpyf). My question is will the 'clrpfm' run for hours ??
1 - 12 of 12
PREVIOUS 1 NEXT
