Midrange News for the IBM i Community


Posted by: Chris Proctor
Programmer Analyst
Columbia Sports Company
Portland, OR
DCL-DS for database fields to an array?
has no ratings.
Published: 26 Aug 2015
Revised: 26 Aug 2015 - 3019 days ago
Last viewed on: 30 Nov 2023 (3909 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

DCL-DS for database fields to an array? Published by: Chris Proctor on 26 Aug 2015 view comments(2)

I'm just starting to use the freeform for F, D and P specs and I had a question. I have an input file that has 7 identical numeric fields that I would like to assign to an array to simplify processing, but I'm not sure how/if I can do that freeform. If you have a solution, I'd appreciate it. I really like the freeform.

Thanks!

Chris

Return to midrangenews.com home page.
Sort Ascend | Descend

COMMENTS

(Sign in to Post a Comment)
Posted by: bobcozzi
Site Admin ****
Chicagoland
www.cozTools.com/qryfile
Comment on: DCL-DS for database fields to an array?
Posted: 8 years 3 months 6 days 8 hours 18 minutes ago

If memory serves, the OVERLAY keyword is replaced with the POS keyword. So doing an array, probably need to look at the documentation for POS with DCL-SUBF.

Posted by: chrisp
Premium member *
Portland, OR
Comment on: DCL-DS for database fields to an array?
Posted: 8 years 3 months 6 days 8 hours 7 minutes ago

Thanks, Bob. I'll check that out.