MCI-4604 - Getting issue details... STATUS

The hashedFiles section

hashedFiles:                               # Special settings for handling the translation of Server Hashed Files
  type: ORACLE                             # The type settings to be used for the generated DRS Connector stages.  Valied values are DB2,ORACLE or	ODBC
  variant: 11                              # the DRS variant setting
  connection: MCIDEMO                      # the DRS connection name
  username: MCITESTDEV                     # the DRS database username (this can also be a job parameter name if required)
  password: '{iisenc}CeGmkL8fluDU7OVw=='   # the DRS database password (this can also be a job parameter name if required)

The hashedFiles section allows you to set defaults for the Parallel DRS stage used to replace Server Hashed Files. For more information about these settings see Defining a DRS Connector stage connection to the database - IBM Documentation.

we take these properties and generate a Parameter Set called SPXHashedFiles which contains each of these properties as a parasmeter.

in config file:

S2PX takes properties and generates Parameter Set with all those properties within

and a single value file (“default”) with those values in

Generated Jobs expect parmeter set passed

Top-level sequence also passes paramter set to Job tasks iw

If we don’t

Addiiotnal parameter (optional) called schema” which causesd al jobs to prefix tablenames wiuth “schema.tablename”: (if omitted no schema is prefixed, and partmeter is not added to paramet set!)

usefule whgen scopeing jobs to different schemas (or users in Oracle, fro example)