DSXchange

Please let me know if it worked or if there is something I can do to improve the script. I am adding this to my directories of utilities I have written. I have also added it to the open topic I have for Perl scripts I have made available for anyone to use. I figure maybe having a bunch in one place ...

This script will take a text file and pivot the values on the first field. It assumes the header is the first row of the file and that the first field in each row is the key. All you have to do is put the program in the directory where your file is (or vice versa) and pass it the name of the file, t...

Hi Dave (and anyone else that may be interested), I have a potential solution to this problem for you to try. You are welcome to use it as you see fit and modify it to suit your needs. If you don't have Perl installed, go to Activestate and get it. It is standard on any Unix/Linux install and I wrot...

How many rows are you working with? 100,000 per minute is pretty slow especially if you are working with a significant data set. I'll try to put something together for you in Perl real quick and see if I can't improve on the speed. Any chance you could send me the file winzipped? If so, send to jmic...

Hi Dave, Stepping outside of DataStage, you could use a Perl script to do this for you. If it were programmed correctly, there would be no issue with changing parameters AS LONG AS the first field is always the KEY. The Perl script would then just create a new file for you with the pivoted values. I...

Is it possible a temp file is being built wherever tempspace is defined for and that it will not flush to the destination file until the entire process is finished? I would think there would be buffer writes if this were the case, but maybe for some reason it is doing the whole there. Just a thought...

If you change the field length, I think you also have to change the Display length. DB2 defaults the format of timestamps to YYYY-MM-DD HH:MM:SS.mmmmmm (I think). If the process is converting that to char or varchar, then you need more than 18 or you will truncate. Don't know if that helps or not! :...

Follow this link for a Perl parser that should have no show stoppers (famous last words of course!):

viewtopic.php?t=113429&highlight=perl

Bestest!

Here is a link for a bunch of Perl scripts I have written, including a cutter, joiner, and parameter block replacer. Feel free to use them!

viewtopic.php?t=113429&highlight=perl

Bestest!

Hi Gents! Doing this in Perl would not be too tough. :? Notice that I say that without actually having more than what I see here. It would probably take any hour or two to come up with something that could parse that formatted file into the structure you want. Would you want to drop it into a sequen...

This thread has multiple utilities to work with .dsx and other files (in Perl):

viewtopic.php?t=113429&highlight=perl

I hope it help!

Bestest,

This perl script is great when it comes time for a team like Release Management to release your new code to a different environment. This may be needed to change your default parameters for all jobs in the export file (unless, of course, you are using one of a several job control methods where you p...

Here is the last scripts opposite, turning dos files to unix terminations. Usage is perl dos2unix.pl directoryname . #!/usr/bin/perl -w # A script to convert Windoze files to Unix line termination format. # WARNING: THIS SCRIPT DOES NOT CHECK FOR PRE-EXISTING # FILE, USE WITH CAUTION # usage: dos2un...

This perl utility is a simple unix to dos converter. I wish I could take complete credit for it, but it is a pretty basic item and most of the code is lifted from a book (though I don't remember right off which one to give proper credit). Just know I am not claiming it solely as my own, though I did...

I also do a lot of table name extraction to a file or whatever and then use VI or Vim to do substitutions to add the rest of what I want in front of and behind the names. Sometimes I forgot to order things, so I wrote this little sorting script with the option of sorting ascending or descending. Thi...