topic Re: Sql Tool yes4sql in Application Development and Automation Discussions

Sql Tool yes4sql

Former Member — Fri, 18 Apr 2008 11:59:20 GMT

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

Re: Sql Tool yes4sql

Former Member — Fri, 18 Apr 2008 12:02:54 GMT

Hi,

Refer

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

Regards

Re: Sql Tool yes4sql

Former Member — Fri, 18 Apr 2008 12:03:06 GMT

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).

Re: Sql Tool yes4sql

Former Member — Fri, 18 Apr 2008 12:10:05 GMT

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

Re: Sql Tool yes4sql

Former Member — Fri, 18 Apr 2008 12:15:38 GMT

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

Re: Sql Tool yes4sql

Former Member — Fri, 18 Apr 2008 12:27:09 GMT

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

%_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

Re: Sql Tool yes4sql

Former Member — Wed, 18 Nov 2009 10:38:34 GMT

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