![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
On z/OS, you must provide a fully qualified data set name when opening a data set. On Open Systems, you can provide a full path name to your external files in your CALL to the file, for example:CALL @OPENDSN(‘/usr1/osb/dsn/UNLOAD.TST’);
CALL @OPENDSN(‘D:\usr1\osb\dsn\UNLOAD.TST’);If you provide an incomplete file name, the following facilities are used to direct the CALL to the appropriate directory:You can specify the name of the path to be used to create a full file name using the DSDIR Execution Environment parameter. For example, if you provide the value usr1/osb/dsn or D:\usr1\osb\dsn and the following call is made:the full path is /usr1/osb/dsn/UNLOAD.TST or D:\usr1\osb\dsn\UNLOAD.TST.You can create a file called filespec.dsn to be used to map a z/OS data set name or Windows or Solaris file name to another value. For example, if the original file name is in mixed case and your TIBCO Object Service Broker application requires it to be in uppercase, you can map the values in filespec.dsn or if you require special characters (*, ?, <, >), map your file name to the filespec.dsn file to avoid having them replaced.filespec.dsn must be in the same directory as the one you specified in the DSDIR Execution Environment parameter. Using an editor such as Notepad or vi, put each entry on a separate line in the following format:
The name to be mapped; it can be the name of a z/OS partitioned or non-partitioned data set, or of a Windows or Solaris file. If a relative file name is specified, the value for filetouse is appended to the directory specified in your DSDIR Execution Environment parameter. For example, if the value for filetouse is file2use and the directory named in the parameter is /usr1/osb/dsn the value for originalfile is mapped to the path /usr1/osb/dsn/file2use.If a complete file name is specified, such as /usr1/osb/dsn/unload.tst, the value for originalfile is mapped to this file. The length of each record in a native file format. Otherwise, specify 0 (zero). The last record in the file can be shorter than this length.
• LENGTH_PREFIXED_EBCDIC – Native TIBCO Object Service Broker format. This data is stored in EBCDIC and big-endian format. The length of a record is determined by a length stored in the first two bytes of a record.
• LENGTH_PREFIXED_EBCDIC_NATIVE_ENDIAN – The native format for the platform. The length of the record is defined using the filespec.dsn mapping file.
• LINE_SEPARATED_ASCII – ASCII line-oriented data where the end of a line is delimited by the new line character or the end of the file.If filetype is not specified, the default value depends on its use: if the file is used in file access calls (@OPENDSN, @READDSN, @WRITEDSN, and @CLOSEDSN, the default value is the value provided by the DSBIFTYPE Execution Environment parameter.If the file is used in import or export tables, the default value is the value provided by the DSIXFTYPE Execution Environment parameter. Used only if fieldtype is LINE_SEPARATED_ASCII; otherwise it is ignored. It specifies the field separator to be used in LINE_SEPARATED_ASCII files for import and export tables. The value for fldsep must be one of the following:
• NONE – No field separator: input is in columns.
• SPACE – Spaces (tabs and blanks) are used as field separators.
• TAB – Only tabs are used as field separators.
• COMMA – Only commas are used as field separators.If fldsep is not specified when filetype is LINE_SEPARATED_ASCII, the default value is NONE and can be modified by the DSFIELDSEP Execution Environment parameter. Used only if filetype is LINE_SEPARATED_ASCII and fldsep is something other than NONE; otherwise it is ignored. It specifies the character to be used for quotation marks in LINE_SEPARATED_ASCII files being used for import and export tables. The value for quote must be one of the following:
• NONE – No quote characters.
• SINGLE – A single quotation mark (‘) is used as the quote character.
• DOUBLE – A double quotation mark (“) is used as the quote character.If quote is not specified when required, the default value is SINGLE and can be modified by the DSQUOTE Execution Environment parameter.If the DSDIR Execution Environment parameter is set to /usr1/osb/dsn, to map a file called /usr1/testone/workfile to D:\testone\workfile, the entry for filespec.dsn, is:The file type is TEXT, tabs separate each field in the file, and the quotation mark character is a single quotation mark. Record length is ignored for TEXT files and therefore is set to zero (0).If a z/OS partitioned data set name is being mapped in filespec.dsn, its name must be set with a “()” (parenthetic) suffix to distinguish it from non-partitioned data sets. The file attributes specified in the map entry are applied to all members in the data set. filetouse becomes the name of the directory for the members in the data set. The directory is created automatically. Names of members are mapped into uppercase file names to be located in the directory filetouse.If the DSDIR Execution Environment parameter is set to /usr1/osb/dsn, the member PART.DATA.SET(MEMBER) is mapped to the file /usr1/osb/dsn/partdataset/MEMBER.
• TIBCO Object Service Broker Parameters for information about the Execution Environment parameters
• TIBCO Object Service Broker Shareable Tools for information about the (@OPENDSN, @READDSN, @WRITEDSN, and @CLOSEDSN tools.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |