DSXchange

dsdoubt - you cannot use any varying column such as VarChar or VarBinary but you can use decimal and integer. Just specify lengths.

The open files warning can be ignored. Try changing your input derivation from a column value to the string "A123-6A". Do you still get a compiler error? Is the line-break in your derivation or was it just the display and cut-and-paste?

PX has no equivalent to ICONV/OCONV and no corresponding hex conversion function. You can either use a BASIC transform stage or write a c++ buildop to perform the same functionality in PX.

Yes, filler columns occupy actual space. They are columns just like any others.

Pipe errors usually are triggered by other errors. In order for a pipe to function, you need to ahve one reader and one writer process attached. If one of those processes fails, then you might see a pipe communication error even though the cause is elsewhere. In order to find the real cause of the p...

One method of gauging a job's impact is to do a APT_DUMP_SCORE to get the number of pids it will run on with a given configuration. The nature of PX jobs is that even though it might fire up 100 or more players there might only be 4 process at some point in time that are actively using resources. Th...

There is no limit to string constant lengths close to what you have. If you cut-and-pasted the derivation then I would guess that your "ToXfmCaseStudy.CHAR_CD" is invalid. What is your compile time error?

On AIX the command "df k ." will show inodes used and available. But Ray was correct - you have probably run into an OS limitation on the number of subdirectories in a project. The quick way to get around this is to delete jobs that you don't need. If you need all the jobs in the project, then a tem...

The "Level Number" comes from COBOL. Level 01 is usually the record name, levels 77 and 88 have special meanings. All the other numbers can be chosen at will. Convention is to use steps of 5 or 10 for levels and that each sub-record or group has a higher value than the level it is a subdivision of.

It is impossible to tell your structure from the post. The column "DELTA_FILE_BYTE" is something specific to your application.

Several of the documents are available for free at IBM Support

the (d) limit would preclude you from doing a "mkdir {dir}", can you try that? The limits I have seen are ~32766 subdirectories in a directory, I think that was on AIX.

If you attach to the directory and do a "df -F ufs -o i" to see if there are inodes left on the device.

Do you have ORACLE_HOME set at runtime? If yes, is there a file " $ORACLE_HOME/network/admin/tnsnames.ora"

You can do a range lookup just as you've described in the Lookup stage. Have you tried that?

You need to "cd" to the project directory and make sure that $DSHOME/bin is in your path, then you can issue your