Re: dbimport with procedures
Posted in 1995
Topics: Installation, Setup & Upgrades, Error Codes & Troubleshooting, Connectivity: ESQL/C, 4GL & Embedded SQL, Migration, Import/Export & Data Conversion
}>
}> i have a problem with the dbimport facility and it's really
}> bugging me (pun intended).
}>
}> Now in our database we have a bunch of database procedures
}> because of gordona's microstrategy stuff.
}>
}> I do a dbexport of the database and then I get an error when I
}> do a dbimport. The error is:
}>
}> ***prepare sqlobj
}> 674 - procedure (fourgen.creditinverse) not found.
}>
}> 111 - ISAM error: no record found.
}>
}>
}> I think the problem is that this procedure that is trying to be
}> created calls (or has included in it) the procedure called
}> creditinverse. Unfortunately, creditinverse is yet to be
}> imported (it comes later in the tape).
}>
}> Have you heard of this problem, or is it an Informix known bug?
}> Is there a workaround?
}>
}> I'm running:
}>
}> Installed Informix products (Based on copyright files in /u/informix5/etc)
}> INFORMIX-4GL Interactive Debugger .................... 4.11.UC4
}> INFORMIX-4GL ......................................... 4.11.UC4
}> INFORMIX-4GL Development System ...................... 4.11.UC4
}> INFORMIX-OnLine ...................................... 5.02.UC6
}> INFORMIX-STAR ........................................ 5.02.UC6
}>
}>
}>
}> geoffc
}>
}>
}>