Search found 307 matches
- 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
- 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...
- 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...
- 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...
- Tue Oct 07, 2008 2:22 pm
- Forum: General
- Topic: compile multiple jobs
- Replies: 8
- Views: 3306
- 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...
- Mon Oct 06, 2008 7:54 am
- Forum: General
- Topic: Migrating DataStage resources...a sort of poll
- Replies: 20
- Views: 8454
- Mon Oct 06, 2008 7:54 am
- Forum: General
- Topic: Migrating DataStage resources...a sort of poll
- Replies: 20
- Views: 8454
- 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...
- Thu Oct 02, 2008 3:48 pm
- Forum: General
- Topic: Migrating DataStage resources...a sort of poll
- Replies: 20
- Views: 8454
- 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
;-P
- 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...
- Wed Jun 25, 2008 9:37 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How do i compare ??
- Replies: 12
- Views: 3148
- 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
- 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...