RE: Creating Fields in a Logical Using SST and CONCAT

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

I don't think DDS will allow this.  This could be done part-way in SQL, by
creating a view that transforms the data to your new format.  However, the
resulting LF will not have a key, so using this directly in an RPG
application may not be realistic.  Embedded SQL would probably be the most
robust choice for this sort of thing.

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: Ted J Barry [mailto:tjbarry@xxxxxxxxxxxxx]
Sent: Tuesday, January 18, 2005 6:55 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Creating Fields in a Logical Using SST and CONCAT



Can someone help me out?  Is my syntax correct or is this impossible?

ACAKCD, ACALCD and ACAMCD all exist in the physical, the rest I'm trying to
create in 
this logical file.

0022.00 A            C3SAPN             I      CONCAT(C3AKCD C3ALCD 
C3AMCD)    
0023.00 A                                      COLHDG('Assessors 
Parcel' 'Numbe
0024.00 A                                      TEXT('Assessors Parcel 
Number') 
0025.00 A            C3AKCD             I      SST(ACAKCD 1 3)

0026.00 A            C3ALCD             I      SST(ACALCD 1 3)

0027.00 A            C3AMCD             I      SST(ACAMCD 1 3)

0028.00 A          K C3SAPN                      



-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.