DSXchange

We just upgraded to 11.5 version. For previous versions, we use to find Licensing information in Administration tool and also in Information Server Web console. But 11.5 version doesn't show this information. I know the licensing information can be obtained from IBM through PVU values. But I want to...

Thanks for your reply. We are using internal registry and the version is 8.1.1

Hi- How to create an non expiring User Id in Datastage? Is there any option in web console?

Thanks for the reply. As suggested I had gone through the guide. But can you plz also suggest the settings I need to use to get maximum speed? I am reading 10M records from table in one database and loading to other dbase. What values should be defined for before properties? Oracle connector propert...

Hi- I have a simple job to load data from tables in one database to tables in other database. The same job is parameterized and will run 20 times to load data which ranges from 1M - 10M Oracle Connector-> Transformer -> Oracle Connector(Bulk Load) I am achieving speed of 5000 rec/sec by designing th...

Any help is highly appreciated.

Hi- I am using Oracle Connector stage in Datastage 8.1 job to BULK Load the data. The job is running on 4 node parallel. When I am executing the job, the Oracle Connector stage is issuing 4 LOCK TABLE statements with EXCLUSIVE MODE. Because of this the job is failing with below error- ORA-00054: res...

am using normal connection settings, transaction record cnt- 2000, session array size- 2000 and am not defining any before/afte SQL.

Sorry. This is the error message am getting.

ODBC_Connector_80: ODBC function "SQLPrepare" reported: SQLSTATE = HY000: Native Error Code = 0: Msg = [IBM(DataDirect OEM)][ODBC Oracle Wire Protocol driver]General error. setStmtType failed

I a using ODBC connector stage to read data rom oracle 10g table and writing the data into dataset.

ODBC Connector stage ---> Dataset

Select stmt in ODBC- {FILE}/#SOURCE_QRY_PATH#

Using Run time column propagation.

run time value passing to the parameter SOURCE_QRY_PATH - /home/dsadm/select.sql

Thanks for the info. I have tried the below approaches but it's not working.

{FILE}#SOURCE_QRY_PATH#
{FILE}/#SOURCE_QRY_PATH#

Is there any other way to get this resolved?

I have mentioned this in the Select statement-

#SOURCE_QRY_PATH#/selectdynamic.sql

I am passing the source query path during runtime. As I have said this is working in Oracle connector but not in ODBC connector. Plz lemme know if this is correct?

I have tried specifying the file path in the Select statement box of ODBC connector stage but it didn't work.
The Oracle connector has the specific option to pick the select query from a file. So, if am using ODBC connector is there any other way to pick the query from a file?

Hi- We are using Datastage 8.1. I am using ODBC connector stage to read data. But am unable to see "Read Select statement from file" option in the stage. Is this option available only in later versions of Datastage but not in 8.1?

Thanks

Hi- We have got 9.1 installation software. We need to install/ configure the software and migrate our 8.1 jobs to 9.1 version. I want to know how difficult is that to install/configure 9.1 software? we are all developers here and no one has previous installation experience. Do we definetely need IBM...