RE: Creating Fields in a Logical Using SST and CONCAT

It looks right, however, I think you will need to define the field size(s) 
on the new fields that you're creating thru SST.

Ron Adams





"DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
01/19/2005 09:44 AM
Please respond to Midrange Systems Technical Discussion


 
        To:     "'Midrange Systems Technical Discussion'" 
<midrange-l@xxxxxxxxxxxx>
        cc: 
        Fax to: 
        Subject:        RE: Creating Fields in a Logical Using SST and CONCAT


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.


-- 
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.