DSXchange

Are you getting the error message when connecting to "ETL" or to "testprogress"? Do either of them work?

Does Openlink have another configuration file that might contain errors? I'm not sure what you mean with regards to the DataStage license - has it expired on your test system?

Hmmm.. The error message states

[SQL Client] An illegal configuration option was found

and your testprogress has an options line reading

Options = -S 5000 -H 172.22.162.69 -N tcp

, which none of your other ODBC connections contains.

What do you think?

Let's say you have two columns in your link, In.Key and In.Data and you want to remove duplicate keys and keep the first record. Declare stage variables and derivations as: IsDuplicate IF(In.Key = LastKey) THEN 1 ELSE 0 LastKey In.Key Then in your constraint put the value "IsDuplicate = 0" s...

Craig has already pointed out that your program is doing a lot more than it needs to. Since you do an OCONV() on D1 and D2 to get displayable dates, the assumption is that both D1 and D2 are already in internal format. ABS(D2-D1) will give you the difference in days between the two dates, and if you...

Julio,

try to start off with a very simple example to get a feel for how the stage works. Create two sequential files with just a couple of lines and only two columns and use that as the basis - once you have that working you can start making the join more complex and can work with "real" data.

Are you certain that the user you are using to connect has SELECT privileges on both databases and that you don't have the "Filter" set incorrectly?

Yoganand, as Ray has already pionted out, you need to do some complicated work to make the DataStage BASIC or server engine call an external routine in C++. You will need to define the GCI parameters and re-link the dssh/uvsh executable. There is a manual available on IBM's website describing how to...

Since your source is a flat file, you can pre-process this using "sort -u" on UNIX or if your server has a package like MKS Toolkit installed. If not, you can do a normal DOS sort (which won't remove duplicates) and then use a stage variable in a transform to store the previous row's value and then ...

The character sets involved all support extended characters, but they place them at different codepoints, so using the wrong definitions makes DataStage convert them from one to another representation. Set your NLS_LANG to the correct definition (to that which your database is using) and it should w...

Venky, do you see where your conversion problems are occuring? You are reading in 8859-1 data (Latin-1) and then telling DataStage that the Oracle Database is in ASCL_PC860 / UTF-8. But your environment variable says that the oracle database is in Latin-1 again ("WE8ISO8859P1") so your data is being...

Hello Giang, DataStage seems to think that it doesn't have enough disk space, so I would check the location that your UVCONFIG points to for temporary disk space (the default is /TMP) and I think that there was another variable path in there for small files as well, but am no longer 100% of the name...

What are your error messages? What is your DataStage NLS setting? What are your DataStage sessions's runtime settings for NLS (NLS_LANG, etc.)? Thiese factors all affect how your data will get translated and might account for errors.

The limit of the string length is very large - it can as large as what is left of your process' virtual memory space.

Since the error message is complaining about illegal values in the configuration, could you (a) check the date/time modified on it to see if it has perhaps been modified by someone recently and (b) post it here? I mean the odbc.ini file.

It looks like column 4 (LAST_NAME) has a character in that line that cannot be mapped from MS1252 and might not even be legal in that representation. Can you see what the contents of that field for that row are in the database? Also, what are the Oracle NLS settings for your session (check the ENV v...