DSXchange

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...

What's the SQL input query you use?

Ogmios

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

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