DSXchange

Craig, Most of available address space in a text field is unused, i.e. normally strings only use half of their possible values. This would be the easiest approach. I once write a Huffmann-encoding in BASIC, but don't have the code anymore. I think I could rewrite it in a day or three. This does the ...

No, but of course the client can't connect to anything until you have the server up and running.

I think that you are attempting to set an NLS map that doesn't exist. You specify the EBCDIC conversion in either the string type defaults or in the column definitions and this attribute is completely independant of any NLS settings.

Kumar,

using a lookup file/table would work, but would be much slower. I think that an IF...THEN...ELSE construct would also work, and would be fast if you could order the statements by order of frequency.

The missing columns setting will solve this, but you need to start at the last column and work your way back until you get to a column which cannot be missing. Also, are you telling it to ignore errors or drop rows?

Change the stage to a peek stage and see if the data looks like what you expect; perhaps some values are incompatible with the PX settings (nullability is a common cause) and are keeping the records from being written. Usually these messages can be seen in the director (but sometimes they are very w...

Hiten,

PX has no built-in function to do this; you could either write your own in C++ or you would need to code it into the job. The following would work:



MonthNumber is the extracted month from the date.

No limits of the type you are looking for exist. How are you ascertaining that the records aren't being written to the sequential file? Does the designer "view data" show anything? Does the Job Director log actually state the n-rows were written?

Hello Carter, the case is open with Ascential, but now that you brought the subject back up I realized that I haven't followed through on this. So far I haven't gotten it to work. The temporary workaround in use is that the developer has written the data to a flat file as a string (he's put the time...

Hiten, the Parallel Job Developer guide lists the builtin functions available in PX. There are different function for different stages (and even different syntax and options for the same function in different stages) and are documented there. The c++ issue is a bit different, but using the search op...

LegendKiller,

you are correct, the modulo goes from link number 0 to {n-1}.

Kalyan, the first problem you had was most likely a locking issue, i.e. if your client is terminated unexpectedly while editing this sequence. The problem I think you have caused is more severe. I am assuming that you went to UNIX and did a 'rm -r RT_CONFIG396' which removed it from the OS but corru...

hhh, in order to compute an AND condition both elements need to be evaluated, so you are going to perform an illegal operation on a null value in your query. Change it to if isnotnull(P_MKTPRC_BAM) or P_MKTPRC_BAM => 0 Then '+' Else '-' if you really want to keep your original design, but the second...

The CRC32 function does more than convert data into binary - it compresses it into 4 bytes regardless of string length. PX has a number of builtin conversions to and from binary as well. Are you looking for a particular function or just asking a general question? In addition to the builtin functions...

Most likely you have misspelled one of the parameter names, that would explain the error. Variable names such as parameters are case-sensitive. If you can't find the problem, replace the parameters with constant values until the error goes away.