# Specific properties

## AS/400 IBMi target

![](https://help.qlik.com/talend/en-US/change-data-capture-reference-guide/Resources/images/tcdc-distribution-properties-AS400-target.png)

Default libraryDefault library

| Property | Description |
| --- | --- |
| Independent ASP Group | This specifies the target iASPGRP. |
| Null supported | This property affects the access of non-SQL (RRN, Key, and Backup) to<br>process the null value to a target field, if the source field<br>(buffer 0 as a result of affecting buffer I with or without<br>transformation) is null.<br><br>It is the default value for all of the distributed tables (tables<br>being part of this distribution).<br><br>If a table/file is defined in SQL access mode and if a source field<br>is null, the target field will also have the null value by default<br>only if this target field accepts the null value. |
| Default library | The default library is used to change the default library in which<br>the files are located on the target machine, only if the target<br>machine is addressed using TCP-IP.<br><br>If the link between the source machine and the AS/400 IBMi target is<br>established through SNA, the list of libraries is taken from the<br>source machine.<br><br>If this value is not entered, the default library remains the library<br>in which the file is located on the source machine.<br><br>Information noteWarning: If you replicate within the same AS/400 IBMi<br>machine, take care not to replicate the file to itself.<br><br>Information noteNote: As a reminder, you can specify a destination library for each<br>file individually in the file properties in the model and in the<br>distributed file properties.<br><br>If the desired library is not found in the list of libraries, it may<br>be because it was created after the parameter definition program was<br>started.<br><br>You can refresh the library list for AS/400 IBMi by pressing the<br>F5 key (with the cursor in the Default<br>library field). |
| QPJOBLOG source and target | The Source QPJOBLOG button is displayed only<br>for an AS/400 IBMi source. The Target<br>QPJOBLOG button is displayed only for an AS/400 IBMi<br>target.<br><br>These buttons are used to download the contents of the QPJOBLOG of<br>the source machine or the target machine, depending on your<br>choice.<br><br>Information noteNote: You cannot download the QPJOBLOG contents unless the distribution<br>is stopped. |

## Windows target

![](https://help.qlik.com/talend/en-US/change-data-capture-reference-guide/Resources/images/tcdc-distribution-properties-windows.png)

| Property | Description |
| --- | --- |
| Database type | This specifies the nature of the target database. |
| Data source | This parameter is used to select the data source (ODBC DSN)<br>configured on the target machine.<br><br>You must create the DSN on the target machine before distributing the<br>model on the target, using the Data Source Manager (ODBC).<br><br>When you select a data source, the login window below is displayed<br>for you to enter your security parameters.<br><br>![](https://help.qlik.com/talend/en-US/change-data-capture-reference-guide/Resources/images/tcdc-data-source-login.png)<br><br>The user ID displayed by default is the current Windows NT session<br>user's name.<br><br>Click OK to test the connection with the<br>target databases.<br><br>A message informs you as to whether the connection attempt succeeded<br>or failed. |
| **Table name syntax** | This option is used to specify the syntax used to create the target<br>table's name. The choices available depend directly on the nature of<br>the target database.<br><br><table><colgroup><col><col><col></colgroup><thead> <tr> <th>Syntax</th> <th>DB type</th> <th>Description</th> </tr> </thead> <tr> <td>File Table</td> <td>All</td> <td>The target table name is composed only of the                                                  target file name.</td> </tr> <tr> <td>Library_File Db_Table</td> <td>All</td> <td>The target table name is composed of the name                                                  of the target library, the underscore character,                                                  and the target table name.</td> </tr> <tr> <td>Library..File Db..Table</td> <td>MS SQL Server for example</td> <td>With this naming procedure, you can use the                                                  target library name as the destination database                                                  name.</td> </tr> <tr> <td>Library.File DB.Table</td> <td>Oracle for example</td> <td>With this naming procedure, you can use the                                                  target library name as the destination database                                                  schema name.</td> </tr> </table><br><br>Information noteNote: As a reminder, the library name and target file name are obtained<br>by applying the default value substitution rules. |
| **Default DB (MS SQL Server for example)** | This option is displayed only for an MS SQL Server-type target DB,<br>and if the syntax you chose for the table name is<br>Library..File.<br><br>You can then choose the name you want to assign to the target<br>database that is selected by default.<br><br>If nothing is selected, the library name of the source file is used<br>as the default database name. |
| **Default schema (Oracle for example)** | This option is displayed only for an Oracle-type target DB, and if<br>the syntax you chose for the table name is<br>Library.File.<br><br>You can then choose the name you want to assign to the target schema<br>that is selected by default.<br><br>If nothing is selected, the library name of the source file is used<br>as the default schema name. |