DSXchange

There is only one answer - either get rights or get someone who has rights to do the cleanup for you.

The format is good, but we had to check. The error is "unable to open file". You have to work out why. Make the project directory (C:\Projects\TECH) and all its subdirectories Full Control for the user ID under which QualityStage jobs are run. You may require administrator privileges to set this.

Ah. That wasn't me, that was ArndW.

You still haven't reported the ulimit for dsrpcd nor the value of USER or LOGNAME environment variable from a job run.

I'm sorry, you seem to have misunderstood what I sought. I want to see that the file containing the data is formatted as per the dictionary. This would use one pair of Code tags. For example tom MI 48864 ashley IL 60601 And did you verify the permissions on every folder in the path C:\Projects\TEST\...

What kind of join? Instead of using a Surrogate Key Generator stage use a Column Generator stage, and generate the same constant on each of the inputs to the Join stage. Then perform a left outer join (1st source file is the left input) with the generated constant as the join key. Therefore you need...

Because the input column might be null and the TimestampToString() function does not like null.
Try something like

Good catch.

Please wrap the EINFO file records in Code tags so that I can verify that the field widths are correct. I also asked you to verify that you are still getting the same error (unable to open file). If so, can you please check what the permissions on that file are (and advise the result of your check)?...

Yes you should monitor ALL file systems (use df -k command repeatedly) because you don't know which one is filling.

Nah, just a brief inundation. More your "flooding rains". Floods in other parts of the world are far worse.

I read few message posted by you that we can set the ulimit in dsenv profile to unlimited. Can you please provide the example and command to set data segment ulimit to unlimited? Show me where. I doubt that I ever did. Only superuser can increase ulimit. What is the ulimit for the dsrpcd process?

Yes, a Sequencer is what you need in your job sequence. Were you to have wrapped your design in Code tags it would have been easier to understand. Please do that. JobA -----> JobB ------------------------> JobC ----> JobD | | | | | | | | V V V V JobA1 ----> Sequencer ----> JobB1 -------> JobC1 ---->...

A good local container name is "Magic_Happens_Here". It's useful when showing (I can't bring myself to say "explaining") to PHBs.

Still the same error? I note that you are now using a different project (TECH instead of NEWGS).

Can you post a couple of lines from the EINFO file and, if possible, its data file definition (its DIC file)?

I heard today that Massachusetts residents currently have 37 words for snow, not one of which is printable!


(For people encountering this post after later December 2007, the north east USA is presently in the grip of horrendous blizzards, snowstorms and other ugly weather.)