× 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.


  1.  Home
  2. RPG400-L
  3. February 2012

Re: Format Level ID

do you see anything strange if you do a DSPFFD between the two files?

On 2/1/2012 9:27 AM, Kurt Anderson wrote:
File 1 - DDS: http://code.midrange.com/d9e8f69923.html
File 2 - SQL: http://code.midrange.com/08cab3a254.html

Record length matches
Record format names match
Field Count matches
Number and order of fields matches.
Field names, data types and size of fields should match since File1's fields are defined as reference fields

-Kurt
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of CRPence
Sent: Tuesday, January 31, 2012 7:20 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Re: Format Level ID

On 31-Jan-2012 14:49 , Kurt Anderson wrote:
We have a SQL file, TAXSTMTP. We also have a DDS file, CURTAXP.
CURTAXP is like a history/save file of TAXSTMTP. Our "cur" files are
multi-member, so they can't be created via SQL, which is why they are
created using DDS source.

These two files, compiled at 'the same time', one after the other,
results in the following format IDs:

TAXSTMTP: 43856FE31EAC4
CURTAXP: 43856FE31EAB4

What is the DDS and what is the DDL?

Regards, Chuck
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l.



As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.