Generate IP Address through DS Jobs

[eaman]

Hi all,

I need to generate a file containing approx. 8 million distinct IP addresses - eg. 10.96.04, 10.96.05, 10.96.06, etc.

All I have is a start IP Range and an end IP Range (10.96.04 - 10.96.255.254) to work on and I have been given 64 varied ranges.

Would anyone know how to create a routine that would generate this distinct IP addresses? Any thoughts would be much appreciated.

Cheers,

eaman

[roy]

Hi and welcome aboard ,
There are plenty who knows how.
The question is will anyone contribute such an effort for free?
(even if it might be a small effort)

You can find all the ingridiants for the solution in your Basic.pdf guide.
you'll need some loops (2 nested ones at least and some string concatenation and your good to go )

IHTH,

[ArndW]

There are 4 sets of numbers between 0 and 255 in an IP address. Assuming your start address uses the top 2 groups:

Code: Select all

StartIPClassA = 64
StartIPClassB = 23
AddressesToGenerate = 8000000
AddressString = '' ;** this is going to be a big string!

IPA = StartIPClassA
IPB = StartIPClassB
IPC = 0
IPD = 0
FOR Counter = 1 TO AddressesToGenerate
   IPD += 1
   IF (IPD=256)
   THEN
     IPD = 0
     IPC += 1
     IF (IPC=256)
     THEN
        IPC = 0
        IPB += 1
         IF (IPB=256)
         THEN
            IPB = 0
            IPA += 1
            IF IPA=256 THEN CALL DSLogFatal('oopsie','')
         END
      END
   END
   AddressString<-1> = IPA:'.':IPB:'.':IPC:'.':IPD
NEXT Counter

I didn't debug this so it probably won't compile, but the rough logic is there. I might also change it to multiple FOR a=0 TO 255 loops...

[Sunshine2323]

Hi,

If I have understood your question correctly then u need

10.96.4.0
|
10.96.4.255
|
10.96.5.0
|
10.96.5.255
|
|
|
10.96.255.255

This can easily be done in DataStage Job using Stage Variables

Declaring 2 stage Variables
Counter1 - Intial Value =4
Counter2 - Intial Value =0

Counter1 Derivation: If Counter2=255 then Counter1+1 else Counter1
Counter2 Derivation: If Counter2<255 then Counter2+1 Else 0

IPAdress=10: "." : 96 : "." : Counter1 : "." : Counter2

In the transformer stage give the correct OUTROWNUM which calculates to 64512 for 10.96.255.255

Hope this helps

Thanks

[eaman]

YES it works! thank you so much Sunshine, its exactly what i need!

More power to all.

Hi,

If I have understood your question correctly then u need

10.96.4.0
|
10.96.4.255
|
10.96.5.0
|
10.96.5.255
|
|
|
10.96.255.255

This can easily be done in DataStage Job using Stage Variables

Declaring 2 stage Variables
Counter1 - Intial Value =4
Counter2 - Intial Value =0

Counter1 Derivation: If Counter2=255 then Counter1+1 else Counter1
Counter2 Derivation: If Counter2<255 then Counter2+1 Else 0

IPAdress=10: "." : 96 : "." : Counter1 : "." : Counter2

In the transformer stage give the correct OUTROWNUM which calculates to 64512 for 10.96.255.255

Hope this helps

Thanks