Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Canot copy Bullet symbol in DB2 column using JCL

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
rukmakiran

New User


Joined: 19 Apr 2005
Posts: 21

PostPosted: Tue Mar 27, 2012 3:10 am    Post subject: Canot copy Bullet symbol in DB2 column using JCL
Reply with quote

Hi , Bullet symbol is not going correctly when i am trying to use an JCL to capture the data into a sequential file & insert into other table.

Note : Column definition & format of the tables are same.

Data in source table :
• 011 251 291 tar 020 272 4373

Data in destination table with out :
011 251 291 tar 020 272 4373

Can any one suggest how i can get the bullet ( • ) to a flat file & load into another table ?

Thanks,[/img]
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7307

PostPosted: Tue Mar 27, 2012 4:14 am    Post subject: Reply to: Canot copy Bullet symbol in DB2 column using JCL
Reply with quote

You're going to have to give some clue.

We know you are using JCL. You have to. But what does your JCL look like? What program does it cause to be run?
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10232
Location: italy

PostPosted: Tue Mar 27, 2012 9:33 am    Post subject: Reply to: Canot copy Bullet symbol in DB2 column using JCL
Reply with quote

Quote:
Column definition & format of the tables are same.

useless info...
wiser to tell us the involved column[s] definition.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
This topic is locked: you cannot edit posts or make replies. DB2 query Using Recursion, Converting... smilewithashu2 DB2 3 Tue Jan 03, 2017 12:50 pm
No new posts HALDB data refresh/copy from producti... vineetanand2007 IMS DB/DC 1 Mon Jan 02, 2017 11:16 am
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us