DSXchange

Just an FYI... you can go back and edit your post to correct spelling or other contextual errors rather than post a correction. Trust me, it comes it handy. You'll see it as an option at the top of the posts that are yours, along with the other options like 'Reply with quote'.

By 'batch job' do you mean a Sequencer Job or hand coded Job Control? In any case, the only part of the process that will 'prompt' you for values is the master / outer / batch job itself - and that's only if you run it by hand. It then has the responsibility for assigning values to the parameters u...

Hmmm... no. Or at least not directly. A couple of alternatives off the top of my head: Pass the Stage Variable out of the job using DSSetUserStatus. Write a routine to 'wrapper' the call to the function and other to execute your shell script and have the value it needs passed in as an argument. Use ...

Found this in the Release Notes for 7.5:

End-of-Data Row in IMS Stages
-----------------------------
The IMS stage now includes the option to add an end-of-data indicator after the last row is processed on the output link.

Why don't they spread a little more of that around, eh?

Oh, this message! You must have been planning ahead.

I'd be curious what you mean by 'compressed by Oracle'.

Errr... what other post? All I could find was one from April that Ray took a whack at. If you need more help you need to come back and continue the discussion!

It's already generated for you. Check out the System Variables @DATE and @TIME which represent the date/time that the 'job' started. Note that this is a constant value and would be used when you want to timestamp every row identically for the same unit of work. Also note that Best Practice say: use ...

I knew I should have mentioned that bit about the VOC pointer. Figured it was more of an 'advanced topic', so decided to leave it out.

I too have a routine to create one, if needed, but wasn't aware of the sorting trick you mentioned. Thanks for that!

I'd suggest going back and re-doing this using the Server installation / upgrade methodology rather than by using the package installer. Just found this in the 7.5 Release Notes: If the installation program detects plug-ins that were installed at a previous release, it upgrades them automatically. I...

Just got my hands on 7.5 and found this in the Release Notes: Change to operation of dsjob on Unix: ------------------------------------------------------- dsjob on Unix now outputs the return code to the standard error stream in all circumstances (this is true of the Windows version as well). On Un...

I doubt it. Latest version is 7.5 btw.

You can do it in your version, it's just not automagic. With 'only' four columns to pivot it won't be that bad.

Upgrade?

Build them yourself - write out four links from your Transformer stage. Either that or use a big goofy 'union' in your source query to bring four records into the job for every row in the source.

However, it's perfectly OK to use a hashed file stage to feed a stream input link. You will note, in this case, that the Selection tab is enabled, so that you can restrict the rows selected. Note that this is only true if the hash file was created in your Project / Account. A pathed hash does not g...

Pulled from the 'readme', 7.1r1 for HP/UX: New at Release 7.1 : Dynamic Relational Stage (DRS) ------------------------------ The Dynamic Relational Stage (DRS) provides users with the ability to access multiple vendor's relational databases for both reading and writing using native database client ...

Kindly let us know if there is any round about way to handle Update and Insert in a single job. It's already been mentioned by Sara123. I've used it extensively and don't have any 'locking' issues. The key is to use two links to a single target stage, not two seperate target stages. There may still...