DSXchange

Realizing this response is coming 7 1/2 years late: yes, I have seen this happen. I am not sure why, but it appeared in the last year or two depending one which version of Windows you run it on. I have revised the script to fix the problem and I have also added in functionality that was not part of ...

Hi Kim, Thanks for your input too. I had to stop using the KBA utilities because the version we have is for the 7.5.x and when we converted to 8.0.1, we started getting very flakey results on certain things. The decision was made by my boss and the admins to stop using them. I just haven't had time ...

Doesnt your job use a sequence? Are you not running it thru scheduler? I do have job sequences that control the work flow for processing each table. The interesting thing about the job sequences is that even though each step that calls a job is set to 'Reset if required, then run', it doesn't alway...

Thanks Gents for getting back to me with your input. I very much appreciate it :D Thanks too for the reminder of the DSJ.JOBFAILED & DSJ.JOBCRASHED values, Craig. I had forgotten about those. For some reason I tend to think at the file and script level over routines. I will do some digging and s...

Hi all, Here's the technical stuff to set the stage for the question(s): - Running DataStage Server Edition v.8.0.1 on AIX Unix. - Source and target db's are SQL Server 2005 and 2000 respectively. - The project is one code base parameterized to handle 22 separate companies. - The project was convert...

Once all of settings suggested by ArndW and JRodriguez have been implemented, wouldn't recompiling clear the logs? That is what happens when I recompile my Server stuff. Just wondering...

Hi Craig, I knew you would be the one to ask that question. :P I wrote this up late last night and I did not have access to our DS Admins to find out the specifics of the change that was made. I fully intend to get it and post it up, but they are all in company core meetings until the end of the day...

Hi all! Our Int system appears to have developed an issue with quotes around date parameters, in this case the #ProcessDate#. When cycles are running, many of these server jobs are failing with syntax errors that we have not experienced often. I have about 400 server jobs that have the same bit of c...

We had the same issue for a bit until I figured out the any use of the RETURN functionality of SQL Server returns a SUCCESS message to DataStage, regardless of what number you attach to it. The only way I have found to beat this is to use RAISERROR, with a severity level greater than 10. This means ...

How are you calling your stored procedure (Stored Procedure stage, ODBC stage, RDS stage, other)? That can make a difference in how it runs. I have been fighting through some of the same issues this last week, but my transactions are working, so I am wondering if there is a difference in how we are ...

Well, this is kind of hokey, but should work (I'm pulling this off the top of my head and have not tested it - so make sure you do that): Create a routine something like this: Function RemoveLetters(Arg1) Text = Arg1 Ans = "" LC = LEN(Text) For i=1 to LC Letter = Text[i,1] Tst = Num(Letter...

Hi Craig, I have been experimenting with the downcasing of the variable as it is passed in from the shell script and that part works OK now. However, I do still have another place that requires the upper case version in the same job. Changing the case for passing from the shell is no biggie, it is j...

Thanks Sanaith for the suggestion, but setting it up that way got me a file called: : downcase(LMC) : _int.csv Is there something I have to do to get the interpreter to actually process the function in this location, since it isn't a normal Derivation spot? Maybe enclose it in {} or something? I'll ...

Hi all! I have done some searching and haven't found anything like this question yet. If it is out there and I missed, I offer my apologies in advance. I have a large project that runs common code for 19 different companies at the moment (and growing). Everything that I can parameterize to make thin...

In my own project, I have SQL Server 2000 source and targets with DS on AIX Unix. I have mangled the Sybase Stage every which way I could think of to get it to work with SS2K since they are 2nd cousins about three times removed now. I never could get anything to work to any usable degree. As to date...