How to created output metadata?

CloverDX Platform
1

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.

2

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,

3

yes i did the same thing what you have mention.
I am using the trial version of CLover ETL designer is it because of that?

4

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;

5

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,