Re: Creating Fields in a Logical Using SST and CONCAT

Ted, I think you have to include the orignal fields you wish to CONCAT or 
SST in the logical as well.
Try adding C3AKCD, C3ALCD, C3AMCD and ACALCD to the logical.

>Can someone help me out?  Is my syntax correct or is this impossible?
> 
>ACAKCD, ACALCD and ACAMCD all exist, 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 


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Troy Bryant 
Analyst Programmer
Patrick Autocare.
Phone: +61 03 9926 9913
Fax: +61 03 9926 9977
Mobile: +61 0408 397 333
T.Bryant@xxxxxxxxxxxxxx