DSXchange

Did u need the odbc.ini file entry if so find below.. [edwtest] Driver = /usr/local/nz/lib/libnzsqlodbc3.so Description = NetezzaSQL ODBC Servername = edwtest Port = 5480 Database = test_edw Username = test_edw_etl Password = CancelAsFreeStmt = false CommLog = false Ksqo = false Lie = false Optimize...

i am using ODBC stage to connect the Netezza database. I am getting the following error, Could not connect to datasourceError occurred while loading translation library ODBC entry is available in odbc.ini file and entry to uvodbc.config also done. Please help me in solving this issue. Thanks in adva...

We are using datastage 8.7 , when we trying to use aggregate stage for huge volume of records getting the below error: Aggregator_124,0: The current soft limit on the data segment (heap) size (134217728) is less than the hard limit (9223372036854775807), consider increasing the heap size limit Aggre...

Is there any way we can find who created the datastage job in 7.5.2 Or which user modifed the datastge job? Please advice.

Sreedhar wrote:Hi,

does your odbc.ini file has this project listed ?

Regads

Yes it is listed.Actually my server got rebooted after that it is not working..Whether i need to start any process?

Close the Manager, re-open it, try it. If it happens again, tell us when the error pops up. When you click "ODBC Table definitions" or something else..? Error occurs when i click the Table definition->Import->odbc table definition. When i entered the DSN,user name and password.I am gettin...

suryapkakani wrote:Give detailed information about the the message that you are getting

ERROR CALLING SUBROUTINE:DSR_IMPORT(Action=2);Check Datastage is set up correctly in project
(The connection is broken (81002).

I cannot able to import the table definition through plug in odbc definition.

I am getting the data stage error and i close the datastage designer and needs to reopen again.
Kindly help me on this.

asorrell wrote:Once the job is deleted there's no way I know of to recover it other than your normal system backups. That's why I have created an automated job that backs up every job in every project every single day (In Development).

If i made the server backup whether i can able to recover that job.

I accidentally deleted one category.Is there any way to recover that?I am using datastage 7.5.2.help me to solve this.

Thanks a lot it works!!!

Sainath.Srinivasan wrote:Check this thread. Similar and almost identical.

viewtopic.php?t=129330

Hi All, I have one clarification in generating the sequence number. File layout: 12|44 12|43 14|22 14|21 16|29 So depend on the first column if it same number ie 12 i need generate the sequence number from 1 and proceeds further if the first column value changes i need to reset again to 1 to generat...

Hi all, I need some clarification in assigning the value: Input file : Column1 BB CC CC BB CC Lookup file: Column1 column 2 BB 34 CC 23 CC 45 CC 12 So i need to assign the column 2 value for each records ,there is only one column 2 value for BB record in the lookup file,i need to assign the value fo...

It must be netowrk issue or the server may down at your time running or the file with the particular pattern is not created. The file name from your mail shows that the date pattern is available when the particular file is running on the other day of server time it will not fetch that file.. :oops: ...

Please check the lookup table.. the key used is not unique... there is more duplicate records in it.. Choose primary key of the table.