What version? Works fine for me at v5r4

create function cmwtest ( )
returns char(1)
language sql
set option dbgview = *SOURCE
begin
return 'A';
end

Charles

On Wed, Apr 20, 2011 at 1:53 PM, James Lampert <jamesl@xxxxxxxxxxxxxxxxx> wrote:
rob@xxxxxxxxx wrote:
To create one from source (knowing your background) you could try the
following:
STRSEU SRCFILE(ROB/QSQLSESS) SRCMBR(CREATEUDF) TYPE(TXT) OPTION(2)
create table qtemp/test
(myfld char(10));
F3
RUNSQLSTM SRCFILE(ROB/QSQLSESS) SRCMBR(CREATEUDF) COMMIT(*NONE)
NAMING(*SYS)

Yes. Is there a source type for which Option 14 in PDM does a RUNSQLSTM?

Charles Wilt wrote:
 > Include
 > set option
 >   dbgview = *SOURCE
 >
 > When you create the proc.  Works like the list view in RPG, the source
 > is included in the compiled object.

Include "set option dbgview = *SOURCE" where? If I type that into an
STRSQL session, I get "Token DBGVIEW was not valid. Valid tokens: COMMIT
NAMING DECMPT DATF" back.

--
JHHL
--
JHHL
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].