Hi,
I want to create output metdata. But some how i m not able to do that.
I want to insert the data into table and after that want retrieve few columns from the same.
INSERT INTO BRANCH_VERSION (BRANCH, BASE_CODE, VERSION_NUMBER, BUILD_NUMBER, PRICE_GROUP, COUNTRY_GROUP, VERSION_SHORT_DESC, VERSION_DESC, EFF_START, EFF_END, BASE_CODE_IND, CURRENCY, LANGUAGE)
VALUES ($BRANCH, $BASE_CODE, $VERSION_NUMBER, $BUILD_NUMBER, $PRICE_GROUP, $COUNTRY_GROUP, $VERSION_SHORT_DESC, $VERSION_DESC, $EFF_START, $EFF_END, $BASE_CODE_IND, $CURRENCY, $LANGUAGE)
RETURNING $id:=AUTO_GENERATED,$BUILD_NUMBER:=$BUILD_NUMBER;
i found the sample to do this but when i tried the same way it was not working.
also find the screenshot attached. where i dont see any output metadat.
I want to create output metdata. But some how i m not able to do that.
I want to insert the data into table and after that want retrieve few columns from the same.
INSERT INTO BRANCH_VERSION (BRANCH, BASE_CODE, VERSION_NUMBER, BUILD_NUMBER, PRICE_GROUP, COUNTRY_GROUP, VERSION_SHORT_DESC, VERSION_DESC, EFF_START, EFF_END, BASE_CODE_IND, CURRENCY, LANGUAGE)
VALUES ($BRANCH, $BASE_CODE, $VERSION_NUMBER, $BUILD_NUMBER, $PRICE_GROUP, $COUNTRY_GROUP, $VERSION_SHORT_DESC, $VERSION_DESC, $EFF_START, $EFF_END, $BASE_CODE_IND, $CURRENCY, $LANGUAGE)
RETURNING $id:=AUTO_GENERATED,$BUILD_NUMBER:=$BUILD_NUMBER;
i found the sample to do this but when i tried the same way it was not working.
also find the screenshot attached. where i dont see any output metadat.
-
Hi itstushar,
I am not sure I understand your question. From my point of view, it is more convinient to create metadata from database and then send a query in the graph. Did you try this approach?
http://doc.cloveretl.com/documentation/ ... abase.html
metadata.png
Kind regards, -
i wanted to have insert data in the DB and then read few fields from the same DB row.
can we extract input and output metadata at the same time using retruning key mentioned below. I tried below approach but it didnt work. so please suggest the approach on how to achieve it.
INSERT INTO BRANCH_VERSION (BRANCH, BASE_CODE, VERSION_NUMBER, BUILD_NUMBER, PRICE_GROUP, COUNTRY_GROUP, VERSION_SHORT_DESC, VERSION_DESC, EFF_START, EFF_END, BASE_CODE_IND, CURRENCY, LANGUAGE)
VALUES ($BRANCH, $BASE_CODE, $VERSION_NUMBER, $BUILD_NUMBER, $PRICE_GROUP, $COUNTRY_GROUP, $VERSION_SHORT_DESC, $VERSION_DESC, $EFF_START, $EFF_END, $BASE_CODE_IND, $CURRENCY, $LANGUAGE)
RETURNING $id:=AUTO_GENERATED,$BUILD_NUMBER:=$BUILD_NUMBER; -
Dear itstushar,
Please use SELECT query to generate your metadata, not INSERT. You can even generate the whole query using "Generate query" button. But I am affraid you have the wrong window on your screenshot. The proper window for metadata extraction looks similar but not the same. Your window looks like SQL query property in some component but you should not create metadata in a component. You should use Metadata extraction from Outline pane as you can see on my screenshot and in the link I posted.
And regarding your question, trial version of Desginer does not have any influence in your situation.
Kind regards,
Please sign in to leave a comment.
Comments 4