DSXchange

I have a sequence that contains a few jobs. One of them does some transformations on 17million+ rows and outputs it to a sequential file. The next job in the sequence loads these records (from the sequential file) into the database. Whenever I run the sequence, the 2nd job will abort. But if I run t...

DeepakCorning wrote:Add a stage variable which will act like a flag and will be set depending on the row is found in the hashed file or not and add a constraint depending on the flags value.

yeah, but what kind of stage variable allows me such an ability to detect whether the row is detected or not?

I have a flat file full of rows and a hash file that i want to do an inverse lookup against. That is, normally, a hash file servers to lookup keys but in this case I want to filter out all the rows in my flat file that do not exist in the hash file.. how do I do this without using reject rows option...

Kenneth,

How do I get access to this utility of yours? Might come in handy in the future

Is there anyway to do this without typing them all in? it takes forever.

basically i have a set of parameters in one job that i'd like to copy to another

any help is greatly appreciated

cool, thanks

Is this possible to do in DS?

I have a flat file, let's say, and want to feed it into a transformer sorted by a certain column.. is there anyway to do this?

thanks, any help is greatly appreciated.

chulett wrote:Please start a new thread rather than (further) hi-jacking this one.

good point, I just thought it was relevent to the OP but I started a new one here:

viewtopic.php?t=100317

I have a flat file with, say, 4 rows and each row has to be run through a sequence of jobs. I understand this can be done with loops and userdefined variable stages, can someone explain how? I guess I'm having trouble understanding how I could be able to pass each row into the 'start loop' stage. th...

Chulett,

I have a flat file with say, 4 rows, how do i tell the loop to go through my sequence of jobs 4 times and pass elements from each row into my sequence?

thanks

where can i define variables in the start loop stage?

chulett wrote:If you have version 7.5.x then - Sequence job: Start Loop, End Loop and UserVariables Activity stages will get you what you need.

can the start/end loop stages read a uservariable activity variable?

the one that needs the file name from the row of the flat file, as its parameter. Also pass it all required parameter values. Inspect the code or read the help or manual for more information on running UtilityRunJob. but i have no flat file with a filename in it. all the rows contain are data that ...

so when i use this UtilityRunJob, do I just have the flat file (with rows that I want to process seperately) going into a transformer?

and just use the UtilityRunJob for each row? what do i put for the output of the transformer? another flat file?

ray.wurlod wrote:Create one job that reads that flat file.
In a Transformer stage call the UtilityRunJob routine to run the other job, passing ID and element (and anything else required) as job parameters.

does that command allow you to pass sequences into it?