System variable types in a sqlprocedure

[AntonPierhagen]

I have created a table in a HDBCDS file;

In a store procedure i would like to use this entity and write the following code;

But when i try to build the procedure, it will return with an error.

THere is a mismatch with HEADER.PURCHASEID and the variable AP_ID.

The first one is of the type CORE/EPM.BusinessKey. My own declared variable, AP_ID is of the type BIGINT.

So in my procedure file, i also would like to address the CORE library , so i can set my variable AP_ID at the right

one.

But i cannot find anything who it is done.

Or, how can i know how the CORE data type BusinessKey is build up?

Kindly here from you!

Anton Pierhagen

[lbreddemann]

Without the actual error message we have to guess here. My guess would be that the problem is that the SELECT does not provide the correct column names for the table variable.

PURCHASEID simply is not the same as AP_ID.

That should be fixable by simply using column aliases.