DSXchange

Hi All We just installed the Fix Pack 1a for version 8.0.1 on the AIX host. The process jobmon and dsrpcd are up an running and we can CONNECT in the unix host using our dsadm user id but the client is telling the username and password is not valid. Information Analyzer was able to recognize and log...

Thanks for the explanation and clarification.

I will mark this resolved.

I though the dsenv file is required for a user id to connect as it defines the library path etc. If I understand the last response, would a user be able to connect to datastage if we remove dsenv. I am adding the ORACLE_HOME AND ORACLE_SID in the dsenv file. If the file's location does not matter, t...

I should clarify, I want to know what is the best practice when it comes to the location of the dsenv file? That will help me drive how to setup individual user accounts to source that profile

Hi We are trying to setup the latest version of DataStage ( Or IBM Information Server). Version 8.x.x By default the location of the dsenv is /home/dsadm. For a security perspective, being in initial phase of installation we are all using the dsadm unix account that is defined to have its home direc...

I added an entry in the .odbc.ini under the DSEngine folder I added an entry in the Projects uvodbc.config file And my odbc enterprise stage recognises the new DSN. So why or what is the reason one should have the uvodbc.config under the DSENGINE updated. Please let me know Currently I have not upda...

I added an entry in the .odbc.ini under the DSEngine folder I added an entry in the Projects uvodbc.config file And my odbc enterprise stage recognises the new DSN. So why or what is the reason one should have the uvodbc.config under the DSENGINE updated. Please let me know Currently I have not upda...

Hi All I am more of a developer then an administrator but in my new job we currently do not have a dedicated ETL administrator. We are to pick that role. I am required to create a new ODBC DSN for an oracle access and I just wanted to make sure I am understanding the process before making any change...

Thanks a lot and I am sure you had a laugh at the rudimentary mistake.

Nonetheless I greatly appreciate the help and we can consider this post closed and it worked

Regards
Arvind

Thanks it partly worked As suggested I set the default to "$" for the previousvalue variable and "?" for the currentvalue variable I added another output column with Y AND N indicator for the change if PreviousValue <> CurrentValue then 'Y' else 'N' This above statement seem to b...

Thanks it partly worked As suggested I set the default to "$" for the previousvalue variable and "?" for the currentvalue variable I added another output column with Y AND N indicator for the change if PreviousValue <> CurrentValue then 'Y' else 'N' This above statement seem to b...

Initial value for the counter is 0
It is type integer

Initial value for the previous value is "none" and it is varchar 25

My output is

0 Test1
0 Test2
0 Test3

I reviewed the other post for the similar situation and did not find anything in particular about version 8.

In general my logic is

currentvalue=source column
if previousvalue <> currentvalue then counter= counter+1 else counter
previousvalue=currentvalue

arvind

Expected output is


1 Test1
2 Test2
3 Test3