DSXchange

Friends,

I am getting the following error when I tried to connect to DataStage Designer. I have checked on the server and found no active connections.
Any idea why I am getting the error?

Error: All available licenses in use:84336-DSDES Limit=5

Thanks in advance
Yamini

Thanks a lot for the information. I will try all the scenarios and post the results here

Craig,

The job is running fine if there is only one value but is failing when there are multiple values in the file.
The data in the file is as follows
'1',
'2'

Any ideas how can I parse the file to input the values as '1','2'?

Thanks
Yamini

Craig,

The job is running fine if there is only one value but is failing when there are multiple values in the file.
The data in the file is as follows
'1',
'2'

Any ideas how can I parse the file to input the values as '1','2'?

Thanks
Yamini

thanks a lot for the information.
As a follow up question, is there a way to pass values in the 'WHERE' clause during run time

Thanks
Yamini

Friends,

I am trying to design a job which selects data from a table based on the values passed in the query. The values to be passed are stored in a flat file on DS server.

Is there a way to pass values to the select query in ODBC stage during the run time?

Thanks a lot in advance
Yamini

Hello friends, We are having issues with a job which selects data from 10 source tables and populates 10 staging tables. There are two other jobs, executed sequentially, which populate the same staging tables The design of the job is simple ODBC ==>TRANSFORMER==>ODBC which is repeated 10 times Once ...

Thank you guys for your suggestions.

Yamini

We were using the OCI stage from the beginning but it was performing poorly. Only after increasing the array size, the job picked up the pace

Craig,

I have increased the Array size to 5000 and the job completed in less than 30 minutes.
Is it a good practice to commit after writing all the records or should I change the 'Rows per transaction' value to commit multiple times?

Thanks
Yamini

Craig,

Can we use the ORAOCI BULK stage if DataStage (Linux) and database (AIX) are on two different servers?

Thanks
Yamini

All are write inserts only

Ray,

We are not using array processing. Also, we have set 'Rows per transaction' to zero so as to commit after writing all the records to the database

Thanks
Yamini

Hello friends, I am trying to tune a job which processes about 4 million records a day. The job reads data from a table in database A and writes to a table in another database (B). ODBC ==>TRANSFORMER==> Oracle OCI The job takes about 3 hours and commits after writing all the records. Is there anywa...

Friends, I am working on a small project which requires me to generate some flat files with the data selected from an Oracle db. I am generating one file per table by selecting all the records. The main requirement is to append the record count at the end of the file. Is there a way to accomplish th...