DSXchange

7.5x2 is a Windows version and is quite old and... quirky. Surely you've got something more recent for UNIX - 7.5.1A, 7.5.2, 7.5.3 if you haven't gone to 8.x? And the change in behaviour is understandable now that you are fundamentally changing the O/S at the same time - sendmail is used for all UN...

Can someone tell me how the DSSendmail routine is different on enterprise 7.5 from server 7.1 and if there is something I can do to make this look correct? I really don't believe there is anything different as it's just an interlude to sendmail as the O/S level. For grins, what exact 7.5.x version ...

If the proc doesn't return anything, then I don't believe you can use it as a 'source'. If you just need to call it, then create a job that starts with a Transformer and point it to the ODBC or DRS stage that calls the proc. You'll need to create a 'dummy' stage variable in the transformer so the jo...

Right, sorry - Row Generator, that should be fine. Make sure it only generates 1 row, however.

Oracle may be converting the spaces to nulls and not PX, if that's the case then you can set APT_ORACLE_PRESERVE_BLANKS to true to stop that from happening.

So a failure trigger from the WFF stage to the job in question. I believe you can use a Column Generator as the first stage in your 'sourceless' job to generate the static value you need.

Just... update it. You'll need to supply something in the way of 'key' information so the job knows what record to update. What part are you having problems with? What job status are we discussing here? How will you check / pass it?

Do you have anything like a specific question?

Sorry, don't know beans about SQL Server. And I don't see how a difference in calling 'tools' can alter the behaviour of the proc, assuming they are called in the same manner by the same user.

I believe you'll need to fall back to the O/S for that. For Windows, perhaps a 'dir' with the '/tc' and then the '/tw' option, parsing the results.

Yes.

Have you configured ODBC for DataStage? Meaning, are you sure the 'correspoding entry' is correctly set up? Note one is in $DSHOME and the other is in the Project.

ans for ur que is (you r using jobsequencer in that u have 5 jobactivities if the job aborted after 4 job u can run from 4 onwards but if u want to run again from 1job or 2 job then u have to enable that option then the sequencer will run again from wher u required) Good Lord, do you send emails at...

The TX product might have something specific but here you'll need to roll your own. From Googling, 'HL7' is Health Level 7 and the answer looks like it will depend on what version files you have to process. Version 3 seems to be XML so should be possible. Version 2 "mostly uses a proprietary (non-XM...

Did you try searching the forums? This error has been discussed here, try searching for "Error setting up internal communications", see if any of them help.

As noted, you first need to determine the bottleneck. Split the job, land the data. Tune both halves individually. Use a hashed file to determine inserts v. updates. Consider a bulk loader for the inserts and possibly the updates as well.