DSXchange

This is likely because your $DSHOME/dsenv file has not the correct variables such as shared library path set.
Try reading the client plug-in installation and configuration pdf documentation installed with your DS client.

Or search the forum. This has been covered before.
Good luck,
B.

I know this not what you are planning...
but sometimes different approaches are helpful.

Could you write to a staging table, then, if the job completes successfully, you can move data from staging into production. Otherwise truncate the staging table ?

B.

I am using version 7.1 I have a job that selects from database and looks up a hash file with 3 key columns plus a lookup column. The hash file was built from a database select and in some rows, one of the key column values were null. some of my select result:- (note the last 3 values are the key col...

kduke wrote:I guess my answer was too direct or too short. I wanted the shortest answer. How'd I do?

"Likely" instead of "Probably" might have been shorter

Gold star to trammoham for the longest

Yes you are all correct it was because the col was null

So does setting an input column's 'Nullable' property to 'No' have no effect ?

I have a job with a transformer which takes in 907,124 rows. it has two outputs, both with constraint on non null char(1) column. The 1st has constraint input.colX='5' The other has constraint input.colX <> '5' The output counts are 814,682 and 60,142 respectively, which add up to 874,824. This is a...

There are two other techniques that may be appropriate to loading Oracle, depending on your warehouse design and the data you need to load. 1) External tables Similar to sqlldr, but with additional ability to transform and perform queries on the data while loading. Additionally, a parallel option ex...

Thanks Ray. Got the pdf. Will take a look at the ds_metadata.

A good reference that desribes the VOC file is the UniVerse System Description which can be downloaded from the IBM web site. Hi Ray, this seems to have moved and when I search the IBM site for something, the best I can get is a publication they want $45 for. What Im looking for is a reference that...

Does it need to be a bubble sort for some reason? Windows has built in sort filter command. If you had your array in a file (or put it in one) like infile.txt... You could have a prejob something like: - sort < infile.txt > sortedfile.txt Then in your job, pick up the sequential file sortedfile.txt ...

Hi all, as posted about 'elsewhere' recently, sometimes the client tools give errors like Error calling subroutine: DSR_EXECJOB (Action=5); check DataStage is set up correctly in project <project-name> (The connection is broken (81002)) Error calling subroutine: DSR_PROJECT (Action=7); check DataSta...

there is another job I have to modify but I'm still wondering if I can do it in DS job. I have 1000 person_id in a file and 3 ao_code in another file. Each ao_code has its weight. For example: ao_code weight ______________ 901 1 902 2 903 3 After the caculation,1/6 of 1000 person_id are assigned to...

One of our team has *ahem* removed a directory that was a datastage project directory, bypassing the administrator tool. :evil: When attempting to run a job that writes a hashfile in an account of the same name (ie oneview), I got the error "CpSubPricePlanExtractEnd..CHashedFileStage11.DSLink12...

Are you using unconditional triggers?

The conditional triggers can be used to determine if an activity succeeds (or fails etc) which implies waiting for a result.

And the read only issue in our production system can be worked around using the multiple job compile :) Don't believe so. From what I recall, you'll go through all the motions and then every compile will fail because the jobs are read only. :? You need to repromote them. All. Well it compiles them ...