Note:  Library ROB was created with SQL's CREATE COLLECTION.  Thus 
everything is journaled by default.
STRSQL
CREATE TABLE ROB/DJOHNSON (MYDEC DECIMAL (15 , 5) NOT NULL WITH DEFAULT)
INSERT INTO ROB/DJOHNSON VALUES(5.2)

DSPJRN JRN(ROB/QSQJRN) FILE((ROB/DJOHNSON))
Sequence  Code  Type  Object      Library     Job         Time 
    3281   J     XP   DJOHNSON    ROB         ROBS1       14:34:50
    3282   D     CT   DJOHNSON    ROB         ROBS1       14:34:50
    3283   D     JF   DJOHNSON    ROB         ROBS1       14:34:51
    3284   D     GO   DJOHNSON    ROB         ROBS1       14:34:51
    3285   D     RV   DJOHNSON    ROB         ROBS1       14:34:51
    3286   F     JM   DJOHNSON    ROB         ROBS1       14:34:51
    3287   D     MA   DJOHNSON    ROB         ROBS1       14:34:51
    3288   F     MC   DJOHNSON    ROB         ROBS1       14:34:51
    3289   R     PT   DJOHNSON    ROB         ROBS1       14:35:08

On the last entry
5=Display entire entry

            Entry specific data 
Column      *...+....1....+....2
00001      '        ' 

Here's the clue...
F24=More keys
F11=Display hexadecimal format
Code . . . . . . . . :   R  - Operation on specific record
Type . . . . . . . . :   PT - Record added 
 
            Entry specific data 
Column      * . . . + . . . . 1 . . . . + . . . . 2 . . . 
00001      '000000000520000F' 

Rob Berendt

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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.