It is also possible to run the SQL scripts from the b>RUN SQL SCRIPTING facility in Client Access or (even better) ACS (Access Client Solution). The SQL Scripts containing the source code for the stored procedures, can be run with the RUNSQLSTM command: RUNSQLSTM SRCFILE(YOURSCHEMA/QSQLSRC) SQL Stored Procedures and User Defined Functions If you create a binder directory with the name HSBNDDIR in your schema and add the SNDMSG service program to this binder directory, the RPG programs can be compiled with the the CRTSQLRPGI command. Delete the module after having successfully created the service program.Create the service Program with the CRTSRVPGM CRTSRVPGM SRVPGM(YOURSCHEMA/SNDMSG).Create a module with the same name using the CRTRPGMOD CL command.Minimum IBM i Release: 7.2 TR7 (or 7.3 TR3) Compile SNDMSG Service Program In addition, she is co-author of two IBM Redbooks and also the author of several articles and papers focusing on RPG and SQL for a German publisher, IBM DeveloperWorks and IT Jungle. Since 2002 she has frequently spoken at the COMMON User Groups and other IBM i and Power Conferences in Germany, other European Countries, USA and Canada.
She also works in consulting with regard to modernizaing legacy IBM i applications IBM i as well as in education as a trainer for RPG and SQL developers. Character and XML data (data type XML) directly to the IFS with SQL Descriptionįor writing any character data to the IFSįor writing XML data (Data type XML) to the IFSįor writing any character data into the IFS.įor writing XML data (data type XML) into the IFS.īirgitta Hauser is Software and Database Engineer, focusing on RPG, SQL and Web development on IBM i at Toolmaker Advanced Efficiency GmbH in Germany.
0 kommentar(er)
