'myimport -C'
David Grove asked what the myimport -C option does in Art Kagel's utilities. Art Kagel explained that with external table exports, the storage directory path is embedded in the generated scripts; -C supplies a replacement path when data files are loaded from a different location, kept separate from the -i script path in case of tight storage. David understood. Solved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Greetings, I apologize for being such a Neanderthal, but might anyone offer a fuller (than the "usage" output from 'myimport') explanation of what the "-C" option does? In my (alleged) mind, it looks like it might be similar to the "-i" option. But, that doesn't make sense, since "-i" already exists. I am currently re-evaluating Art's utilities, which looked very promising in the past, but we had some esoteric issues that were problematic, but now are probably fixed. Thank you for any comments. Regards, David Grove ------------------------------ David Grove ------------------------------ #Informix
P.S. Will be using external tables (-E), which makes "-C" required. Last time I was working with myimport, that option (-C) didn't exist. [And, we were using -E.] ------------------------------ David Grove ------------------------------
David: OK, so, if you do an external table export, the target storage directory path is embedded in the SQL scripts that create the external tables for unload and also the scripts that myimport will have to ue to reimport the data files. If you will be loading the data from a path that is different from the path used to unload, then myimport's -C option lets you provide a replacement path that will be used to rewrite those scripts with the correct path. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
Also, I made it a separate option rather than just substitute the -i path so that the data files could be moved to a different directory from the scripts in case of storage issues. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
Ahhh. Now it makes sense. Thank you, Art. DG ------------------------------ David Grove ------------------------------
B^) When in doubt or confused, just remember that everything in my utilities packages came from a real need, either mine or some other user. Tight storage on the target machine is all too common when the hardware folks don't bother talking to the DBAs before ordering systems. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
That makes complete sense, and my experience tells me your use case is exactly correct. DG