How to test SQVI queries

[Former Member]

Hello Guys,

I have bunch of SQVI queries created in production system whcih are assigned to the z transaction codes.

My question is how can we test them in Quality system?

( We are doing upgrade so these z transactions with SQVI queries needs to be tested )

Thanks!

[Former Member]

No way except to convert them into infoset queries, but for which they need to be in development system first. SQVI queries are local to the system and you cannot test them in Q unless you recreate them in Q or create programs copying the generated code.

[Former Member]

Hi ,

first you create query is in DEV and genarate a program and copy that program into a custom program then move it it Quality system. so that you can test the same in QA also you can move later to production system.

thanks,

Venkat

[Former Member]

Hi ,

first you create query is in DEV and genarate a program and copy that program into a custom program then move it it Quality system. so that you can test the same in QA also you can move later to production system.

thanks,

Venkat

[Former Member]

Hi Owais Ahmed,

This is very simple.

First you need to convert the Quick View queries to Infoset Queries.

Then you download them (SQ02) (the converted infoset queries) from production environment to your presentation server.

Then you upload them (SQ02) to your Quality / Staging environment.

Whola. ...there you have it. You can test it.

Revert, If you need detailed steps .

Regards,

Subin John.

Edited by: subin john on Sep 29, 2009 6:21 PM

[Former Member]

Hi Owais Ahmed,

This is very simple.

First you need to convert the Quick View queries to Infoset Queries.

Then you download them (SQ02) (the converted infoset queries) from production environment to your presentation server.

Then you upload them (SQ02) to your Quality / Staging environment.

Whola. ...there you have it. You can test it.

Revert, If you need detailed steps .

Regards,

Subin John.