DBCS "open data type" problem - time-critical situation
BACKGROUND: We use a case tool to create simple file maintenance and inquiry programs over our core software's database. The new release of our core software has added DBCS support, and has changed a lot of long fields which were formerly data type "A" to data type "O". Our case tool is recognizing...
BACKGROUND: We use a case tool to create simple file maintenance and inquiry programs over our core software's database. The new release of our core software has added DBCS support, and has changed a lot of long fields which were formerly data type "A" to data type "O". Our case tool is recognizing...
iSeries Navigator V5R3M0
Hi all, I have a DDS from a logical file on my system: A R I55120 PFILE(F55120) A K ICBOX A S ICSTAT COMP(EQ 'I') A ICTIPC COMP(EQ '1') How can I make this index...
Hi all, I have a DDS from a logical file on my system: A R I55120 PFILE(F55120) A K ICBOX A S ICSTAT COMP(EQ 'I') A ICTIPC COMP(EQ '1') How can I make this index...
What does a Logical File in AS/400 contain?
Does it contain data. If not then why do we need a member for alogical file?
Does it contain data. If not then why do we need a member for alogical file?
Rebuilding Logical Files
What does rebuilding a logical file do? Is rebuilding the same as recompiling? Or, is it a separate process How often should they be rebuilt? If you reorganize a physical file, does that rebuild the logical files as well?
What does rebuilding a logical file do? Is rebuilding the same as recompiling? Or, is it a separate process How often should they be rebuilt? If you reorganize a physical file, does that rebuild the logical files as well?
Database Issues - Trying to prove that something has to be done
Hello Everyone, I'm currently trying to prove a concept on why we should re-create our old existing PFs into SQL defined tables (Portability, performance, etc.). After taking a look at some files, I noticed an even larger problem that would ruin my chance of proving this concept. Unless some...
Hello Everyone, I'm currently trying to prove a concept on why we should re-create our old existing PFs into SQL defined tables (Portability, performance, etc.). After taking a look at some files, I noticed an even larger problem that would ruin my chance of proving this concept. Unless some...
Logical file with Substring fields
I have a Physical file field 100 characters long. But it has more than one data elements with various data types in this field. I know these sub fields’ types, starting positions and lengths. I tried to create a Logical file to describe these sub fields using “SST” function. But I got an...
I have a Physical file field 100 characters long. But it has more than one data elements with various data types in this field. I know these sub fields’ types, starting positions and lengths. I tried to create a Logical file to describe these sub fields using “SST” function. But I got an...
DB2 logical files
HI, i wanted to know if i can add a new field to a PF via a logical file. If yes give me an example. thanks....ram
HI, i wanted to know if i can add a new field to a PF via a logical file. If yes give me an example. thanks....ram
DDS with temporary name for Physical file
Good day all ! On AS400 I have a CL program that creates a temporary Physical file with variable name. File name is created with "user_id + job_name + time". How can I create a logical file, specifying in DDS for logical file that my PFILE is temporary and has variable name ? Thanks !
Good day all ! On AS400 I have a CL program that creates a temporary Physical file with variable name. File name is created with "user_id + job_name + time". How can I create a logical file, specifying in DDS for logical file that my PFILE is temporary and has variable name ? Thanks !
CL/400
I would like to convay my Thanks ReshmaG & Gilly400. My main requirement is I have a Physical file called PF1.On this there are 20-logical files are depended . I have changed some attributes on my PF1. Now I want to recompile all the Lgical Files , which are depended on PF1. I am writing code...
I would like to convay my Thanks ReshmaG & Gilly400. My main requirement is I have a Physical file called PF1.On this there are 20-logical files are depended . I have changed some attributes on my PF1. Now I want to recompile all the Lgical Files , which are depended on PF1. I am writing code...
CL/400 CRTLF
while creating an object for a logical file we will use in CL/400 CRTLF FILE(library/logical-file-member) SRCFILE(SARKNS/FIVE) But I need to give the logical-file-member name as a field like this pgm Dcl var(&var1) type(*char) len(10) chgvar var(&var1)...
while creating an object for a logical file we will use in CL/400 CRTLF FILE(library/logical-file-member) SRCFILE(SARKNS/FIVE) But I need to give the logical-file-member name as a field like this pgm Dcl var(&var1) type(*char) len(10) chgvar var(&var1)...
Position to in Single page subfile
Hi I have one PF with Policy No . , Cust. Name and both fields are key fields in PF . I want to use position to for field cust name which is the second key field in PF . So is there any way to do this without creating any Logical file ??????(in single page subfile)
Hi I have one PF with Policy No . , Cust. Name and both fields are key fields in PF . I want to use position to for field cust name which is the second key field in PF . So is there any way to do this without creating any Logical file ??????(in single page subfile)
Merge two Physical Files using Logical File
I have multiple Physical files (Trans2006, Trans2007, Trans2008, etc…) with same record layout with the yearly transactions on my iSeries. I want to merge these files (for temporary period). Is it possible to create a Logical file? If so please help me.
I have multiple Physical files (Trans2006, Trans2007, Trans2008, etc…) with same record layout with the yearly transactions on my iSeries. I want to merge these files (for temporary period). Is it possible to create a Logical file? If so please help me.
Selecting Fields in Logical File
If you would make a logical file and select only fields you need from a physical file that has 500,000 records it, Would it cause a performance issue when a record is updated in the PF?
If you would make a logical file and select only fields you need from a physical file that has 500,000 records it, Would it cause a performance issue when a record is updated in the PF?
Override to a Logical File
hi, I am trying to create an override to a logical file. I have a PF File A which has a logical AL1. My CL program can run in a build/copy mode where Build would just build the work file and copy would build & copy the workfile etc. The CL has an override to A called B and then calls the RPGLE...
hi, I am trying to create an override to a logical file. I have a PF File A which has a logical AL1. My CL program can run in a build/copy mode where Build would just build the work file and copy would build & copy the workfile etc. The CL has an override to A called B and then calls the RPGLE...
join logical files
Hi, Can i join one physical file's 2nd member to another physical file's 5th member? Is it possible? If so how? can anybody help me out?...thanks
Hi, Can i join one physical file's 2nd member to another physical file's 5th member? Is it possible? If so how? can anybody help me out?...thanks
AS/400: Unique records in file
hi all, i have a problem , suppose i have a physical file which has multiple occurrences of fld1 , now i need to access that in distinct (one data single time) order. so i created a logical file with UNIQUE keyword . but when i make query on this LF then msg comes that no member found. and a dump...
hi all, i have a problem , suppose i have a physical file which has multiple occurrences of fld1 , now i need to access that in distinct (one data single time) order. so i created a logical file with UNIQUE keyword . but when i make query on this LF then msg comes that no member found. and a dump...
FORMAT keyword in non-join logical files -- what and how?
How do I use FORMAT keyword in a non-join logical file? What is the main purpose of that keyword?
How do I use FORMAT keyword in a non-join logical file? What is the main purpose of that keyword?
Logical file update during FTP
When are the associated logical files updated when a physical file is receiving data via FTP?
When are the associated logical files updated when a physical file is receiving data via FTP?
Can an AS/400 COBOL pgm have a logical & physical file open and referenced at the same time
In the COBOL program, using calls to IO modules, can the same file be opened with a physical fiile definition and a logical file definition at the same time? Or can it be opened as a physical file and then read by logical key and updated with physical key? Or does the file have to be opened as...
In the COBOL program, using calls to IO modules, can the same file be opened with a physical fiile definition and a logical file definition at the same time? Or can it be opened as a physical file and then read by logical key and updated with physical key? Or does the file have to be opened as...


