I am trying to create a daily report off the Reportcaster Botlog, Botlog2 and Botsched files but am running into a problem with the message field on Botlog2. Has anyone done any of this kind of reporting? I want a report that will tell me when certain verbage appears in the message field.

This message has been edited. Last edited by: LaVonne,

I have a number of reports that go against BOTLOG and BOTLOG2. The MESSAGE field in BOTLOG2 is defined as an A150. I currently don't do any CONTAINS on it.

What kinds of problems are you having? Have you created synonyms for the tables?

Yes, I've created synonyms. I'm trying to get the most recent comment to go with each daily job. Contains doesn't seem to be working properly as I've come across jobs with verbage that I'm looking for that isn't showing up on my report. I've tried the contains against the actual message field and also against a defined field and neither seems to be working. I've tried FST. and LST. also. Any ideas?

Well, the most recent comment or log would be the one with the highest datetime stamp as stored in BOTLOG. You have to join BOTLOG to BOTLOG2 to get this to work. There are multiple MESSAGE records per 'job' execution, each uniquely identified by the COUNTER field. You would have to search all of the lines to find what you are looking for.

Why don't you post your code? I may not have time to look at it this afternoon as I have to do a training session for my users. But if it ends early, I'll take a quick peek.

Where in Detroit are you? I grew up there and have a home in Ann Arbor.

My problem seems to be with the variable length fields .. the A150V message field and the A12V scheduleid field. I've never worked with this type of field before and couldn't find anything in the manuals on reading them, only on creating them. How do you edit them? Is there something special you have to do if you want to print them? 150 bytes is a large field,,,I'd like to edit it down to say 50 or 60 bytes.

I live by Port Huron and work in downtown Detroit. Raised in Windsor.

Mine aren't defined as V fields. You can use a DEFINE to equate them to a non-variable field. Also there are variable versions of some of the functions, SUBSTV for instance.

I have not tried PARAG on a V field but you might want to give that a try.

Boy, that's a long drive for you.

I just thought of something else. In my edasprof.prf or global profile, for each of my relational adapters, I have the line

SET ENGINE xxx SET VARCHAR OFF

Now when I create my synonyms, I don't get V columns. You might want to try that and regenerate your synonyms for your RC tables. That would save you a lot of hassle.

Parag worked. This is the subroutine I had been trying to use but evidently something else in the code was causing a problem as its working now. Thanks all.