DSXchange

Thanks, chulett. I was already using DSSendMail which I believe through the dssendmail_template.txt was using dssmtpmail.exe. I tried seeing if I could get dssmtpmail.exe to accept a cc. But I couldn't find any documentation and none of my guesses worked so I gave up. I eventually switched to blat a...

I only saw one post on cc-ing, but there was no real response to it...

Is it possible to send an email and include a "cc" ? I need DataStage to send an email to another application that requires a "cc" in certain situations.

We are using Director to schedule the jobs.

Our jobs tend to have a lot of parameters, from file locations to passwords all of which need to entered when we schedule a job in production (because the defaults are usually the values we use in development and that's the way we want it). After we schedule the job, we don't have to worry about ent...

I've got a job that runs fine in our production environment and obviously worked fine in our development environment (before we moved it to production). Now, when we go back to dev to run the job for the first time in a couple of months, we get the following errors: ADPDS_IMPACT_FINTAX..IMPACT_FINTA...

Actually, now I'm wondering if the problem is just when the routine is linked directly to the EndLoop. I took out my dummy routine and just put a sequencer in between the EndLoop and the Routine. It still seems to be working.

I was beginning to think I was going insane, so it was nice to hear that chulett has run into this too. That prompted me to stop trying to fix it and instead look for a workaround. Again, keep in mind that it works perfectly if there is no loop. But as soon as you add the StartLoop and EndLoop activ...

:) I did do something similar... the results of the call spit out: Found 0 instance(s) of NEWMTH in D:\Ascential\DataStage\Staging\IT_Tracy\Exports\ADPDS_RECEIVABLES_JS\ADPDS_RECEIVABLES_JS.INVOICEDETAIL.CURMONTH where "0" is the value that's being returned from the routine. Also, in the l...

Thanks for your reply, ArndW. I can't see the whole thing, but I did try to put "CALL DSLogInfo()" into my routine to see what the values of the variables in it were. Everything looks fine to me. I really don't understand it. If I remove the StartLoop and EndLoop activities, it works prope...

I've got an interesting situation. I've got a routine that returns a number. In this particular job, I expect that routine to return either a 0 or a 1 and therefore I have triggers: Return Value - (Conditional) = 0 Return Value - (Conditional) = 1 Otherwise This seems to be working fine until the ro...

I seem to have got it to work by unchecking the "Create file" box and then deleting the files/folder on the server associated with the hashed file. I honestly don't understand why it works like this and why it didn't work the other way, so if anybody has any insight, I'd love to hear it. I...

Yes, I am clearing the file... actually deleting and recreating the file. I'm also noticing that when I monitor it, it's showing 1 record going into the hashed file and 3 coming out. It doesn't make much sense.

I have created a sequence that does the following: 1. Calls a job that creates a hashed file that contains a single record... it basically just holds an id (like customer number) and a "key" which is hardcoded to "DUMMYKEY". 2. Calls another job that selects data from the databas...

Thanks for the tips. I didn't even think to use the import feature. I went ahead and did that and in case you are wondering, the NUMBER comes out to Decimal with a length of 38 and no scale. I'll stick with that.

We generally use DataStage to move data from sources to Oracle. In Oracle, it's my understanding that there are different NUMBER data types: NUMBER(6) would allow six digits max. I think that may mean 6 total including decimals, so you could have 4 before the decimal and 2 after, but not more than 6...