DSXchange

Thanks for your reply kduke. I had already tried with all possible ways of ordering the /NODEPENDENTS but resulted with error as "the current user does not have the desired datastage role setup" and "failed to attach to project". Any other solution to avoid the list of dependent ...

I need to export a list of datastage jobs using the command dsexport. I need the DSX export excluding the dependent items. i tried with the below command dsexport.exe /D=domain /H=hostname /U=username /P=password /Job=xyz_abc project pathname1 When /NODEPENDENTS was included to the command i get the...

We are using DataStage V 8.0 and received the following error when we tried to run the job main_program: Fatal Error: Table `AGG_TENDER_TILL_MB' must exist before querying the node group. But the table exists and we could able to insert manually by using the same user. So it was clear that there wer...

Hi, You cannot do the rollback for data which is inserted through Job1. You can do the followings. a. Add a lookup and verify for primary key, insert the data if it is not present else update. b. Use insert and update after defining the primary key in database. c. If it is staging area, always do tr...

I have 7 jobs that extracts data from 7 db2 tables and loads into respective 7 SQL Server tables at target in a batch mode, all 7 jobs will be called in 15 minutes interval. All 7 tables doesn't have metadata column to identify the data load for any batch. Challenge is if any one of the job is faile...

In Designer, the jobs are enabled to log the performance statistics. So it logs the statistics in the directory (/opt/IBM/InformationServer/Server/Performance/%Project Name%). Now the job fails due to insufficient space in the directory /opt/IBM/InformationServer/Server/Performance/%Project Name%. C...

The issue is fixed. I have mentioned both Schema name and Table name which was giving erro, so i modified to have only the table name. It is working fine. Thanks for your help.

Hi, I modified all the configuration files, now i could able to connect to database. I am receiving the following error. ODBC_Contr_PoS_Baskets: [IIS-CONN-ODBC-000031] Unexpected character found at offset 19 parsing table name POS_Storage_ITF.dbo.POS_Baskets (CC_OdbcTableNameParser::parse, file CC_O...

I don't think it is a problem with .odbc.ini or DSN's because the same parameter is working fine through ODBC stage but not able to connect to same DSN by using ODBC Connector stage.

Hello,

I have configured in ODBC.ini and .uvobdc config files. Please let me know if i need to configure in other places.

Hello, I could able to import the job from Designer. Please see the below commands that is used to import the job from Command Line. #!/usr/bin/ksh #~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ # # Import DataStage jobs # Parameters: 1. Directory where DSX files reside # 2. DS p...

I am also facing the same problem. I am extracting it from Db2 database and inserting the data into SQL Server 2000. I modified the job to write into a dataset and it work fine, so there were no issues with Source. I am using ODBC Connector Stage only to connect SQL Server Database. Using DataStage ...

Hi, We are importing our code from One environment to other by using dssh and DS_IMPORTDSX. After compiling the jobs in Development environment, We have exported out code and moved to common place. We have exported both Design and Executables. When we imported the code into Testing environment by us...

Hi,

I got the same error. i am able to run the job that extracts the data but the job inserts / updates the data is failing stating the above error. Any suggestion / solution for this please.

Hi Vinod, Log on to Administrator, Enable the option "Protected Project". All the jobs will be made read only. If you want few of the jobs to be read-only, then export the job and open dsx file in notepad / editplus. You can see the datastage code "Read-Only" in dsx file. It shou...