DSXchange

You can use either single or double quotes, so if you need to check for double-quotes in your string, surround it with singles: Index(CustomerLoad.NAME1, 'IMPERIAL COLLEGE - "ACTIVE ACCESS"',1) = 0 Make sure your logic is correct - if the expression equates to true the record will exit the...

Hmmm... then it seems your fate is firmly in the hands of your support provider.

OK, but are you certain the 'dsjob' being executed is the one that lives inside the 7.5.1a directory structure?

Sounds to me like you need to ensure you are running the dsjob command from the version you are currently "switched to".

No worries.

Wish I could help with the container issue, but I've got no clue at the moment, but perhaps someone else will chime in on that. Or it may be one of the many things I've heard they've fixed in the 8.1 release.

Yes, you should be getting the standard DataStage return values from the job: 1 = Finished OK 2 = Finished (see log) 3 = Aborted Etc. Can you check inside BMC what the actual return code is and verify that it knows a 1 is ok? Out of the box they typically want a 0 for success, from what I've seen. A...

Was wondering if the exercise was purely academic. Nothing wrong with that in the least, learning new stuffs is a good thing. I've never seen a need to clock one against the other, the normal lookup / overwrite process has always been a good performer for me over the years. Besides, we "path&qu...

Depends on the options you used in dsjob when scheduling. The -jobstatus option returns the 1 for OK you are looking for, without that a zero indicates success. ps. Got nothing to do with the fact that your job runs a stored procedure, this applies across the board to all jobs regardless of their de...

You need to be more specific. Sequence jobs easily handle parameters across multiple objects, jobs included. Other ways exist. What are you trying to accomplish and what specific issue are you having?

I prefer simply looking for whatever files are there on any given day and moving / archiving them elsewhere when complete. That way you don't have to worry about your date getting out of sync and you can process multiple files on any given day if need be. You may only need to track what days you've ...

As noted, in a proprietary "dsx" format. However, open it up as a text file and take a look at it, the format is very straight-forward and fairly easy to digest.

You won't be able to use the WFF stage with wildcards, only a static filename. You may need to build a loop to check, possibly in conjuntion with the Folder stage which does support wildcards or a script you leverage from the Sequence.

You're not doing anything wrong, I don't believe you can find the "system" tables like that. AFAIK, you'll need to manually do a "LIST.DICT DS_AUDIT" from the Administrator or a TCL prompt to get the metadata. That or we're both missing something.

1. No, they were designed to support exactly this kind of situation. 2. Yes. That's a trip across the network to fire a singleton query for each row. For small volumes you may not see it but it is about the slowest way to do this. 3. Check the "Key Management" routines in the sdk, particul...

Hmmm... three questions, all with the same answer: no. Not sure what's going on, but I'm curious - why are you going to all this trouble when you could simply do a reference lookup to the hashed file, get all of the current values for that key, update the ones you need and then write the entire reco...