RPG/400 !!

Hi,

1)      I tried an embedded SQL program, but it was not working as I intended it
to. The code I wrote looked somewhat like (program is of the type SQLRPG) :

C/EXEC SQL
C+ INSERT/UPDATE/DELETE INTO/FROM TABLE-NAME
C+.......................
C/END-EXEC

Now the problem is that the program is compiling properly, but it is not
updating, inserting or deleting from the particular table. Do I have to
change the compiler options somewhere ? 

2) This is a Y2K question, what are the various steps right from doing the
impact analysis to doing the system testing on AS/400 and also what are the
tools that are used for the same. Can I get any documentation about the
procedure and the working of the tools on the web somewhere ?

3) When I issue a DSPLY command, I get the display on the workstation, but
the same display carries on for the next DSPLY command that I issue. Is
there any way I can clear this screen before the next DSPLY command is
issued ?

/******************************************************************/
                          HAVE A NICE DAY !!!!                          

                        * * * * * * * * * * * * * * * * * 
                        * Pavan Krishnamurthy,          *
                        * No 271,Sri Ganesha Complex,   *
                        * Hosur Main Road,Madivala,     *
                        * Bangalore - 560068.           *
                        * Ph 5539134 Extn 134           *
                        *    5539138      136           * 
                        *                 148           *
                        *                               *
                        * Res : 080-333-6397            *
                        * * * * * * * * * * * * * * * * *

/******************************************************************/
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *