brainchime.com Latest Questions

Admin
Asked: 2024-10-05T19:37:56+05:30 In:

Can we provide spaces between colon and host variable in embedded SQL in IBM i?

I have gone across many example program’s source code and I observed that there is no space between the colon (:) and the host variable in embedded SQL within RPG programs on IBM i.

I am curious whether we can provide space between the colon and variable name when using the host variable in SQL queries in the embedded SQL programming in RPG/COBOL programs.
However, I did not get a chance to try this on any IBM i machine.

db2embedded-sqlrpg

Related Questions

Leave an answer

Leave an answer

Browse
Browse

Choose from here the video type.

Put Video ID here: https://www.youtube.com/watch?v=sdUUx5FdySs Ex: "sdUUx5FdySs".

1 Answer

  1. Admin

    It works. You can provide space between the colon(:) and the host variable  used in embedded SQL in the RPG program.
    Refer to the below snippet code where we have space in between the colon(:) and host variable l_name.

         D l_name          S             10A       
      /Free                                    
        clear l_name;                          
        exec sql                               
        select name into : l_name              
        from clpf1 where rollno = 26;             
        *inlr  = *on;                          
      /End-Free