DSXchange

The ODBC driver is correct and still i am able to connect from the Sql Server Query Analyzer. The point here i noticed is i changed the driver from "Ascential SQL Server Wire Protocol" to "Sql Server". It is working fine now. Not sure what is happening in the driver??? Is there a...

Hi All, I am querying from SQL server database using the ODBC stage. The query is just selecting a single column from the source table. I have created a ODBC Connection string in the DS Server. I have a user name / pwd for the same. I validated the test connection in the Server. When entering the &q...

How to type cast date in datastage server jobs? Prob Desc : I am using sql server as my source connection and extracting date from one of a table. The date format in sql server is "1/18/2006 11:14:37 AM". I have typecasted in the query of the ODBC stage as "convert(varchar(10),INVOICE...

I think you have to install the ODBC Drivers from the Ascential Datastage CD. I even faced the same problem just 1 hr back and gone thru the product documentation as mentioned by Arndw. The driver for Oracle is : Ascential Oracle Wire Protocol The DLLs for the driver are : VMORA19.dll , VMOR819.dll ...

DataStage is not a report-writer. Please don't ask for urgent help here - it causes offence. We are an all-volunteer site, who post (unpaid) when we can. If you want urgent support, sign up for premium support from your service provider, and discover the true cost of "urgent". Ray, I remo...

I am posting this error, because i am not able to find the post for the error No : 81011. points: 1) I am getting this error when i am trying to connect to datastage server. This does not happen in the past, since i was using the datastage client ver 7.5 to connect to the server box (different machi...

Hi, Error obtained when a job is been ran in datastage designer. steps: 1. I created database in sql server box (which is also hosting Datastage Server). 2. Designed the job to transfer data to another table using transformer. 3. Created DSN in the client box to connect to server box (For SQL Server...

Hi,

I have created a New Protected Project in Datastage Administrator.
In Designer, I am not able to add new Jobs. The properties permission for the [user = Datastage production manager].

Do i need to make any change. Suggest a solution.

I didnt do any reindex. I closed the jobs and open jobs. when i tried again after re-starting the machine, I am able to export the only desired jobs / sequences / table definitions. The clarifications as discussed in the chain: Sounds like you need to reindex the project. Search the forum for the pr...

Hi, I have created jobs in project A and need to move to project B. When i tried to do a export with selected Jobs and Table definitions from Datastage Manager the following errors are popped up : Dialog 1 Error calling subroutine. *Datastage*DSR_SELECT (Action=7); check Datastage is set up correctl...

I am just looking for the output records to be send in a email. (At the end of the transformation).

The vital things such as recipient, subject and even the mail body will be the predefined contents.

Where can i configure the DSSendMail component ?

STATUS = 2 means "file not found" both in UNIX and in DOS. Hi , The file is present in the target link. I am able to see the data after the transformer ran. I am not able to send email once the transformer ran. I configured the settings in the Transformer stage as follows : 1) open the tr...

I have a requirement. I need to use a source file (3 records). Load this data to a target file multiple times in a Loop. Input file : 3 records Loop : 10 Output file : 30 records How can i go about this? Is there any stage been used to handle this type of transformations? I could remember in another...

Your job is failing because of your DSSendMail routine call; it doesn't seem to have a problem with your sequential source file at all. If you remove your after-job call temporarily (before you fix the parameter errors) the job should run to completion without an error. Yes that's the right one. Bu...