DSXchange

Note: The requested capabilities may not work correctly when using a grid of servers. Thus, this request is for customers using one server or when only using one server for a set of related jobs. 1. Please add the following capabilities to each database stage so that the number of commits issued by ...

If you choose to employ your own method, make sure that you add a dash of salt. For example, you could choose to input encrypted string pairs wherein for each encrypted string you pass in the encrypted string as just a string variable and you also pass the decrypted string as an encrypted string. He...

Many thanks.

I'll look around for those add-ons and thank you for sharing information from the conference. It looks impressive and nice job.

Take care

Do you know if it is possible to use the TeraData Connector for this type of activity?

The Windows version will give you a SQL Enterprise stage which can be used for doing bulk loads to SQL Server. That might be important for doing a lot of SQL Server work. Maybe what OS the developers are most familiar with could be an issue as well? Other than that, the Unix version will probably be...

If you can supply values in column order of the table for all columns, then I think you can use a transformer to put that data out into a varchar column which has a field delimiter that you build into the data. Pass this data a target command stage and invoke bcp. I think you can do it as follows: m...

Hello, We are currently using 8.1 FP1 of DataStage and using the ASE Write method we can specify a different "Field Delimiter" in the properties-> options. Is that option missing? If so, I think you could use a transformer to put in your own delimeter in the data and put the data in column...

If the source and target are the same database or database server, you could try splitting the job into two jobs (an extract job and a load job) and see if the two jobs complete faster than one due to saturation of the database server.

I like doing a clean install, but I don't have any experience with version 8.0. However, we have been very happy with the latest release of DataStage. I am sure we will find a few things here and there, but so far we have found the latest release to be excellent. I hope that when you have completed ...

The indexing is not very good on the XMETA tables. There are not any composite indexes. The data model is not very good either. Looks like it was just thrown together with a whole bunch of columns and whole bunch of indexes and should they be used, they'll be used. Columns have bad names (so what t...

The job for which you are trying to see the log is a generic job with multiple instance ?? The indexing is not very good on the XMETA tables. There are not any composite indexes. This helps (about 20 times faster, but still too slow): CREATE INDEX XMETA.IDX_1466CB5F_RYAN ON XMETA.LOGGING_XMETAGEN_L...

The XMETA database is well and truly obfuscated, so you'd need to involve your official support provider for help with that. ... I ran a whole bunch of tracing on the DB2 UDB instance while pulling out log information. Here is what I found: #1: DB2 UDB is extremely inefficient at cursor handling. S...

This string works and is more secure: echo #AES_PASSWORD# | openssl enc -e -aes-256-cbc -salt -pass stdin -in #FilePath#/Seq/Aes256Bit_Infile.seq -out #FilePath#/Seq/Aes256Bit_Outfile.seq 2>&1 Thanks. Trying to use openssl within datastage to encrypt a file from the source stage. Source_Stage ==...

Trying to use openssl within datastage to encrypt a file from the source stage. Source_Stage ====> Sequentile_File_Stage(Log_File) In the source stage I specify this string: openssl enc -e -aes-256-cbc -salt -pass pass:#AES_PASSWORD# -in #FilePath#/Seq/Aes256Bit_Infile.seq -out #FilePath#/Seq/Aes256...

We mathematicians think there are two types of people in the world: Those who say the next number in the sequence 3,1,4,1,5 is 1 and those who say it is 9. My configuration files are defined as follows: For all N<9 an element of the natural numbers, there exists a configuration file which is named d...