J

JIS date/time format

A date/time format that complies with the standard of the Japanese Industrial Standard Christian Era: DATE as yyyy-mm-dd and TIME as hh:mm:ss.

join

The generic relational operation that yields a result table comprised of columns from two or more tables. Tables are joined based on columns that the tables have in common. See also outer join.

journal buffer

The storage space in memory that holds the journal pages being written to a journal file. Each DMCL contains one and only one journal buffer. See also buffer, database buffer, and record buffer.

journal file

A file on which database processing is automatically recorded. The information recorded includes checkpoints and before and after images of database records updated during processing. Journal files allow recovery of the database in the event of a program or system failure. See also archive journal file.

journal fix utility

See FIX ARCHIVE utility statement, PRINT JOURNAL utility statement.

journal record entry

An entry written to a journal file by CA IDMS/DB to document changes to a record in the database.

journal reporter

A reporting facility that enables users to analyze the contents of the CA IDMS/DB archive journal file. The journal reporter is implemented through CA Culprit. See also JREPORTs.

journaling

In CA IDMS/DB, the process of writing journal buffer information to the journal file.

JREPORTs

Reports that provide information on the contents of an archive journal file. See also journal reporter.

junction record

In CA IDMS/DB, a member record representing the relationship between records that own it. Junction records permit many-to-many relationships between record types.