DSXchange

Thanks Chaks Can you show the code snippet of the shell script in which you are reading the values from the file and returning them to be fetched by the loop activity? I tried doing that but I think I'm missing something in the script. In addition to that could you let me know what are you mentionin...

Chaks In your code, did u mean to read all the values at first using the shell script or one by one. I'm assuming that u r using the list loop option but how are u passing the values as parameters (one sequencer run per value) to the sequence job Chulett Can UtilityRunJob function be run from a para...

I have a parallel job that reads a csv file having two columns (col1, col2) through sequential file stage. For each value in the file I need to run a sequence job SeqJob1 and send the values of col1, col2 as parameter to the sequence job which will finally generate a report in xls format. Thus if th...

The simplest way to deal with it is to change the dataype of the column QTY to float with scale 2. It will do the required conversion without need of using any functions.

use APT_STRING_PADCHAR with value 0X20 where 20 is hex value for space.

Why to use a modify stage, Keshav? We can directly change it in the input/output metadata of the lookup stage.

You can also verify whether the set of values for compute node and partion parameters given in the job properties are same for both the projects. Both the projects should have same set of values.

Mandy If you have got the segmentation fault from a Database stage (eg. ODBC stage) and if you are using a user-defined query in it, then check for the query syntax by running the query directly in the database. Many a times, segmentation fault error occurs due to syntactical mistakes in the user de...

However when we connect ODBC enterprise stage with lookup stage and choose the sparse lookup option, we are not able to choose the column meant for lookup in the lookup stage. It says "Key expressions cannot be set on key columns of this link. The connected stage defines the key lookup."

My TD Enterprise stage is acting as a source that queries a couple of tables using joins. These tables are getting parallelly updated by other jobs. The records queried by the TDE stage pass through a lookup stage and based on a particluar column value the matching records are inserted/updated to th...

Can you please tell me what is this Multiple client manager. Is this a Datastage utility or 3rd party application. Any links which will give more details will be of great help. Thanks in advance

What is the level of effort to convert a datastage 7.5.2 project and jobs to the datastage 8 platform? Are there any showstoppers or major issues with this migration ? Is this a small, medium or large effort from a planning perspective?

Hi,

we have Datastage 7.5.2 version in Unix platform and we are planning to install Datastage 8.0 in Linux based grid platform.

Once we install Datastage 8.0, Can we use Datastage 8 client to connect with Datastage 7.5.2 server and work\compile 7.5.2 Jobs.

The exact error is RDBMS error: 8024, All virtual circuits are in use. And yes I'm working in Grid environment. Well I'm not exactly sure how many PEs are there but its less than 3. To attack the sessions constraints I gave TPUMP sessions min,max as 1,1 for all the TPUMP stages through sequencer. In...

I tried to change APT_GRID_PARTITIONS from 4 to 2 and this time none of the jobs gave the above erros of missing resource bundle. Not sure how was this param related to the error. However many jobs now got aborted due to virtual ckts error 8024. Note: I'm using a TPUMP stage loading data into Terada...