LOOP IN A MF INVIROMENT
Moderators: chulett, rschirm, roy
LOOP IN A MF INVIROMENT
Hi,
I want to multiply by 40 each row that comes from the input stage to the output stage
I'm using the MF edition
Thanks'
Guy smadga
I want to multiply by 40 each row that comes from the input stage to the output stage
I'm using the MF edition
Thanks'
Guy smadga
Re: LOOP IN A MF INVIROMENT
Hi,
What is the MF edition ?
What a strange idea !!!
You can use a row generator to create 40 lines with one column (called "JOIN" for example) filled with a fixed value (for example "1").
Then you create a column (also called "JOIN") in your "stream" flow with the value "1".
Use a join stage to join your flows on the "JOIN" column.
Each line from your "stream" flow will be multiply by 40.
That's all !
Matthieu
What is the MF edition ?
What a strange idea !!!
You can use a row generator to create 40 lines with one column (called "JOIN" for example) filled with a fixed value (for example "1").
Then you create a column (also called "JOIN") in your "stream" flow with the value "1".
Use a join stage to join your flows on the "JOIN" column.
Each line from your "stream" flow will be multiply by 40.
That's all !
Matthieu
Last edited by mpouet on Wed May 24, 2006 8:38 am, edited 1 time in total.
Re: LOOP IN A MF INVIROMENT
Matthieu,mpouet wrote:Hi,
What is the MF edition ?
What a strange idea !!!
You can use a row generator to create 40 lines with one column (called "JOIN" for example) filled with a fixed value (for example "1").
Then you create a column (also called "joined") in your "stream" flow with the value "1".
Use a join stage to join your flows on the "JOIN" column.
Each line from your "stream" flow will be multiply by 40.
That's all !
Matthieu
guysma is using MVS Edition. Rowgenerator stage is not available in MVS Edition. It is available only in EE Edition.
Re: LOOP IN A MF INVIROMENT
Ok,
So, just create a flat file with 40 lines containing "1"...
Matthieu
So, just create a flat file with 40 lines containing "1"...
Matthieu
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: LOOP IN A MF INVIROMENT
The edition does not really matter. You use a Transformer stage, and build an expression that multplies the input column by 40,in the derivation expression of the output column.guysma wrote:Hi,
I want to multiply by 40 each row that comes from the input stage to the output stage
I'm using the MF edition
Thanks'
Guy smadga
The job itself looks after iterating through all the rows supplied via its input.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Guysma, based on your example, I would explore a utility approach unless a programmatic (i.e., DataStage) solution is demanded. Solicit some help from the MVS system or application programmers in your shop. I'm suggesting that there may be several IEB utilities that can accomplish what you want to do without creating a special program to do it.