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.
>
> ***************************************************************************
>
Reading data from SQL-Server table
Reading data from SQL-Server table
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Reading data from SQL-Server table
-----Original Message-----
From: RAMAN ANBUCHELIAN [mailto:raman.anbuchelian@wipro.com]
Sent: Monday, October 20, 2003 4:58 AM
To: datastage-users@oliver.com
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.
***************************************************************************
From: RAMAN ANBUCHELIAN [mailto:raman.anbuchelian@wipro.com]
Sent: Monday, October 20, 2003 4:58 AM
To: datastage-users@oliver.com
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.
***************************************************************************
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Reading data from SQL-Server table
-----Original Message-----
From: Narender.Vittal@chase.com [mailto:Narender.Vittal@chase.com]
Sent: Monday, October 20, 2003 6:20 AM
To: datastage-users@oliver.com
Subject: Re: Reading data from SQL-Server table
Lookk for any contraints in the transformer stage
Naren
"RAMAN ANBUCHELIAN" on 10/20/2003 05:57:33 AM
Please respond to
To:
cc:
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.
***************************************************************************
From: Narender.Vittal@chase.com [mailto:Narender.Vittal@chase.com]
Sent: Monday, October 20, 2003 6:20 AM
To: datastage-users@oliver.com
Subject: Re: Reading data from SQL-Server table
Lookk for any contraints in the transformer stage
Naren
"RAMAN ANBUCHELIAN" on 10/20/2003 05:57:33 AM
Please respond to
To:
cc:
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.
***************************************************************************
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Reading data from SQL-Server table
-----Original Message-----
From: David Barham [mailto:david@barham.hm]
Sent: Monday, October 20, 2003 6:28 AM
To: datastage-users@oliver.com
Subject: RE: Reading data from SQL-Server table
Is it a primary input link or a reference link?
Can you give more information about your symptoms? Does a Monitor show no
rows processed after the job is finished?
-----Original Message-----
From: RAMAN ANBUCHELIAN [mailto:raman.anbuchelian@wipro.com]
Sent: Monday, 20 October 2003 7:58 PM
To: datastage-users@oliver.com
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.
***************************************************************************
From: David Barham [mailto:david@barham.hm]
Sent: Monday, October 20, 2003 6:28 AM
To: datastage-users@oliver.com
Subject: RE: Reading data from SQL-Server table
Is it a primary input link or a reference link?
Can you give more information about your symptoms? Does a Monitor show no
rows processed after the job is finished?
-----Original Message-----
From: RAMAN ANBUCHELIAN [mailto:raman.anbuchelian@wipro.com]
Sent: Monday, 20 October 2003 7:58 PM
To: datastage-users@oliver.com
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.
***************************************************************************
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Reading data from SQL-Server table
-----Original Message-----
From: Tony Stark [mailto:tonystark622@yahoo.com]
Sent: Monday, October 20, 2003 8:12 AM
To: datastage-users@oliver.com
Subject: RE: Reading data from SQL-Server table
Anbu,
I had the same problem once, when I was using a reference link to an Oracle
table, but the column I was using as a key wasn't in an index. This made it
do a table scan every time it went for a lookup row and made the job very,
very slow. If I let it run over night, I would have 1000 rows or so when I
came back in the next morning.
Hope this helps,
Tony
David Barham wrote:
Does the job ever finish?
There are a number if factors that can affect how often the row count is
updated while a job is running, but once it is finished, the correct number
should be shown.
Source table locking shouldn't be a problem unless something else is
updating it at the same time. Does the job go back and update its own
source table?
Can you run the job by itself to removing locking as a possible cause?
-----Original Message-----
From: RAMAN ANBUCHELIAN [mailto:raman.anbuchelian@wipro.com]
Sent: Monday, 20 October 2003 9:45 PM
To: datastage-users@oliver.com
Subject: RE: Reading data from SQL-Server table
Its is primary link and the it show 0 Rows Processed from Source link in Job
Statistics.
Even monitor shows status as 'Running' and Number of Rows as 0.
Will it be a source table Locking?. Because, the same source table is used
by more than one job.
Rgds,
Anbu
-----Original Message-----
From: David Barham [mailto:david@barham.hm]
Sent: Monday, October 20, 2003 4:58 PM
To: datastage-users@oliver.com
Subject: RE: Reading data from SQL-Server table
Is it a primary input link or a reference link?
Can you give more information about your symptoms? Does a Monitor show no
rows processed after the job is finished?
-----Original Message-----
From: RAMAN ANBUCHELIAN [mailto:raman.anbuchelian@wipro.com]
Sent: Monday, 20 October 2003 7:58 PM
To: datastage-users@oliver.com
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.
***************************************************************************
**************************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.
***************************************************************************
---------------------------------
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
From: Tony Stark [mailto:tonystark622@yahoo.com]
Sent: Monday, October 20, 2003 8:12 AM
To: datastage-users@oliver.com
Subject: RE: Reading data from SQL-Server table
Anbu,
I had the same problem once, when I was using a reference link to an Oracle
table, but the column I was using as a key wasn't in an index. This made it
do a table scan every time it went for a lookup row and made the job very,
very slow. If I let it run over night, I would have 1000 rows or so when I
came back in the next morning.
Hope this helps,
Tony
David Barham wrote:
Does the job ever finish?
There are a number if factors that can affect how often the row count is
updated while a job is running, but once it is finished, the correct number
should be shown.
Source table locking shouldn't be a problem unless something else is
updating it at the same time. Does the job go back and update its own
source table?
Can you run the job by itself to removing locking as a possible cause?
-----Original Message-----
From: RAMAN ANBUCHELIAN [mailto:raman.anbuchelian@wipro.com]
Sent: Monday, 20 October 2003 9:45 PM
To: datastage-users@oliver.com
Subject: RE: Reading data from SQL-Server table
Its is primary link and the it show 0 Rows Processed from Source link in Job
Statistics.
Even monitor shows status as 'Running' and Number of Rows as 0.
Will it be a source table Locking?. Because, the same source table is used
by more than one job.
Rgds,
Anbu
-----Original Message-----
From: David Barham [mailto:david@barham.hm]
Sent: Monday, October 20, 2003 4:58 PM
To: datastage-users@oliver.com
Subject: RE: Reading data from SQL-Server table
Is it a primary input link or a reference link?
Can you give more information about your symptoms? Does a Monitor show no
rows processed after the job is finished?
-----Original Message-----
From: RAMAN ANBUCHELIAN [mailto:raman.anbuchelian@wipro.com]
Sent: Monday, 20 October 2003 7:58 PM
To: datastage-users@oliver.com
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.
***************************************************************************
**************************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.
***************************************************************************
---------------------------------
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.