1,485 pts.
 AS400
Hi.. i have 200 length of character variable(for ex Address)as a field name. I want to use this in a subfile. Is it possible? How ? yes ,by using sflfold option

Software/Hardware used:
ASKED: June 25, 2012  5:07 AM
UPDATED: June 28, 2012  10:02 AM

Answer Wiki:
I answered this earlier, but it looks like the answer did not stick. Yes it is possible Split the 200 character field into 3 fields. Define 3 lines in your subfile and display one of the 3 new fields on each of the 3 lines.
Last Wiki Answer Submitted:  June 28, 2012  10:02 am  by  ffffffffffff   15 pts.
All Answer Wiki Contributors:  ffffffffffff   15 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

This display file feature may help:
SFLFOLD (Subfile Fold) keyword for display files
You use this record-level keyword on the subfile-control record format to assign a command attention (CA) key or a command function (CF) key that the workstation user can press to truncate or fold subfile records that require more than one display line. The format of the keyword is: SFLFOLD(CAnn | CFnn)

 5,525 pts.

 

I wonder if CNTFLD and WRDWRAP work in subfiles?

 5,670 pts.

 

The SFLFOLD keyword (or SFLDROP, depending on exactly how it’s wanted to work) should work fine for output fields in a subfile. It’ll take some practice on the input side for a 200-char field. (I’m pretty sure I wouldn’t want to make it work for input in a subfile record.)

Also, this would be a candidate for a DSPSIZ( 27 132 *DS4 ) display file.

Tom

 107,985 pts.

 

I wonder if CNTFLD and WRDWRAP work in subfiles?

From the i 7.1 DDS Reference:

  • The field containing the CNTFLD keyword must be defined as an input-capable field with the data type A. It cannot be defined in a subfile.

No, they can’t.

Tom

 107,985 pts.

 

Should also add that a 200-char field can display fine in a subfile. It’s not actually necessary to break it up for separate lines. To be really useful, the SFLFOLD or SFLDROP keywords are handy.

Tom

 107,985 pts.