2 weeks ago
Dear Experts,
I want to display current date in one of the field routine of the BW transformations. I wrote the below code in field routine and getting the error message as
Incorrect syntax error near :CUR_DATE.
outtab = select (select current_date into CUR_DATE from dummy AS "CUR_DATE"),
"RECORD",
"SQL__PROCEDURE__SOURCE__RECORD"
from :INTAB;
Please guide me how to solve this error.
Thanks.
Hi,
try this without INTO and the alias is related to the column not to the table (dummy):
outtab =
select (select current_date from dummy) AS "CUR_DATE",
"RECORD",
"SQL__PROCEDURE__SOURCE__RECORD"
from :INTAB;
Torsten
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
71 | |
9 | |
8 | |
6 | |
6 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.