Re: SQLRPGLE & variable path

[Charles Wilt <charles.wilt@xxxxxxxxx>]

IFS paths or filenames can contain spaces...

try using a varchar() variable instead of fixed length.

Charles

On Wed, Jun 23, 2021 at 9:59 AM <SReeves@xxxxxxxxxxxxxxxxxx> wrote:

> Hi,
> I'm testing out using SQLRPGLE which I haven't really touched before.
> The command I'm running is
>    EXEC SQL select NETSERVER_SESSION into :pHold from
>           table(IFS_OBJECT_LOCK_INFO(Path_NAME => '/home/IBMIFS/file.csv'
> ));
>
> Which works as above with the hard-coded path.
>
> However when I pull out the hard-coded path and pass it as a variable, the
> command doesn't return a result.  In debug the variable/path returns
> exactly as it is shown in the first test.  Can a variable not be used?
>
>         pPath = '/home/IBMIFS/file.csv';   //first test
>         pPath = '''/home/IBMIFS/file.csv'''; //second test
>     EXEC SQL select NETSERVER_SESSION into :pHold from
>           table(IFS_OBJECT_LOCK_INFO(Path_NAME => :pPath));
>
> Thanks!
>
>
> --
> 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.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com