Sql Tool yes4sql

[Former Member]

Hi all,

can someone explain me how these SQL Tool "yes4sql" is to be set up. I was able to activate the

programm, but how do i set up the screen which ist provided with the tool/programm.

I don't know nothing about screens.

Thanks in advance.

Regards,

Ali

[Former Member]

Hi,

Refer

https://forums.sdn.sap.com/click.jspa?searchID=10906586&messageID=2924192

Regards

[Former Member]

Hi,

1.try ST05 - Is the most useful if you want to track time taken for execution of each of the sections.

http://help.sap.com/saphelp_47x200/helpdata/en/f2/31adaa810c11d288ec0000e8200722/frameset.htm

2.Use ST05 for the stastment, it is better write 2 programs for different different select statmnet and look at the time taken by the Select statment

Regards,

SHIVA(reward if helpful).

[Former Member]

Thanks for all of your help but ST05 is not exactly what I am looking for. What i want ist to get

this tool running, and executing my statement with viewing the results. Programm is working but the screen not.

Need help to set up the screen.

Thanks in advance for your answers.

Best Regards,

Ali

[Former Member]

Hi,

In SE51, display the attribute page of the screen, in the "Utilities" menu there should be a "Download/upload" entry, here you can import your screen

Regards

Kiran

[Former Member]

Hi Kiran many thanks for your answer.

But when i try to upload the *.txt file which suppose to conzain the screen, i get the message

"File does not Contain a Dynpro"

This is the content of the screen file :

****************************************************************

• SCREEN 100

****************************************************************

%_DYNPRO

YES4SQL

0100

620

40

%_HEADER

YES4SQL 0100 0100 1 54192 36 0 0 27120 0G E 20040930020857

%_DESCRIPTION

ScreenYes4SQL

%_FIELDS

%#AUTOTEXT001 0 CHAR 9 00 00 00 30 00 1 3 0 0 0 0 0 0 Row Count X

ROWS X INT4 6 80 00 80 00 00 1 13 0 0 0 0 0 0 ______

%#AUTOTEXT002 0 CHAR 8 00 00 00 30 00 1 22 0 0 0 0 0 0 Open SQL

ISOPEN C CHAR 1 80 00 80 00 00 1 31 0 0 0 0 C 0 0 101

%#AUTOTEXT003 0 CHAR 20 00 00 00 30 00 1 36 0 0 0 0 0 0 Untick if Native SQL

MYEDIT 74 00 00 00 30 00 2 3 0 0 0 20 U 1 1 102

G_OK_CODE CHAR 20 80 10 00 00 00 255 1 O 0 0 0 0 0 0 ____________________

%_FLOWLOGIC

PROCESS BEFORE OUTPUT.

MODULE PBO.

*

PROCESS AFTER INPUT.

MODULE PAI.

can you help please ?

Regrads,

Ali

[Former Member]

I am the author of YES4SQL

Please download latest ZIP from

http://ojnc.byethost11.com/Yes4SQL.zip

Those still in doubt or needing clarifications can contact me via

http://ojnc.byethost11.com

Regards & "Happy Native SQL"

-jnc