 |
Connection from DB2 to Text
Holger Pucker 02/02/2006 04:59 AM
Connector for Text LEI - 6.5 iSeries
Hello,
I want to move datas from a db2 table to a text file. (Not shure if this is possible).
For testing I created a connection document to get two fields from a db2 table and to move them to a textfile in the ifs.
Unfortunatly I get always an error indicating, that I used invalid ZID field options.
I used the following Field Specifications:
Type: TYPE TEXT value "Artstp01"
ARTIK: TYPE TEXT START 01 END 11
REFNR: TYPE NUMBER start 12 END 23
Error text:
02/02/2006 10:51:58 Activity started
02/02/2006 10:52:00 line 1 - Type: TYPE TEXT value "Artstp01"
, Connector 'Test - Text Connector', Method -Connect-
02/02/2006 10:52:00 Error: ERROR: Invalid ZID field option:
on line 1, file: /tmp/QACXD5N93W, Connector 'Test - Text Connector', Method -Connect-
02/02/2006 10:52:00 line 2 - ARTIK: TYPE TEXT START 01 END 11
, Connector 'Test - Text Connector', Method -Connect-
02/02/2006 10:52:00 Error: ERROR: Invalid/missing END value on line 2, file: /tmp/QACXD5N93W, Connector 'Test - Text Connector', Method -Connect-
02/02/2006 10:52:00 line 3 - REFNR: TYPE NUMBER start 12 END 23, Connector 'Test - Text Connector', Method -Connect-
02/02/2006 10:52:00 Error: ERROR: 2 errors in ZID file entries, Connector 'Test - Text Connector', Method -Connect-
02/02/2006 10:52:00 Error: ERROR: Processing of ZID file failed: /tmp/QACXD5N93W, Connector 'Test - Text Connector', Method -Connect-
02/02/2006 10:52:08 Activity Ended With An Error
The target file is not created yet. I have created a sub directory, where the qnotes user has all authorities.
Any help would be nice.
Go back |