Re: ds and sql insert

[Daniel Gross <daniel@xxxxxxxx>]

Looks legit for me - what does the (pre)compiler say? SQL0312?

Sometimes it’s just the sequence of the definitions or something strange - whenever I get SQL0312 I think “come on - you can’t be serious”. 

Regards 
Daniel


> Am 01.05.2023 um 20:40 schrieb Jay Vaughn <jeffersonvaughn@xxxxxxxxx>:
>
> 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.