DSXchange

Hi Team,

How to perform RANGE LOOKUP In server job, without using Enterprise or UV stage.

Thanks In Advance

I ma trying to load data from a file into a Netezza Table. The job is getting aborted with the fatal error : Table loaded Successfully. When I queried the table, data is getting loaded there, but the job is getting aborted . Please find below the error messages from the Director Log: Netezza_Enterpr...

Thanks Mobashshar for the reply. We are using nzload in all our jobs. Still to give it a try, I changed the option to ET and it did not create any External table.

Can there be something else causing this issue?

Thanks Again!

Hi All, We are using Datastage with Netezza Combination. We use Netezza Enterprise stage to load data in Netezza tables. While loading data, Datastage creates external tables in between the process. These tables have names starting with 'NZORCH'. Even after the process finish successfully, DS do not...

That's true. Having identical parameter set is pre-requisite. Probably thats why, when I re-loaded parameter set, it fixed the problem.

But in one of the sequences, I saw that disabling "run time column propagation" fixed this error



Thanks for all your valuable suggestions!

Thanks a lot.... this works!
Just reloading job definition in job activity, reloading parameter set and disabling run time column propagation did the trick.

Thanks much for your help!

Thanks for your suggestion. I made the changes and it worked for few sequence, but for other I am still getting following error: " Controller problem: Error calling DSSetParam, code=-3 ParamName does not reference a known parameter of the job" Here is the problem and the steps I took to de...

chulett wrote:So Ray was the only person that replied, eh? Nice.

Not like that I am always thankful to DSXchange for providing their suggestion.

Thanks to all as always!! :D

Hi Ray, Thanks for your reply. I think I am stuck with a big problem here then. We have created a project level parameter set where we have created all the parameters which we are using in any job. For example I have 10 jobs. If every job is using one parameter then all those parameters are created ...

Hi, I am creating a sequence and when I set Parameter value as SetTodefault I am not able to change the value of any parameter at run time. However If I change this option to 'Insert Parameter' my sequnece aborts with a warning "Error calling DSSetParam(iConnect.JPM_WK_SAP_XREF_FILE_DT), code=-...

Hi All, I am trying to load one Flat file toNetezza database. In flat file, I have a column as Varchar and in Target the datatype of column is Integer. I am not using any function for explicit conversion in between. Now if I have data as 1234, it gets loaded correctly. But when I have data like 'abc...

Thanks Ray.

Hi All,

I was trying to run a job in Datastage 8.5 Enterprise Edition and could not see limit number of rows option enabled while running. Is this feature only in Server edition?

Thanks.

It does support link ordering. The link you connect first will be executed first. It does not work though when you set link ordering through Transformer stage -> output column ordering setting.

Any thoughts why??

Thanks for your reply. For link ordering, I opened transformer and moved the delete link to the top with Array Size of 1 and a Transaction Size of 1. But when I run the job, it deletes all the records. Here is an example of current scenario Src File ID Name A1 Abc Initial Load into target Skey ID Na...