Oh, so *that's* what a cobol redefine is. How incredibly ugly. Must have been someone's crutch for poor (or no) design.
Of course, I have seen this done in Oracle as well. Jared On Wed, 2003-11-26 at 13:34, Stephane Paquette wrote: > Hi all, > > We'll do a conversion from IMS to Oracle (817). > The conversion team wants to move data on Oracle then processed it. > > Off course, in the file format, the cobol redefine command is used on a filler field > (20 times). There is also a redefine command in a redefine command. > > For the younger ones, it means a zone (50 caracters) that can be defined in many > ways depending on a key : 2 fields of 25 char or 5 fields of 10 char or .... > > The programmers can always use substring to death to work this out but I was > wandering if there was a more elegant and a less error prone solution, maybe using a > record type or a function ... > > > > Stephane Paquette > Administrateur de bases de donnees > Database Administrator > Standard Life > www.standardlife.ca > Tel. (514) 499-7999 poste 7470 > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Stephane Paquette > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
