MVSFORUMS.com

[sendhil]

Hi,
We are trying to generate update SQLs based on a sql condition.

SELECT

'UPDATE TABLEA',
'SET COL1 = ''X''',
'WHERE COL2=',

COL2,

';'
'COMMIT;'
FROM TABLEA
WHERE COL3= 'xxxxxx' ;

We got the output of this select statement as follows.


UPDATE TABLEA SET COL1 = 'X' WHERE COL2= COL2value1; COMMIT

UPDATE TABLEA SET COL1 = 'X' WHERE COL2= COL2value2; COMMIT

UPDATE TABLEA SET COL1 = 'X' WHERE COL2= COL2value3; COMMIT

UPDATE TABLEA SET COL1 = 'X' WHERE COL2= COL2value4; COMMIT

etc...

We need a colon before and after the COL2value* so that we can rerun those update statements.(These are the variables that filled up the places as a result of the select statement)

I am not sure how to achieve this.

[sendhil]

Sorry ,

We need a apostrophe before and after the COL2value* so that we can rerun those update statements.(These are the variables that filled up the places as a result of the select statement)

I am not sure how to achieve this.

[kolusu]

sendhil,

Try this

[sendhil]

Kolusu,
I have tried the above mentioned query .
The problem was i got extra spaces when i did that.
The output looked as below.

[kolusu]

sendhil,

That is only in SPUFI Display. Spufi automatically puts a space after each column selected. Try unload using the same query in batch and you will Not see the extra spaces.

Hope this helps...

Cheers

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