× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



I believe that in order to use concat with PF fields only.  You are trying
to use fields that you are creating in the LF....pretty sure that's a
no-no...

Thanks,
Tommy Holden


-----Original Message-----
From: T.Bryant@xxxxxxxxxxxxxx [mailto:T.Bryant@xxxxxxxxxxxxxx]
Sent: Thursday, January 13, 2005 7:00 PM
To: RPG programming on the AS400 / iSeries
Subject: 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

-- 
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.