With this option, you continue to use CLPPlus, and you don't need any of the following. You need to study the documentation to get the details. This may suit your use case, only you can decide. Use the EXPORT CLPPlus command to export an external table file to a local server location, a remote client, a IBM® Cloud Object Storage, or an AWS S3 object store. One option with v11.5 is to use external tables, that is to copy the contents of the real table into a external-table and then use the clpplus command export (external table). You have different options with v11.5 (as compared to earlier versions), depending on why you want to create CSV files. IMPORT, EXPORT and LOAD commands have a restriction that processedįiles must be on the server (note: only for CLPPlus). You are using Db2-LUW v11.5 (currently the latest version), which documents the following CLPPlus restructuib at this link: Installed at "C:\PROGRA~1\IBM\SQLLIB" with DB2 Copy Name "DB2COPY1". "DB2") uses "64" bits and DB2 code release "SQL11050" with level SQ元001C An I/O error (reason = "sqlofopn -2029060079") occurredĭB21085I This instance or install (instance name, where applicable: ![]() I tried something like EXPORT TO server1-ip\C:\Data\alarms.csv OF DEL MODIFIED BY NOCHARDEL SELECT * FROM v_alarms īut doesn't seem to work as it returns an I/O error The thing is that alarms.csv file is created on server2, but I want it to be created on server1. I am trying to connect to db2 database (server2) to export data from table to a csv file, for this I am using clpplus from the local server (server1) (which I want to export the csv to), the reason I want the CSV file to be on server1 is that I want to import it to a VERTICA database using COPY command clpplus I run EXPORT TO C:\Data\alarms.csv OF DEL MODIFIED BY NOCHARDEL SELECT * FROM v_alarms
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |