DSXchange

Hi,

I have a simple job which gets data from a DB2 table and creates a hash file.

The job fails and when i try to see data in the DB2 stage

It throws an error HY090

What cud the possible problem be?

Thanks and regards
Lucky

Hi,

How to check if the data is loaded into database with querying the database after running a job which loads data into database

I am getting this error whenever i use the user name of scott and related password but this works fine when i use the system account and specify the table name as scott.emp Oracle_Enterprise_6: Access to sys.dba_data_files required but not available. Please see your dba for select privileges Thanks ...

Thanks guys

The workaround works

i am trying to remove duplicates using remove duplicate stage on the emp table using scott user

but getting an error like this ... please provide me a work around for it

Sequential_File_1,0: Field "COMM" is null but no null export handling is defined

The problem was with the TNS name

Its resolved now


Thanks for the support

i can place it but not able to complie the job ..it gives an error

saying : unable to identify the connection

Not able to use Oracle OCI stage in a server job an odbc in the same place gives perfect results but slows down the process