View logical file as400

Lines 2 — 4 shows how I can rename and change the data type of a field. PFLD6 is defined date field in the Physical file. When you prompt line 4 the editor displays is as:. Now will I get data when this Logical file is used for an input operation.

But I cannot update the field on an output operation. Don not worry if you are thinking how to flag the field as input and output, just leave it blank. So what happens to the fourth byte? I can also substring a field from the Physical file into fields in the Logical. I show the two ways I have commonly seen it below. The SST , substting, function has two mandatory parameters, Phyiscal file field name and starting position, and an optional, number of positions.

This will help if you are trying to an order by on your view, but will not really help if you have a performance issue. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Can i create "logical files" in AS using sql? Ask Question. Asked 10 years, 11 months ago.

Active 9 years, 10 months ago. Viewed 11k times. I need to create as "logical files". Is it possible to create "logical files" with sql statements? If yes I would appreciate a sample statement. Improve this question. Aba Dov Aba Dov 4 4 gold badges 12 12 silver badges 20 20 bronze badges. Tracy Probst Hi, My original purpose was to create a materialized query containing a select on multiple tables for performance. I think you may be a bit stuck on the nomenclature here.

Sysfiles has a lot of interesting information, however not what I was looking for. Thank you again. If your partition is version 7. If you are on an older release then this View is not available to you. I have used that before to recreate the source of a PRTF.

Had high hopes that I could get to of records. Is there another way to get to that with SQL. See here. To prevent "comment spam" all comments are moderated. Learn about this website's comments policy here. Some people have reported that they cannot post a comment using certain computers and browsers. If this is you feel free to use the Contact Form to send me the comment and I will post it for you, please include the title of the post so I know which one to post the comment to.

Line 6: And data files, not source files. Bill Wragg. Spud Work. Graeme Dobie. Paul Nicolay. Not that simple, I'm afraid.