How to write subfile and search record without physical file key?

[PeonyWonderWhy]

Hi seniors,

I have a physical file without key and have to display in subfile in one category only.
I cannot use key to chain the physical file and look for record. How can I do that?
Firstly, user key in input 'A' then only records of category 'A' will be displayed....

[Poch@hont@s]

Hi Every1,

I have a flat file and a physical file.We need to write all the records from PF to the flat file but length shud be variable.
For ex -
Physical file -
Name Designation Age
AAAA XYZZ 28
BB CC 9
...

[ramin]

Hi

I have a physical file with three fields (say f1 f2 and f3). I am developing a program that should delete some of the records in this file depending on the value of f2 each time the program is run. Not sure how to do this.

Any advice?

Many thanks in...

[xo0627]

when i am running STRSQL to get records counts on our system, i noticed that the SQL running time with PFs is much shorter than LFs. This puzzles
me a lot. Could any of the experts help me to answer this question, thanks in advance.

waiting online

Xo

[Lenny2113]

Hi all.

We are using iSeries and only now converting from System36 to ILE. Most applications are written in COBOL.
All data access is done via native "Read / Write".
I am considering switching to Databases and SQL as opposed to PF and LF.

I came...