DSXchange

Oh well, I was hoping to do this in the transformer without calling a routine.

I'll try the str(char(13),Count) technique. Maybe I can somehow insert the data after I've created the empty rows in another stage.

Thanks again Ray.

intermediate text file and generating the same number of line terminators as there are in your count column. Can I use a transformer to read the two fields and write to 1 field with the line terminators? I'm stuck on how to write the number of terminators based on the count field. I don't recall an...

Is a subroutine the only way to go for generating variable output records per input record? Can this be done using stages only? I have a similar problem as the original poster. I have two columns: Company Count ABC 100 DDD 50 So I would like to make 100 records of ABC and 50 of DDD. The Count is var...

Pavan_Yelugula wrote:Thanks a lot for trying it out with a example
Actually i am trying to get the maximum of the reckey and please note that the data is not sorted

Thanks for the help


Pavan

Anytime....good luck!

well, i just tried it....and it seems to be outputting according to your logic. So i guess the ascential documentation was correct. datastage does break down the shared container as if it was just part of the job. my result from the aggregator was 30 (sum of 20 and 10). Are you summing the maxreckey...

can you please tell me how a shared container work i have job design which looks like this Seq1-->SharedContainer--->seq2 If i have 10 records in my seq1 file. will my shared container execute 10 times taking one record at a time. or will all the 10 records be grouped and the shared conatiner will ...

Exactly. Thats what i want to do?.Can you help to implement that logic Ken?If possible can you give me some sample code please. You can see sample code by just simply clicking on "Job properties". Choose the "job control" tab. Select a job on the drop down menu and then click ad...

Job control allows you to run different jobs, kinda like a job sequencer. The plus of using job control is that you can run loops for a specific job, specifying different inputs via job parameters. Say, you had several source files but you want to apply the same mapping or transformation to each one...

Is there a way to pass the filename being loaded from a sequential file stage into a transformer stage in order to have the filename included as an output field? A ghetto way of doing it would be to set a job parameter with the file name and output a column with the filename....you could also input...

Please see this thread

viewtopic.php?t=91732

DROP TABLE if created with CREATE TABLE or UV stage I was able to DROP TABLE, but it was really ugly how I did it. In the UniVerse stage, I checked the "Create table in target database" again and edited the DDL with DROP Table "tablename". I ran the job to drop the table. It sol...

OK, I think I found it......drop table, not delete table is the magic criteria

How you delete a UniVerse table depends solely on how it was created; there are three or four possibilities. Searching the forum will yield all of them. I created the table via a UniVerse stage. I checked the box "Create table in target database". On the Edit DDL tab, I clicked on the &qu...

how do you delete a UniVerse table?

You could create a new job. Use the job properties|job control tab to set up another job that loops Job A. Refer to the BASIC guide for looping commands.