1. Application Runtime for Batch Reference Guide
  2. Z/OS JCL in the Batch Runtime Environment
  3. DB2 Utilities
  4. DSNTIAUL
  5. DSNTIAUL Limitations

1.4.1.1 DSNTIAUL Limitations

  • When applying equivalent SQL functions in select statement for the same database table column, the data type that Batch runtime DSNTIAUL outputs for Oracle Database may be different from the data type that mainframe DSNTIAUL outputs for DB2.
  • For real, Float(n) (1<=n<=21), Float(n)(22<=n<=53), and Double data types in DB2, they are converted to BINARY_DOUBLE data type (with eight bytes) in Oracle Database. You can retrieve the field in target file to COMP-2 variable in COBOL program by using Micro Focus COBOL (COBOL-IT COBOL may produce incorrect results).
  • The output file should be a fixed-width sequential file.

Parent topic: DSNTIAUL