Re: SQL display_journal

My hypothesis about the timestamp being in previous/post receivers is
flawed.
This returns rows even though they are outside of that receiver's range.
starting_timestamp => '2023-04-02-00.00.00.000000',
ending_timestamp => '2023-04-05-07.34.59.999999'
And so do these:
starting_timestamp => '1800-04-02-00.00.00.000000',
ending_timestamp => '2900-04-05-07.34.59.999999'
And so do these:
starting_timestamp => '0001-01-01-00.00.00.000000',
ending_timestamp => '2900-04-05-07.34.59.999999'

Ooo, I found something. Stay tuned for a new thread...

On Wed, Apr 5, 2023 at 7:33 AM Rob Berendt <robertowenberendt@xxxxxxxxx>
wrote:

If you want everything starting at the beginning to the end isn't it
rather pointless to specify a starting and ending timestamp especially when
you are selecting a single receiver?
The documentation says
If no starting timestamp is specified, *FIRST is used.
If no ending timestamp is specified, *LAST is used.
Maybe specifying dates like you are freaks it out since those dates start
in a different receiver and end in a different receiver than the one you
specify?

BTW, any attempt to try
starting_timestamp => '*FIRST',
ending_timestamp => '*LAST'
will result in:
SQL State: 22023
Vendor Code: -809
Message:[SQL0802] Data conversion or data mapping error.

On Tue, Apr 4, 2023 at 11:35 AM <smith5646midrange@xxxxxxxxx> wrote:

I am trying to pull data from a journal receiver using SQL using that
starting_timestamp and ending_timestamp parms. I was not getting any
results so I tried switching my dates to be from
0001-01-01-00.00.00.000000
to 9999-12-31-23.59.59.999999 to include everything in the receiver.



When I use the below statement with the starting and ending timestamp, I
get
0 rows returned.

select *
from table (qsys2.display_journal ('##JOURNALS',
'IPLIBD',
object_objtype => '*FILE',
starting_receiver_name =>
'IPLIBD3277',
starting_receiver_library =>
'##JOURNALS',
ending_receiver_name =>
'IPLIBD3277',

ending_receiver_library =>
'##JOURNALS',
starting_timestamp =>
'0001-01-01-00.00.00.000000',
ending_timestamp =>
'9999-12-31-23.59.59.999999'
)
) ;



However, when I use the below statement WITHOUT the starting and ending
timestamp, I get lots of rows returned.



select *
from table (qsys2.display_journal ('##JOURNALS',
'IPLIBD',
object_objtype => '*FILE',
starting_receiver_name =>
'IPLIBD3277',
starting_receiver_library =>
'##JOURNALS',
ending_receiver_name =>
'IPLIBD3277',

ending_receiver_library =>
'##JOURNALS' )
) ;



What am I overlooking?

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.