DSXchange

Hi All, Here i m facing problem with DB2 Database log. My source is Flatfile having huge data and target is DB2 Database. When i m loading data into DB2, DB2 database log is getting filled very fast and my job is getting aborted, and DataStge is throughing the error as SQLSTATE=S1000, DBMS.CODE=-968...

Hi Kumar, Here is the example of my data. 111ABABA BY Delivery Area 2221HYD KT Post Office Boxes 3334BANG NT Post Office Boxes Here my file is a fixed width of 38 positions but, First record here is ending at position 35.Since it is a fixed width file the linefeed should be at 38th position for all ...

Hi All, Here we have a problem with the Source file with different Line feed positions. For me the source is fixed width flat files and the data is coming with different Line Feed positions in the source files and unable to read those data in datastage using Sequential file Stage. Can any one help m...

ArndW wrote:Yes, you can do this with your 7.5 version. The instructions on how to set this up and prepare your machine are in the installation guide.

This thread also discusses doing this.

Thanks for the Response...

Cheers
Sasi

Hi All,

I have a need to install two DataStage instances in the Same AIX box. Will it possible to install Two instances of Datastage into the Same Server.

Thanks in Advance

Cheers
Sasi

Hi ArndW,

Thanks for ur reply.

But in the Documentation (For Universe Stages ) it is saying that To connect to a UniVerse data source, the data source must be configured in the uvodbc.config file. Kindly clarify in this regard.

Thanks

Datastage is installed on AIX Box and Client is installed on Windows. Alos DB2 Client is installed.
Will DB2 Connect supports to extract data if my DS Server is on AIX?

Pls provide the procedure of using DB2 Connect from DS. Should i need to install any other things like drivers....?

Thanks

Hi All, I need to extract the data from Universe Database. For that I m using Universe Stage. Here my doubt is should I need to configure (or define ) the systems in the uvodbc.config file in the relevant DataStage project directory on the server or without configuring anything in uvodbc.config can ...

Hi All, Can any one tell me how to use DB2 Connect to extract DB2/Mainframe (Database) Data from Server Jobs. I m new to DB2 Connect, Pls let me know wht are the steps i need to follow to connect to DB2 Which is on Mainframe using Server Jobs. As of my Knowledge we need to Install DB2 Connect and DB...

Hi All,

Is there any way to access the data from Focus Database using datastage.
As of my Knowledge Using IWay Adaptor we can. But is there any way to access using ODBC Stage(Installing Supported Drivers if any) like Other Databases.

Thanks in Advance

Thanks
Sasi

Thank u, Keneeth and Loveojh02 for u r Response, So, I can give project level access to the users created . I mean if create 2 users as User1 and User2 of which user1 as Developer and user2 as Operator, I Can restrict user1 (Developer) for not accessing particular Project . Operator we cant restrict...

Hi All,

I want to give permission to access only some jobs, to particular user in my project. So that he will not have permission to access other jobs.
Can any one tell me how to give permission to particular user.

Thanks in Advance
SASI

Hi All,

How to kill a process using Unix.
I need to kill the process for the aborted job without using the Datastage Director.

Thanks in Advance

SAS

Hi, I have data in a flat file. When i try to move this data into an XML stage the job is running successfully but it is not creating any file in the path defined (in options tab of output stage). What is the exact procedure to do this? Can anyone give some more inputs on the xml stages. Thanks, Sasi

Hi All, My Source is Flat fle and target is SQL Server TABLE. I m using ODBC Stage as a target for loading the data into Database. In the database table i dont have any key columns specified. I want to Insert the values which are coming as new and Update the Existing rows in the Database table. I m ...