Question

small doubt

DB2, UDB for iSeries/i5, OS/400, iSeries, i5, Backup & recovery, Hardware, Security, Tools, tips and tricks

Hi,
I have a small doubt in AS400 programming. This is regarding receiving journal entries. I am using ILE C to write the exit program. I am using RJNE0200 format on the RCVJRNE command. I am getting the entries in the exit program. But I have a few questions:
- in the RJNE0200 format, there are data types for fields like BINARY(8) UNSIGNED. Now if i want to store the entries in my own DB2 table, what is the corresponding data type I need to use? Right now I am using BIGINT, but how to specify unsigned BIGINT?
- in the RJNE0200 format, the timestamp is unformatted BINARY(8) UNSIGNED format. How do I get date and time out of this? I mean, are there any APIs which can be used to deal with unformatted BINARY(8) UNSIGNED timestamp? I want to do this in ILE C.
- also I get garbage or just null in the remote address field but at the same time I get a valid value in the remote port field as well as in the address family field. I am getting valid values in all the fields except remote address and journal identifier fields. Any clues?

Thanks in advance,
P.Prasad

For unsigned BIGINT items, I'd probably use a CHAR(8) column in my tables. There's nothing that can be done by DB2 for these values; all must be done by programs, so the database doesn't need to know anything about the contents.

I don't know the date format for those journal entries. My first guess would be that they are system date/timestamp fields since they're 8-bytes in length. I would first try the Convert Date and Time Format (QWCCVTDT) API to see if they converted with an input type of *DTS. Again, store them as CHAR(8) in any tables. The numeric values are essentially meaningless; treat them as binary (or hex) values.

If I saw values for remote address that weren't meaningful, I'd first check the value in the Address family (JOADF) field in the returned entry. What value do you get in that field?

Tom