Home > IT Answers > AS/400 > Creating logical file keyed by partial field.
Dantheband
0 pts.
 Creating logical file keyed by partial field.
RPG
We have a need to create a logical file based on a substring of a particular field as opposed to the entire field. I know it can be done using 'CREATE VIEW' within SQL. Is there a way to do it within DDS specs? I appreciate your help!

Software/Hardware used:
ASKED: October 15, 2004  8:54 AM
UPDATED: October 15, 2004  9:54 AM
RELATED QUESTIONS
Answer Wiki:
The SUBSTRING IN DDS is SST and it is used like this: USR1 SST(USRCM 1 1) USRCM and, along with substring, you can also use CONCATENATE: CMDATE CONCAT(YRCCM MNCCM DYCCM) YRCCM MNCCM DYCCM Both of these resulting fields are available for use as the key fields in logical files. Hope this answers it for you. these
Last Wiki Answer Submitted:  October 15, 2004  9:35 am  by  LFiato   200 pts.
All Answer Wiki Contributors:  LFiato   200 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Use the SST keyword in DDS. Duh!
Thank you very much LFiato!!!

Dantheband
 0 pts.