DSXchange

linkname.NOTFOUND manytimes doesn't work correctly with lookup stages other than Hashed File lookups. Unfortunate but true. It doesn't seem to work at all with the OCI stages, probably because they haven't coded them to support it. The only stage I used the NOTFOUND status with is a hashed file sta...

I don't think there's a number you can give that wouldn't vary from system to system. More of a threshold of pain... if your sort takes 'too long', try it from the command line. And what makes you think you can't sort a timestamp from UNIX? An ISO formatted timestamp is perfectly sortable, even as a...

Kumar - he asked about the option to Filter log entries, not purge them. Two different things.

This is all I ever get from it: $ pwd /opt/datastage/Ascential/DataStage/DSEngine $ ./bin/dslictool Standard License is in effect. Message[PIN0037] 8 CPU's licensed. DSSRV package licensed. No. Pid, Package Device name IP address Device sub-key 0 license seats are in use. 8 license seats are availab...

So, Arnd... are you of the opinion that the silly thing actually does work?

I know it should, but that certainly doesn't seem to be the case in my 7.0.1 version.

Yup, global.

Search is your friend!

Many more examples exist... and no, it doesn't work.

Dump the folder stage, it is really only useful for input... the XML Output stage has an option to create an output file.

First suggestion would be to find someone where you work who can help you with simple UNIX commands like this.

Second suggestion would be to start a new post as this one has been solved and we're moving off on to another topic entirely.

Is the datastage utility is not that efficient for huge date. May i know what is the difference between unix sort and datastage? At least a 10x speed improvement for the UNIX sort, from what I've seen on my system... HP 'Superdome'. And the UNIX sort can handle large volumes. Disclaimer: my experie...

Whereas i want to extract all the numeric characters from a alphanumeric string. Eg: string-> 123fre233 should return me 123 {numeric characters until first non-numeric character is encountered.} Just wanted to point out that 'all numeric characters' and 'numeric characters until the first non-nume...

Depends on if the metadata is the same for all three files or not. No - you'll need to process them one at a time. Yes - Folder stage.

From a private message, answering here so others can (hopefully) benefit: Hey Craig, Referring to your suggestion of using DSJobStartDate in stage variable and initial value rather than in Derivation,do you think the same is valid for constants. I am hard coding lot of constants of my target file in...

What is the end result you are shooting for? The Folder stage may not be the most... reliable... way to get a list of filenames, if that is all you are after. I would *guess* those two files may be 'too big' to process correctly through that stage. Have you considered using ExecDOS to list them usin...

Version shouldn't matter, the error is the same for 5, 6, 7... it should mean you ran out of space where you were writing the file. Is that not the case?