CODE HELP

[Ahsan]

Hello,

I need some help to validate oracle code which is implemented in the database. I am validating in SAS.

Here is the business logics which I have to tested

1)Derive True Original TCN on the CLAIM_HEADER_ALL table based on the TCN found on a table for that 'replaced TCN number'.

If the 'replaced TCN number' field is a null or ‘~’ value, then the fetched TCN becomes the True Original TCN.

2) Derive True Original TCN on the CLAIM_HEADER_ALL table based on the TCN found on a table for that 'replaced TCN number'.

If the 'replaced TCN number' field is a null or ‘~’ value, then the fetched TCN becomes the True Original TCN.

3)Derive True Original TCN on the CLAIM_HEADER_ALL table based on the TCN found on a table for that 'replaced TCN number'.

If there is a value in the 'replaced TCN number' field, then fetch the row where the TCN matches that value, up the chain, until the original TCN is found.

4)Derive True Original TCN on the CLAIM_HEADER_ALL table based on the TCN found on a table for that 'replaced TCN number'.

If the original TCN is not found, the default value of <NULL>  will be assigned.

I appreciate all the help.

Thank You

[Kurt_Bremser]

You should post the SAS code you need help with. Use the "little running man" icon for posting code.

[LinusH]

So you want to mimic the logic from an Oracle application and compare the results?
Well there is no real silver bullet, you probably need to code this in SAS. Can you be more specific on what you need help with?

[Ahsan]

Yes i would like to compare the results. I need to code this in SAS. I need help to right a code to verify the business logic.

Thank You

[Patrick · Accepted solution]

@Ahsan

If you want to verify if the business logic has been correctly implemented in Oracle, wouldn't you rather run the logic either against factored test cases or then analyse the data - source and result - and verify that the cases where data gets changed/not changed comply with the business logic? And of course: You can use SAS for this sort of analysis.

[Ahsan]

Thank you I did verify the business logic which was implemented in oracle.

Thank You

[ChrisNZ]

Please be a lot more specific in your title next time.

Any question here could have the same title, and that would be a huge pain.

Useful titles also trigger faster, better help.