Search found 307 matches

by jdmiceli
Wed Oct 15, 2008 3:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: abort after 50 warnings
Replies: 8
Views: 2154

If you use Ken Bland's job control architecture, you have full control with an entry in a .ini file. I think you can get it from his website, http://www.kennethbland.com/
by jdmiceli
Wed Oct 15, 2008 3:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Replace Db2 stage with Teradata stage
Replies: 13
Views: 8201

Please note: I glossed over your initial question of how to do it in XML. Craig's answer appears to work for both. My answer might work for both, but was primarily intended for the .dsx file comparison and changing. Your question actually just kind of spurs me to try and finish some smaller Perl pro...
by jdmiceli
Wed Oct 15, 2008 3:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Replace Db2 stage with Teradata stage
Replies: 13
Views: 8201

Craig is just going to love this... :shock: If you are Perl cognizant, I wrote a utility a while ago that will change parameters and the like within a .dsx file. That script is not limited to just parameters the way it is named. With little or no modification, you could use it in Batch (B) mode to c...
by jdmiceli
Wed Oct 15, 2008 3:09 pm
Forum: General
Topic: Useful Perl Scripts I have written
Replies: 24
Views: 37229

This will allow the user to change anything in a file, item by item. It says it is for parameters, but if it can be identified, it can be changed. It is also not really limited to .dsx files, but that is its primary purpose. Once again, follow the instructions in the header to use this utility. #!/u...
by jdmiceli
Tue Oct 07, 2008 2:22 pm
Forum: General
Topic: compile multiple jobs
Replies: 8
Views: 3306

You can compile the jobs from the command line of the client machine, but I have found the performance to be just as dismal as it is in the GUI. It can also be a little tricky to get it to work right. Dig in the documentation for the 'dscc' utility. Maybe you will fare better than I did... 8)
by jdmiceli
Tue Oct 07, 2008 1:11 pm
Forum: General
Topic: Migrating DataStage resources...a sort of poll
Replies: 20
Views: 8454

In case anyone is interested, I tried to compile some of my jobs using the command line interface instead of the V8.0.1 GUI and the performance is actually a little slower (at least in my experience). We will be opening a ticket with IBM about the performance issues we are having as they make develo...
by jdmiceli
Mon Oct 06, 2008 7:54 am
Forum: General
Topic: Migrating DataStage resources...a sort of poll
Replies: 20
Views: 8454

Will do. Thanks, Vincent! :)
by jdmiceli
Mon Oct 06, 2008 7:54 am
Forum: General
Topic: Migrating DataStage resources...a sort of poll
Replies: 20
Views: 8454

Will do. Thanks, Vincent! :)
by jdmiceli
Fri Oct 03, 2008 8:17 am
Forum: General
Topic: Migrating DataStage resources...a sort of poll
Replies: 20
Views: 8454

Are any of those scripting objects documented anywhere, Vincent? I have been having horrid performance using the v8 gui. I even boosted my local machine to 4 GB RAM and installed the client locally to get better performance than running through Citrix like we normally do. I saw some improvement, but...
by jdmiceli
Thu Oct 02, 2008 3:48 pm
Forum: General
Topic: Migrating DataStage resources...a sort of poll
Replies: 20
Views: 8454

WooHoo!!!

:lol: :D :lol:
by jdmiceli
Thu Oct 02, 2008 3:33 pm
Forum: General
Topic: Migrating DataStage resources...a sort of poll
Replies: 20
Views: 8454

hehe

Perl??? Did someone say Perl??

;-P
by jdmiceli
Fri Sep 26, 2008 7:43 am
Forum: General
Topic: Migration to Version 8
Replies: 13
Views: 5651

Hello all! If it helps at all, I am in the process of moving a large project from 7.5.1a to Version 8.0.1 right now. My first attempt at this with some older code went very well and I had no errors, but my testing was not extensive. It was just to have a little something to play with and learn the n...
by jdmiceli
Wed Jun 25, 2008 9:37 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How do i compare ??
Replies: 12
Views: 3148

Also, if the data is going to a hashed file, then the key value rows are simply going to overwrite each other as they occur. That is most likely not the desired result, but it is something to be aware of just in case.
by jdmiceli
Mon May 19, 2008 1:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Creating hashed file takes too long
Replies: 11
Views: 4918

If I understand you correctly, the minimum mod is 1 with a max of 999999. I don't see why you would need the admin tool to see this.
by jdmiceli
Mon May 19, 2008 11:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Convert data from LATIN1 to UTF8
Replies: 14
Views: 9760

If you aren't using NLS for whatever reason, the safest way would be to extract the data from LATIN-1 source and dump the data to a sequential file on a UTF-8 box. I think this will create the file in the codepage format you want and then you could bulk load the file to DB2. It is a one-off fix, but...