Re: dds-all-formats

TP:

No idea what a 'transaction' file is. However, I've seen 'DDS' used to declare keys for an isam file on AS/400s.

Michael
Rick Smith wrote:
"josephit" <dakron@xxxxx> wrote in message news:etr907$cc9$1@xxxxxxxxxxxxxxx
Could you tell me what this realy mean with COPY and database file? I have
this pice of code:
FD Mydatabase
LABEL RECORDS STANDARD.
01 R-Mydatabase.
COPY DDS-ALL-FORMATS OF Mydatabase.

Second try:

<
http://publib.boulder.ibm.com/infocenter/iadthelp/v6r0/index.jsp?topic=/com.
ibm.etools.iseries.pgmgd.doc/c0925405365.htm >

-----begin quoted material
Describing a Transaction File

To use a TRANSACTION file in an ILE COBOL program,
you must describe the file through a file description entry in
the Data Division. See ILE COBOL for AS/400 Reference
for a full description of the File Description Entry. Use the
Format 6 File Description Entry to describe a
TRANSACTION file.

A file description entry in the Data Division that describes a
TRANSACTION file looks as follows:

FD CUST-DISPLAY.
01 DISP-REC.
COPY DDS-ALL-FORMATS OF CUSMINQ.

In ILE COBOL, TRANSACTION files are usually
externally described. Create a DDS for the
TRANSACTION file you want to use. Refer to Defining
Transaction Files Using Data Description Specifications
for how to create a DDS. Then create the
TRANSACTION file.

Once you have created the DDS for the TRANSACTION
file and the TRANSACTION file, use the Format 2 COPY
statement to describe the layout of the TRANSACTION
file data record. When you compile your ILE COBOL
program, the Format 2 COPY will create the Data Division
statements to describe the TRANSACTION file. Use the
DDS-ALL-FORMATS option of the Format 2 COPY
statement to generate one storage area for all formats.

(C) Copyright IBM Corporation 1992, 2006. All Rights
Reserved.
-----end quoted material



.

Relevant Pages

  • Re: Running Balance
    ... The Date field has the propertys Date/Time in the table, ... you would have to force that format instead of using the explicit format ... I would have probably had a single field for transaction amount ... I've used the following expression in the query. ...
    (microsoft.public.access.queries)
  • Re: Running Balance
    ... If so, we have to include ALSO the time of the transaction, in our format: ... >> Are all of the Payments and Fees values numeric or might some be Null? ... I've used the following expression in the query. ...
    (microsoft.public.access.queries)
  • Re: Bulk Insert
    ... in memory much like a file format and bulk inserted from that point ... > seconds if the inserts are part of the same transaction and you are using ... > You could build a single string of insert statements (or proc executes) and ...
    (microsoft.public.sqlserver.programming)
  • Re: Formatting more than one field at the same time (and dates as dates)
    ... Leave the Format property in the table blank. ... The source data is a table with account details (each record is an ... account) and another one with transaction details (each record a ... so your suggestion works. ...
    (comp.databases.ms-access)
  • Re: "CEDF" type of ability in IMS??
    ... You enter a transaction and IMS moves it from queue to queue until the unit of work is complete. ... You can pre format the screen with a /FOR command if you know the format name. ...
    (bit.listserv.ibm-main)