MVSFORUMS.com

[s_shivaraj]

Hi FOLKS,

In one of the forum, i saw this question :

> I want to use a variable with a value in SPUFI which I will use in sql
> query. For ex:-

> set nam='mvs';
> select * from table_nam where name=nam;

I know we can do this SQL ( Orcale ), but is it possible in SPUFI , if possible how and if not why ?


Cheers
Sivaraj S

[kolusu]

Sivaraj,

You cannot assign host variables in spufi. When you a run a sql query in spufi, you are actually running a dynamic sql. Spufi prepares the statement and then execuetes it for you. So you really cannot assign host variables in spufi. But you can do that in an application program.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[s_shivaraj]

Thanks Kolusu for your Information
_________________
Cheers
Sivaraj S

'Technical Skill is the Master of complexity, while Creativity is the Master of Simplicity'