DSXchange

I encountered this problem before with the Aggregator stage on 4.2. I think this stage has got a memory leak problem. I once filed a case with Ascential tech support but didn't pursue it because I was not able to send the test data to them... perhaps, you would want escalate your case to them... You...

Hi Johnno,

Please try the following...

1. Open DS Director
2. Highlight your job
3. From menu, click Job then Clear Status File
4. If the file still shows "Running", open it in DS Designer and re-compile

Hope this helps... [:)]

vladimir

Hi srsr, Here's a nice trick you can do with sequential files having headers and footers... or with different record layouts, in general... 1) Normally, the header records and footer records will not have as many columns as the file details records. In the sequential file stage, while reading the fi...

Hi ND,

You may contact Jane Lim, Ascential's Sales Director in Southeast Asia (jane.lim@ascentialsoftware.com). They conduct regular courses in Singapore including the advanced courses.

Cheers,
Vladimir

Hi Rajan,

Another altenative is to use the FMT() function, e.g.

FMT(DateDiff, 0)

Cheers,
Vladimir

vladimir

hi Stephan, pls use all upper case for DSX.UTILITYHASHLOOKUP. if this doesn't work, pls 1. check if this SDK function is compiled 2. check in the directory DSU_BP.O under your project directory if it exists (take note of the case) i tried in my machine and it works. i'm using DS 6.0.1 running on Sol...

hi stephan,

pls try this...

DefFun UtilityHashLookup(A1,A2,A3) Calling "DSX.UtilityHashLookup"

hope it helps

cheers,
vladimir

hi raj,

you can use CALL in the Oracle OCI stage. below is an example on how to run a stored proc without parameter,

CALL SampleProc()

i've used and tested it before (on Ora8i and 9i) and it works... you might want to try it...

vladimir

[/quote]