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
 

 

Problem in ftp as | delimiter gets converted to special char

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
CHANDAN KAPOOR

New User


Joined: 12 Apr 2008
Posts: 36
Location: NOIDA

PostPosted: Mon Oct 31, 2011 11:50 pm    Post subject: Problem in ftp as | delimiter gets converted to special char
Reply with quote

Hi ,

I have unload file having '|' as delimiter , when I ftp this file to windows in .txt format . | gets converted to some special char .

Can anybody help in this.
Back to top
View user's profile Send private message

superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Mon Oct 31, 2011 11:54 pm    Post subject: Reply to: Problem in ftp as | delimiter gets converted to sp
Reply with quote

Is it an X'4F' in EBCDIC?
Back to top
View user's profile Send private message
CHANDAN KAPOOR

New User


Joined: 12 Apr 2008
Posts: 36
Location: NOIDA

PostPosted: Mon Oct 31, 2011 11:58 pm    Post subject: Reply to: Problem in ftp as | delimiter gets converted to sp
Reply with quote

How can I have | in the .txt file .
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Tue Nov 01, 2011 12:02 am    Post subject: Reply to: Problem in ftp as | delimiter gets converted to sp
Reply with quote

Try making sure it's a logical 'OR' Hex '4F' in EBCDIC...
Back to top
View user's profile Send private message
CHANDAN KAPOOR

New User


Joined: 12 Apr 2008
Posts: 36
Location: NOIDA

PostPosted: Tue Nov 01, 2011 12:11 am    Post subject: Reply to: Problem in ftp as | delimiter gets converted to sp
Reply with quote

Is there any way I can get the ASCII code for | so that I can use corresponding EBCDIC which I can as delimiter in mainframes.
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Tue Nov 01, 2011 12:17 am    Post subject: Re: Reply to: Problem in ftp as | delimiter gets converted t
Reply with quote

CHANDAN KAPOOR wrote:
Is there any way I can get the ASCII code for | so that I can use corresponding EBCDIC which I can as delimiter in mainframes.

Assuming that you run Windows on your workstation, look at the Character Map accessory.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7223

PostPosted: Tue Nov 01, 2011 12:33 am    Post subject: Reply to: Problem in ftp as | delimiter gets converted to sp
Reply with quote

I'm confused as to which way round you want things.

x'4F' is the Logical Or/Pipe/Vertical Bar/Vertical Line in EBCDIC.

x'7C' is the same in ASCII.

Assuming standard translation.

Again assuming standard translation, when the ftp does EBCIDIC to ASCII the character should appear correctly on the target sytem. Same with ftp from target.

Immediately after the ftp try to look at the file with an "editor". If you don't see "|" then you have to look at the "code tables". If you see "|", then something down the line is interpreting the x'7C' as another character.
Back to top
View user's profile Send private message
CHANDAN KAPOOR

New User


Joined: 12 Apr 2008
Posts: 36
Location: NOIDA

PostPosted: Tue Nov 01, 2011 1:25 am    Post subject: Reply to: Problem in ftp as | delimiter gets converted to sp
Reply with quote

Hi Bill,

Thanks for your reply can u please assist me that how can I view this file in editor after the ftp.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Tue Nov 01, 2011 1:27 am    Post subject: Reply to: Problem in ftp as | delimiter gets converted to sp
Reply with quote

Quote:
Thanks for your reply can u please assist me that how can I view this file in editor after the ftp.
icon_question.gif icon_question.gif icon_question.gif
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7223

PostPosted: Tue Nov 01, 2011 1:45 am    Post subject: Reply to: Problem in ftp as | delimiter gets converted to sp
Reply with quote

Yes, well.... you didn't actually mention what sort of system is your ftp target. Even then, I think your own colleagues would be a better source of information. It doesn't even have to be an editor. If you don't know the system, just ask someone, nicely, if they can show you the first screenful of records on the file.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Nov 04, 2011 6:51 pm    Post subject: Re: Problem in ftp as | delimiter gets converted to special
Reply with quote

CHANDAN KAPOOR wrote:
I have unload file having '|' as delimiter , when I ftp this file to windows in .txt format . | gets converted to some special char .
As you're reluctant to answer what Kevin has asked and then suggested and later explained by Bill -- why don't you live with the new some special char, I belive the change is universal across the file and it will still serve the purpose of delimiter, no?
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 -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm
No new posts Comparing Decimal and CHAR columns rakesh17684 DB2 7 Thu Oct 20, 2016 2:33 am
No new posts Problem in Running Query via JCL vickey_dw DB2 3 Tue Oct 18, 2016 11:11 pm
No new posts DB2 Streaming Batch Processing Problem Manshadi DB2 4 Sat Sep 24, 2016 12:14 pm
No new posts Problem with GETMAIN command amitc23 CICS 6 Thu Sep 01, 2016 1:01 pm


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