DSXchange

The general consensus seems to be that it doesn't work. I was blissfully unaware since I have only tried it on two installations and it has worked on both. I'm positive that I used a job parameter for the email recipient (there is no way that I am going to hard-code my email address into the notific...

I ran into this a while back ( I think it was on version 6 with the OCI9 stage). Without NLS enabled, it seems like the OCI stage only deals with 7-bit ASCII characters. Whenever I tried to use a character above a CHAR(127), what ended up in Oracle was always 128 less that the intended character. Fo...

I'm pretty sure that I've used job parameters in the email notification activity successfully in both versions 6.0 and 7.1. I can't check at the moment to see how I got it to work. I seem to recall that it didn't follow the usual enclosing within #'s. I think I used the parameter as emailSendTo inst...

Num("3,990") evaluates to false, so you took your else clause. Num does not consider the comma as a numeric character.

I'm no network expert, but I'll hazard a guess.

What is the second node of your IP address? Addresses like 192.168.xxx.xxx are non-routable. If there is a network router between your SQL Server database server and your UNIX DataStage server, then that could be your network problem.

Mike

Tom, Sorry, I just reread your post and it looks like you might have actually been asking about how to write the final value back out. Just create an extra flat file as an output from your transformer. Put in a constraint so that it only gets written to when you hit an end of file condition on your ...

Tom, It's been a while since I've done 390 work, but from memory: 1) Go to the Parameters tab on the Job Properties page . 2) Put in a DD name (e.g. JOBPARM) 3) Put in the GDG dataset name (e.g. MY.GDG(0)) 4) Fill in the parameter names in the grid. These parameters should be available to use in the...

Hi Tom, I've used a GDG dataset as a parameter file for surrogate key management. Job reads gen 0 to get the starting value and writes the last value to gen +1 at the end. Use a stage variable in the transformer to increment (i.e. NextVal = ParmVal + NextVal + 1). NextVal is initialized to 0, and re...

How about the DS Macros: DSJobStartTimestamp, DSJobStartDate, and DSJobStartTime? Do these behave similarly? The names imply that they are at the job level, but are they really?

Thanks,
Mike

Hope my reply isn't too late. I'm an infrequent visitor. This sounds eerily similar to a problem I had a few weeks back. I had an aggregator that was producing output that was exactly 1 record short. I happened to be passing the source data through a transformer prior to the aggregator (source -> tr...