Issue testing Mr Art myexport + Mr Leffler sqlcmd
Posted in 2011
Topics: Installation, Setup & Upgrades, Connectivity: ESQL/C, 4GL & Embedded SQL, Migration, Import/Export & Data Conversion, Versions, Editions & End-of-Life
Hello, friends. Informix Dynamic Server version 11.70.FC1 on linux_64 redhat machine. I´m testing Mr Art´s myexport, with Mr Leffler´s sqlcmd utils. The sqlcmd was compiled (for 64 bits), but now I am getting some strange errors on the myexport (utils2 package) is the last one downloaded here. (Version dated: December 10, 2010) sqlcmd version installed is: sqlunload: SQLCMD Version 87.00 (2010-10-21) My csdk is: IBM Informix CSDK Version 3.70, IBM Informix-ESQL Version 3.70.FC1 When I run the first one, using the cmd: myexport desenv -ss -p -m -o /tmp/DBEXPORT -Z it creates the output directory, just fine, the sql commands, but the unload data files are always with this message: sqlunload (at /dev/stdin:0): cannot open file /dev/stdout errno 6 - No such device or address It seems some integration trouble between myexport and sqlunload, but where? Do I need to setup something else? I´ve already checked my stdin and stdout, and they are just fine. Thanks for your attention!
Sorry for the inconvenience, friends. I found the issue, it´s regarding the -Z option.... Thanks for your attention! Em 16/03/2011 08:25, ALEXANDRE MARINI escreveu: > Hello, friends. > Informix Dynamic Server version 11.70.FC1 on linux_64 redhat machine. > > I´m testing Mr Art´s myexport, with Mr Leffler´s sqlcmd utils. > > The sqlcmd was compiled (for 64 bits), but now I am getting some strange > errors > on the > > myexport (utils2 package) is the last one downloaded here. > (Version dated: December 10, 2010) > > sqlcmd version installed is: > sqlunload: SQLCMD Version 87.00 (2010-10-21) > > My csdk is: > IBM Informix CSDK Version 3.70, IBM Informix-ESQL Version 3.70.FC1 > > When I run the first one, using the cmd: > myexport desenv -ss -p -m -o /tmp/DBEXPORT -Z > > it creates the output directory, just fine, the sql commands, but > the unload data files are always with this message: > > sqlunload (at /dev/stdin:0): cannot open file /dev/stdout > > errno 6 - No such device or address > > It seems some integration trouble between myexport and sqlunload, but where? > Do I need to setup something else? > I´ve already checked my stdin and stdout, and they are just fine. > > Thanks for your attention! > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Alexandre Marini Tecnologia da Informação - DBA msn: alexandre_marini@hotmail.com SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix Cert-Info-Mgmt_color <Cert-Info-Mgmt_color.jpg> IBM Certified System Administrator - Informix Dynamic Server V10 / V11 <http://www.iiug.org/conf/2011/iiug/>