DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
coolbin81
Participant



Joined: 04 Oct 2006
Posts: 6

Points: 49

Post Posted: Tue Nov 07, 2006 8:48 am Reply with quote Back to top

DataStage® Release: 7x
Job Type: Parallel
OS: Unix
Hi,
We have an input flat file with ( ASCII char 253) as the field delimiter.
How can i get DataStage to read this character as delimiter? I tried copy pasting it to the sequential file stage but it doesn't recognise this character and gives a compilation error.
Please let me know if anyone knows of a solution to this problem.

Thanks in advance.
Krazykoolrohit


since July 2006

Group memberships:
Premium Members

Joined: 13 Jul 2005
Posts: 560
Location: Ohio
Points: 2890

Post Posted: Tue Nov 07, 2006 9:06 am Reply with quote Back to top

in the delimiter space, type as following.

press 'ALT' and type 253
release alt.

this is the way you type ASCII characters. run the job after this.
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 43011
Location: Denver, CO
Points: 221947

Post Posted: Tue Nov 07, 2006 9:57 am Reply with quote Back to top

Actually, just type the '253'... no alt required. Wink

_________________
-craig

The muffin man is seated at the table in the laboratory of the Utility Muffin Research Kitchen reaching for an oversized chrome spoon
Rate this response:  
Not yet rated
coolbin81
Participant



Joined: 04 Oct 2006
Posts: 6

Points: 49

Post Posted: Tue Nov 07, 2006 1:36 pm Reply with quote Back to top

These solutions don't work! Typing 253 or (with or with escape character '\') in delimiter string option doesn't help either! And using normal delimiter option will allow us to enter only a single character.
Rate this response:  
Not yet rated
narasimha


since February 2010

Group memberships:
Premium Members, Heartland Usergroup

Joined: 22 Oct 2004
Posts: 1236
Location: Staten Island, NY
Points: 6560

Post Posted: Tue Nov 07, 2006 1:41 pm Reply with quote Back to top

coolbin81 wrote:
These solutions don't work!

What errors do you get?


Give an example of how your flat file looks.
coolbin81 wrote:
And using normal delimiter option will allow us to enter only a single character.

This is true.

_________________
Narasimha Kade

Finding answers is simple, all you need to do is come up with the correct questions.
Rate this response:  
Not yet rated
coolbin81
Participant



Joined: 04 Oct 2006
Posts: 6

Points: 49

Post Posted: Tue Nov 07, 2006 4:06 pm Reply with quote Back to top

When we try to use the special character and compile the job, it gives the following error:

Property value cannot contain UniVerse mark characters.
Property name is: Value
Invalid data is : final_delim=end, delim_string='\', quote=double
Will replace with: final_delim=end, delim_string='\*', quote=double


So does that mean DataStage wont recognize such characters if we copy paste it there? Then how do we specify it to DS (like specifying ASCII 253 instead of copy pasting the character itself).
Rate this response:  
Not yet rated
narasimha


since February 2010

Group memberships:
Premium Members, Heartland Usergroup

Joined: 22 Oct 2004
Posts: 1236
Location: Staten Island, NY
Points: 6560

Post Posted: Tue Nov 07, 2006 5:04 pm Reply with quote Back to top

Why are you using \ simply use or 253 in the "Delimiter" space
You can enter only a single-byte or an ASCII code here

Give a sample of how your flat file looks and what is the delimiter

_________________
Narasimha Kade

Finding answers is simple, all you need to do is come up with the correct questions.
Rate this response:  
Not yet rated
talk2shaanc


since July 2006

Group memberships:
Premium Members

Joined: 18 Jan 2005
Posts: 199
Location: India
Points: 1827

Post Posted: Wed Nov 08, 2006 8:43 am Reply with quote Back to top

ASCII 253 is for ...so please check the correct value for ..

secondly if you press "ALT" and then type ASCII value from you number key pad and release it once you have given the number in normal delimiter option, you would get(see) the special character against "delimeter"..you dont have to use back-slash, to escape

_________________
Shantanu Choudhary
Rate this response:  
Not yet rated
tagnihotri
Participant



Joined: 28 Oct 2006
Posts: 83

Points: 399

Post Posted: Wed Nov 08, 2006 8:48 am Reply with quote Back to top

Have tried on a test job working fine for me !
Rate this response:  
Not yet rated
narasimha


since February 2010

Group memberships:
Premium Members, Heartland Usergroup

Joined: 22 Oct 2004
Posts: 1236
Location: Staten Island, NY
Points: 6560

Post Posted: Wed Nov 08, 2006 10:58 am Reply with quote Back to top

Like Craig said you dont need to press ALT, you can just enter 253

But if you want to go the "ALT" way then use ASCII 0253

_________________
Narasimha Kade

Finding answers is simple, all you need to do is come up with the correct questions.
Rate this response:  
coolbin81
Participant



Joined: 04 Oct 2006
Posts: 6

Points: 49

Post Posted: Wed Nov 08, 2006 9:05 pm Reply with quote Back to top

Thanks a lot guys for your help!
Rate this response:  
Not yet rated
bkerebel
Participant



Joined: 05 Jan 2005
Posts: 15

Points: 154

Post Posted: Mon Sep 02, 2019 8:28 am Reply with quote Back to top

Hi all,
for information if you have trouble to use a special delimiter or quote character to read a Sequential file, you can use a schema file and the import column

Exemple : if you use double quote for the quote, you can use ASCII value

record
{final_delim=end, delim='|', quote="\0"}
(
INV_ID:string[max=20];
VEH_ID_NBR:string[max=17];
...
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 43011
Location: Denver, CO
Points: 221947

Post Posted: Tue Sep 03, 2019 7:08 am Reply with quote Back to top

Wow... this might be a record. Wink

_________________
-craig

The muffin man is seated at the table in the laboratory of the Utility Muffin Research Kitchen reaching for an oversized chrome spoon
Rate this response:  
Not yet rated
qt_ky



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2870
Location: USA
Points: 21792

Post Posted: Wed Sep 04, 2019 5:38 am Reply with quote Back to top

I thought the same thing! Laughing

_________________
Choose a job you love, and you will never have to work a day in your life. - Confucius
Rate this response:  
Not yet rated
Display posts from previous:

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours