IDS Forum

RE: dbexport fails due to '/' in table name

Posted By: NormaJean.Sebastian@tellabs.com
Date:

Colin,

I understand your point. Normally a logical person would not create
things that Informix does not understand.
However some of us are at the mercy of application providers such as
SAP.
In this case the person (I don't have the original mail) is trying to
export an SAP database.

My question/comments to the person who originally submitted this ....
1) sending mail to sapmix instead of /in addition to ids might get you a
better answer. sapmix is supported by the IIUG.
2) check OSS notes or open an OSS ticket. I suspect, like HPloader,
dbexport might not be supported by SAP. Our DB is too big to even try
it.

Norma Jean


-----Original Message-----
From: c.bull@videonetworks.com [mailto:c.bull@videonetworks.com]
Sent: Wednesday, June 25, 2003 6:42 AM
To: ids@iiug.org; forum.subscriber@iiug.org
Subject: RE: dbexport fails due to '/' in table name [1419]


Jonathan Leffler answered .....
>
> Bug (Feature Request) 153265 applies - DBIMPORT CANNOT IMPORT SOME
> DATABASES SUCCESSFULLY EXPORTED WITH DBEXPORT. DBEXPORT
> CANNOT EXPORT SOME
> DATABASES AT ALL.
> There are other related bugs, but that's the one I'd recommend using.
> --
I think Jonathon is being polite here.
Q what moron would create a table name with a slash in it.
A The same sort who create file names with spaces.
Please tell me Informix is not stupid enough to accept this ..
Colin Bull
c.bull@videonetworks.com
>
> I am currently running Informix Dynamic Server Version 7.31.FD2X9 on a
> Sun/Sparc/Solaris 2.8 platform. I am trying to export a
> 'SAP' database to
> a local directory. I have used the command 'dbexport
> <database> -X -c -ss
> -o /export' successfully many times in the past. Recently
> some SAP objects
> have been added to the database, including tables that start with the
> character '/'.
> This causes the dbexport to halt when trying to write to an
> unload file
> such as: '{ unload file name = /ssf/00100.unl number of rows
> = 0 }'. I
> have tried setting different combinations at both startup and
> runtime the
> environment varaible 'DELIMIDENT' but I still get the failure.
>
> Does anyone have a clue as to how to get the dbexport utility
> to work with
> table names such as these?
> Thanks,


--openmail-part-3ebaa1c0-00000002
Content-Type: application/rtf
Content-Disposition: attachment; filename="BDY.RTF"
;Creation-Date="Wed, 25 Jun 2003 08:27:38 -0500"
Content-Transfer-Encoding: base64

e1xydGYxXGFuc2lcYW5zaWNwZzEyNTJcZnJvbXRleHQgXGRlZmYwe1xmb250dGJsDQp7XGYw
XGZzd2lzcyBBcmlhbDt9DQp7XGYxXGZtb2Rlcm4gQ291cmllciBOZXc7fQ0Ke1xmMlxmbmls
XGZjaGFyc2V0MiBTeW1ib2w7fQ0Ke1xmM1xmbW9kZXJuXGZjaGFyc2V0MCBDb3VyaWVyIE5l
dzt9fQ0Ke1xjb2xvcnRibFxyZWQwXGdyZWVuMFxibHVlMDtccmVkMFxncmVlbjBcYmx1ZTI1
NTt9DQpcdWMxXHBhcmRccGxhaW5cZGVmdGFiMzYwIFxmMFxmczIwIENvbGluLFxwYXINClxw
YXINCkkgdW5kZXJzdGFuZCB5b3VyIHBvaW50LiAgTm9ybWFsbHkgYSBsb2dpY2FsIHBlcnNv
biB3b3VsZCBub3QgY3JlYXRlIHRoaW5ncyB0aGF0IEluZm9ybWl4IGRvZXMgbm90IHVuZGVy
c3RhbmQuXHBhcg0KSG93ZXZlciBzb21lIG9mIHVzIGFyZSBhdCB0aGUgbWVyY3kgb2YgYXBw
bGljYXRpb24gcHJvdmlkZXJzIHN1Y2ggYXMgU0FQLlxwYXINCkluIHRoaXMgY2FzZSB0aGUg
cGVyc29uIChJIGRvbid0IGhhdmUgdGhlIG9yaWdpbmFsIG1haWwpIGlzIHRyeWluZyB0byBl
eHBvcnQgYW4gU0FQIGRhdGFiYXNlLlxwYXINClxwYXINCk15IHF1ZXN0aW9uL2NvbW1lbnRz
IHRvIHRoZSBwZXJzb24gd2hvIG9yaWdpbmFsbHkgc3VibWl0dGVkIHRoaXMgLi4uLlxwYXIN
CjEpIHNlbmRpbmcgbWFpbCB0byBzYXBtaXggaW5zdGVhZCBvZiAvaW4gYWRkaXRpb24gdG8g
aWRzIG1pZ2h0IGdldCB5b3UgYSBiZXR0ZXIgYW5zd2VyLiAgc2FwbWl4IGlzIHN1cHBvcnRl
ZCBieSB0aGUgSUlVRy5ccGFyDQoyKSBjaGVjayBPU1Mgbm90ZXMgb3Igb3BlbiBhbiBPU1Mg
dGlja2V0LiAgIEkgc3VzcGVjdCwgbGlrZSBIUGxvYWRlciwgZGJleHBvcnQgbWlnaHQgbm90
IGJlIHN1cHBvcnRlZCBieSBTQVAuICBPdXIgREIgaXMgdG9vIGJpZyB0byBldmVuIHRyeSBp
dC5ccGFyDQpccGFyDQpOb3JtYSBKZWFuXHBhcg0KXHBhcg0KXHBhcg0KLS0tLS1PcmlnaW5h
bCBNZXNzYWdlLS0tLS1ccGFyDQpGcm9tOiBjLmJ1bGxAdmlkZW9uZXR3b3Jrcy5jb20gW21h
aWx0bzpjLmJ1bGxAdmlkZW9uZXR3b3Jrcy5jb21dXHBhcg0KU2VudDogV2VkbmVzZGF5LCBK
dW5lIDI1LCAyMDAzIDY6NDIgQU1ccGFyDQpUbzogaWRzQGlpdWcub3JnOyBmb3J1bS5zdWJz
Y3JpYmVyQGlpdWcub3JnXHBhcg0KU3ViamVjdDogUkU6IGRiZXhwb3J0IGZhaWxzIGR1ZSB0
byAnLycgaW4gdGFibGUgbmFtZSBbMTQxOV1ccGFyDQpccGFyDQpccGFyDQogSm9uYXRoYW4g
TGVmZmxlciBhbnN3ZXJlZCAuLi4uLlxwYXINCj4gXHBhcg0KPiBCdWcgKEZlYXR1cmUgUmVx
dWVzdCkgMTUzMjY1IGFwcGxpZXMgLSBEQklNUE9SVCBDQU5OT1QgSU1QT1JUIFNPTUVccGFy
DQo+IERBVEFCQVNFUyBTVUNDRVNTRlVMTFkgRVhQT1JURUQgV0lUSCBEQkVYUE9SVC4gIERC
RVhQT1JUIFxwYXINCj4gQ0FOTk9UIEVYUE9SVCBTT01FXHBhcg0KPiBEQVRBQkFTRVMgQVQg
QUxMLlxwYXINCj4gVGhlcmUgYXJlIG90aGVyIHJlbGF0ZWQgYnVncywgYnV0IHRoYXQncyB0
aGUgb25lIEknZCByZWNvbW1lbmQgdXNpbmcuXHBhcg0KPiAtLVxwYXINCkkgdGhpbmsgSm9u
YXRob24gaXMgYmVpbmcgcG9saXRlIGhlcmUuXHBhcg0KUSB3aGF0IG1vcm9uIHdvdWxkIGNy
ZWF0ZSBhIHRhYmxlIG5hbWUgd2l0aCBhIHNsYXNoIGluIGl0LiBccGFyDQpBIFRoZSBzYW1l
IHNvcnQgd2hvIGNyZWF0ZSBmaWxlIG5hbWVzIHdpdGggc3BhY2VzLiBccGFyDQpQbGVhc2Ug
dGVsbCBtZSBJbmZvcm1peCBpcyBub3Qgc3R1cGlkIGVub3VnaCB0byBhY2NlcHQgdGhpcyAu
LlxwYXINCkNvbGluIEJ1bGxccGFyDQpjLmJ1bGxAdmlkZW9uZXR3b3Jrcy5jb21ccGFyDQo+
IFxwYXINCj4gSSBhbSBjdXJyZW50bHkgcnVubmluZyBJbmZvcm1peCBEeW5hbWljIFNlcnZl
ciBWZXJzaW9uIDcuMzEuRkQyWDkgb24gYVxwYXINCj4gU3VuL1NwYXJjL1NvbGFyaXMgMi44
IHBsYXRmb3JtLiAgSSBhbSB0cnlpbmcgdG8gZXhwb3J0IGEgXHBhcg0KPiAnU0FQJyBkYXRh
YmFzZSB0b1xwYXINCj4gYSBsb2NhbCBkaXJlY3RvcnkuICBJIGhhdmUgdXNlZCB0aGUgY29t
bWFuZCAnZGJleHBvcnQgXHBhcg0KPiA8ZGF0YWJhc2U+IC1YIC1jIC1zc1xwYXINCj4gLW8g
L2V4cG9ydCcgc3VjY2Vzc2Z1bGx5IG1hbnkgdGltZXMgaW4gdGhlIHBhc3QuICBSZWNlbnRs
eSBccGFyDQo+IHNvbWUgU0FQIG9iamVjdHNccGFyDQo+IGhhdmUgYmVlbiBhZGRlZCB0byB0
aGUgZGF0YWJhc2UsIGluY2x1ZGluZyB0YWJsZXMgdGhhdCBzdGFydCB3aXRoIHRoZVxwYXIN
Cj4gY2hhcmFjdGVyICcvJy5ccGFyDQo+IFRoaXMgY2F1c2VzIHRoZSBkYmV4cG9ydCB0byBo
YWx0IHdoZW4gdHJ5aW5nIHRvIHdyaXRlIHRvIGFuIFxwYXINCj4gdW5sb2FkIGZpbGVccGFy
DQo+IHN1Y2ggYXM6ICdceyB1bmxvYWQgZmlsZSBuYW1lID0gL3NzZi8wMDEwMC51bmwgbnVt
YmVyIG9mIHJvd3MgXHBhcg0KPiA9IDAgXH0nLiAgSVxwYXINCj4gaGF2ZSB0cmllZCBzZXR0
aW5nIGRpZmZlcmVudCBjb21iaW5hdGlvbnMgYXQgYm90aCBzdGFydHVwIGFuZCBccGFyDQo+
IHJ1bnRpbWUgdGhlXHBhcg0KPiBlbnZpcm9ubWVudCB2YXJhaWJsZSAnREVMSU1JREVOVCcg
YnV0IEkgc3RpbGwgZ2V0IHRoZSBmYWlsdXJlLlxwYXINCj4gXHBhcg0KPiBEb2VzIGFueW9u
ZSBoYXZlIGEgY2x1ZSBhcyB0byBob3cgdG8gZ2V0IHRoZSBkYmV4cG9ydCB1dGlsaXR5IFxw
YXINCj4gdG8gd29yayB3aXRoXHBhcg0KPiB0YWJsZSBuYW1lcyBzdWNoIGFzIHRoZXNlP1xw
YXINCj4gVGhhbmtzLFxwYXINCn0=

--openmail-part-3ebaa1c0-00000002--

Messages In This Thread

• dbexport fails due to '/' in table name
  RICHARD MOLDOVAN -- Tuesday, 24 June 2003, at 7:08 p.m.
  • Re: dbexport fails due to '/' in table name
    Jonathan Leffler -- Tuesday, 24 June 2003, at 9:11 p.m.
    • RE: dbexport fails due to '/' in table name
      Colin Bull -- Wednesday, 25 June 2003, at 7:41 a.m.
      • RE: dbexport fails due to '/' in table name
        Walter Haslbeck -- Wednesday, 25 June 2003, at 9:03 a.m.
      • RE: dbexport fails due to '/' in table name
        NormaJean.Sebastian@tellabs.com -- Wednesday, 25 June 2003, at 9:30 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.