DSXchange

I think instructions say to place it on an active web server, not necessarily on WAS. Eventually I want to ask support's suggestion on this question since it's vague. Glad to know of options!

The parameter can hold a value like A or M but not so much code, I don't believe, because the Transformer code must be compiled before the job is run (before the parameter is resolved).

The head can contain lymph nodes. The computer cannot.

Something had changed, glad you got it, thanks for sharing.

Precision is number of digits and scale is number of digits to the right of the decimal. Your sample number, 13456.123456789012, has a precision of 17 and a scale of 12, which is decimal(17,12).

If such reporting capability exists, support / engineering will know of it. There are command line tools that can be used to query registry info, but those commands and their syntax are not documented for us. Contact support.

Option 2 is the fastest, most useful type of export for backup purposes. It's a good idea to export each project you work on regularly in case something bad would ever happen on the server. If your administrator runs regular backups then you should be OK too.

Also post actual data types of rd.data_point_float according to the source systrem and msref_ltv according to metadata in your job columns tab.

Yes, Ereplace() does find/replace in strings. Look it up in the docs first in case you have any more questions about it. I agree with Keith and suggest you follow his advise. You and your management both need to understand you are spending much valuable time "reinventing the wheel." Tell t...

Have you tried that? It sounds like a lot of work potentially, if you wanted to move logs say for a whole project with 500 jobs. All the job numbers would get renumbered and just to map from one to the other... could be a project in itself.

On your two lines for what should be LIBPATH and THREADS_FLAG, make sure they are each on two lines or else separate each two lines using a semicolon.

I'm not sure the significance of the THREADS_FLAG setting. I don't have it in my dsenv file and everything has been working OK.

I have DB2 Connector stages working from 8.5/8.7 on AIX 6.1 (all 64-bit). I don't have INSTHOME in the dsenv file, although that can't hurt. I don't have any DB2 settings added to PATH in dsenv. These next two are key: On AIX you need to use LIBPATH instead of LD_LIBRARY_PATH. In LIBPATH I have /opt...

That's one thing the Standardize stage does automatically. It's part of QualityStage. Convert() won't do that. If you don't have QS, you could use a Server job or a BASIC Transformer stage in a Parallel job to use the Ereplace() function. Just be aware you'll manually be building your own logic that...

Here's an 8.5 IBM tech note on the same error / different error number / different stage type. Research the patch and contact support if need be.

JR41480: Importing a stored procedure from a Netezza database causes DSR.MetaGeta Cannot read result file DS_METATEMP record

Hi SURA, I didn't say No. In fact I offered a suggestion of how you can test it yourself. If you have not asked IBM, then they have also not said No. You can contact support and request an enhancement. Once you ask the owner of the product, then they can tell you Yes or No. I am not the product owne...