Searching a number other than 0

[Database Administrator]

Hi,
I have a doubt. I have a file which looks as folows.

Import results for DBCHECK

Number of rows read = 1
Number of rows skipped = 0
Number of rows inserted = 1
Number of rows updated = 0
Number of rows rejected = 0
Number of rows committed = 1

SQL3526N The modifier clause "IDENTITYIGNORE" is inconsistent with the
current load command. Reason code: "3".
Import results for COLLECTION_METHOD

Number of rows read = 3
Number of rows skipped = 0
Number of rows inserted = 3
Number of rows updated = 0
Number of rows rejected = 0
Number of rows committed = 3

SQL3526N The modifier clause "IDENTITYIGNORE" is inconsistent with the
current load command. Reason code: "3".
Import results for INDIVIDUAL_PROVIDER

Number of rows read = 4050
Number of rows skipped = 0
Number of rows inserted = 4050
Number of rows updated = 0
Number of rows rejected = 0
Number of rows committed = 4050

SQL3526N The modifier clause "IDENTITYIGNORE" is inconsistent with the
current load command. Reason code: "3".
Import results for INDIVIDUAL_PROVIDER_AUDIT

Number of rows read = 937
Number of rows skipped = 0
Number of rows inserted = 0
Number of rows updated = 0
Number of rows rejected = 937
Number of rows committed = 937


Number of rows read = 937
Number of rows skipped = 0
Number of rows inserted = 937
Number of rows updated = 0
Number of rows rejected = 0
Number of rows committed = 937

Import results for VENDOR_CLAIMS_SUBMISSION_NPI

Number of rows read = 2435
Number of rows skipped = 0
Number of rows inserted = 2435
Number of rows updated = 0
Number of rows rejected = 0
Number of rows committed = 2435

SQL3526N The modifier clause "IDENTITYIGNORE" is inconsistent with the
current load command. Reason code: "3".
Import results for VENDOR_CLAIMS_SUB_NPI_AUDIT

Number of rows read = 45
Number of rows skipped = 0
Number of rows inserted = 0
Number of rows updated = 0
Number of rows rejected = 45
Number of rows committed = 45


Number of rows read = 45
Number of rows skipped = 0
Number of rows inserted = 45
Number of rows updated = 0
Number of rows rejected = 0
Number of rows committed = 45

Import results for VENDOR_PAYMENT_NPI

Number of rows read = 2342
Number of rows skipped = 0
Number of rows inserted = 2342
Number of rows updated = 0
Number of rows rejected = 0
Number of rows committed = 2342

SQL3526N The modifier clause "IDENTITYIGNORE" is inconsistent with the
current load command. Reason code: "3".
Import results for VENDOR_PAYMENT_NPI_AUDIT

Number of rows read = 130
Number of rows skipped = 0
Number of rows inserted = 0
Number of rows updated = 0
Number of rows rejected = 130
Number of rows committed = 130


Number of rows read = 130
Number of rows skipped = 0
Number of rows inserted = 130
Number of rows updated = 0
Number of rows rejected = 0
Number of rows committed = 130

Import results for VENDOR_PROVIDER

Number of rows read = 2299
Number of rows skipped = 0
Number of rows inserted = 2299
Number of rows updated = 0
Number of rows rejected = 0
Number of rows committed = 2299

SQL3526N The modifier clause "IDENTITYIGNORE" is inconsistent with the
current load command. Reason code: "3".
Import results for VENDOR_PROVIDER_AUDIT

Number of rows read = 1058
Number of rows skipped = 0
Number of rows inserted = 0
Number of rows updated = 0
Number of rows rejected = 1058
Number of rows committed = 1058


Number of rows read = 1058
Number of rows skipped = 0
Number of rows inserted = 1058
Number of rows updated = 0
Number of rows rejected = 0
Number of rows committed = 1058

Now, how do i search for Number of rows inserted = any other number
other than 0 using Grep or any other command. Plz help me with this.

Thanks in advance

[Database Administrator]

chaitu wrote:
> Hi,
> I have a doubt. I have a file which looks as folows.
>
> Import results for DBCHECK
>
> Number of rows read = 1
> Number of rows skipped = 0
> Number of rows inserted = 1
> Number of rows updated = 0
> Number of rows rejected = 0
> Number of rows committed = 1
>
> SQL3526N The modifier clause "IDENTITYIGNORE" is inconsistent with the
> current load command. Reason code: "3".
> Import results for COLLECTION_METHOD
>
> Number of rows read = 3
> Number of rows skipped = 0
> Number of rows inserted = 3
> Number of rows updated = 0
> Number of rows rejected = 0
> Number of rows committed = 3
>
> SQL3526N The modifier clause "IDENTITYIGNORE" is inconsistent with the
> current load command. Reason code: "3".
> Import results for INDIVIDUAL_PROVIDER
>
> Number of rows read = 4050
> Number of rows skipped = 0
> Number of rows inserted = 4050
> Number of rows updated = 0
> Number of rows rejected = 0
> Number of rows committed = 4050
>
> SQL3526N The modifier clause "IDENTITYIGNORE" is inconsistent with the
> current load command. Reason code: "3".
> Import results for INDIVIDUAL_PROVIDER_AUDIT
>
> Number of rows read = 937
> Number of rows skipped = 0
> Number of rows inserted = 0
> Number of rows updated = 0
> Number of rows rejected = 937
> Number of rows committed = 937
>
>
> Number of rows read = 937
> Number of rows skipped = 0
> Number of rows inserted = 937
> Number of rows updated = 0
> Number of rows rejected = 0
> Number of rows committed = 937
>
> Import results for VENDOR_CLAIMS_SUBMISSION_NPI
>
> Number of rows read = 2435
> Number of rows skipped = 0
> Number of rows inserted = 2435
> Number of rows updated = 0
> Number of rows rejected = 0
> Number of rows committed = 2435
>
> SQL3526N The modifier clause "IDENTITYIGNORE" is inconsistent with the
> current load command. Reason code: "3".
> Import results for VENDOR_CLAIMS_SUB_NPI_AUDIT
>
> Number of rows read = 45
> Number of rows skipped = 0
> Number of rows inserted = 0
> Number of rows updated = 0
> Number of rows rejected = 45
> Number of rows committed = 45
>
>
> Number of rows read = 45
> Number of rows skipped = 0
> Number of rows inserted = 45
> Number of rows updated = 0
> Number of rows rejected = 0
> Number of rows committed = 45
>
> Import results for VENDOR_PAYMENT_NPI
>
> Number of rows read = 2342
> Number of rows skipped = 0
> Number of rows inserted = 2342
> Number of rows updated = 0
> Number of rows rejected = 0
> Number of rows committed = 2342
>
> SQL3526N The modifier clause "IDENTITYIGNORE" is inconsistent with the
> current load command. Reason code: "3".
> Import results for VENDOR_PAYMENT_NPI_AUDIT
>
> Number of rows read = 130
> Number of rows skipped = 0
> Number of rows inserted = 0
> Number of rows updated = 0
> Number of rows rejected = 130
> Number of rows committed = 130
>
>
> Number of rows read = 130
> Number of rows skipped = 0
> Number of rows inserted = 130
> Number of rows updated = 0
> Number of rows rejected = 0
> Number of rows committed = 130
>
> Import results for VENDOR_PROVIDER
>
> Number of rows read = 2299
> Number of rows skipped = 0
> Number of rows inserted = 2299
> Number of rows updated = 0
> Number of rows rejected = 0
> Number of rows committed = 2299
>
> SQL3526N The modifier clause "IDENTITYIGNORE" is inconsistent with the
> current load command. Reason code: "3".
> Import results for VENDOR_PROVIDER_AUDIT
>
> Number of rows read = 1058
> Number of rows skipped = 0
> Number of rows inserted = 0
> Number of rows updated = 0
> Number of rows rejected = 1058
> Number of rows committed = 1058
>
>
> Number of rows read = 1058
> Number of rows skipped = 0
> Number of rows inserted = 1058
> Number of rows updated = 0
> Number of rows rejected = 0
> Number of rows committed = 1058
>
> Now, how do i search for Number of rows inserted = any other number
> other than 0 using Grep or any other command. Plz help me with this.
>
> Thanks in advance
>

grep "Number of rows inserted" file | grep -v -w 0

or

grep "Number of rows inserted" file | grep -v "= 0"

[Database Administrator]

Thank a lot buddy.....It worked and helped me a lot.

[Database Administrator]

Hi Roy,

I have an other doubt. I have an other file and i want to print some 10
lines starting from a particular line. And i want to search this
particular line as grep SQL3109N and then start to print 10 lines after
that. How do i do that?

Thanks in advance.

[Database Administrator]

chaitu wrote:
> Hi Roy,
>
> I have an other doubt. I have an other file and i want to print some 10
> lines starting from a particular line. And i want to search this
> particular line as grep SQL3109N and then start to print 10 lines after
> that. How do i do that?
>
> Thanks in advance.
>

Sorry. I don't know an easy answer to that one. I would suspect awk
may do it but I am a novice at awk.

[Database Administrator]

Roy wrote:
> chaitu wrote:
> > Hi Roy,
> >
> > I have an other doubt. I have an other file and i want to print some 10
> > lines starting from a particular line. And i want to search this
> > particular line as grep SQL3109N and then start to print 10 lines after
> > that. How do i do that?
> >
> > Thanks in advance.
> >
>
> Sorry. I don't know an easy answer to that one. I would suspect awk
> may do it but I am a novice at awk.

Use grep -n to return the line number; add 20 to that , use that
number to `head` the file the file ; pipe the output of that thru
`tail -10` ...maybe?....

[Database Administrator]

chaitu wrote:
> Hi Roy,
>
> I have an other doubt. I have an other file and i want to print some 10
> lines starting from a particular line. And i want to search this
> particular line as grep SQL3109N and then start to print 10 lines after
> that. How do i do that?
>
> Thanks in advance.
>

One way is:

perl -nle "if (/SQL3109N/ .. $. == $e) {print} else {$e = $. + 10}" file

--

Len