When they say SQL Cache, I'm going to venture to guess they mean an *SQLPKG object on IBM i. My personal experience is those are a plague, get corrupted quietly and make things break quietly until things just stop working. Find the one(s) that they are using and delete it(them). It does have a performance hit as it's rebuilt, but I prefer a performance hit to rebuild it rather than bad data. If the app goes down or is quiet at some point during the day you can always just remove it then and have it as the app runs. That can keep it clean and fixed as you go.
Coy Krill
Core Processing Administrator/Analyst
Washington Trust Bank
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Troy Hyde
Sent: 2017 October 18 13:08
To: midrange-l@xxxxxxxxxxxx
Subject: Re: DDS vs DDL. Record format level
Importance: Low
Nathan,
"I have long questioned the relevance of converting existing DDS-defined to DDL-defined files while attempting to maintain the same Level ID. Okay, it can be done in most cases. But what value do you expect to gain?"
Not a ton of gain and none from the RPG/server side. Our GUI application is written in Java using Hibernate. Our Java programmers are experiencing an issue that has to do with the SQL cache that they claim is a non-issue for SQL tables. This is another attempt to resolve a problem I actually inquired on (very poorly) several years ago.
https://archive.midrange.com/midrange-l/201303/msg00417.html
----
To answer some of the other notes/questions:
Running 7.2
I get no errors running the SQL to create the table. I get the identical table source when I use the ACS wizard as I did with the QSQGNDDL api.
Regarding the api, I have a hard time believing that's the issue. Whether the SQL used to created the table is generated by ACS, the api or pulled out of the air, the resulting table is going to be the same:
For those interested here's some snipped source:
A UNIQUE
A R LASECVF
A SVAPNO 6S 0
A SVMODL 40 VARLEN
A K SVAPNO
Results:
Format level identifier . . . . . . . . . . : 21BBD4C3F064B
Number of fields . . . . . . . . . . . . . : 2
Record length . . . . . . . . . . . . . . . : 48
SQL code:
CREATE TABLE MYLIB/LASECV (
SVAPNO NUMERIC(6, 0) NOT NULL DEFAULT 0 ,
SVMODL VARCHAR(40) CCSID 37 NOT NULL DEFAULT '',
PRIMARY KEY( SVAPNO ) )
RCDFMT LASECVF ;
Results:
Format level identifier . . . . . . . . . . : 21BBD4C3F0E53
Number of fields . . . . . . . . . . . . . : 2
Record length . . . . . . . . . . . . . . . : 48
SQL code:
CREATE TABLE MYLIB/LASECV (
SVAPNO NUMERIC(6, 0) NOT NULL DEFAULT 0 ,
SVMODL VARCHAR(40) CCSID 37 NOT NULL , (removed default)
PRIMARY KEY( SVAPNO ) )
RCDFMT LASECVF ;
Results:
Format level identifier . . . . . . . . . . : 21BBD4C3F4E93
Number of fields . . . . . . . . . . . . . : 2
Record length . . . . . . . . . . . . . . . : 48
In addition, I can change leave "Default 0" or "Default '' for char and numeric columns and it doesn't make a difference.
TROY HYDE, Upgrades and Standards Manager
FLEX : 800 262 3539
Troy.Hyde@xxxxxxxxxxx
Confidentiality Notice: This communication and any associated attachments is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. Dissemination, distribution or copying of this communication and any accompanying attached information by anyone other than the intended recipient(s), or an employee or agent acting on behalf of the intended recipient, is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to this message, and then delete it from your computer.
Subject: Re: DDS vs DDL. Record format level
On Tue, Oct 17, 2017 at 7:53 PM, Troy Hyde <troy.hyde@xxxxxxxxxxx> wrote:
I've got a handful of DDS physical files, some that have existed
since
the
late 80s, that I'm converting to DDL.
I have long questioned the relevance of converting existing
DDS-defined to DDL-defined files while attempting to maintain the same
Level ID. Okay, it can be done in most cases. But what value do you expect to gain?
I've never viewed DDS and DDL to be mutually exclusive. I see value in
both. I'm aware of people who preach DDL vs. DDS. To each their own.
--
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:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx 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:
http://amzn.to/2dEadiD
---------------------------------------------------------------------
This electronic mail message and any attachments may contain confidential or privileged information and is intended for use solely by the above-referenced recipient. Any review, copying, printing, disclosure, distribution, or other use by any other person or entity is strictly prohibited under applicable law. If you are not the named recipient, or believe you have received this message in error, please immediately notify the sender by replying to this message and delete the copy you received
---------------------------------------------------------------------
midrange.com
