DSXchange

In the Administrator -> Command prompt execute the following: SELECT * FROM DS_JOBS WHERE NAME='<Job Name>'

This will list the category where the job is available.

There are similar queries raised here before.... You can achieve this through lookup using ODBC or Universe Stage. Use Col1 & Col2 as Key fields in the lookup and enable "Reference link with multi row result set" in Transformer Stage Properties -> Inputs. This will return you all the m...

It happens this way when any of the DataStage Jobs are open in Designer during the REINDEXing process. Make sure that none of the jobs are opened (locked status) before executing this command. You can execute this command once again after making sure that none of the jobs are on locked state.

Ya, this is the first time i'm trying to use DSDB2 Stage in the server.

Hi All, I am facing a problem with my DSDB2 Stage. The whole environment was set up recently. I am getting the following error when i select view data from the stage " ds_loadlibrary: error in dlopen ". We have installed DB2 Client on the ETL Server (AIX) and specified the LIBPATH and floo...

Thanks Ray for the reply. Amazing ...!!! Yes,Last week I joined ETL development team here. Got to know, you were here till last week.

Thanks,
Tom.

Hi, I have created a DSN on my ETL Server (Unix) to connect to DB2 Database. When I execute "[color=olive]bind20 DB2DSN[/color]" from unix, it's throwing the following error [b][color=olive]" xec(): 0509-036 Cannot load program bind20 because of the following errors: 0509-150 Dependen...

Thanks Kim and Mathias for your valuable inputs.

Hi,
I have configured a DSN on the ETL server for DB2 Database. But unfortunatly it's not working. I would like to know whether I should install DB2 client on ETL server to connect to the database using the DSN on my ETL Server on Unix.

Thanks in Advance,
Tom

Thanks Ray for the immediate reply.

Hi All,
Can we directly connect to SAS DataSets from DataStage. To put in another way, does DataStage provide any Stages (Plugin) to connect to SAS DataSet?

Any input on this will be of grreat help.

Thanks in Advance,
Tom.

Hi All, I facing a problem with my new installation of PX. PX is installed on Linux system with a single processor. I have developed a sample job in the new installation but while running, the job aborts. Going through the error, I could find that there is a configuration related issue with my insta...

Thanks Luke. It was because, I did not copy the uvodbc.config file to the project directories.

Thanks,
Tom

Hi, I am facing a problem with configuration of DSN on Linux. I set the entries in .odbc.ini and uvodbc.config files. I can connect to the Oracle DB from ODBC Stages using the DSN, user name & password. But if I try to import the metadata from DS Manager - "ODBC Definitions" - "Im...

Hi All, I have a Job which populates SAP IDOC segments using IDOC R3 Load stage. I am populating several IDOC segments and it is working fine. Recetly I added one more link to populate IDOC Control Segment and assigned values but the values passed for Control Record are not getting updated into SAP....