On Wed, Apr 15, 2015 at 11:35 AM, Ron Thomas <[email protected]> wrote:
> Hello > > we have a copybook like the one below and which is a flat file data > > 10 HDTS-CUS-GBL-LOC-SLD-TO. > 49 HDTS-CUS-GBL-LOC-SLD-TO-LEN PIC S9(4) USAGE COMP. > 49 HDTS-CUS-GBL-LOC-SLD-TO-TEXT PIC X(13). > 10 HDTS-CUS-GBL-LOC-BIL-TO. > 49 HDTS-CUS-GBL-LOC-BIL-TO-LEN PIC S9(4) USAGE COMP. > 49 HDTS-CUS-GBL-LOC-BIL-TO-TEXT PIC X(13). > > We are planning to create a pipe delmited file and so here for the length > information involved in the layout , how do we need to handle this ? Do we > need to send this information to the SQL server Db team ? > > Thanks > Ron T > > If by pipe delimited you mean you are going to output the data in the ????-TEXT fields with a | between them, then I think that all the DB people need to know is that the columns are either CHAR(13) or VARCHAR(13) (assuming I remember SQL correctly). But one really big thing. On a real 3270, the | key inputs x'6A'. What happens on an emulated 3270 depends on the emulator (mine is set up correctly, other people's were not). This hex value is a broken vertical bar. It likely won't transfer properly to Windows via FTP. You might want to double check this. It is just a vague memory. -- If you sent twitter messages while exploring, are you on a textpedition? He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
