Search found 5168 matches

by kumar_s
Fri Jun 24, 2005 4:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Ebcdic(binar) to ascii
Replies: 5
Views: 3335

Thans Arnd,
I tried with CFF stage, with ASCL_EBCDIC as NLS, with the same modified colomn properties, its working :D
by kumar_s
Fri Jun 24, 2005 2:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Ebcdic(binar) to ascii
Replies: 5
Views: 3335

Thanx for your real patience, i would start to understand things indepth :shock: . Here is my story. My source is from mainframe. We are geting the layout in a cobal file format. I imported using cobal file defn. Obviously the data would be in EBCIDIC. Iam trying with sample data. I got some error l...
by kumar_s
Fri Jun 24, 2005 12:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Ebcdic(binar) to ascii
Replies: 5
Views: 3335

Ebcdic(binar) to ascii

Hi, I am trying to read a EBCDIC file in a binary format. But when i try to read using sequential stage with the specification Under general properties as Character set as Ebcdic Dataformat as 'Binary' packed decimal = yes record length of 509 i could not even view data. Is there any other way i can...
by kumar_s
Mon Jun 20, 2005 11:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Routine not cataloged
Replies: 3
Views: 2926

Routine not cataloged

HI, We get the following warning when we try to edit job properties or adminstrator as a user, Routine *vmadmsub does not appear to be cataloged is this a part of NLS problem. How to catalog to client users. This warning doesnt apear to dsadmn. P.S: We have some NLS installation problem. Thanx in ad...
by kumar_s
Mon Jun 20, 2005 10:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: full outer join
Replies: 6
Views: 2884

Thanks,
I could make it within one job with change code 0.

Thanks for all.
by kumar_s
Mon Jun 20, 2005 8:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: full outer join
Replies: 6
Views: 2884

Thanks,
yes i tried with chang capture and transformer stage, in a single job we can capture changed, new records for the both the file.
is there way to capture the common records for the both the table using the same job....
by kumar_s
Mon Jun 20, 2005 6:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: full outer join
Replies: 6
Views: 2884

full outer join

HI all, if two files need to be full outer joined. Table A key value 1 a 2 b 3 c 4 d Table B Key Value 3 c 4 h 5 g output Key value A Only 1 a 2 b B only key value 5 g A&B common key value 3 c A&B different key value 4 d can any one help me out Thanks in advace kumar
by kumar_s
Fri Jun 17, 2005 2:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: NLS error - *NLS.LISTMAPS - Not installed?
Replies: 7
Views: 18532

Thanx Arndw, This warning comes only when we try to edit some stages. When i execute "MAP" from command the output for the client user is could not locate NLS map Unable to open "GLOBAL.CATDIR" file." And in Admin i dont get hundreds of lines but very few and those were as f...