RE: SQL -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

What about commitment control?

-----Original Message-----
From: dave_peters@xxxxxxxxx [mailto:dave_peters@xxxxxxxxx]
Sent: Wednesday, June 19, 2019 5:55 PM
To: midrange-l <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: SQL

Hi

use strpdm
chose work with objects
select file use option 18 to create DFU

here is the program BLD003RP SQLRPGLE

Demp e ds extname(sfl001pf)

/Free

exec sql
set option
commit = *none;

exec sql
insert into sfl001pf VALUES
( 0419440,
'Slovabz',
'Dave',
'E',
'Red',
'13945 56 ave',
'Surrey',
'BC');

*Inlr = *On;

/End-Free

----- Original Message -----
From: "Justin Taylor" <JUSTIN@xxxxxxxxxxxxx>
To: "midrange-l" <midrange-l@xxxxxxxxxxxxxxxxxx>
Sent: Wednesday, June 19, 2019 3:09:41 PM
Subject: RE: SQL

What's "option 18"?

Is it an SQLRPGLE program that did the insert? Does it use commitment control? If so, did you do a commit after the insert? If it's SQLRPGLE, do a DSPPGM command against it. On the module page (3 for me), do a "Display description" against your module. You want " DB2 for IBM i module attributes:", which is down several pages.

This mailing list archive is Copyright 1997-2024 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].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.