DSXchange

You must source dsenv into your environment before running dsjob from the command line:


Then try your command again.

Mask <> encrypt. If all you need to do is mask the first five digits so it looks something like this:

***-**-1234

Then just substring off the last four digits and concatenate that with the 'mask' for the first 5. Just don't expect to be able to 'unmask' it later.

If you don't need to keep both around intact afterwards, you could just write the contents of one into the other. Or just use a Link Collector.

Start by searching the forum for 'Record too big to fit in a block', others have posted the same question in the past - see if anything there helps.

Then don't suggest it.

Two jobs, run in the proper RI order by a Sequence job or using whatever you've got for job control there.

Post the entire message. Unless things have changed in 8 there should be a numeric code reported as well.

ArndW wrote:Some more details on the stage types involved in the source and target would make solving the problem a lot easier as well.

Any details, actually.

do i have to install the plug-in stage on the new server where i intend to run the executable when you migrate jobs to another server, any plugins you've used in the job must have been installed on that server. They will not transfer with the job itself. Asked and answered. Use a plug-in in a job, ...

ArndW wrote:I suppose that this is one way to rack up some serious points.

How are you managing to double-post all over the place here Arnd, every one several minutes apart? Curiouser and curiouser...

Could you perhaps split or partition your data on this FILE_ID field? Or build some sort of iterative process? Also be curious how many discrete values you'd have in that field in a typical load.

My doubt is in some jobs when i run the second job the first job is internally called. Not sure exactly what this means, but why not use a Sequence job to tie the two together? Or merge the hashed file build logic from the first job into the second job so you only have to run the 'second' job and i...

Not sure what you are asking. There's an entire section on reject handling and constraints in the help which would walk you through the various aspects of this. Your warning that is being logged is an artifact of selecting the 'Reject Row' checkbox. The behaviour of what gets rejected can change if ...

Welcome! :D

I don't see why not, but you'd need to be more specific in your needs or questions. Examples are always good. Are you familiar at all with creating XML with DataStage?

I kindly suggest you take your error string "Unable to load subroutine on host (30105)" and do an exact search of the forums. See if any of the other posts where people have had this exact same message help you at all.