View Full Version: Gen Fun

LawsonTalk > Database > Gen Fun


Title: Gen Fun


trezaei - June 12, 2006 10:59 PM (GMT)
Maybe one of you can shed some light on this for me.
You'll probably have to copy and past this to make sense. but in GEN there is a table called jobstep which stores information about the job, its prodline, and it params.

Well when I dump out the table the header reads:

UserName,JobName,StepNbr,StepKey,Description,Type,Token,ProductLine,Project,Params,IntRptServer,Tran
Size,FilePathName,MachineName


But the data looks like

"NT00000001","MANJOB1",,,"Manual Job Setup",,"PA230","TRAIN","TRAIN","0001MYCOMP I,,,, G,,,,

I know you can't tell whats wrong just yet. Go ahead and past it into notepad, one line after another so you have two lines, one header and one record.

Then you'll notice that the "params" field starts with "0001MYCOMP ... and it seems to end with "I".

Well then according to the header there are only 4 field left. So what is "G,,,,"
then?

You might be wondering why I want to know this, but if I told you I'd have to waste a lot of your time so just trust me, I need to know :)

Thanks

P.S. My hunch is that rngdbdump is actually screwing this up.

trezaei - June 12, 2006 11:01 PM (GMT)
Okay so after posting that I noticed it wiped out all the whitespaces making it very difficult to see what I mean. I have attached a text file which should help. Right click on it and save it on your drive before opening because then the browser is gonna do the same.

T

schroncd - June 13, 2006 12:49 PM (GMT)
I haven't validated this, but I'm guessing that rngdbdump is giving you a message that jobstep may contain binary data. Looks like you finally found a file where that is true.

schroncd - June 13, 2006 03:46 PM (GMT)
Yep - Validated now.. At least i n 803 ESP 6 - there's binary data in jobstep so your editor is probably freaking out when it tries to read it.

I'd recommend a binary editor instead of text - it may handle it for you..

g'luck!



Hosted for free by InvisionFree