Re: Bill of Materials/Parts Explosion

On Jun 8, 2:04pm, Peter Estabrook wrote: > Subject: Bill of Materials/Parts Explosion > I am looking for any code/suggestions for performing parts explosion or > bill of materials type functions. I'm looking for a function with > capabilities similar to the "CONNECT BY" option in ORACLE's SQL SELECT > command. > > Regards, > Peter Peter, There is no direct equivalent in Informix. You either have to use recursive functions in esql/c or 4gl or you can do it as a single cursor calling a stored procedure which recursively calls other stored procedures that work down the hierarchy in whatever fashion you need, loading the result into an ordered temporary table which the first SP then reads and returns results from. Code fragments to implement parts explosion are in the 4GL by Example book published by Informix. I'm sorry but I don't currently have access to the code we use to implement it. Cheers - Jim -- ----------------------------------------------------------------------------- Jim Gordon DHL Airways Inc. jgordon@us.dhl.com ----------------------------------------------------------------------------- My opinions are my own. They may vary with time but they remain mine!