MVSFORUMS.com

[YVRAMJ]

Hi,

How Can I insert into a table values for some columns from one table and
rest with values option ?

This query is not a working one. I want to know if there is any other way.

INSERT INTO ENGR_WO_APPROVER

(APPROVER, EMP_LAST_NAME, EMP_FIRST_NAME,
UPDATE_CLOCK_NO, UPDATE_PROGRAM, UPDATE_TIMESTAMP)

SELECT EMPLOYEE_NUMBER, EMP_LAST_NAME, EMP_FIRST_NAME
FROM TXDBT01.LDAP_DIRECTORY WHERE EMPLOYEE_NUMBER = 'zzzzzzzz'

and

VALUES ('OUTX625','CEDSF01C',CURRENT TIMESTAMP)


Thanks,
Ram.

[SureshKumar]

Try this

INSERT INTO ENGR_WO_APPROVER

(APPROVER, EMP_LAST_NAME, EMP_FIRST_NAME,
UPDATE_CLOCK_NO, UPDATE_PROGRAM, UPDATE_TIMESTAMP)

(SELECT EMPLOYEE_NUMBER, EMP_LAST_NAME, EMP_FIRST_NAME,'OUTX625','CEDSF01C',CURRENT TIMESTAMP
FROM TXDBT01.LDAP_DIRECTORY WHERE EMPLOYEE_NUMBER = 'zzzzzzzz' )

[YVRAMJ]

Hi,

I am sorry. I forgot to mention about the query. I am storing this query in a DB2 table so that my stored procedure can read it and prepares and then executes. In this process I will be passing the last 3 columns as parameters. So I can't code them as constats except current timestamp.
sorry for the confusion.

Thanks,
Ram.

[YVRAMJ]

Hi,

I got the solution. I passed the variables as parameters and it worked fine.

Thanks,
Ram.