Control characters inserted into Oracle
Moderators: chulett, rschirm, roy
Control characters inserted into Oracle
Hi,
I have a datastage job in which the source and target are defined as varchar,but while inserting into the database where the column is defined as 50, i see ^z (ascii 32) being inserted into the table.
if input is say "abc" in the database i see abc padded with ^z till 50 bytes. it appears as a white space,but its actually ^z.
I have replaced the database stage(oracle enterprise) with a peak to see the value. its fine in the peak.
any idea?
I have a datastage job in which the source and target are defined as varchar,but while inserting into the database where the column is defined as 50, i see ^z (ascii 32) being inserted into the table.
if input is say "abc" in the database i see abc padded with ^z till 50 bytes. it appears as a white space,but its actually ^z.
I have replaced the database stage(oracle enterprise) with a peak to see the value. its fine in the peak.
any idea?
Re: Control characters inserted into Oracle
I verified the input and there are no ^z from the source. even in the intermediate stages, i verified it with peak,but i see them on the database.pavankvk wrote:Hi,
I have a datastage job in which the source and target are defined as varchar,but while inserting into the database where the column is defined as 50, i see ^z (ascii 32) being inserted into the table.
if input is say "abc" in the database i see abc padded with ^z till 50 bytes. it appears as a white space,but its actually ^z.
I have replaced the database stage(oracle enterprise) with a peak to see the value. its fine in the peak.
any idea?
APT_STRING_PAD_CHAR
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
What load method are you using and are these VarChar2 columns?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Using an Upsert mode with a user defined update only. i have a insert statement instead of update. all columns are varchar2.ArndW wrote:What load method are you using and are these VarChar2 columns? ...
with in the oracle stage, in the insert statement if i use trim(orchestrate.column), i dont see these characters though. but i dont want to do that..
Using an Upsert mode with a user defined update only. i have a insert statement instead of update. all columns are varchar2.ArndW wrote:What load method are you using and are these VarChar2 columns? ...
with in the oracle stage, in the insert statement if i use trim(orchestrate.column), i dont see these characters though. but i dont want to do that..
That means somewhere in your job you are converting from a fixed length CHAR field to a VarChar and are getting those ^Zs
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Also, if i USE a Load option instead or regular insert, i dont see those characters. its happening only for a insert.pavankvk wrote:I checked all the stages, from source to target, i dont see any char..each and every stage its defined as varcharArndW wrote:That means somewhere in your job you are converting from a fixed length CHAR field to a VarChar and are getting those ^Zs ...
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Does any sequential file stage in your job specify DOS-style line terminators, or process a file that was created in a Windows environment?
Ctrl-Z is the Windows end-of-file marker character.
Ctrl-Z is the Windows end-of-file marker character.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.