Creating a field in AS/400 physical file

815 pts.
Tags:
AS/400
Physical File
Hi,
How to create a field in Physical file with (123 456 789). Tried with EDTWRD, unable to specify spaces in between.
Thanks


Software/Hardware used:
EDTWRD

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi Habbie,

You can’t use EDTWRD keyword in Physical File.
You can create field as 9P 0 (9A if character) and you can use EDTWRD keyword on Display File/Printer File while you are displaying/printing data.
Pradeep.

Discuss This Question: 7  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • ToddN2000
    The only way you can get spaces in a field in your PF is if it's defined as an alpha. If you want to break it out into 3 separate fields, if it is stored an a numeric value, move it to a data structure or alpha then sub sting out your positions. How is this field defined in your PF.
    9,700 pointsBadges:
    report
  • WoodEngineer
    I believe your life will be simpler if the number is stored as a 9,0 field and edited when displayed or printed.
    We have a payroll package which stores the employee number in a 10A field, right justified.  It is a royal pain.
    6,435 pointsBadges:
    report
  • philpl1jb
    You could make a PF like the one this.  The default display for this field would be like an SSN.
     A	R TESTSSNR
    A	TESTSSNF	9S 0	EDTWRD('0  -  -    ')	
    49,720 pointsBadges:
    report
  • philpl1jb
    Sorry space
    A	R TESTSSNR
    A	TESTSSNF	9S 0	EDTWRD('0	-	-	')
    A	TESTSSNS	9S 0	EDTWRD('0	&	&	')
    49,720 pointsBadges:
    report
  • philpl1jb
    Had a few formating errors .. here is the field with spaces in the default format.
    A	R TESTSSNR
    A	TESTSSNS	9S 0	EDTWRD('0  &   &    ')
    49,720 pointsBadges:
    report
  • hunshabbir7
    I'll support Todd's recommendations. 
    1,070 pointsBadges:
    report
  • HABBIE
    Thanks Philp for your clear description
    815 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following