DSXchange

Define your ODBC system connection to MySQL and import the metadata that way.

Since it seems that the data content of the file isn't important, you can use Windows/UNIX utilities such as "wc -l" and "tail -1 <yourfile> " to get the information you want and process the logic from there. This can be done easily in a Job Sequence.

Yes, you can do this in DataStage. This assumes you use a Sequence to get the filename or list of filenames and then you can process this to extract the date. p.s. Please don't use ASAP in a post, it usually will cause any answers to be much slower. ASAP and URGENT are for paid services and usually ...

Amos,

I've used recursive functions quite often and they are quite fast. The CALL @Routine is a fast method, but will only work on SUBRoutines and not on FUNCtions.

There is a function called MAXIMUM which you might want to use, particularly if you need a MAX of more than 2 columns, otherwise stick with the simple IF-THEN-ELSE statement.

The DEL or DELETE command will remove a specific field, value or subvalue. You can use the GROUPSTORE command to do the same if the delimiter in the dynamic array is another one.

puli.reddy - it is fixtool, not fixfile! And the only other option is the old UVFIXFILE from the TCL environment, and you need to be DataStage administrator to run it.

Do you have your $DSHOME environment variable defined? If not, the program location is a `cat /.dshome`/bin/fixtool

The program is call fixtool and if it is not there you have an incomplete installation. You can always use the UNIX command "find / -file fixtool -print" to locate it.

The fixtool is in your $DSHOME/bin directory. When you run this program it will attempt to fix the file, chances are high that you will lose a group's worth of information or more but that the file will be useable after you run the fix. Since the DS_JOBOBJECTS file contains important parts of job de...

Craig, I did some testing a while back on the performance differences and the PCL does have a significant overhead when the routine itself only does a couple of actions. This is mainly internal overhead for pushing and popping off the stack. I just did a quickie test of a 1-liner routine call and do...

You need to use fixtool from a UNIX shell, not from inside the DataStage shell. The command is in your $DSHOME/bin directory in case you don't have that in your path.

Most likely your problem was triggered with a disk full condition, and if you still cannot create a file it probably still is full. Correct that first. Then you will need to go into TCL or your ADMIN tool. Run the command "COUNT DS_JOBOBJECTS" to see what, if any, error message you get. If you have ...

It seems that your settings for the $APT_DATE_CENTURY_BREAK_YEAR are such that this conversion works incorrectly. You can also specifically force a century for a 2 digit date by using %year_cutoffyy two digit year from year_cutoff (e.g. %2000yy)

Philos, Ray just explained it to you in his post. Just follow his suggestion in the designer.
If you have a straight derivation in all those columns you apply the TRIM($1) rule and -bingo- it is done for all columns.

The INDEX function is used frequently and has been very well tuned. It is also (algorithmically) quite a simple linear search for a substring so is easy to implement. The MATCHES function is much a more complex pattern matching function which has to parse the picture string into it's components and ...