DSXchange

Thanks. Its working.

I have a sequence in which I am using NOTIFICATION ACTIVITY.

I need to get the CURRENT PROJECT NAME and THE SEQUENCE NAME in the subjectline of notification activty stage without harding coding its value.

How to unlock a job in Datastage V8. Our metadata resository is in DB2 Database.

I have configured the DEV and PROD in the same way.

I have configured the .odbc.ini
and uvodbc.config

I have other jobs which are accessing the same database using DRS stage and they are running fine.

Hi, I have job in which I pulling data from Netezza database using ODBC drive in a ODBC EE stage. If I do the view data in the source ODBC stage it is showing data returned by the db query. But if I run the job I am getting fatal error: ods_cas_instrm_mst: Unrecognized argument: ) "ods_cas_inst...

We have a requirement in which we need to provide read only access to a user. This user should be able to view the jobs but not edit it.

How it can be done. Pls let me know.

Thanks,
Prashanto Dev

Hi, I have a sequence in which we are using email notification act stage. In the email we pass the calling Sequence Name (The seq which is calling the Email Act). Right now we are passing the Seq Name as hardcoded value. Can we avoid this hardcoding by using a parameter,so that it will get the seq n...

I have to convert output of an aggregate field from an aggregator (Double) to an INTEGER field.
I can do it using Transformer. But I want to do it through Modify Stage. Please let me know the syntax to be used in specification in modify stage.

Is anybody has answer for this problem: I am also getting same kind of errors: >CONNECT myodbc3 Enter username for connecting to 'myodbc3' DBMS [dsadm]: edw01 Enter password for edw01: Abnormal termination of DataStage. Fault type is 4. Layer type is BASIC run machine. Fault occurred in BASIC progra...

I am using this now:

[mysqldsn]
Driver = /usr/local/mysql/lib/libmyodbc5.so
Description = Connector/ODBC 3.51 Driver DSN
SERVER = 32.91.255.12
PORT = 3306
USER = myuser
Password =
Database = mysqldb1
OPTION = 3
SOCKET =

Still not working

Hi, Can anybody please send me the entry in the odbc.ini file for connecting to mysql database. I need a entry which is working. I am using this but nor working. [mysqldsn] Driver = /usr/local/mysql/lib/libmyodbc5.so Description = Connector/ODBC 3.51 Driver DSN SERVER = 32.91.255.12 PORT = 3306 USER...

I have tried other drive also but it is not working

yes I have created.

I am getting the error:

Error calling subroutine: DSR_IMPORT (Action=2); check DataStage is set up correctly in project BUIEDW01
(The connection is broken (81002))

yes I have tried and still getting the same problem.

[myodbc]
Driver=/usr/local/mysql/lib/libmyodbc3S-5.1.0.so
Description=MySQL ODBC 3.51 Driver DSN
SERVER=70.91.45.1
Database=edw1ops
OPTION=3