DSXchange

Hi all, I am using ODBC stage to extract data from oracle for lookup. Here In user-generated query, I wrote a query ... Select column a. column b, new coulmn where (coulmn c=?) union all Select column a. column b, new coulmn where (coulmn d=?); Iam getting an error : [datastage][SQLClient][ODBC][Dat...

Link: link_name, 0 rows, last error=2006-06-12 08:50:36\job_name..hashfile_name.link_name: WriteHash() - Write failed for record id 'XXXXX'

This is the error format for each record.

While running a job which creates a hash file of data in a oracle table, listener was down.When I restarted the job after solving the problem, I got warning saying write error for each record.

But the job was running fine earlier.

Can anyone help me

thanks

Hi all,

Anyone can tell me, how to run a datastage routine from unix shell script

Thanks

Can anyone tell me of how to write data to a file in universe database using a hash file

Thanks

You can also use a hash file.

Load required columns from the oracle table into hash file.Enable preload memory option in hash file which helps in performance.

As the number of rows is 130,000 using hash file is not a big problem.

You can use the following derviation in the transformer

TIMESTAMP(Iconv(date column,"D DMY[,A3,2]"))

It works....

TIMESTAMP is in DS Transforms/built-in/date

You can use the database stage as reference link with where clause in select statement. Or if you want to do aggregations in the reference stage u need to use groupby and having clauses.

I think u need to use loop condition while running those jobs using a shell script. In that, run the first job and then for each row of the output file run run the second job.

kumar

Hi All, Iam running a job which extracts data using a hash file from universe database(data is in different partitions) to load into a sequential file. In hash file after giving details of the partition, columns, When I entered key column value in Selection tab for extracting a specified single row,...

Hi All, Iam running a job which extracts data using a hash file from universe database(data is in different partitions) to load into a sequential file. In hash file after giving details of the partition, columns, When I entered key column value in Selection tab for extracting a specified single row,...

Same error is shown while trying to view data....

And one more, Job is running even after I stopped it from director.

I tried using compile option in designer ..

In director their is an option called clean up resources which helps to kill a job. But I couldn't understand the procedure of it.

I am creating the file in the same job.........

It worked fine last day before i reset the job........

But The job is reset. it shows the error

DSD.UVOpen Unable to open file

I even tried by deleting the files which are created and started from first ..But no use....

I am running a job which loads 5 hash files from a single oracle table. Job is aborted. Reason I found in director is 'it couldn't open hash file'. The path I gave is correct. The same thing is happening in another job where iam loading a hash file from a sequential file. Here it is unable to open s...