Hey people- Here's some feedback from another cf-linux user sent to me that I thought might be interesting for the rest of ya...
-jesse > -----Original Message----- > From: Des Dromgool [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 30, 2001 7:53 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: CFFTP, 80 byte files and mainframes > > > > > Just found your threads re CFFTP, CFEXECUTE and 80 byte files. > You saved us a lot of time here ( we're using CF 4, and > didn't know about > CFEXECUTE ). > Maybe I can return the favour - if this makes sense, perhaps > you could post it. > > Our mission was to have CF send a DB2 query to the mainframe > for execution and > report generation. Since the query is large, CF won't wait, > just send it and > continue. > The m/f can do the query, generate a PDF, and mail it back to > the originator. > Getting this done required CF to send a job to the m/f. > > Only the m/f ftp server understands the site command, but > most ftp clients can > send unparsed strings with a quote command. > To have ftp send a file direct to a m/f job queue for > execution, you need to > send an ftp command 'site filetype=jes', and then you do a > put with a 'from' > file, but no 'to' file. > Both these actions are beyond the CFFTP tag abilities. > (Which is where we got > stuck with CF 4.0 - thank you, Jesse) > > Mainframe jobs are nominally 80 byte fixed length records, > harking back to their > origin as punched cards. These days, you can have records up > to 254 bytes long, > but the JCL records only get scanned up to column 72 (bytes > 73-80 were and still > are reserved for sequence nos.) > If you want to send lines of varying length, which is what > you'd normally have, > the trick is to append a Line feed character (0x0A) to each > line. Note, not > CRLF, not CR, just LF. > > Dave's original issue with 255 byte records is almost > certainly because that > happens to be the default output recordsize for the ftp server. > Of course the m/f sysprogs could change it, but to what? If > you have to send > stuff to a mainframe, I suggest you first ask whether you are > sending a job, > and if they don't know about submitting it directly to the > JES queue, tell them, > as per the above. > Secondly, if it's a regular file, try and get it preallocated > on the m/f end. > Then all you have to do is a simple ftp put. > If you have to create a new m/f file each time, then use the > site command > options to specify the file characteristics at the m/f end - > things like logical > record size (lrecl), > block size and record format. > > The manuals for the IBM ftp server can be found online - > Search GOOGLE for 'CS > IP User's Guide', and try the IBM sites or mainframes.com. > > DesD > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
