Re: SQLRPGLE Format name for records

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Raul mentioned the RCDFMT clause in the CREATE TABLE - that has been 
available for quite a long time now - that's what the ACS text box fills in.

Cheers
Vern

On 2/6/2019 7:58 AM, Justin Taylor wrote:
> By default, DDL-defined tables use the table name as the record name, which RPG doesn't like.  The work-around now is the RENAME keyword on your F-spec.
>
> iACS New Table has a box for "Record format name".  You can specify the record name there in the future to avoid this issue.
>
>
>
>
> -----Original Message-----
> From: Booth Martin [mailto:booth@xxxxxxxxxxxx]
> Sent: Tuesday, February 05, 2019 8:39 PM
> To: RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
> Subject: SQLRPGLE Format name for records
>
> I created a file using SQL.  Looks right to me.  I then compiled a program with that file in an F-spec and got this:
>
>        41   dcl-f CUSPI usage(*update: *output) usropn;
>    ======> aaaaa
>    ======> bbbbb
>    *RNF2121 30 a      004100  Record format CUSPI in file CUSPI already defined; record
>                               format is ignored.
>    *RNF2109 40 b      004100  All Record Formats for externally-described file CUSPI
>                               ignored or dropped due to error; file ignored.