473,386 Members | 1,817 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

ADMIN_CMD IMPORT and CODEPAGE

Hi!

I'm using procedure ADMIN_CMD to export/import tables into IXF files.
Is there a way to tell what codepage EXPORT/IMPORT should use?

Best regards,
Kovi
--
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
Nov 2 '06 #1
1 2368

Gregor Kovac schreef:
Hi!

I'm using procedure ADMIN_CMD to export/import tables into IXF files.
Is there a way to tell what codepage EXPORT/IMPORT should use?
Yes, you can add "modified by codepage=<your codepage>" to the
export/import command.
For version 9 this is described here:
http://publib.boulder.ibm.com/infoce...c/r0011046.htm
but it will also work for v8 (and even v7, I think).

HTH.

--
Jeroen

Nov 2 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
by: Christopher H. Laco | last post by:
Long story longer. I need to get web user input into a backend system that a) only grocks single byte encoding, b) expectes the data transer to be 1 bytes = 1 character, and c) uses the HP Roman-6...
1
by: Ralf | last post by:
I am trying to import and export text in a middle-European language with Access 2000. I know that - normally - I can choose (within imp/exp specs assistant) language (all) and codepage...
3
by: chettiar | last post by:
I am trying to do the following from within a procedure. set vcsql = 'Call SYSPROC.ADMIN_CMD(' || '''load from /dev/null of del replace into bi.Provisioned_Spam''' || ')'; execute immediate...
0
by: jabernet | last post by:
As importing/exporting data ist not directly supported for JDBC/SQLJ, we call a c-stored procedure which uses the administrative API for exporting/importing. Now with the newest DB2 8.1 Fixpack...
2
by: Gregor Kovač | last post by:
Hi! I'm trying to use ADMIN_CMD procedure in my SQL procedure like this: DROP PROCEDURE IMPORT_DATA# CREATE PROCEDURE IMPORT_DATA() SPECIFIC IMPORT_DATA MODIFIES SQL DATA NOT DETERMINISTIC...
1
by: jefftyzzer | last post by:
Friends: The (v9) documentation for invoking LOAD via the ADMIN_CMD SP has this to say: "Since all load processes (and all DB2 server processes, in general) are owned by the instance owner,...
2
by: joachim.c.mueller | last post by:
Hello, is it not possible to load data with admin_cmd into a table? This SP ended with SQL3304N The table does not exist.: CREATE PROCEDURE ADM_LOAD ( ) DYNAMIC RESULT SETS 1 -- SQL...
0
by: David Beardsley | last post by:
I'm trying to write a stored procedure that will terminate a load for a given table using the SYSPROC.ADMIN_CMD procedure. When I take the syntax that works using Quest: LOAD FROM '/dev/null'...
3
by: Stefan | last post by:
Hi, When I import data from an CSV file, data seems to be converted (into iso-8851-1 ???) although the csv data and the db are in utf-8 format. I also tried "modified by codepage=1208" but it...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.