DSXchange

Hi, I have job like storedprocedure---->transformer----->file I exported metadata for storedprocedure,and its exporing 83 columns.But when i run the procedure on Sql -server client,it fetches 112 columns. When i try to manually add missing cloumns to source stage,it throws me below errors:- Stored_P...

Can anyone help me with above issues..???

Hi All, when i ran the test its giving "Link Monitoring is OFF.",but test is successful. ./DSAppWatcher.sh -test DSODB is turned ON in the DSODBConfig.cfg file. Link Monitoring is OFF. Job Run Usage is ON. Resource Monitoring is ON. Checking Database Connection: Successfully loaded the dat...

Hi, Datastage 8.7 operational cosole is showing with the error message "Some services in error" . appwatcher: Not running engmonapp: Not running odbqueryapp: Not running resmonapp: Not running But when i checked the status on server,its showing as running state. ./DSAppWatcher.sh -status A...

Hi All,

I am able to insert records.That error was coming because in one source column there was new line character was there. So i removed new line charcter by writing function convert(char(10),"",input.col).

Thanaks
Prasoon

Yes in target metadata...i am also out of my mind.....

I have changed nchar to nvarchar...but still it is aborting with same error....

Hi,

We have only four columns in target infomix database with two different datatypes.
Col1 Char Unicode 4 nullable
Col2 Char Unicode 1 nullable
Col3 date 10 nullabe
Col4 Char unicode 2000 nullable --- This column has the value of 50 source columns concatinated with pipe.

Hi, I have a job where i am extracting data from MSSQL server and target is Informix database. I am using ODBC connection for both source and target. For SQL Server i am able to extract data into Datastage but while writing to ODBC Enterprise target i am getting below error message:- ODBC_Enterprise...

Hi,
On unix you can check the file format by command "od -c" and check if there is some garbage character there or not.

Hi All,

Now we need to connect to 20 different databases on same sql server.So do we need to create 20 different entries,for each database in .odbc.ini file or is there any way we can connect to all 20 databases with single entry of just server name.


Thanks
Prasoon

Hi Ray,

Thanks for your reply.

Our problem is resolved by removing inialization string entry from the .odbc.ini file.

InitializationString=

Hi All, we are trying to connect to SQL using ODBC,but it is failing with the error message:- SQLSTATE=28000,CODE=18456[Datastage][Sql Client][ODBC][IBM](DataDirect OEM)[[ODBC SQL Server Wire Protocol Driver][SQL Server]Login failed for user 'aaaaa'. Password is #abcd12 We also tried entering the pa...

Hi,

I think using Index function,u can achieve your requirment.Try serching in this forum,you will get multiple threads.

Thanks
Prasoon

Hi All, We are trying to connect to oracle through oracle connector stage,but its giving below error message:- Error loading connector library libccora10g.so. 0509-022 Cannot load module /opt/IBM/InformationServer/DSComponents/bin/libccora10g.so. We are able to connect to same database using Oracle ...