Search found 307 matches
- Thu May 23, 2019 1:20 am
- Forum: General
- Topic: Useful Perl Scripts I have written
- Replies: 24
- Views: 37177
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 ...
- Tue Aug 03, 2010 6:21 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Determine which jobs have failed without using Director
- Replies: 7
- Views: 5910
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 ...
- Tue Aug 03, 2010 3:28 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Determine which jobs have failed without using Director
- Replies: 7
- Views: 5910
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...
- Tue Aug 03, 2010 8:08 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Determine which jobs have failed without using Director
- Replies: 7
- Views: 5910
- Mon Aug 02, 2010 4:15 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Determine which jobs have failed without using Director
- Replies: 7
- Views: 5910
Determine which jobs have failed without using Director
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...
- Mon Aug 02, 2010 2:44 pm
- Forum: General
- Topic: Too much space in DB XMETA db2
- Replies: 20
- Views: 14107
Just a thought...
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...
- Tue Oct 06, 2009 11:23 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Server Jobs appear to be dropping quotes from code
- Replies: 2
- Views: 3111
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...
- Mon Oct 05, 2009 7:06 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Server Jobs appear to be dropping quotes from code
- Replies: 2
- Views: 3111
Server Jobs appear to be dropping quotes from code
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...
- Thu Sep 24, 2009 10:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: stored procedure stage always returm 0
- Replies: 12
- Views: 5991
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 ...
- Wed Aug 26, 2009 4:11 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Help!!! Procedure Err when Executed from Datastage
- Replies: 2
- Views: 4738
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 ...
- Wed Mar 18, 2009 10:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data Issue
- Replies: 3
- Views: 2641
- Mon Mar 02, 2009 12:10 pm
- Forum: General
- Topic: Changing case of parameters on the fly
- Replies: 8
- Views: 5110
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...
- Mon Mar 02, 2009 11:18 am
- Forum: General
- Topic: Changing case of parameters on the fly
- Replies: 8
- Views: 5110
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 ...
- Mon Mar 02, 2009 9:44 am
- Forum: General
- Topic: Changing case of parameters on the fly
- Replies: 8
- Views: 5110
Changing case of parameters on the fly
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...
- Thu Feb 26, 2009 2:28 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Insert date value into SQL Server datetime columm
- Replies: 31
- Views: 26810
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...