Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
Krazykoolrohit
Charter Member
Posts: 560 Joined: Wed Jul 13, 2005 5:36 am
Location: Ohio
Post
by Krazykoolrohit » Tue Nov 07, 2006 9:06 am
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.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Tue Nov 07, 2006 9:57 am
Actually, just type the '253'... no alt required.
-craig
"You can never have too many knives" -- Logan Nine Fingers
narasimha
Charter Member
Posts: 1236 Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY
Post
by narasimha » Tue Nov 07, 2006 1:41 pm
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.
tagnihotri
Participant
Posts: 83 Joined: Sat Oct 28, 2006 6:25 am
Post
by tagnihotri » Wed Nov 08, 2006 8:48 am
Have tried on a test job working fine for me !
narasimha
Charter Member
Posts: 1236 Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY
Post
by narasimha » Wed Nov 08, 2006 10:58 am
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.
coolbin81
Participant
Posts: 6 Joined: Wed Oct 04, 2006 2:50 pm
Post
by coolbin81 » Wed Nov 08, 2006 9:05 pm
Thanks a lot guys for your help!
bkerebel
Participant
Posts: 15 Joined: Wed Jan 05, 2005 3:18 am
Post
by bkerebel » Mon Sep 02, 2019 8:28 am
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];
...
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Tue Sep 03, 2019 7:08 am
Wow... this might be a record.
-craig
"You can never have too many knives" -- Logan Nine Fingers
qt_ky
Premium Member
Posts: 2895 Joined: Wed Aug 03, 2011 6:16 am
Location: USA
Post
by qt_ky » Wed Sep 04, 2019 5:38 am
I thought the same thing!
Choose a job you love, and you will never have to work a day in your life. - Confucius