DSXchange

Generally we have the option for use account name if we dont want to mention the path name. The Account name generally describes just the structure of the data(correct me if i am wrong!) but not the physical data as such. Then in that case, where does the data actually reside when we use the Accoun...

Make sure you are filling out the Invocation ID field when running it, otherwise it is just running as a 'normal' job.

Strange coincidence, but someone posted the same question earlier today on ADN. If you are registered over there, click here to read that discussion. I've seen this once before. I forget which 'number' hash file type this is, but it can happen when the hash gets corrupted (or fooled with). Not sure ...

Now, if my memory doesn't fail me, you CAN use DS logic in the parameter assignment field Nope, 'fraid not. That's why we tend to do everything in one parameter value which can easily be set in a routine and passed into a downstream parameter by a Sequencer. Unless you are writting your own job con...

However, keep in mind that 7.5 and 7.5.1 are the same release, other than a maintenance type update having been applied to the .1 version. Going from 7.5 to 7.0 is a whole different kettle of fish.

No, you can't go 'backwards'.

Now, we could get into a long discussion of features unique to 7.1 or 7.5 and jobs that only use functionality found in 7.0, but I find the simplest answer is usually the best.

No.

I would think sed would be a better answer. Takes all the normal regular expressions, so something like this perhaps? sed -e '/^$/d' -e '/^ *$/d' filename Off the top of my head, this should remove blank lines and lines that only consist of spaces. Exact syntax may vary from UNIX to UNIX. Output wou...

Depends on what you mean by 'use'. Account is synonymous with Project. Common practice when using hash files in an Account rather than a specific pathname is to leave the account name blank. This means 'the current Project' the job is running in. That way you can move the job from your development p...

As you suspected, you can't do any IF-THEN-ELSE logic in your sql. It must be legal DML for the database in question, not any sort of procedural language, DataStage or otherwise. Another option, one that we typically use when we need to do something like this, is to replace the entire 'extra' portio...

Use a single trigger. Link to the move activity and then to the notification and do the abort routine last. In other words, run them in a serial fashion, not in parallel.

Run the UNION statement (without the INSERT ) in a single source stage using custom sql. Make sure your columns defined in the stage match the output of the union. From there, link that to another stage to do the actual insert into the target table.

I'd think it is related to the fact that 'Viewing' data in PX involves cranking up an instance of the engine and running a small osh script to do the work. That was why there was a delay in the process when we viewed data in class. It's not Server where it just calls a little viewer executable. That...

Welcome aboard.

Unfortunately, the answer is 'no' - nothing other than the pdf manuals that install with the Client software on your local pc. Well, other than the official Tutorial with accompanying documentation which (if I remember correctly) ships on a seperate cdrom.

Search is your friend.

Try this post.

Ray, I got the impression that Bryan was saying the message was there but there was nothing other than that particular message itself. No gory details. I don't recall it working that way. It only shows up when it has something from the Phantom directory to pull into the log. No information there, no...