ODBC connector source connection
Posted: Tue May 01, 2018 7:55 am
Hi,
I have a job where I am using ODBC connector stage as source to read from sql server.
In the logs, I see that it connects to the source two times. Why is that so? Isnt ODBC connector stage sequential by default?
I have not configured parallel read option. I want to run it in sequential mode. I changed this in properties, but still its connecting two times to source.
Please see the log below:-
Type: Info Event: Parallel job initiated
.. .. .. ..
.. .. .. .. .. ..
Type: Info Event: main_program: orchgeneral: loaded (...)
Type: Info Event: ODBC_SQL_BYR: Connected to Microsoft SQL Server, version 12.00.2271 through driver VMsqls00.so.
Type: Info Event: ODBC_SQL_BYR: The driver does not support quoted identifiers in SQL statements
Type: Info Event: target: Using case-insensitive indentifiers
Type: Info Event: target: Generated table action SQL: TRUNCATE TABLE T.BUYERGRP
Type: Info Event: main_program: APT configuration file: /opt/IBM/InformationServer/Server/Configurations/default.apt (...)
Type: Info Event: main_program: This step has 2 datasets: (...)
Type: Info Event: ODBC_SQL_BYR,0: Connected to Microsoft SQL Server, version 12.00.2271 through driver VMsqls00.so.
Type: Info Event: ODBC_SQL_BYR,0: The driver does not support quoted identifiers in SQL statements
Type: Info Event: target: Number of rows inserted: 4
Type: Info Event: main_program: Step execution finished with status = OK.
Type: Info Event: main_program: Startup time, 0:20; production run time, 0:33.
Type: Info Event: Parallel job reports successful completion
I have a job where I am using ODBC connector stage as source to read from sql server.
In the logs, I see that it connects to the source two times. Why is that so? Isnt ODBC connector stage sequential by default?
I have not configured parallel read option. I want to run it in sequential mode. I changed this in properties, but still its connecting two times to source.
Please see the log below:-
Type: Info Event: Parallel job initiated
.. .. .. ..
.. .. .. .. .. ..
Type: Info Event: main_program: orchgeneral: loaded (...)
Type: Info Event: ODBC_SQL_BYR: Connected to Microsoft SQL Server, version 12.00.2271 through driver VMsqls00.so.
Type: Info Event: ODBC_SQL_BYR: The driver does not support quoted identifiers in SQL statements
Type: Info Event: target: Using case-insensitive indentifiers
Type: Info Event: target: Generated table action SQL: TRUNCATE TABLE T.BUYERGRP
Type: Info Event: main_program: APT configuration file: /opt/IBM/InformationServer/Server/Configurations/default.apt (...)
Type: Info Event: main_program: This step has 2 datasets: (...)
Type: Info Event: ODBC_SQL_BYR,0: Connected to Microsoft SQL Server, version 12.00.2271 through driver VMsqls00.so.
Type: Info Event: ODBC_SQL_BYR,0: The driver does not support quoted identifiers in SQL statements
Type: Info Event: target: Number of rows inserted: 4
Type: Info Event: main_program: Step execution finished with status = OK.
Type: Info Event: main_program: Startup time, 0:20; production run time, 0:33.
Type: Info Event: Parallel job reports successful completion