DSXchange

What port are you using for the host - I get the 9080 for the domain, but which port/process are you using.

Painful! Any suggested approaches, like export DSX files and run a sed or two over them?

Is it possible to change a table defn from say varchar 64 to varchar 255 and have that change propagate to its dependent jobs?

The fuction was specified in the Appendix of the Advanced course - course manual (not the lab manual)

How is the heap space modified? You mean the process heap space, say at the UNIX OS level?

Great feedback - thank you. I understand about the $APT_TSORT_STRESS_BLOCKSIZE. Or rather I understand its the memory setting, but is this the memory setting per node? For instance, say I have 4GB of RAM per NODE, It doesnt appear that DSEE is burning up the RAM before it starts hitting the scratch ...

I have reviewed several threads regarding scratch space issues; however, I was hoping that someone might summarize the best approach for maximizing resources used for sorting (tsort)? That is, if I am in a situation where I have a very large file to sort, if I use an explicit sort stage and specify ...

I was reviewing the Framework documentation and was trying to find the API for datasets. We have several legacy applications that write very large text files - in an effort to speed things up, we are considering the possibility of writing to a dataset directly. Has anyone tried this before? I am sur...

Very true. Maybe the Trim() was a bad choice on my part. your example is in the clear because it uses less than the max inbound buffer length. I should have suggested StringCat or the like to illustrate my point. Nevertheless, thank you for the background.

Its based on the assumption that DSEE will cleanup the memory that you alloc-ed. I am not saying that you are wrong. What I am saying is that its a big deal to just allocate something and pass it over the fence. I would have expected very clearly written documentation to explain this behavior. I hav...

I have read several posts that mention using the uvbackup (and uvrestore) commands and it got me thinking about the different approaches to backing up DSEE. How can these be used in the context of an overall backup/recovery strategy. That is, I would imagine that a cold backup (DSEE down) would prov...

Thank you all for the posts - great insight. DSguru2B your code worries me - got memory leak written all over it - that said, I am willing to try your approach - its simple enough and I am running out of memory as it is. I agree with the previous post that the DSEE documentation 1. sucks 2. doesnt d...

DSguru2B - dont follow. paraphrase: If I still write my own Trim() and I "define my variable" inside of my function - how? This is the heart of the issue. Using the following code is invalid - it will return an address of "LocalBuffer" which will be out of scope once the function...

Interesting - so if I wanted to write my own trim function the signature would read

Trim(instring, outstring) rather than Trim(instring)

Why do the ~standard~ routines not require this sort of hassle? I was told they were handled in much the same way.

Where is the buffer coming from, DataStage? How would I call this from a Transformer?