Reading data from SQL-Server table
Posted: Mon Oct 20, 2003 6:53 pm
Does the ODBC data source definition mark the database as "exclusive use"? If so, your job will wait until that connection can get exclusive use of the database.
----- Original Message -----
From: "RAMAN ANBUCHELIAN"
Date: Mon, 20 Oct 2003 15:27:33 +0530
To:
Subject: Reading data from SQL-Server table
>
> Hi Gurus,
>
> We are using datastage6.0 on Win-NT.
> One of my job using ODBC Stage to retrive data from a SQL-Server database table.
> When I am running a job, records are not transferred from the source table to transformer stage. But I am able to see the records using "View Data" property of ODBC Stage.
>
> Any suggestions to resolve this problem?.
>
> Rgds,
> Anbu
>
>
>
> **************************Disclaimer************************************
>
> Information contained in this E-MAIL being proprietary to Wipro Limited is
> 'privileged' and 'confidential' and intended for use only by the individual
> or entity to which it is addressed. You are notified that any use, copying
> or dissemination of the information contained in the E-MAIL in any manner
> whatsoever is strictly prohibited.
>
> ***************************************************************************
>
----- Original Message -----
From: "RAMAN ANBUCHELIAN"
Date: Mon, 20 Oct 2003 15:27:33 +0530
To:
Subject: Reading data from SQL-Server table
>
> Hi Gurus,
>
> We are using datastage6.0 on Win-NT.
> One of my job using ODBC Stage to retrive data from a SQL-Server database table.
> When I am running a job, records are not transferred from the source table to transformer stage. But I am able to see the records using "View Data" property of ODBC Stage.
>
> Any suggestions to resolve this problem?.
>
> Rgds,
> Anbu
>
>
>
> **************************Disclaimer************************************
>
> Information contained in this E-MAIL being proprietary to Wipro Limited is
> 'privileged' and 'confidential' and intended for use only by the individual
> or entity to which it is addressed. You are notified that any use, copying
> or dissemination of the information contained in the E-MAIL in any manner
> whatsoever is strictly prohibited.
>
> ***************************************************************************
>