DSXchange

Hi, I need to run a sequencer in multiple instance mode. I have file say EMP_ID. For each EMP_ID I need to run the sequencer with EMP_ID as the parameter to the sequencer. [b]My requirement is that at any given time only N number of instances should be running untill it finishes for all the EMP_ID.[...

[quote="Mallayagari"]How to pass input parameter to the wrapper stage. Any sample syntax are welcome.[/quote]

My requirement is to call a unix script for each record (one column record). The column value will be parameter to the script. Can this be doable in wrapper stage?

How to pass input parameter to the wrapper stage. Any sample syntax are welcome.

IF you have enough time to pull the records from mainframe using API stage then its better to use API stage. If time is critical factor to your processing then extract and ftp the data is the best method. How much time do you have to pull this data? [quote="nvuradi"]Hi All, We need to extr...

I need to calculate max of decmial(31,0) in aggregator stage. The output is also defined as decimal(31,0). But the output is truncating the values. Is there any limitation(length of column) on max function of aggregator????????????????? For small values its working fine.

Thanks in advance

[quote="us1aslam1us"]Aggregator has nothing to do but the max() forces to throw an error. Convert your string to Numeric before sending it to aggregator.[/quote]

USe the preserve type property set to 'True' and it will work

hi,
I need to use the aggregator stage to aggreagte few numeric fields. Apart from that I have a string field for which I need to get the max() of it. The output is throwing as all zero's. Is it that aggregator doesn't work on string fields?? How can it be done?

Thanksin advance

Hi
I am writing a large varcharfield(2000) to a sequential file(fixed widh) but its truncating the value and writing. Is there any limitation on varchar field or fixed width file??


Thanks in advance

[quote="ray.wurlod"]There is nothing within a job sequence that allows you to access a table. A job sequence processes no data whatsoever; it prescribes the flow of control. Probably your best solution is to construc ...[/quote] ******************************************************* In yo...

Hi

In this case you need to use a buil-op (custom stage) to do this. If the data is small then you can go for a unix script but if the data is huge then build-op is the right option.

Thanks
Malla

Hi Senthil As others said using look-u is big NO. There are two options (a) if the two tables can be indexed on the keys that you are trying to join then join those two tables on the database instead on Datastage. (b)If you want to join the two tables on Datastage, check with your Datastage admin wh...

What is the volume of data that you are expecting in the look-up?? Look-up can't handle huge(depends on system config) data as it bring entire data to memory before processing the input data. If the data is huge use a join stage and it has no issues on the heap memory.

Thanks
Maddy

[quote="reachthiru"]Hi Madhav, There are multiple ways to do that. If you want it to write to a sequential file, you can read each record and whle writing it to a sequential file, write it with the record delimiter as 'comma(,)'. So all the records will be written to a single record. Other...

I have multiple records (varies from 10 to 50) having only one date field and I want to write to a sequentail file as one record with all the dates appended.

I want to use these in a job parameter in the next job. Is there any other way of passing the parameters to the next job??

Thanks
Madhav

How can I provide restart instructions in the ETL program when a job/step fails. Can it be done with datastage?? if not how can it be done.
TIA
Macks