Hi
found my problem, sorry wasting your time
----- Original Message -----
From: "dave peters" <dave_peters@xxxxxxxxx>
To: "midrange-l" <midrange-l@xxxxxxxxxxxxxxxxxx>
Sent: Wednesday, June 19, 2019 7:01:16 PM
Subject: Re: SQL
Hi
wrote a program to read by physical file instead of logical file and it reads
record okay so it seems when I add record with SQL the logical
file is not updated.
----- Original Message -----
From: "midrange" <franz9000@xxxxxxxxx>
To: "midrange-l" <midrange-l@xxxxxxxxxxxxxxxxxx>
Sent: Wednesday, June 19, 2019 5:06:26 PM
Subject: RE: SQL
Can you define what you mean by "read it".
Is this a chain or setll and read or reade ?
Are you accessing by the primary key or other columns? (and is their delayed
maint on the indexes)
Is the read by the name column and not mixed case like the insert..?
Are there other columns in the file and having an issue with null values?
Lots of possibilities..
Jim
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of
dave_peters@xxxxxxxxx
Sent: Wednesday, June 19, 2019 6: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.
-----Original Message-----
From: dave_peters@xxxxxxxxx [mailto:dave_peters@xxxxxxxxx]
Sent: Wednesday, June 19, 2019 4:38 PM
To: midrange-l <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: SQL
Hi
wrote simple program to insert a record into an external file using SQL,
works fine can see the record using option 18 on file, but can not read it
with RPG program using external file or SQL
Dave
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
