DSXchange

I missed the "Parallel Routine" part - I saw the DSU text and thought that perhaps the routine hadn't been compiled or was incorrectly typed, I hadn't realized that the poster wasn't trying to call a BASIC routine. Thanks for catching that one!

No, the IPC uses pipes and they are FIFO (first in first out) and won't change any row ordering.

Ray, are you certain about what gets loaded to memory? I had the impression that only those clumns defined in the lookup would get loaded through the memory mechanism.

Could you tell us what your error message was? You should be able to call Routines from the job control section of PX jobs.

Colin, regarding question 1 load only those columns and rows you need into memory, it will let the memory load go faster as well as reduce the amount of memory needed. Question 2 is a lot tougher to answer and there is no single or correct answer. Factors such as disk speed, system memory utilizatio...

Samba, does your reply mean that it is executing correctly? we are not clairvoyant Is there something special about the query? Do other tables show data correctly in PX? Is it user-SQL or generated? Are you using some odd datatypes? If you remove some columns does it work? Can you try to see if the ...

The output of the filter command on the file "abc.gz" will go to standard output, which is what leaves the stage to go to the next link., you shouldn't use the "abc" as the file in the stage

Use the stage variable, it will only be computed once per row.

Add an IF-THEN-ELSE statement that checks for LEN(In.Column)=8 or explicitly format the column to 9 places padding on the left; i.e. FMT(In.Column,'9"0"R')

samba,

if you cut-and-paste the SQL select statement from the Oracle stage to your favorite query tool do you get a better error message or does it run correctly?

Instead of using the ICONV/OCONV I think your easiest solution is to use

Are you creating these files as directory paths or as local hashed files? How much space is there available in the target directory (remember, a large minimum modulus will preallocate disk space)? Do you have enough i-nodes available on that volume? If you are using paths, the "mkdbfile" command wil...

Does your response mean that if you run the job again it will create the hashed file correctly?

BIuser, to clarify some of the important terms that are often confused or used in an unclear manner: paging - the act of moving a "page" of memory to a special disk location or returning that page from the location to memory. swapping - the act of moving a process and it's associated memory to disk ...

Diya, there is no need to repost, threads won't get lost. I just don't have the time to play with your query in PX at the moment. The difficulty is that the StringToDate function expects a different type of input format from what you have. The two difficulties are handling the time zone and the text...