DSXchange

Kumar, I am able to view the data when i give correct password. I have changed the password in admin like 'xxxx' (wrong password) and tried to view the data. Naturally, it should give error like 'Security reasons. Password in valid". But it is showing the data. thats why, i am saying its not ta...

No, I have not reported to any official support providers.

Thanks for your prompt reply.

I am using $PROJDEF.

Hi, In my project I am facing the following issue: We developed datastage server (7.5.2) jobs in AIX environment(UNIX). The jobs are running fine in Development environment. When we change the password(encrypted) in the administrator of same environment, its not reflected in the Job and its taking t...

Hi, We are facing the following eror while try to export or import the jobs: "RUNTIME ERROR :13 TYPE MISMATCH". After getting this error, our whole project got crashed. We are not able to open DS Manager. (We try to migrate the jobs within one server only) Will any one please suggest work ...

Hi ,

I can able to get the mulitple records using the ODBC stage by check in the option "Reference link with multi row result set".

Thanks for your help.

Hi ,

I can able to get the mulitple records using the ODBC stage by check in the option "Reference link with multi row result set".

Thanks for your help.

Hi,

We are using Datastage 7.5.1 server jobs on Unix background.

I need to take the backup of the each job in the daily basis.

Will anyone suggest me the workaround to do this?

Thanks for your help.

Thanks. I am using the Dynamic RDBMS stage for lookup table. So, Shall i replace it with the UV stage? Is it any work that i have to do with the uvodbc.config file? In the uvodbc.config file, already the following entry for the UNIVERSE is present. <localuv> DBMSTYPE = UNIVERSE network = TCP/IP serv...

Thanks for your reply. Yes, we want all those 10 records in the target which are all unique by another two keys. For example, the data looks as below: key1 key2 key3 key4(absent in lookup) key5(absent in lookup) 100 xxxx yyy 1 a 100 xxxx yyy 2 b 100 xxxx yyy 3 c 100 xxxx yyy 4 d 100 xxxx yyy 5 e 100...

Hi All, Thanks for the help. The update method used is 'INSERT OR UPDATE'. The table is indexed for the some of the columns and not to all the columns. We tried using the sequential file which is very fast and we put the target table in which performance is down Eventhough there is no constraint for...

Hi All, Thanks for the help. The update method used is 'INSERT OR UPDATE'. The table is indexed for the some of the columns and not to all the columns. We tried using the sequential file which is very fast and we put the target table in which performance is down Eventhough there is no constraint for...

Hi All, Thanks for the help. The update method used is 'INSERT OR UPDATE'. The table is indexed for the some of the columns and not to all the columns. We tried using the sequential file which is very fast and we put the target table in which performance is down Eventhough there is no constraint for...

Hi, In my job i used source and target stage as Dyanamic RDBMS. I am using the query which is having UNION. Initally the job is fetching 200 rows/sec and slowly it get worst to 2 row/sec. Is this issues due to some hardware where the datastage is installed or Problem with the query itself. Will any ...

Hi, I am using Dyanamic RDBMS as my source and target. How to remove the duplicates in the DYNAMIC RDBMS stage in source. I am using the lookup in the job. I want to restrict the duplicates either in the source(Dynamic RDBMS) or in lookup stage. Will any one please help me out. Thanks for the help.