DSXchange

Failed lookups return NULL for every field. This is not the same as "" or as " ". You need to effect the conversion if required, perhaps using a NullToEmpty Transform.

Posting in the DSXchange Testimonials forum wouldn't have helped.

There may be a .bash_profile there. You can edit that. Make a copy called .profile (a quick way to get a .profile file). Here's my dsadm .profile (and .bash_profile ) file. The first line does not occur in the .bash_profile file. #!/bin/sh DSHOME=`cat /.dshome` export DSHOME APT_ORCHHOME=$DSHOME/../...

IBM made several performance-related changes to the parallel Transformer stage in version 7.5.1A. If you have this or a later version prefer the Transformer stage to Filter or Switch. Modify and Copy, however, are still faster at doing the things they do.

Will the portion to the right of the decimal place ever contain the time portion? You need to plan for these contingencies, particularly if you seek to create re-usable components. Extend the method suggested by DSguruji. Use the Field() function to retrieve all the digits to the right of the decima...

BuildOp gives you total control over the C++ code, and therefore over the code optimization. In theory, therefore, you should be able to "build a better mousetrap"; in your case a stage that outperforms the Pivot stage, provided that you have the skills to optimize code. If you don't, why re-invent ...

What is your data source? Might it have duplicate dates in the same line? Search for one (or more) of the dates in the error message.

Are you applying any transformation to the date?

If you don't trust what you see in Director, verify by executing AT in a CMD shell.

The row count in the ODBC stage is "rows per transaction", or rows between issuing COMMIT statements. Setting this value to 0 has the special meaning "all rows are one transaction". If anything goes wrong, the entire transaction will be rolled back. Beware, however, that for large numbers of rows th...

You are using ODBC. The ODBC protocol specifies double quotes around identifiers (column names, table names, etc.) and single quotes around literal strings. Note that Microsoft, who published the ODBC standards, do not conform to them. Microsoft Access, for example, uses a back-quote ( ` ) as the qu...

You will need to consult the documentation for Progress (or for the ODBC driver for Progress) to find out what generates the error code 7888. This may also suggest remedy. Please also verify that ar_nbr and ar_xcomm_pct are both columns in a table called ar_mstr. (Sometimes "bad array" can mean "bad...

I wonder...

Try 22.0/7.0 as the expression.

It may just be that the optimizer is being too clever, recognizing integer arguments and therefore performing integer arithmetic.

cd to your home directory (cd with no command line arguments will achieve this). Use ls -la .*to see the hidden files there. Edit the relevant file(s) with your chosen editor, perhaps vi.

Last time I looked (7.5.1), "DOS format" was not available for record delimiter when running on UNIX platform. Otherwise I would have cited that as the appropriate technique. The only way to know what's there is to look at the actual characters. If you have a hex editor, such as UltraEdit, use that....

Search is your friend. This topic has been covered before on a number of occasions. A good start point would be the dscmdexport command.