Can host variables in IBM i SQL have spaces?

Question

Is it possible to provide space between colon and variable name when using host variables in RPG/COBOL embedded SQL.

I have never encountered a space in any example programs.

I do not have the relevant language reference manual to hand but that is where you should look. How to define a host variable will be defined in that manual (SQL Language Reference). — NicC, Jul 19 '18 at 13:11

score 3 · Accepted Answer · answered Jul 19 '18 at 13:14

3

It's not really that hard to test...

Yes.

answered Jul 19 '18 at 13:14

Charles

21,637
1
20
44

score 1 · Answer 2 · answered Aug 30 '18 at 15:45

1

Yes. The variable itself cannot though, for obvious reasons. Also keep in mind, when embedding variables, you cannot do so for a multiple value string in an IN() operator. It doesn't parse properly.

answered Aug 30 '18 at 15:45

SovietFrontier

2,047
1
15
33

Can host variables in IBM i SQL have spaces?

2 Answers2