hi there,
i wanted to ask if ou know a way to search inisde a db2 file via clle and find a specifi pattern in any location of the file?
i have a flat file that i put in it a spool file. my goal is to look for a specifi pattern (the string "I6") and then if i see the string cut the 4 next
charcther after that sting and put in a varaible.
i know that i can serch via a loop and %sst and an if presudre, but this will resticet me to a sertion postion,
and i don't know where the postion will be.
here is an example of the spool file:
as you can see the I6xxxx string (a name of a tape) is not in the same location.
any advice?
i wanted to ask if ou know a way to search inisde a db2 file via clle and find a specifi pattern in any location of the file?
i have a flat file that i put in it a spool file. my goal is to look for a specifi pattern (the string "I6") and then if i see the string cut the 4 next
charcther after that sting and put in a varaible.
i know that i can serch via a loop and %sst and an if presudre, but this will resticet me to a sertion postion,
and i don't know where the postion will be.
here is an example of the spool file:
*...+....1....+....2....+....3....+....4....+....5 ....+....6....+....7....+....8....+....9....+....0 ....+....1....+....2....+....3
5770BR1 V7R1M0 100416 Backup Recovery and Media Services Log LEUMITBK 14/01/14 18:09:39 Page
Date Time Message Sev Text Program User Type
14/01/14 9:02:09 BRM1553 10 Data has been moved from the source to destination media. q1aDuplica SCDUSR *MED
Cause . . . . . : Data has been moved from media ID1460 ID1479
ID1474 ID1477 to media I60096.
14/01/14 11:57:53 BRM1553 10 Data has been moved from the source to destination media. q1aDuplica SCDUSR *MED
Cause . . . . . : Data has been moved from media ID1403 ID1499
ID1431 ID1422 ID1486 ID1550 to media I60189.
14/01/14 12:05:00 BRM1553 10 Data has been moved from the source to destination media. q1aDuplica SCDUSR *MED
Cause . . . . . : Data has been moved from media ID1432 ID1490
ID1548 ID1509 ID1538 to media I60187.
14/01/14 12:16:34 BRM1553 10 Data has been moved from the source to destination media. q1aDuplica SCDUSR *MED
Cause . . . . . : Data has been moved from media ID1225 ID1487
ID1472 ID1280 ID1491 to media I60186.
* * * * * E N D O F L I S T I N G * * * * *
5770BR1 V7R1M0 100416 Backup Recovery and Media Services Log LEUMITBK 14/01/14 18:09:39 Page
Date Time Message Sev Text Program User Type
14/01/14 9:02:09 BRM1553 10 Data has been moved from the source to destination media. q1aDuplica SCDUSR *MED
Cause . . . . . : Data has been moved from media ID1460 ID1479
ID1474 ID1477 to media I60096.
14/01/14 11:57:53 BRM1553 10 Data has been moved from the source to destination media. q1aDuplica SCDUSR *MED
Cause . . . . . : Data has been moved from media ID1403 ID1499
ID1431 ID1422 ID1486 ID1550 to media I60189.
14/01/14 12:05:00 BRM1553 10 Data has been moved from the source to destination media. q1aDuplica SCDUSR *MED
Cause . . . . . : Data has been moved from media ID1432 ID1490
ID1548 ID1509 ID1538 to media I60187.
14/01/14 12:16:34 BRM1553 10 Data has been moved from the source to destination media. q1aDuplica SCDUSR *MED
Cause . . . . . : Data has been moved from media ID1225 ID1487
ID1472 ID1280 ID1491 to media I60186.
* * * * * E N D O F L I S T I N G * * * * *
any advice?
Comment