Re: ds and sql insert

[Raul Alberto Jager Weiler <raul.jager@xxxxxxxxx>]

Try to put the DS before the Dcl_proc

On Mon, May 1, 2023 at 2:40 PM Jay Vaughn <jeffersonvaughn@xxxxxxxxx> wrote:

> is there a reason sql precompiler is blocking this?
> I was actually under the impression you could not use a LIKE or LIKEDS host
> variable in an sql, but then I saw this..
>
> https://www.rpgpgm.com/2018/01/using-rpg-data-structures-with-sql.html
>
> and my code is...
>
>
> dcl-proc insertIt;
>   dcl-pi *n ind;
>     i_rowDetail       likeDS(ds_myFile)       value;
>     o_msgText       char(80);
>   end-pi
>
> dcl-ds ds_myFile     extname('MYFILE')    qualified;
> end-ds;
> dcl-ds ds_myFile2   likeDs(ds_myFile)  inz;
>
> exec sql
>   insert into myFile3
>                    values(:ds_myFile2);
>
> return *on
>
> end-proc
>
>
> tia
> jay
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.