Re: Community help on DB import seeked

Gerrit > > I am running IDS 11.5 on my personal XP box. When using the dbexport > command > I get an export (schema and data files) according to the > documentation. > > Now I have been handed another DB export that allegedly has been > created with > the same 'dbexport' command as well. However this export does not > contain > { unload file name = xxx} clauses in the schema file. More then this > the > data files have an 'unl.a' extension. > > Question 1: Is this difference a version or an OS issue? Has the > export been created with > a different command maybe? You likely have an output of "dbschema" and some selfwritten database unload tool which compresses *.unl files to unl.a > > Question 2: Is there a difference in behaviour between the load and > the dbimport command when it > comes to loading of data files? > Not really but have a look to the Migration Guide and GLS Support. http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?tab=search&s earchWord=Migration+Guide > Question 3: Would anybody have a hint on proper settings when it > comes to creating a DB and loading associated data files that > - have all sorts of characters (latin, bulgarian, greek) > - which are properly encoded as UTF-8 within the files > - which need to go to DB CHAR fields? > The environment variables for DATE, LANGUAGE Settings etc. should be the same with dbexport and dbimport. > I have played around for two days now with different locale settings. > Tried many combinations of > DB, SERVER and CLIENT. Nothing seems to work......;-( What errors did you get? What did not work?