DSXchange

What Ray says - don't write off Server jobs! There are some tricks and the burden falls back more on the designer of the jobs than letting it be handled automagically by the engine, but you can move some goodly amounts of data with it.

No. Your BASIC and/or Universe knowledge will help you when working with Server jobs. Technically, DataStage Server jobs now run under the "DataStage Engine" and not Universe as there has been a code-split and they are actually seperate products with a common ancestor, but for all intents and purpos...

Very high level... * A QA DataStage Project must be created for the jobs, routines, etc. * Use something like Version Control to do the actual migration of the jobs from the Dev environment to the QA environment. * Modify your Job Parameters to reflect the new environment. You'll need to do basical...

Don't really have time for the Full Wurlod, but in a nutshell... A routine is called by the job when it runs, so the disadvantage is the overhead of the context switching and the passing of the arguments back and forth. This can tend to become significant when dealing with large data volumes. The ad...

roy wrote:does anyone know/has any idea what might cause this?

Well, if I had to guess... because of a large transformation (with 53 stage variables)?

Seriously, I've seen this on occasion and never got a good answer as to what was going on. I'd call Support and see what they have to say.

Reading sequential file is not a problem but need help in declaring array and reading array to get elements and assigning values to array elements. I am trying to write BASIC statements to do the above and am doing this in the server job only. Answered in my first post... unless you have some speci...

Urk... didn't even notice the 'Parallel' bit. Sorry to give a completely Server based answer without noting it as such.

Search the forum for dynamic array and you'll find lots of examples like this one. Basically you'll find they are very easy to work with and use angle brackets to access specific elements. For example: MyArray="" ; *declared MyArray<-1>=Whatever ; *add an 'automatic' entry Whatever=MyArray...

kduke wrote:I hope at least Craig tries the DSaveAsBmp.bat.

Wha... err... sorry, was napping and thought I heard my name.

Is this off in your forum, Kim? I'll have to go check it out.

vrsraju wrote:But when I run the job, it fails.

Fails how? How is your OCI output column defined and what are the error messages you receive?

Jennifer, it is documented in the online help for Director. You can either specify it there when manually launching a job as you'll see a new input field for Invocation ID. In a Sequence job you'll see an input field for it as well in the Job Activity stage. When running a job from the command line ...

A quick search through my install shows a mention of this function only in the DSR_GETRTCONFIG.H file. This would lead me to believe it is part of the RTI services and therefore not available to mere mortals and Server jobs.

If you search this forum for add_to_heap you'll see that it typically means you ran out of disk space. Any chance of that?

Also, do you have Write Cache enabled for this hash? If so, try it again with that unselected.

It looks like you are writing NULLs to the key field or fields of a hash file. This is something you should avoid doing.

There was a discussion on ADN about the folder stage when someone had a very similar issue. Here is a direct link to the discussion for any members. The gist of the problem is this: It may be worth noting that the Folder Stage was officially designed for XML and had its original debut when DataStage...