DSXchange

Thanks Ray for your suggestion.

Thanks, but the characters that i need to suppress are more that those .Anything thats not an English letter or a number should be suppressed. Input will always be ascii text only.( not unicode)

I have a requirement to extract only the alphanumeric data from a string. Non alphanumeric data ((!@#$%^&*().etc) should be replaced with empty String. I havent been able to efectively use Oconv() for this. I wrote a routine which seems to work. One more piece of info : No nulls are expected in ...

Thanks Craig . We found your reply helpful. Will probably use a very similar approach, albeit the differences in our peculiar situation . FOLDER(with chunk as wildcard)--------->TRX(concate chunk with end and start tags)--------->SeqFile(named as XML file) I dont know if this will also hit any limit...

Thanks for your reply craig. But i guess there's no way i can match up the contents of the nested chunk with my input data. I just wanted to know if there was a size limitation on the nested chunk. My other option would be to use a shell script to concatenate the contents of the nested chunk with an...

Im having a job that writes some data to XML output pack stage. Apart from writing some dat to XML output pack, im also including an XML nested chunk in the XML o/p stage using nested chunk option by specifying file path of nested chunk.The chunk can be rather large (40 MB)or very small (200 KB or l...

Strange But True
I have DataStage installed on Solaris and i still get ExecDOS in before-After routines,and Of course ExecSH is there too. However i dont get ExecDOSSilent. Is that a bug? EE Ver 7.51A.

What i encountered was that errors generated while using functions in modify stage were far more difficult to correct and took many iterations.I almost gave up on PX when confronted with modify stage :( . On the theoretical side , im however led to believe equivalent code/transformation done by modi...

this is what i did to add a sybase ODBC DSN in my system added this entry to .odbc.ini ( IN $DSHOME directory) [car] Driver=/app/ascential/Ascential/DataStage/branded_odbc/lib/VMase20.so Description=DataDirect Sybase Wire Protocol ApplicationName= ApplicationUsingThreads=1 ArraySize=50 Charset= Curs...

Alas, im not controlling the censor software. Nor am i asking to stop linking to other sites, the only thing that a poster can do is to indicate external link, so that the one who browses the thread decide at his discretion to open the link or not.NO saying when the IT security department decides it...

I very well assumed it would be a harmless site ,even probably one of your blogs,but the one thing we can possibly do hence forth is to indicate external link. I got a crazy pop up warning me about the 'hazards' of accessing non business content. I couldnt access dsxchange from a previous client's i...

If anyone posts a link to NON IT or non business content , please mention it clearly. One of the links posted on this thread was considered inappropriate content by the proxy server in the company. This erodes member's trust in the forum and will potentially compromise its value/trustworthiness. Tha...

deleted

as noted You cannot Use DSJ.LASTIMESTAMP, it is DSJ.LASTTIMESTAMP. And you do not use it from the transformer stage derivation within that job. When job executes the transformer, it hasnt yet completed, so how can you capture its end time within a run? You need to have a routine that attaches the jo...

im addressing VSI's original query here I feel you cannot get the end time of a job within a job itself, because the job run cycle would not have completed . You would need to write a routine that attaches the job , and reads the job info , using DSGetJobInfo, after the job has completed a run. I us...