Getting Error: data source is empty

sureshchandra · Post by **sureshchandra** » Mon Apr 07, 2008 4:07 am

Hi all,
I'm my source stage(ODBC).In view data i'm getting data source is empty.In my source stage i'm using tab user defined SQL query.
Pls help me how to resolve.

Thanks in advance

ray.wurlod · Post by **ray.wurlod** » Mon Apr 07, 2008 4:31 am

It's not an error. "Is empty" means that your query returns 0 rows. Try the same query using any other client (not DataStage) - you will get the same result.

If that's not what you require, you will need to review the constraints in your SELECT statement (or stored procedure).

sureshchandra · Post by **sureshchandra** » Mon Apr 07, 2008 4:43 am

Hi ray,
i'm sorry.Yes it is giving data source is empty.But while i'm running that query in QTODBC it is running fine.I'm getting the output.
Can u suggest me of what are the changes shoulkd i do.

ray.wurlod · Post by **ray.wurlod** » Mon Apr 07, 2008 6:23 am

Verify that the SQL being sent from DataStage is exactly the same as what you executed through QTODBC. You may need to involve your DBA to monitor the connection to establish what query is actually being received by the database server.

Also, please report whether you received any warnings or errors (not counting the "data source is empty" message) when you run the job.

keshav0307 · Post by **keshav0307** » Mon Apr 07, 2008 7:08 am

you can find what query statement is submitted through your job?

sureshchandra · Post by **sureshchandra** » Wed Apr 09, 2008 6:05 am

hi keshav,
It is a DB2 query.Which i pasted in ODBC stage.

ray.wurlod · Post by **ray.wurlod** » Wed Apr 09, 2008 6:37 am

keshav0307 wrote:you can find what query statement is submitted through your job?

Yes, it's reported in the job log.