same structure - DDS vs DDL - File and level id'sHow to list the tables in a SQLite database file that was opened with ATTACH?Save PL/pgSQL output from PostgreSQL to a CSV fileWhat is DDL and DML?Trigger at Database Level on DDL StatmentsImporting data from AS/400 DB2 into SQL Server databaseHow do I programmatically determine the CCSID of a file in the IFS?How to import an SQL file using the command line in MySQL?Treat NaN's as NULL in SSIS packageSQL: Nesting coalesce and convertRPG IV Files processing issue
Which star / galaxy is moving away from us the fastest?
When an electron changes its spin, or any other intrinsic property, is it still the same electron?
How can a dictatorship government be beneficial to a dictator in a post-scarcity society?
Is there any reason why MCU changed the Snap to Blip
Extracting points from 3D plot that lie along an arbitrarily oriented line
Why return a static pointer instead of an out parameter?
What specific instant in time in the MCU has been depicted the most times?
Can you cast a blanket Invisibility and let the targets see each other?
Can I run a #12 outlet branch and a #14 light branch off a 30A breaker?
Is "De qui parles-tu" (for example) as formal as it is in English, or is it normal for the French to casually say that
Can the Mage Hand cantrip be used to trip an enemy who is running away?
Is English unusual in having no second person plural form?
Salt, pepper, herbs and spices
Why are they 'nude photos'?
What does the phrase "head down the rat's hole" mean here?
Is it possible to create a craft with specific bones, like the bones of a forgotten beast?
Terry Pratchett book with a lawyer dragon and sheep
Are there any balance issues in allowing two half-feats to be taken without the Ability Score Increase instead of a feat?
Optimization terminology: "Exact" v. "Approximate"
Graduate student with abysmal English writing skills, how to help
How do you move up one folder in Finder?
When I press the space bar it deletes the letters after it
Was I subtly told to resign?
Why do people keep referring to Leia as Princess Leia, even after the destruction of Alderaan?
same structure - DDS vs DDL - File and level id's
How to list the tables in a SQLite database file that was opened with ATTACH?Save PL/pgSQL output from PostgreSQL to a CSV fileWhat is DDL and DML?Trigger at Database Level on DDL StatmentsImporting data from AS/400 DB2 into SQL Server databaseHow do I programmatically determine the CCSID of a file in the IFS?How to import an SQL file using the command line in MySQL?Treat NaN's as NULL in SSIS packageSQL: Nesting coalesce and convertRPG IV Files processing issue
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
In IBM i (as/400), I want same program to run against DDL and DDS created files (tables). Using "CALL qsys2.generate_sql" API I was able to convert DDS to DLL.
However once compiled, I get different File and member level id's.
Here is very simple example of DDS and DLL code...
A R TST_RC
A ORDER_NUM 8S 0 TEXT('ORFER_NO')
A ORDER_CUST 20A TEXT('CUST NO')
..
CREATE TABLE MYLIB.MYTABLE (
ORDER_NUM NUMERIC(8, 0) NOT NULL DEFAULT 0 ,
ORDER_CUST CHAR(20) CCSID 37 NOT NULL DEFAULT '' )
RCDFMT TST_RC ;
;
sql ibm-midrange ddl
asked Mar 26 at 1:30
Mustapha GeorgeMustapha George
9768 gold badges38 silver badges64 bronze badges
add a comment |
In IBM i (as/400), I want same program to run against DDL and DDS created files (tables). Using "CALL qsys2.generate_sql" API I was able to convert DDS to DLL.
However once compiled, I get different File and member level id's.
Here is very simple example of DDS and DLL code...
A R TST_RC
A ORDER_NUM 8S 0 TEXT('ORFER_NO')
A ORDER_CUST 20A TEXT('CUST NO')
..
CREATE TABLE MYLIB.MYTABLE (
ORDER_NUM NUMERIC(8, 0) NOT NULL DEFAULT 0 ,
ORDER_CUST CHAR(20) CCSID 37 NOT NULL DEFAULT '' )
RCDFMT TST_RC ;
;
sql ibm-midrange ddl
asked Mar 26 at 1:30
Mustapha GeorgeMustapha George
9768 gold badges38 silver badges64 bronze badges
Hello, Can you give more information as to what you are trying to do?
– wavery
Mar 26 at 3:48
taking legacy AS/400 DDS table and converting to SQL equivalent is such a way that file level ID does not change... see developer.ibm.com/articles/i-sql-indexs-and-native-io
– Mustapha George
Mar 26 at 5:34
add a comment |
In IBM i (as/400), I want same program to run against DDL and DDS created files (tables). Using "CALL qsys2.generate_sql" API I was able to convert DDS to DLL.
However once compiled, I get different File and member level id's.
Here is very simple example of DDS and DLL code...
A R TST_RC
A ORDER_NUM 8S 0 TEXT('ORFER_NO')
A ORDER_CUST 20A TEXT('CUST NO')
..
CREATE TABLE MYLIB.MYTABLE (
ORDER_NUM NUMERIC(8, 0) NOT NULL DEFAULT 0 ,
ORDER_CUST CHAR(20) CCSID 37 NOT NULL DEFAULT '' )
RCDFMT TST_RC ;
;
sql ibm-midrange ddl
asked Mar 26 at 1:30
Mustapha GeorgeMustapha George
9768 gold badges38 silver badges64 bronze badges
In IBM i (as/400), I want same program to run against DDL and DDS created files (tables). Using "CALL qsys2.generate_sql" API I was able to convert DDS to DLL.
However once compiled, I get different File and member level id's.
Here is very simple example of DDS and DLL code...
A R TST_RC
A ORDER_NUM 8S 0 TEXT('ORFER_NO')
A ORDER_CUST 20A TEXT('CUST NO')
..
CREATE TABLE MYLIB.MYTABLE (
ORDER_NUM NUMERIC(8, 0) NOT NULL DEFAULT 0 ,
ORDER_CUST CHAR(20) CCSID 37 NOT NULL DEFAULT '' )
RCDFMT TST_RC ;
;
sql ibm-midrange ddl
sql ibm-midrange ddl
asked Mar 26 at 1:30
Mustapha GeorgeMustapha George
9768 gold badges38 silver badges64 bronze badges
asked Mar 26 at 1:30
Mustapha GeorgeMustapha George
9768 gold badges38 silver badges64 bronze badges
asked Mar 26 at 1:30
Mustapha GeorgeMustapha George
9768 gold badges38 silver badges64 bronze badges
asked Mar 26 at 1:30
Mustapha GeorgeMustapha George
9768 gold badges38 silver badges64 bronze badges
asked Mar 26 at 1:30
Mustapha GeorgeMustapha George
9768 gold badges38 silver badges64 bronze badges
9768 gold badges38 silver badges64 bronze badges
Hello, Can you give more information as to what you are trying to do?
– wavery
Mar 26 at 3:48
taking legacy AS/400 DDS table and converting to SQL equivalent is such a way that file level ID does not change... see developer.ibm.com/articles/i-sql-indexs-and-native-io
– Mustapha George
Mar 26 at 5:34
add a comment |
Hello, Can you give more information as to what you are trying to do?
– wavery
Mar 26 at 3:48
taking legacy AS/400 DDS table and converting to SQL equivalent is such a way that file level ID does not change... see developer.ibm.com/articles/i-sql-indexs-and-native-io
– Mustapha George
Mar 26 at 5:34
Hello, Can you give more information as to what you are trying to do?
– wavery
Mar 26 at 3:48
Hello, Can you give more information as to what you are trying to do?
– wavery
Mar 26 at 3:48
taking legacy AS/400 DDS table and converting to SQL equivalent is such a way that file level ID does not change... see developer.ibm.com/articles/i-sql-indexs-and-native-io
– Mustapha George
Mar 26 at 5:34
taking legacy AS/400 DDS table and converting to SQL equivalent is such a way that file level ID does not change... see developer.ibm.com/articles/i-sql-indexs-and-native-io
– Mustapha George
Mar 26 at 5:34
add a comment |
1 Answer
1
active
oldest
votes
The file and member level identifier will always be different. That is not a problem, but if the formats are the same, the Format Level Identifier will be the same. It is the format level identifier that causes the level check. So in your example, the file and member level identifiers are different, but the two files will have the same format level identifier, that is 332FE538F73DB on my system. It should even be the same as the format level on your system. Thus the files can be used interchangeably without experiencing level checks.
Using DSPFD, here's what you need to look for
edited Mar 26 at 15:17
Charles
12.1k1 gold badge11 silver badges32 bronze badges
answered Mar 26 at 13:59
jmarkmurphyjmarkmurphy
8,60822 silver badges42 bronze badges
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55348629%2fsame-structure-dds-vs-ddl-file-and-level-ids%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
The file and member level identifier will always be different. That is not a problem, but if the formats are the same, the Format Level Identifier will be the same. It is the format level identifier that causes the level check. So in your example, the file and member level identifiers are different, but the two files will have the same format level identifier, that is 332FE538F73DB on my system. It should even be the same as the format level on your system. Thus the files can be used interchangeably without experiencing level checks.
Using DSPFD, here's what you need to look for
edited Mar 26 at 15:17
Charles
12.1k1 gold badge11 silver badges32 bronze badges
answered Mar 26 at 13:59
jmarkmurphyjmarkmurphy
8,60822 silver badges42 bronze badges
add a comment |
The file and member level identifier will always be different. That is not a problem, but if the formats are the same, the Format Level Identifier will be the same. It is the format level identifier that causes the level check. So in your example, the file and member level identifiers are different, but the two files will have the same format level identifier, that is 332FE538F73DB on my system. It should even be the same as the format level on your system. Thus the files can be used interchangeably without experiencing level checks.
Using DSPFD, here's what you need to look for
edited Mar 26 at 15:17
Charles
12.1k1 gold badge11 silver badges32 bronze badges
answered Mar 26 at 13:59
jmarkmurphyjmarkmurphy
8,60822 silver badges42 bronze badges
add a comment |
The file and member level identifier will always be different. That is not a problem, but if the formats are the same, the Format Level Identifier will be the same. It is the format level identifier that causes the level check. So in your example, the file and member level identifiers are different, but the two files will have the same format level identifier, that is 332FE538F73DB on my system. It should even be the same as the format level on your system. Thus the files can be used interchangeably without experiencing level checks.
Using DSPFD, here's what you need to look for
edited Mar 26 at 15:17
Charles
12.1k1 gold badge11 silver badges32 bronze badges
answered Mar 26 at 13:59
jmarkmurphyjmarkmurphy
8,60822 silver badges42 bronze badges
The file and member level identifier will always be different. That is not a problem, but if the formats are the same, the Format Level Identifier will be the same. It is the format level identifier that causes the level check. So in your example, the file and member level identifiers are different, but the two files will have the same format level identifier, that is 332FE538F73DB on my system. It should even be the same as the format level on your system. Thus the files can be used interchangeably without experiencing level checks.
Using DSPFD, here's what you need to look for
edited Mar 26 at 15:17
Charles
12.1k1 gold badge11 silver badges32 bronze badges
answered Mar 26 at 13:59
jmarkmurphyjmarkmurphy
8,60822 silver badges42 bronze badges
edited Mar 26 at 15:17
Charles
12.1k1 gold badge11 silver badges32 bronze badges
edited Mar 26 at 15:17
Charles
12.1k1 gold badge11 silver badges32 bronze badges
edited Mar 26 at 15:17
Charles
12.1k1 gold badge11 silver badges32 bronze badges
12.1k1 gold badge11 silver badges32 bronze badges
answered Mar 26 at 13:59
jmarkmurphyjmarkmurphy
8,60822 silver badges42 bronze badges
answered Mar 26 at 13:59
jmarkmurphyjmarkmurphy
8,60822 silver badges42 bronze badges
answered Mar 26 at 13:59
jmarkmurphyjmarkmurphy
8,60822 silver badges42 bronze badges
8,60822 silver badges42 bronze badges
add a comment |
add a comment |
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55348629%2fsame-structure-dds-vs-ddl-file-and-level-ids%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Hello, Can you give more information as to what you are trying to do?
– wavery
Mar 26 at 3:48
taking legacy AS/400 DDS table and converting to SQL equivalent is such a way that file level ID does not change... see developer.ibm.com/articles/i-sql-indexs-and-native-io
– Mustapha George
Mar 26 at 5:34