Logical file with Substring fields

50 pts.
Tags:
DDS
Logical Files
PF
SST
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 error for numeric field. 1400 PREMTOT 9S 2I SST(BATCHDATA 22 9) * CPD7926-********** . * CPD7554-* . ID Severity Number * CPD7554 20 2 Message . . . . : Keyword not valid with data type or keyboard shift value. * CPD7926 30 2 Message . . . . : Field not found. Please help me to define these numeric fields. Thank you, Hewage

Answer Wiki

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

I think the only kind of field you can create through the substri

///////////////
How are you going to use this file?
Could you structure it in RPGLE
Could you create a new PF and copy the data?
Phil

Discuss This Question: 3  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
  • nhewage
    Thanks Tod, Yes, It works for Alpha fields. But I need to define it as Numeric filed with two decimals. Is it possible?
    50 pointsBadges:
    report
  • Gilly400
    Hi, I would suggest you create a Physical with the fields defined in it and use that as an external data structure. Read your flat file into the DS which will then populate your fields. Regards, Martin Gilbert.
    23,730 pointsBadges:
    report
  • nhewage
    Currently we used DS method. We decided not use COPY to new PF file method due to the file size and multiple users. So I wish I can create a Logical file. Thanks Nihal
    50 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