When using the SQL call builder in WebSphere Portlet Factory, you can either enter the SQL directly into the SQL field, or select an existing script.
I recommend that you do your SQL in separate text files, and then import them. That way can more easily test the SQL using the Data perspective in RAD. If you do prefer to just past the SQL code in, then remember that you cannot begin the SQL with comments! This will prevent the builder from generating the schema for the SQL call. Remove all your comment code before you click 'Apply' to the builder.
Don't forget to version your application! If you are not doing this then you deserve forty lashes. You can start with a simple, open source system such as Subversion.
Labels: portlet factory