Informix Error -12038: Smart Large Objects: Invalid access time flag combination.

Cause and resolution

Smart Large Objects: Invalid access time flag combination.

During a smart-large-object CREATE or ALTER operation, a create specification was provided that specified conflicting values for the access time flag. Correct the smart-large-object application program. Ensure that the create specification is set to the default NULL values before you provide it to the smart-large-object subsystem. Use ifx_lo.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-12038 fires when a smart-large-object CREATE/ALTER specification sets conflicting access-time flag values — per the official guidance.

Conflicting access-time flag values in the create specification, per the official guidance — the direct, only cause.

Solutions / Resolution

Correct the smart-large-object application program's flag values, per the official guidance.
Ensure the create specification is initialized to default NULL values before use (via ifx_lo), per the official guidance.

Examples

N/A

No specific triggering statement is documented beyond conflicting access-time flags.

Diagnostic Checks

Check the create specification's access-time flags for conflicts, and confirm it was initialized to NULL defaults via ifx_lo before being populated.

Related Errors / Related Topics

-12043 — "Smart Large Objects: Invalid create flags." The general form of this same class of conflicting-flag error.
-12044 — "Smart Large Objects: Invalid integrity type flag combination." The same class of conflicting-flag error, for the integrity field rather than access time.
-12045 — "Smart Large Objects: Invalid logging mode combination." The same class of conflicting-flag error, for the log-mode field rather than access time.

The create specification set conflicting access-time flags — initialize it to NULL defaults via ifx_lo before setting flags.