Re: What is wrong?

On Jan 24, 12:43 pm, CRPence <crpe...@xxxxxxxxxxxx> wrote:
   The /EXEC SQL and /END-EXEC are not RPG, they are tags to denote what
a pre-compiler is supposed to convert into RPG.  They are directives to
the SQL precompiler, that the upcoming and prior source is to be
interpreted as embedded SQL source, rather than as RPG source.  Use
CRTSQLRPGI OBJTYPE(*MODULE) to create an SQLRPG module.

The original poster isn't having trouble with the embedded SQL. His
problem is ILE and RPGLE concepts: he has a subprocedure in his code,
and no way of calling it. Look again.

[...]
.

Relevant Pages

  • Re: object databases
    ... embedded SQL products, like Pro*C. ... Contact, it still works, OR your code breaks at COMPILE TIME, while ... Use embedded SQL. ... When I say SQL based solution, I refer to using the SQL language. ...
    (comp.object)
  • Re: "code" tables?
    ... taught database programming to COBOL programmers). ... But the embedded SQL that I used was not "dynamic", ... The precompiler processed the embedded SQL, opened a database ...
    (comp.databases)
  • Re: Does ecpg precompile C++ programs with embedded SQL, or does it not?
    ... IBM have had a precompiler for embedded SQL since ... before 2000, so it is time that postgreSQL does it to, IMAO. ... Embedded SQL is normally used in a normal "higher level" language, like C, ...
    (linux.redhat.misc)
  • Re: c++ file compilation , which includes a header file , which in turn contains SQL statements.
    ... SQL END DECLARE SECTION;" statments. ... not possibly have done the correct processing of embedded SQL ... SQL/MP from C, not from C++. ... then use another c89 command to compile the ...
    (comp.sys.tandem)
  • Re: how does sql create procedure work?
    ... high level language to use SQL? ... When I glance at the C source code for the procedure specific there is a lot of what looks like SQL CLI calls. ... Generally embedded SQL will generate calls to OS/400 programs such as QSQROUTE. ... What is the embedded SQL C code doing that RPG cannot do? ...
    (comp.sys.ibm.as400.misc)