DSXchange

Mark_E · Post by **Mark_E** » Tue Dec 07, 2004 10:38 am

hi,

i have an Oracle table which contains no data. however when i access this table through an OCI stage it returns in the excess of a million blanks. i am putting the OCI through a hash file into a transform. the reason why i am doing this is because at a later date the table will be eventually populated. my question is this why am i returning all these blank values. thanks in advance...

ogmios · Post by **ogmios** » Tue Dec 07, 2004 10:42 am

What's the SQL input query you use?

Ogmios

Mark_E · Post by **Mark_E** » Tue Dec 07, 2004 10:53 am

it is a simple select statement. no rows should be returned as the table is empty but i receive a million blanks.

ogmios · Post by **ogmios** » Tue Dec 07, 2004 10:59 am

Then something probably is wrong with your SQL. Go to Toad or SqlPlus and execute it there, do you still get a million blanks? Because that's essentially all DataStage is doing when executing such an SQL.

Ogmios

OCI

OCI

Re: OCI