RE: File Help.

["Hatzenbeler, Tim" <thatzenbeler@xxxxxxxxxxxxx>]

Its a journal collector file, that the Infinium software uses to create a GL
#, and their PO program populates this file, and then calls a program that
reads that file to generate a GL #, but I'm writing a program to read an 810
invoice file, and to bypass infiniums PO program, but I need to see what
fields I need to populate in this file, to make sure I have all my basis
covered, to have a succesfull GL resolution.
But I'll give your idea a try...

I agree about your assesment of the MS tools, I had to give our PC guys a
bad time, about that also.

I don't know if wrkqry actually froze, but our normal query response is sub
secound, and I walked away for about 10 mins, and decided, I shouldn't be
doing this interactive, so I ended it.

tim
> -----Original Message-----
> From: jpcarr@TREDEGAR.COM [SMTP:jpcarr@TREDEGAR.COM]
> Sent: Monday, August 07, 2000 6:53 PM
> To:   MIDRANGE-L@midrange.com
> Subject:      Re: File Help.
> 
> 
> My product master(Real Nice 3rd party ERP package<VBG>)  has about 700
> fields, and Record length is about 4000.
> 
> Hmm Access failed ?  what a shame.  Excel failed?  Again what a shame.
> You
> know those industrial strength DB tools.
> (Just kidding MS fans <G>)
> 
> Now then,  Try SQL.
> 
> STRSQL
> 
> Use F13 when in SQL and change default output to *PRINT.  Select * from
> File
> 
> Can't understand why WRKQRY would freeze.
> 
> You said you need to read it.  What for?  Are you just curious?  Just want
> to know what's in it?  Every Field?
> 
> 
> John Carr
> --------------------------------------
> 
> I have a very large record that I need to read, 800+ fields, and over 8000
> bytes of data, any suggestions?
> 
> I have tried DBU 4.1/ WRKDBF without success and when I tried wrkqry, it
> seemed to freeze...  Downloading via/odb to excel failed because the
> worksheet couldn't hold the data, I have tried using Access, but it failed
> also, but it couldn't even give me a reason for why it failed.
> 
> Can anyone think of another way to display data in these fields?  It's
> only
> one record long...
> 
> p.s. I would like to avoid writng and RPG program, the printfile would be
> huge.  Plus adding the description to each field.
> 
> p.s.ps.  I did not create this record :-)
> 
> tia, tim
> 
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---