DSXchange

sjordery wrote:You can take the option (d) (something else)from ray's given options.. Actually I want to assign values to the ENV from a job.

Umm... that's (c).

As noted, pass this value via a flat file or User Status.

Beat me to it.

It worked because everything is a string under the covers in Server.

What is the stored procedure doing? Something that's not possible in a DataStage job? Consider ditching the SP and rebuilding the logic into a job.

Otherwise, you'll need to script a solution as far as I know. Spool your output to a flat file, use that as your 'result set'.

Sure. You just need to find the separator you need for your email system. Probably a space but it could be a comma or something else entirely. Experiment. We are talking about the Notification Activity stage in a Sequence job, yes? Consider using a 'group' contact. That way one address can be used t...

Forget about my 'path' statement. You need to resolve the confusion about what exactly it is you are trying to accomplish. Ray posted a list of four possible meanings - which one is correct? Any? None? To me, it sounds like (c) which is the third item in his list and as mentioned, it is unsupported....

I know this might sound a little crazy, but - have you read the Parallel Job Developer's Guide pdf manual? Search it for 'schema file' and their use will be explained.

Isn't that (c) in Ray's list? If so, you're going to need to take another path.

There's a Full Wurlod here on the subject that a search may turn up. Otherwise, I'm going to go with - lookups, stage variables, constraints then derivations.

Do I pass?

Not sure what's going on. Check razor, project chulett, there is a single job in the Test category. Nothing except a transformer, two links and an OCI stage but it shows the Transaction Grouping information if you check the Transaction tab.

You use the 'T' for MS-SQL? I've only seen it for XML timestamps.

We can sit here and guess all day. I prefer to wait for the Shilpa to come back and clarify what exactly is needed. And what the target is.

------- ------- ------- ----------- ORAOCI ---> TXFR ----> TXFR ----> Seqfile ------- ------- ------- ----------- | /\ V | ----------- ----------- Hash file Hash file ----------- ----------- Ok, there's my hack of your ascii art. Depending on what you mean by 'work' the answer is either yes or no. ...

Huh - if you have multiple links from one transformer to one OCI stage, then the Enable transaction grouping option will appear. When you actually enable / check it, the 'big grey area' will fill with the Input Link Names with the On Skip and On Fail settings per link. Is that not working for you?

I know that issue has been discussed before, don't recall the resolution. Search the forums for 'file name column' and see what turns up.

Define 'back up the DS Server'. Filesystem level backups are possible using 'normal' backup software. There are client side batch scripts available that will automatically export all projects on a server which you can run as a scheduled job. If you are looking for the latter, download the backup scr...