<div>
Hi,<br />
<br />
try and use <a href="http://www-01.ibm.com/support/docview.wss?uid=swg21236366" rel="ugc nofollow">truncate</a>.<br />
<br />
Cheers
</div>


Hi,

try and use truncate [http://www-01.ibm.com/support/docview.wss?uid=swg21236366].

Cheers

<div>
yeah but how to incorporate the truncate into dbload control file ?
</div>


yeah but how to incorporate the truncate into dbload control file ?

<div>
<div class="content wysiwyg-content">
i need to truncate and load data into informix table .. is there a way by which i can used dbload to do it i am using a shell script to load the data .. but it always appends into the table...also i am trying to do a upshift of character data while loading itself .. but that throws error ... as syntax mismatch while using the utility.. my control file is as below<br />
<br />
<br />
<br />
&quot;control.file&quot; 3 lines, 83 characters<br />
FILE &quot;file.unl&quot; DELIMITER '|' 3;<br />
INSERT INTO TAB1(name,age,salary)<br />
VALUES (UPPER(f01),f02,f03);
</div>
</div>


i need to truncate and load data into informix table .. is there a way by which i can used dbload to do it i am using a shell script to load the data .. but it always appends into the table...also i am trying to do a upshift of character data while loading itself .. but that throws error ... as syntax mismatch while using the utility.. my control file is as below



"control.file" 3 lines, 83 characters
FILE "file.unl" DELIMITER '|' 3;
INSERT INTO TAB1(name,age,salary)
VALUES (UPPER(f01),f02,f03);

Loading data into table using dbload

The term 'shell' refers to a general class of text-based command interpreters most often associated with the UNIX and Linux operating systems. Popular shells include Bourne, Debian Almquist (dash), Korn (ksh), Bourne Again (bash) and the C shell family (csh). Some view the DOS 'cmd' prompt as a minimal shell of sorts. It is also possible to install Cygwin on Windows and emulate a full Unix environment with complete shell capabilities. Terminal emulators, such as xterm, GNOME Terminal and OS X Terminal, can be used to access shell.

Shell Scripting

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.